SHOP
Tables (4)
RESERVATION (Untitled3)
- reservation_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- shop_id (Field2) — INT
- reserve_date (Field3) — DATE
- reserve_time (Field4) — DATE
- status (Field5) — VARCHAR
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- shop_id (Key3) — INT — Foreign key → SHOP.shop_id — NOT NULL
REVIEW (Untitled4)
- review_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- shop_id (Field2) — INT
- rating (Field3) — INT
- content (Field4) — VARCHAR
- created_at (Field5) — DATE
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- shop_id (Key3) — INT — Foreign key → SHOP.shop_id — NOT NULL
SHOP (Untitled2)
- shop_id (Key) — INT — Primary key — NOT NULL
- owner_id (Field) — INT
- shop_name (Field2) — VARCHAR
- category (Field3) — VARCHAR
- address (Field4) — VARCHAR
- phone (Field5) — VARCHAR
USER (Untitled)
- user_id (Key) — Primary key — NOT NULL
- name (Key2) — NOT NULL
- email (Key3) — NOT NULL
- password (Key4) — NOT NULL
- phone (Key5) — NOT NULL