table
Tables (3)
Reservation
- reservation_id — Primary key — NOT NULL
- table_id — Foreign key → Table_Info.table_id — NOT NULL
- customer_name — VARCHAR(255) — NOT NULL
- reservation_time — TIMESTAMP — NOT NULL
- people_count — INT — NOT NULL
Restaurant
- restaurant_id — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- opening_time — TIME — NOT NULL
- closing_time — TIME — NOT NULL
Table_Info
- table_id — Primary key — NOT NULL
- restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
- capacity — INT — NOT NULL