/
VladimirMakarov88
/
PostgresSQL_homework
Обзор
Документация
Войти
/
VladimirMakarov88
/
PostgresSQL_homework
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
CREATE_scripts.sql
53 строки
1 KB
VladimirMakarov88
upload files
19 янв 2026, 20:36
Верифицирован
19 янв 2026, 20:36
a01139e
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS Genres ( genres_id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL ); CREATE TABLE IF NOT EXISTS Artists ( artists_id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL ); CREATE TABLE IF NOT EXISTS Albums ( albums_id SERIAL PRIMARY KEY, title_name VARCHAR(255) NOT NULL, year INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS Tracks ( tracks_id SERIAL PRIMARY KEY, track_name VARCHAR(255) NOT NULL, length INTEGER NOT NULL, albums_id INTEGER REFERENCES Albums(albums_id) ON DELETE CASCADE ); CREATE TABLE IF NOT EXISTS Collections ( collections_id SERIAL PRIMARY KEY, collections_name VARCHAR(255) NOT NULL, year INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS Genres_Artists ( artists_id INTEGER REFERENCES Artists(artists_id) ON DELETE CASCADE, genres_id INTEGER REFERENCES Genres(genres_id) ON DELETE CASCADE, PRIMARY KEY (artists_id, genres_id) ); CREATE TABLE IF NOT EXISTS Albums_Artists ( albums_id INTEGER REFERENCES Albums(albums_id) ON DELETE CASCADE, artists_id INTEGER REFERENCES Artists(artists_id) ON DELETE CASCADE, PRIMARY KEY (albums_id, artists_id) ); CREATE TABLE IF NOT EXISTS Collections_Tracks ( collections_id INTEGER REFERENCES Collections(collections_id) ON DELETE CASCADE, tracks_id INTEGER REFERENCES Tracks(tracks_id) ON DELETE CASCADE, PRIMARY KEY (collections_id, tracks_id) );