roomescape

Tables (7)

member

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • store_id — BIGINT — Foreign key → store.id

reservation

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • date — VARCHAR(255) — NOT NULL
  • time_id — BIGINT — Foreign key → reservation_time.id — NOT NULL
  • theme_id — BIGINT — Foreign key → theme.id — NOT NULL
  • store_id — BIGINT — Foreign key → store.id — NOT NULL

reservation_history

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • date — VARCHAR(255) — NOT NULL
  • time_id — BIGINT — NOT NULL
  • theme_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • actor_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

reservation_time

  • id — BIGINT — Primary key — NOT NULL
  • start_at — VARCHAR(255) — NOT NULL

reservation_wait

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_at — TIMESTAMP

store

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

theme

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