123

Tables (5)

codezip (Untitled2)

  • code (Key) — Primary key — NOT NULL
  • code (Key3) — Foreign key → review_rank.code — NOT NULL
  • text (Field)

food_info (Untitled4)

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

restaurant_list (restaurnat)

  • id (Key) — Primary key — NOT NULL
  • food (Key2) — Foreign key → food_info.food — NOT NULL
  • id (Key3) — Foreign key → review_rank.id — NOT NULL
  • store_name (Field2)
  • addr (Field3)
  • tel (Field4)
  • x (Field)
  • y (Field5)

review_rank (Untitled)

  • id (Key) — Primary key — NOT NULL
  • code (Key3) — Primary key — NOT NULL
  • cnt (Field2)

review_visitor (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • res_id (Key2) — Foreign key → restaurant_list.id — NOT NULL
  • id (Key3) — Foreign key → restaurant_list.id — NOT NULL
  • visitor_review (Field)