artist_2

Tables (7)

Artist_Group

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → Group.id — NOT NULL
  • singer_id — INT — Foreign key → Singer.id — NOT NULL
  • singer_link — VARCHAR(255) — NOT NULL
  • enter_id — INT — Foreign key → Entertainment.id — NOT NULL
  • singer_type — ENUM('SOLO', 'GROUP') — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Artist_SNS

  • id — INT — Primary key — NOT NULL
  • singer_id — INT — Foreign key → Singer.id — NOT NULL
  • link_url — VARCHAR(255) — NOT NULL
  • platform — ENUM('INSTAGRAM', 'TIKTOK', 'YOUTUBE', 'X') — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Entertainment

  • id — INT — Primary key — NOT NULL
  • enter_name — VARCHAR(50) — NOT NULL
  • owner — VARCHAR(15)
  • founded — DATE
  • size — ENUM('SMALL', 'NORMAL', 'LARGE')
  • updated_at — DATETIME — NOT NULL

Group

  • id — INT — Primary key — NOT NULL
  • group_name — VARCHAR(25) — NOT NULL
  • group_debut_date — DATE — NOT NULL
  • fandom — VARCHAR(255)
  • sns — JSON
  • enter_id — INT — Foreign key → Entertainment.id — NOT NULL
  • group_type — VARCHAR(255) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

GroupSNS

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → Group.id — NOT NULL
  • link_url — VARCHAR(255) — NOT NULL
  • platform — ENUM('INSTAGRAM', 'TIKTOK', 'YOUTUBE', 'X') — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Singer

  • id — INT — Primary key — NOT NULL
  • singer_link — VARCHAR(255) — NOT NULL
  • birth_date — DATE — NOT NULL
  • singer_name — VARCHAR(15) — NOT NULL
  • birth_name — VARCHAR(20)
  • enter_id — INT — Foreign key → Entertainment.id — NOT NULL
  • description — TEXT
  • debut — DATE — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Solo

  • id — INT — Primary key — NOT NULL
  • singer_id — INT — Foreign key → Singer.id — NOT NULL
  • solo_debut_date — DATE
  • updated_at — TIMESTAMP — NOT NULL