test

Tables (7)

account

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

member

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255)

payment

  • id — BIGINT
  • amount — BIGINT
  • payment_key — VARCHAR(255)

reservation

  • id — BIGINT
  • reservation_date — DATE — NOT NULL
  • member_id — BIGINT
  • payment_id — BIGINT
  • theme_id — BIGINT
  • time_id — BIGINT

reservation_time

  • id — BIGINT
  • start_at — TIME(6)

theme

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

waiting

  • id — BIGINT
  • reservation_date — DATE — NOT NULL
  • created_at — TIMESTAMP(6) — NOT NULL
  • member_id — BIGINT
  • theme_id — BIGINT
  • time_id — BIGINT