roomescape-payment

Tables (5)

reservation_times

  • id — BIGINT — Primary key — NOT NULL
  • start_at — TIME

reservations

  • id — BIGINT — Primary key — NOT NULL
  • date — DATE
  • total_amount — INT
  • theme_id — BIGINT — NOT NULL
  • time_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • payment_key — VARCHAR(255)

themes

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

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(10)

waiting_reservations

  • id — BIGINT — Primary key — NOT NULL
  • date — DATE
  • total_amount — INT
  • waiting_order — INT
  • theme_id — BIGINT — NOT NULL
  • time_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • payment_key — VARCHAR(255)