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