roomescape

Tables (6)

member

  • id — BIGINT — Primary key
  • email — VARCHAR(320) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • session_id — VARCHAR(255)
  • role — ENUM('ADMIN', 'USER') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payment

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

reservation

  • id — BIGINT — Primary key
  • reservation_status — ENUM('PENDING', 'ACCEPTED', 'DENIED') — NOT NULL
  • id (reservation_item_id) — BIGINT — Foreign key → reservation_item.id
  • id (member_id) — BIGINT — Foreign key → member.id

reservation_item

  • id — BIGINT — Primary key
  • Key (reservation_theme_id) — BIGINT — Foreign key → reservation_theme.Key — NOT NULL
  • id (reservation_time_id) — BIGINT — Foreign key → reservation_time.id
  • date — DATE — NOT NULL

reservation_theme

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

reservation_time

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