wooteco-roomescape

Tables (5)

Member (member)

  • pk (id) — BIG INT — Primary key — NOT NULL
  • email — VARCHAR
  • password — VARCHAR
  • name — VARCHAR
  • role — VARCHAR

Payment (payment)

  • pk (id) — BIG INT — Primary key — NOT NULL
  • paymentKey (payment_key) — VARCHAR
  • orderId (order_id) — VARCHAR
  • totalAmount (total_amount) — BIG INT
  • reservation (reservation_id) — BIG INT — Foreign key → Reservation.pk — NOT NULL
  • company — VARCHAR

Reservation (reservation)

  • pk (id) — BIG INT — Primary key — NOT NULL
  • date — DATE
  • status — VARCHAR
  • theme (theme_id) — BIG INT — Foreign key → Theme.pk — NOT NULL
  • time (time_id) — BIG INT — Foreign key → ReservationTime.pk — NOT NULL
  • member (member_id) — BIG INT — Foreign key → Member.pk — NOT NULL

ReservationTime (reservation_time)

  • pk (id) — BIG INT — Primary key — NOT NULL
  • startAt (start_at) — TIME

Theme (theme)

  • pk (id) — BIG INT — Primary key — NOT NULL
  • name — VARCHAR