2026-01-28_erd_prac

Tables (6)

Albums (음반)

  • album_id (PK) — BIGINT — Primary key — NOT NULL
  • artist_id (FK) — BIGINT — Foreign key → Artists.artist_id — NOT NULL
  • group_id (Key) — BIGINT — Foreign key → Artists.group_id — NOT NULL
  • Genre_id (PK2) — BIGINT — Foreign key → Genre_master.Genre_id — NOT NULL
  • album_type (Field) — VARCHAR
  • album_name (Field2) — VARCHAR
  • album_reg_date (Field3) — TIMESTAMP
  • album_info (Field4) — VARCHAR

Artist_Group (아티스트_그룹)

  • group_id (PK) — BIGINT — Primary key — NOT NULL
  • group_name (그룹명) — VARCHAR
  • group_agency (그룹 소속사) — VARCHAR
  • group_info (그룹 정보) — VARCHAR
  • group_type (어떤 그룹) — VARCHAR
  • group_status (활동상태) — VARCHAR
  • group_reg_date (그룹데뷔일) — VARCHAR

Artists (아티스트)

  • artist_id (PK) — BIGINT — Primary key — NOT NULL
  • group_id (Key) — BIGINT — Foreign key → Artist_Group.group_id — NOT NULL
  • artist_status (Field) — VARCHAR
  • artist_name (Field2) — VARCHAR
  • artist_reg_date (Field4) — TIMESTAMP
  • artist_info (Field5) — VARCHAR

Genre_master (장르)

  • Genre_id (PK) — BIGINT — Primary key — NOT NULL
  • genre_name (Field) — VARCHAR

Song_artists (song_singer중계)

  • songo_artists_id (PK) — BIGINT — Primary key — NOT NULL
  • album_id (FK1) — BIGINT — Foreign key → Albums.album_id — NOT NULL
  • artist_id (FK2) — BIGINT — Foreign key → Albums.artist_id — NOT NULL
  • group_id (FK3) — BIGINT — Foreign key → Albums.group_id — NOT NULL
  • Genre_id (FK4) — BIGINT — Foreign key → Albums.Genre_id — NOT NULL
  • role (Field)

Songs (노래)

  • song_id (PK) — BIGINT — Primary key — NOT NULL
  • album_id (FK1) — BIGINT — Foreign key → Albums.album_id — NOT NULL
  • artist_id (FK2) — BIGINT — Foreign key → Albums.artist_id — NOT NULL
  • group_id (Key) — BIGINT — Foreign key → Albums.group_id — NOT NULL
  • Genre_id (PK2) — BIGINT — Foreign key → Albums.Genre_id — NOT NULL
  • song_name (Field) — VARCHAR
  • song_info (Field2) — VARCHAR
  • song_type (Field3) — VARCHAR
  • song_length (Field4) — VARCHAR
  • song_reg_date (Field5) — TIMESTAMP