음반회사

테이블 (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