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