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