Music
Tables (5)
Album (앨범)
- album_id (Key) — Bigint — Primary key — NOT NULL
- artist_id (Key3) — Bigint — Foreign key → Artist.artist_id — NOT NULL
- genre_id (Key2) — Bigint — Foreign key → Genre.genre_id — NOT NULL
- album_name (Field) — varchar(30)
- release_date (Field2) — Date
Artist (아티스트)
- artist_id (Key) — Bigint — Primary key — NOT NULL
- artist_name (Field) — varchar(30)
Favorite (즐겨찾기)
- member_id (Key) — Bigint — Foreign key → Member.member_id — NOT NULL
- genre_id (Key2) — Bigint — Foreign key → Genre.genre_id — NOT NULL
Genre (장르)
- genre_id (Key) — Bigint — Primary key — NOT NULL
- genre_name (Field) — varchar(30)
Member (회원)
- member_id (Key) — Bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- email (Field2) — varchar(40)
- phone (Field3) — varchar(30)
- password (Field4) — varchar(30)