Waiting

Tables (4)

Admin

  • id — INTEGER
  • username — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL

Customer

  • id — INTEGER
  • phone_number — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

NotificationLog

  • id — INTEGER
  • waiting_id — INTEGER — NOT NULL
  • sent_type — VARCHAR(20) — NOT NULL
  • sent_at — DATETIME — NOT NULL

Waiting

  • id — INTEGER
  • customer_id — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • position — INTEGER — NOT NULL
  • created_at — DATETIME — NOT NULL
  • notified_at — DATETIME
  • entered_at — DATETIME