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