Changes between Version 19 and Version 20 of ddl
- Timestamp:
- 09/24/25 21:47:17 (13 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ddl
v19 v20 12 12 * genre_id* (FK → Genre) 13 13 * composer 14 * **milliseconds**15 * **bytes**14 * milliseconds 15 * bytes 16 16 17 17 = Album = … … 22 22 = Artist = 23 23 * __**artist_id**__ (PK) 24 * **artist_name**24 * artist_name 25 25 26 26 = Genre = 27 27 * __**genre_id**__ (PK) 28 * **genre_name**28 * genre_name 29 29 30 30 = !MediaType = 31 31 * __**media_type_id**__ (PK) 32 * **media_type_name**32 * media_type_name 33 33 34 34 = Price = 35 35 * __**price_id**__ (PK) 36 * **value**37 * **date**36 * value 37 * date 38 38 * track_id* (FK → Track) 39 39 … … 43 43 * track_id* (FK → Track) 44 44 * unit_price 45 * **quantity**45 * quantity 46 46 47 47 = Invoice = … … 58 58 = Customer = 59 59 * __**customer_id**__ (PK) 60 * **fcustomer_first_name**61 * **customer_last_name**60 * customer_first_name 61 * customer_last_name 62 62 * company 63 63 * support_rep_id* (FK → Employee) 64 * **contact_id*** (FK → Contact)65 * **address_info_id*** (FK → !AddressInfo)64 * contact_id* (FK → Contact) 65 * address_info_id* (FK → !AddressInfo) 66 66 67 67 = Employee = 68 68 * __**employee_id**__ (PK) 69 * **employee_first_name**70 * **employee_last_name**71 * **title**69 * employee_first_name 70 * employee_last_name 71 * title 72 72 * reports_to* (FK → Employee) 73 * **birth_date**74 * **hire_date**75 * **contact_id*** (FK → Contact)76 * **address_info_id*** (FK → !AddressInfo)73 * birth_date** 74 * hire_date** 75 * contact_id* (FK → Contact) 76 * address_info_id* (FK → !AddressInfo) 77 77 78 78 = !AddressInfo = 79 79 * _**address_info_id**__ (PK) 80 * **address**81 * **city**82 * **state**83 * **country**84 * **postal_code**80 * address 81 * city 82 * state 83 * country 84 * postal_code 85 85 86 86 = Contact = 87 87 * __**contact_id**__ (PK) 88 * **phone**89 * **fax**90 * **email**88 * phone 89 * fax 90 * email 91 91 92 92 = Playlist =
