Changes between Version 5 and Version 6 of ddl


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

--

Legend:

Unmodified
Added
Removed
Modified
  • ddl

    v5 v6  
    44 * **name** (NOT NULL)
    55 * album_id* (FK → Album)
    6  * media_type_id* (FK → MediaType)
     6 * media_type_id* (FK → !MediaType)
    77 * genre_id* (FK → Genre)
    88 * composer
     
    2323 * **name** (NOT NULL)
    2424
    25 = MediaType =
     25= !MediaType =
    2626 * __**media_type_id**__ (PK)
    2727 * **name** (NOT NULL)
     
    5656 * company
    5757 * support_rep_id* (FK → Employee)
    58  * personal_info_id* (FK → AddressInfo)
     58 * personal_info_id* (FK → !AddressInfo)
    5959 * contact_id* (FK → Contact)
    6060
     
    6767 * **birth_date** (NOT NULL)
    6868 * **hire_date** (NOT NULL)
    69  * personal_info_id* (FK → AddressInfo)
     69 * personal_info_id* (FK → !AddressInfo)
    7070 * contact_id* (FK → Contact)
    7171