test
Tables (3)
Customer
- customer_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(30)
- email — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
Reservation
- reservation_id — BIGINT
- customer_id — BIGINT — NOT NULL
- table_id — BIGINT — NOT NULL
- reserved_from — TIMESTAMP — NOT NULL
- reserved_to — TIMESTAMP — NOT NULL
- party_size — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
RestaurantTable
- table_id — BIGINT
- table_no — VARCHAR(20) — NOT NULL
- capacity — INT — NOT NULL
- location_desc — VARCHAR(200)
- is_active — BOOLEAN — NOT NULL