Changes between Version 23 and Version 24 of ddl


Ignore:
Timestamp:
09/24/25 21:58:16 (13 days ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v23 v24  
    1212 * genre_id* (FK → Genre)
    1313 * composer
    14  * milliseconds 
    15  * bytes 
     14 * milliseconds
     15 * bytes
    1616
    1717= Album =
    1818 * __**album_id**__ (PK)
    1919 * **title**
    20  * **artist_id*** (FK → Artist) → Artist)
     20 * **artist_id*** (FK → Artist)
    2121
    2222= Artist =
    … …  
    2626= Genre =
    2727 * __**genre_id**__ (PK)
    28  * genre_name 
     28 * genre_name
    2929
    3030= !MediaType =
    3131 * __**media_type_id**__ (PK)
    32  * media_type_name 
     32 * media_type_name
    3333
    3434= Price =
    3535 * __**price_id**__ (PK)
    36  * value
    37  * date
    38  * track_id* (FK → Track)
     36 * **value**
     37 * **date**
     38 * **track_id*** (FK → Track)
    3939
    4040= !InvoiceLine =
    4141 * __**invoice_line_id**__ (PK)
    42  * invoice_id* (FK → Invoice)
    43  * track_id* (FK → Track)
    44  * unit_price
    45  * quantity
     42 * **invoice_id*** (FK → Invoice)
     43 * **track_id*** (FK → Track)
     44 * **unit_price**
     45 * **quantity**
    4646
    4747= Invoice =
    4848 * __**invoice_id**__ (PK)
    49  * customer_id* (FK → Customer)
    50  * invoice_date
     49 * **customer_id*** (FK → Customer)
     50 * **invoice_date**
    5151 * billing_address
    5252 * billing_city
    … …  
    5454 * billing_country
    5555 * billing_postal_code
    56  * total 
     56 * total
    5757
    5858= Customer =
    5959 * __**customer_id**__ (PK)
    60  * customer_first_name
    61  * customer_last_name
     60 * **customer_first_name**
     61 * **customer_last_name**
    6262 * company
    6363 * support_rep_id* (FK → Employee)
    … …  
    6767= Employee =
    6868 * __**employee_id**__ (PK)
    69  * employee_first_name
    70  * employee_last_name
     69 * **employee_first_name**
     70 * **employee_last_name**
    7171 * title
    7272 * reports_to* (FK → Employee)
    73  * birth_date** 
    74  * hire_date** 
     73 * birth_date**
     74 * hire_date**
    7575 * contact_id* (FK → Contact)
    7676 * address_info_id* (FK → !AddressInfo)
    7777
    7878= !AddressInfo =
    79  * _**address_info_id**__ (PK) 
     79 * _**address_info_id**__ (PK)
    8080 * address
    8181 * city
    … …  
    8484 * postal_code
    8585
    86 = Contact = 
     86= Contact =
    8787 * __**contact_id**__ (PK)
    8888 * phone
    … …  
    9595
    9696= !PlaylistTrack =
    97  * __**playlist_track_id**__ (PK)
    98  * playlist_id* (FK → Playlist)
    99  * track_id* (FK → Track)
     97 * **playlist_id*** (FK → Playlist) (PK)
     98 * **track_id*** (FK → Track) (PK)
    10099
    101100== DDL и DML скрипти: ==