feaw

Tables (9)

Untitled

  • id — varchar(15) — Foreign key → guest_booking.id
  • Field — VARCHAR(255)

Untitled2

  • id — varchar(15) — Foreign key → guest_booking.id
  • id2 — varchar(15)

Untitled3

  • password — varchar(15) — Foreign key → mem_booking.password
  • birth — date — Foreign key → mem_booking.birth

Untitled4

  • password — varchar(15) — Foreign key → mem_booking.password
  • birth — date — Foreign key → mem_booking.birth
  • password2 — varchar(15)
  • birth2 — date

guest

  • name — varchar(4)
  • password — varchar(15)
  • birth — date
  • phone1 — varchar(4)
  • phone2 — varchar(5)
  • phone3 — varchar(5)

guest_booking

  • id — varchar(15)
  • birth — date
  • adult — number
  • teen — number
  • seat_row — varchar(3)
  • seat_nubmer — number
  • id2 — varchar(15)

mem_booking

  • password — varchar(15)
  • birth — date
  • name — varchar(4)
  • adult — number
  • teen — number
  • seat_row — varchar(3)
  • seat_number — number
  • name2 — varchar(4)

member

  • id — varchar(15)
  • password — varchar(15)
  • birth — date
  • phone1 — varchar(4)
  • phone2 — varchar(5)
  • phone3 — varchar(5)
  • email1 — varchar(15)
  • email2 — varchar(15)
  • name — varchar(4)

notice

  • text-number — number
  • text-content — varchar(100)
  • text-date — date
  • text-name — varchar(20)
  • id — varchar(15)