/
Danis_py
/
Advanced_data_sampling
Обзор
Документация
Войти
/
Danis_py
/
Advanced_data_sampling
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
Create.sql
45 строк
1 KB
Danis_py
upload files
08 дек 2025, 12:15
08 дек 2025, 12:15
f4521d7
Код
Авторство
О чём код?
create table Genres ( genre_id integer primary key, name varchar(20) not null ); create table Artists ( artist_id integer primary key, name varchar(30) not null ); create table Albums ( album_id integer primary key, name varchar(30) not null, release_year integer not null check (release_year >= 2000)); create table Tracks ( track_id integer primary key, album_id integer not null, name varchar(30) not null, duration integer not null check (duration <= 600), foreign key (album_id) references Albums(album_id)); create table Artist_genre ( artist_genre_id integer primary key, artist_id integer not null, genre_id integer not null, foreign key (artist_id) references Artists(artist_id), foreign key (genre_id) references Genres(genre_id)); create table Artist_album ( artist_album_id integer primary key, artist_id integer not null, album_id integer not null, foreign key (artist_id) references Artists(artist_id), foreign key (album_id) references Albums(album_id)); create table Collection ( collection_id integer primary key, name varchar(30), release_year integer not null check (release_year >= 2000)); create table Collection_track ( coll_tr_id integer primary key, collection_id integer not null, track_id integer not null, foreign key (collection_id) references collection(collection_id), foreign key (track_id) references Tracks(track_id));