Changes between Version 2 and Version 3 of ddl


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

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v2 v3  
    1 **Track** ( track_id, name, album_id* (Album), media_type_id* (MediaType), genre_id* (Genre), composer, milliseconds, bytes )
     1Track ( track_id, name, album_id* (Album), media_type_id* (MediaType), genre_id* (Genre), composer, milliseconds, bytes )
    22
    33Album ( album_id, title, artist_id* (Artist) )
    … …  
    77Genre ( genre_id, name )
    88
    9 MediaType ( media_type_id, name )
     9!MediaType ( media_type_id, name )
    1010
    1111Price ( price_id, value, date, track_id* (Track) )
    1212
    13 InvoiceLine ( invoice_line_id, invoice_id* (Invoice), track_id* (Track), quantity )
     13!InvoiceLine ( invoice_line_id, invoice_id* (Invoice), track_id* (Track), quantity )
    1414
    1515Invoice ( invoice_id, customer_id* (Customer), invoice_date, billing_address, billing_city, billing_state, billing_country, billing_postal_code, total )
    … …  
    1919Employee ( employee_id, first_name, last_name, title, reports_to* (Employee), birth_date, hire_date, personal_info_id* (AddressInfo), contact_id* (Contact) )
    2020
    21 AddressInfo ( address_info_id, address, city, state, country, postal_code )
     21!AddressInfo ( address_info_id, address, city, state, country, postal_code )
    2222
    2323Contact ( contact_id, phone, fax, email )
    … …  
    2525Playlist ( playlist_id, name )
    2626
    27 PlaylistTrack ( playlist_track_id, playlist_id* (Playlist), track_id* (Track) )
     27!PlaylistTrack ( playlist_track_id, playlist_id* (Playlist), track_id* (Track) )