화면정의서
테이블 (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