Changes between Initial Version and Version 1 of ddl


Ignore:
Timestamp:
09/02/25 19:43:17 (33 hours ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ddl

    v1 v1  
     1Track ( track_id, name, album_id* (Album), media_type_id* (MediaType), genre_id* (Genre), composer, milliseconds, bytes )
     2
     3Album ( album_id, title, artist_id* (Artist) )
     4
     5Artist ( artist_id, name )
     6
     7Genre ( genre_id, name )
     8
     9MediaType ( media_type_id, name )
     10
     11Price ( price_id, value, date, track_id* (Track) )
     12
     13InvoiceLine ( invoice_line_id, invoice_id* (Invoice), track_id* (Track), quantity )
     14
     15Invoice ( invoice_id, customer_id* (Customer), invoice_date, billing_address, billing_city, billing_state, billing_country, billing_postal_code, total )
     16
     17Customer ( customer_id, first_name, last_name, company, support_rep_id* (Employee), personal_info_id* (AddressInfo), contact_id* (Contact) )
     18
     19Employee ( employee_id, first_name, last_name, title, reports_to* (Employee), birth_date, hire_date, personal_info_id* (AddressInfo), contact_id* (Contact) )
     20
     21AddressInfo ( address_info_id, address, city, state, country, postal_code )
     22
     23Contact ( contact_id, phone, fax, email )
     24
     25Playlist ( playlist_id, name )
     26
     27PlaylistTrack ( playlist_track_id, playlist_id* (Playlist), track_id* (Track) )