camp_booking

Tables (4)

admin

  • email — VARCHAR(255) — Primary key
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)

booking

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • department — VARCHAR(100) — NOT NULL
  • start_datetime — DATETIME — NOT NULL
  • end_datetime — DATETIME — NOT NULL
  • reserved_at — DATETIME — NOT NULL

booking_setting_notice

  • id — INT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • sort_order — INT — NOT NULL

booking_setting_time_slot

  • id — INT — Primary key — NOT NULL
  • slot_name — VARCHAR(50)
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • sort_order — INT — NOT NULL