/
Zero1l
/
121
Обзор
Документация
Войти
/
Zero1l
/
121
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
README.py
54 строки
1 KB
Zero1l
update README.py
21 дек 2025, 09:42
21 дек 2025, 09:42
cb1bd90
Код
Авторство
О чём код?
# 123 CREATE TABLE artists ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL ); CREATE TABLE genres ( id SERIAL PRIMARY KEY, name VARCHAR(100) NOT NULL ); CREATE TABLE artist_genres ( artist_id INT REFERENCES artists(id) ON DELETE CASCADE, genre_id INT REFERENCES genres(id) ON DELETE CASCADE, PRIMARY KEY (artist_id, genre_id) ); CREATE TABLE albums ( id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, release_year INT ); CREATE TABLE album_artists ( album_id INT REFERENCES albums(id) ON DELETE CASCADE, artist_id INT REFERENCES artists(id) ON DELETE CASCADE, PRIMARY KEY (album_id, artist_id) ); CREATE TABLE tracks ( id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, album_id INT REFERENCES albums(id) ON DELETE CASCADE ); CREATE TABLE compilations ( id SERIAL PRIMARY KEY, title VARCHAR(255) NOT NULL, release_year INT ); CREATE TABLE compilation_tracks ( compilation_id INT REFERENCES compilations(id) ON DELETE CASCADE, track_id INT REFERENCES tracks(id) ON DELETE CASCADE, PRIMARY KEY (compilation_id, track_id) docker-compose up