ㅇㅇ
Tables (11)
act
- ac_num — int — Primary key — NOT NULL
- ac_at_num — int — Foreign key → artist.at_num — NOT NULL
- ac_gr_num — int — Foreign key → group.gr_num — NOT NULL
- ac_role — varchar(10)
album
- ab_num — int — Primary key — NOT NULL
- ab_title — varchar(50)
- ab_date — date
- ab_publisher — varchar(50)
- ab_agency — varchar(50)
- ab_introduce — longtext
- ab_genre — varchar(50)
- ab_gr_num — int — Foreign key → group.gr_num — NOT NULL
- ab_gr_count — varchar(10)
artist
- at_num — int — Primary key — NOT NULL
- at_name — varchar(50)
- at_birthday — date
- at_agency — varchar(50)
buy
- bu_num — int — Primary key — NOT NULL
- bu_sd_num — int — Foreign key → soundtrack.sd_num — NOT NULL
- bu_me_id — varchar(50) — Foreign key → member.me_id — NOT NULL
group
- gr_num — int — Primary key — NOT NULL
- gr_name — varchar(50)
- gr_type — varchar(10)
- gr_agency — varchar(50)
- gr_date — date
include
- in_num — int — Primary key — NOT NULL
- in_ab_num — int — Foreign key → album.ab_num — NOT NULL
- in_sd_num — int — Foreign key → soundtrack.sd_num — NOT NULL
- in_procedure — varchar(10)
- in_title — int
like
- li_num — int — Primary key — NOT NULL
- li_sd_num — int — Foreign key → soundtrack.sd_num — NOT NULL
- li_me_id — varchar(50) — Foreign key → member.me_id — NOT NULL
- li_state — int
member
- me_id — varchar(50) — Primary key — NOT NULL
- me_pw — varchar(50)
playlist
- pl_num — int — Primary key — NOT NULL
- pl_sd_num — int — Foreign key → soundtrack.sd_num — NOT NULL
- pl_me_id — varchar(50) — Foreign key → member.me_id — NOT NULL
- pl_name — varchar(50)
- pl_procedure — int
sing
- si_num — int — Primary key — NOT NULL
- si_sd_num — int — Foreign key → soundtrack.sd_num — NOT NULL
- si_gr_num — int — Foreign key → group.gr_num — NOT NULL
- si_feat — int
soundtrack
- sd_num — int — Primary key — NOT NULL
- sd_title — varchar(50)
- sd_like — int
- sd_lyrics — longtext