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