karaoke
Tables (6)
members (Untitled)
- member_ID (Key) — string — Primary key — NOT NULL
- name (Field) — string
- password (Field2) — string
- available_songs (Field3) — int
- admin (Field4) — boolean
requests (Untitled3)
- request_ID (Key) — string — Primary key — NOT NULL
- member_ID (Key2) — string — Foreign key → members.member_ID — NOT NULL
- requester (Field) — string
- title (Field2) — string
- genre (Field3) — string
- singer (Field4) — string
sing (Untitled4)
- sing_ID (Key) — string — Primary key — NOT NULL
- member_ID (Key2) — string — Foreign key → members.member_ID — NOT NULL
- song_ID (Field2) — string
- sing_time (Field3) — time
song (Untitled6)
- song_ID (Key) — Primary key — NOT NULL
- sing_ID (Key2) — string — Foreign key → sing.sing_ID — NOT NULL
- member_ID (Key22) — string — Foreign key → sing.member_ID — NOT NULL
- title (Field) — string
- genre (Field2) — string
- singer (Field3) — string
- count (Field4) — int
voucher_record (Untitled2)
- buy_ID (Field3) — string — Primary key
- member_ID (Key3) — string — Foreign key → members.member_ID — NOT NULL
- voucher_ID (Key2) — string — Foreign key → vouchers.voucher_ID — NOT NULL
- bought_time (Field) — time
- num_songs (Field2) — int
- price (Field4) — int
vouchers (Untitled5)
- voucher_ID (Key) — string — Primary key — NOT NULL
- member_ID (Key2) — string — Foreign key → members.member_ID — NOT NULL
- num_songs (Field4) — int