Changes between Version 10 and Version 11 of ddl


Ignore:
Timestamp:
09/02/25 19:51:49 (8 hours ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v10 v11  
    6262 * company
    6363 * support_rep_id* (FK → Employee)
    64  * personal_info_id* (FK → !AddressInfo)
    65  * contact_id* (FK → Contact)
     64 * **address**
     65 * **city**
     66 * state
     67 * **country**
     68 * **postal_code**
     69* __**contact_id**__ (PK)
     70 * **phone**
     71 * fax
    6672
    6773= Employee =
    … …  
    7379 * **birth_date**
    7480 * **hire_date**
    75  * personal_info_id* (FK → !AddressInfo)
    76  * contact_id* (FK → Contact)
    77 
    78 = !AddressInfo =
    79  * __**address_info_id**__ (PK)
    8081 * **address**
    8182 * **city**
    … …  
    8384 * **country**
    8485 * **postal_code**
    85 
    86 = Contact =
    87  * __**contact_id**__ (PK)
     86* __**contact_id**__ (PK)
    8887 * **phone**
    8988 * fax
    9089 * **email**
     90
     91 
    9192
    9293= Playlist =