화면정의서

테이블 (4)

Restaurant_datail_infomation (Untitled2)

  • Restaurant_id (PK) — VARCHAR(20) — 외래 키 → Restaurant_infomation.Restaurant_id — NOT NULL
  • Restaurant_picture (Field) — VARCHAR(2500)
  • Restaurant_keyword (Field2) — BLOB
  • Restaurant_open_day (Field3) — DATE

Restaurant_infomation (Search)

  • Restaurant_id (PK) — VARCHAR(20) — 기본 키 — NOT NULL
  • Restaurant_name (Field3) — VARCHAR(20)
  • Restaurant_add (Field4) — VARCHAR(20)
  • Restaurant_point (Field5) — FLOAT
  • Restaurant_review (Field6) — VARCHAR(50)
  • Restaurant_add (Field10) — VARCHAR(20)
  • Restaurant_food_sort (Field11) — VARCHAR(10)
  • Review_pos (Field12) — NUMBER
  • Review_neg (Field13) — NUMBER

User_input (Category)

  • User_id (Field4) — VARCHAR(20) — 기본 키
  • Select_mood (Field) — VARCHAR(10)
  • Select_add (Field2) — VARCHAR(10)
  • Select_food_sort (Field3) — VARCHAR(10)

Weather_infomation (Untitled)

  • Day (Field) — DATE — 기본 키
  • Weather (Field2) — VARCHAR(10)
  • Temp_high (Field3) — FLOAT
  • Temp_low (Field4) — FLOAT