restaurant
Tables (3)
restaurant (Untitled)
- restaurant_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- address (Field2) — varchar
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
restaurant_menu (Untitled2)
- restaurant_menu_id (Key) — int — Primary key — NOT NULL
- name (Field) — varchar
- price (Field2) — int
- created_at (Field3) — timestamp
- updated_at (Field4) — timestamp
- restaurant_id (Key2) — int — Foreign key → restaurant.restaurant_id — NOT NULL
review (Untitled3)
- review_id (Key) — int — Primary key — NOT NULL
- content (Field) — varchar
- score (Field2) — double
- created_at (Field3) — timestamp
- Field4
- restaurant_id (Key2) — int — Foreign key → restaurant.restaurant_id — NOT NULL