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