Changes between Version 24 and Version 25 of ddl


Ignore:
Timestamp:
09/24/25 22:00:04 (13 days ago)
Author:
221046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ddl

    v24 v25  
    55 - Останати атрибути: без ознака
    66== Релации: ==
     7
     8= Artist =
     9 * __**artist_id**__ (PK)
     10 * artist_name
     11
     12= Album =
     13 * __**album_id**__ (PK)
     14 * **title**
     15 * **artist_id*** (FK → Artist)
     16
    717= Track =
    818 * __**track_id**__ (PK)
    … …  
    1525 * bytes
    1626
    17 = Album =
    18  * __**album_id**__ (PK)
    19  * **title**
    20  * **artist_id*** (FK → Artist)
     27= Playlist =
     28 * __**playlist_id**__ (PK)
     29 * name
    2130
    22 = Artist =
    23  * __**artist_id**__ (PK)
    24  * artist_name
    25 
    26 = Genre =
    27  * __**genre_id**__ (PK)
    28  * genre_name
    29 
    30 = !MediaType =
    31  * __**media_type_id**__ (PK)
    32  * media_type_name
     31= !PlaylistTrack =
     32 * **playlist_id*** (FK → Playlist) (PK)
     33 * **track_id*** (FK → Track) (PK)
    3334
    3435= Price =
    … …  
    3738 * **date**
    3839 * **track_id*** (FK → Track)
     40
     41= !MediaType =
     42 * __**media_type_id**__ (PK)
     43 * media_type_name
     44
     45= Genre =
     46 * __**genre_id**__ (PK)
     47 * genre_name
    3948
    4049= !InvoiceLine =
    … …  
    9099 * email
    91100
    92 = Playlist =
    93  * __**playlist_id**__ (PK)
    94  * name
    95 
    96 = !PlaylistTrack =
    97  * **playlist_id*** (FK → Playlist) (PK)
    98  * **track_id*** (FK → Track) (PK)
    99 
    100101== DDL и DML скрипти: ==
    101102 * [attachment:primary_ddl.sql DDL Скрипта]