Changes between Version 6 and Version 7 of ddl


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

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v6 v7  
    22= Track =
    33 * __**track_id**__ (PK)
    4  * **name** (NOT NULL)
     4 * **name**
    55 * album_id* (FK → Album)
    66 * media_type_id* (FK → !MediaType)
    77 * genre_id* (FK → Genre)
    88 * composer
    9  * **milliseconds** (NOT NULL)
    10  * **bytes** (NOT NULL)
     9 * **milliseconds**
     10 * **bytes**
    1111
    1212= Album =
    1313 * __**album_id**__ (PK)
    14  * **title** (NOT NULL)
     14 * **title**
    1515 * artist_id* (FK → Artist)
    1616
    1717= Artist =
    1818 * __**artist_id**__ (PK)
    19  * **name** (NOT NULL)
     19 * **name**
    2020
    2121= Genre =
    2222 * __**genre_id**__ (PK)
    23  * **name** (NOT NULL)
     23 * **name**
    2424
    2525= !MediaType =
    2626 * __**media_type_id**__ (PK)
    27  * **name** (NOT NULL)
     27 * **name**
    2828
    2929= Price =
    3030 * __**price_id**__ (PK)
    31  * **value** (NOT NULL)
    32  * **date** (NOT NULL)
     31 * **value**
     32 * **date**
    3333 * track_id* (FK → Track)
    3434
    … …  
    3737 * invoice_id* (FK → Invoice)
    3838 * track_id* (FK → Track)
    39  * **quantity** (NOT NULL)
     39 * **quantity**
    4040
    4141= Invoice =
    … …  
    6161= Employee =
    6262 * __**employee_id**__ (PK)
    63  * **first_name** (NOT NULL)
    64  * **last_name** (NOT NULL)
    65  * **title** (NOT NULL)
     63 * **first_name**
     64 * **last_name**
     65 * **title**
    6666 * reports_to* (FK → Employee)
    67  * **birth_date** (NOT NULL)
    68  * **hire_date** (NOT NULL)
     67 * **birth_date**
     68 * **hire_date**
    6969 * personal_info_id* (FK → !AddressInfo)
    7070 * contact_id* (FK → Contact)
    … …  
    7272= !AddressInfo =
    7373 * __**address_info_id**__ (PK)
    74  * **address** (NOT NULL)
    75  * **city** (NOT NULL)
     74 * **address**
     75 * **city**
    7676 * state
    77  * **country** (NOT NULL)
    78  * **postal_code** (NOT NULL)
     77 * **country**
     78 * **postal_code**
    7979
    8080= Contact =
    8181 * __**contact_id**__ (PK)
    82  * **phone** (NOT NULL)
     82 * **phone**
    8383 * fax
    84  * **email** (NOT NULL)
     84 * **email**
    8585
    8686= Playlist =
    8787 * __**playlist_id**__ (PK)
    88  * **name** (NOT NULL)
     88 * **name**
    8989
    9090= !PlaylistTrack =