wooteco-lv2-roomescape

Tables (7)

account

  • id — BIGINT — Primary key
  • password — VARCHAR(255)
  • member_id — BIGINT — Foreign key → member.id

member

  • id — BIGINT — Primary key
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • role — ENUM

payment_history

  • id — BIGINT — Primary key
  • amount — INTEGER — NOT NULL
  • order_id — VARCHAR(255)
  • payment_key — VARCHAR(255)
  • status — ENUM
  • reservation_id — BIGINT — Foreign key → reservation.id

reservation

  • id — BIGINT — Primary key
  • reservation_date — DATE
  • time_id — BIGINT — Foreign key → reservation_time.id
  • theme_id — BIGINT — Foreign key → theme.id
  • member_id — BIGINT — Foreign key → member.id

reservation_time

  • id — BIGINT — Primary key
  • start_at — TIME(6)

reservation_wait

  • id — BIGINT — Primary key
  • reservation_date — DATE
  • time_id — BIGINT — Foreign key → reservation_time.id
  • member_id — BIGINT — Foreign key → member.id
  • theme_id — BIGINT — Foreign key → theme.id

theme

  • id — BIGINT — Primary key
  • name — VARCHAR(255)
  • description — VARCHAR(255)
  • thumbnail — VARCHAR(255)