/
valek
/
homework-SQL-advanced-select
Обзор
Документация
Войти
/
valek
/
homework-SQL-advanced-select
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
task
46 строк
1 KB
valek
update task
18 янв 2026, 21:37
Верифицирован
18 янв 2026, 21:37
3827241
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS Singers ( id serial PRIMARY KEY, name varchar(60) NOT NULL ); CREATE TABLE IF NOT EXISTS Genres ( id serial PRIMARY KEY, name varchar(60) NOT NULL ); CREATE TABLE IF NOT EXISTS Albums ( id serial PRIMARY KEY, title varchar(60) NOT NULL, release_year integer NOT NULL ); CREATE TABLE IF NOT EXISTS Tracks ( id serial PRIMARY KEY, title varchar(60) NOT NULL, duration time NOT NULL, album_id integer REFERENCES Albums(id) ); CREATE TABLE IF NOT EXISTS Collections ( id serial PRIMARY KEY, title varchar(60) NOT NULL, release_year integer NOT NULL ); CREATE TABLE IF NOT EXISTS SingersAlbums ( singer_id integer NOT NULL REFERENCES Singers(id), album_id integer NOT NULL REFERENCES Albums(id), CONSTRAINT pk PRIMARY KEY (singer_id, album_id) ); CREATE TABLE IF NOT EXISTS CollectionsTracks ( collection_id integer NOT NULL REFERENCES Collections(id), track_id integer NOT NULL REFERENCES Tracks(id), CONSTRAINT pk1 PRIMARY KEY (collection_id, track_id) ); CREATE TABLE IF NOT EXISTS SingersGenres ( singer_id integer NOT NULL REFERENCES Singers(id), genre_id integer NOT NULL REFERENCES Genres(id), CONSTRAINT pk2 PRIMARY KEY (singer_id, genre_id) );