Changes between Version 5 and Version 6 of ddl
- Timestamp:
- 09/02/25 19:46:47 (8 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ddl
v5 v6 4 4 * **name** (NOT NULL) 5 5 * album_id* (FK → Album) 6 * media_type_id* (FK → MediaType)6 * media_type_id* (FK → !MediaType) 7 7 * genre_id* (FK → Genre) 8 8 * composer … … 23 23 * **name** (NOT NULL) 24 24 25 = MediaType =25 = !MediaType = 26 26 * __**media_type_id**__ (PK) 27 27 * **name** (NOT NULL) … … 56 56 * company 57 57 * support_rep_id* (FK → Employee) 58 * personal_info_id* (FK → AddressInfo)58 * personal_info_id* (FK → !AddressInfo) 59 59 * contact_id* (FK → Contact) 60 60 … … 67 67 * **birth_date** (NOT NULL) 68 68 * **hire_date** (NOT NULL) 69 * personal_info_id* (FK → AddressInfo)69 * personal_info_id* (FK → !AddressInfo) 70 70 * contact_id* (FK → Contact) 71 71