Changes between Version 18 and Version 19 of ddl


Ignore:
Timestamp:
09/24/25 17:05:29 (13 days ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v18 v19  
    6262 * company
    6363 * support_rep_id* (FK → Employee)
    64  * **address**
    65  * **city**
    66  * state
    67  * **country**
    68  * **postal_code**
    69  * **phone**
    70  * fax
     64 * **contact_id*** (FK → Contact)
     65 * **address_info_id*** (FK → !AddressInfo)
    7166
    7267= Employee =
    … …  
    7873 * **birth_date**
    7974 * **hire_date**
    80  * **address**
    81  * **city**
    82  * state
    83  * **country**
    84  * **postal_code**
    85  * **phone**
    86  * fax
    87  * **email**
     75 * **contact_id*** (FK → Contact)
     76 * **address_info_id*** (FK → !AddressInfo)
     77
     78= !AddressInfo =
     79 * _**address_info_id**__ (PK)
     80 * **address**
     81 * **city**
     82 * **state**
     83 * **country**
     84 * **postal_code**
     85
     86= Contact =
     87 * __**contact_id**__ (PK)
     88 * **phone**
     89 * **fax**
     90 * **email**
    8891
    8992= Playlist =