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