ㅇㅇ

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