final_project

Tables (5)

CODEZIP (Untitled5)

  • code (Key) — Primary key — NOT NULL
  • text (Field)

FOOD_INFO (Untitled3)

  • food (Key) — Primary key — NOT NULL
  • info (Field)
  • ingredients (Field2)
  • taboo (Field3)

RESTAURANT_INFO (restaurnat_info)

  • id — int — Primary key — NOT NULL
  • food — varchar(255) — Foreign key → FOOD_INFO.food — NOT NULL
  • store_name — varchar
  • addr — varchar
  • tel — varchar
  • x — float
  • y — float

REVIEW_RANK (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • res_id (Key2) — Foreign key → RESTAURANT_INFO.id — NOT NULL
  • code (Key3) — Foreign key → CODEZIP.code — NOT NULL
  • cnt (Field3)

REVIEW_VISITOR (visitor_review)

  • id — Primary key — NOT NULL
  • id (res_id) — int — Foreign key → RESTAURANT_INFO.id — NOT NULL
  • visitor_review — varchar