방탈출

테이블 (6)

member

  • id — BIGINT — 기본 키 — NOT NULL
  • name — BIGINT — NOT NULL
  • email — BIGINT — NOT NULL
  • password — BIGINT — NOT NULL
  • role — BIGINT
  • created_at — BIGINT
  • modified_at — BIGINT
  • deleted_at — BIGINT

payment

  • id — BIGINT — 기본 키 — NOT NULL
  • payment_key — VARCHAR(255)
  • order_id — VARCHAR(255)
  • amount — INTEGER
  • payment_type — VARCHAR(255)
  • status — VARCHAR(10)
  • created_at — TIMESTAMP(6)
  • modified_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

reservation

  • id (reservation_id) — BIGINT — 기본 키 — NOT NULL
  • date — DATE — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • payment_id — BIGINT — 외래 키 → payment.id — NOT NULL
  • reservation_time_id — BIGINT — 외래 키 → reservation_time.id — NOT NULL
  • theme_id — BIGINT — 외래 키 → theme.id — NOT NULL
  • created_at — TIMESTAMP(6)
  • modified_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

reservation_time

  • id — BIGINT — 기본 키 — NOT NULL
  • start_at — BIGINT — NOT NULL
  • created_at — BIGINT
  • modified_at — BIGINT
  • deleted_at — BIGINT

theme

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • thumbnail — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP(6)
  • modified_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

waiting

  • id — BIGINT — 기본 키 — NOT NULL
  • date — BIGINT — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • reservation_time_id — BIGINT — 외래 키 → reservation_time.id — NOT NULL
  • theme_id — BIGINT — 외래 키 → theme.id — NOT NULL
  • created_at — BIGINT
  • modified_at — BIGINT
  • deleted_at — BIGINT