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 (신청한시간)