gsmJukeBox

Tables (3)

User

  • number (학번) — Primary key — NOT NULL
  • name (이름)
  • pwd (비밀번호)
  • sndpwd (admin2차비번)

playtime

  • idx (Key) — Primary key — NOT NULL
  • starttime (재생시작시간)
  • closetime (재생종료시간)

reservedsong

  • number (학번) — Foreign key → User.number — NOT NULL
  • songtitle (노래 제목)
  • songurl (유튜브url)
  • registertime (신청한시간)