음반회사
테이블 (8)
album
- album_id — bigint
- title — varchar(200) — NOT NULL
- copyright_date — date — NOT NULL
- album_identifier — varchar(100) — NOT NULL
- format — varchar(20) — NOT NULL
- producer_ssn — varchar(11) — 외래 키 → musician.ssn — NOT NULL
house
- house_id — bigint
- address — varchar(255) — NOT NULL
- phone_number — varchar(30) — NOT NULL
instrument
- instrument_id — bigint
- name — varchar(100) — NOT NULL
- musical_key — varchar(30) — NOT NULL
musician
- ssn — varchar(11)
- name — varchar(100) — NOT NULL
- house_id — bigint — 외래 키 → house.house_id — NOT NULL
musician_instrument
- musician_ssn — varchar(11) — 외래 키 → musician.ssn — NOT NULL
- instrument_id — bigint — 외래 키 → instrument.instrument_id — NOT NULL
musician_song
- musician_ssn — varchar(11) — 외래 키 → musician.ssn — NOT NULL
- song_id — bigint — 외래 키 → song.song_id — NOT NULL
song
- song_id — bigint
- title — varchar(200) — NOT NULL
- author — varchar(200) — NOT NULL
- album_id — bigint — 외래 키 → album.album_id
song_instrument
- song_id — bigint — 외래 키 → song.song_id — NOT NULL
- instrument_id — bigint — 외래 키 → instrument.instrument_id — NOT NULL