umc_week1
Tables (9)
User
- user_id — bigint — Primary key — NOT NULL
- user_password — varchar(30)
- user_name — varchar(20)
- user_phoneNum — varchar(20)
- user_gender — varchar(5)
- user_email — varchar(40)
- user_point — bigint
- user_address — varchar(40)
category
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- category_num — bigint
- food_name — ENUM("한식", " 일식" , "중식" , "양식", "치킨" , "분식", "고기/구이", "도시락", "야식(족발/보쌈)"
- 아시안푸드 — NULL
inquiry
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- inquiry_num — bigint
- inqury_name — varchar(30)
- inquiry_content — varchar(200)
- inquiry_picture — BLOB
- inquiry_answer — status`
- inquiry_answer — content`
local
- local_num — bigint — Primary key
mission
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- mission_num — bigint
- missoin_content — varchar(50)
- mission_mission — completed`
- misson_point — Inteager
notification
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- notification_num — bigint
- new_event_status — Boolean
- review_event_status — Boolean
- inquiry_history_status — Boolean
point
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- user_id2 — bigint — Foreign key → mission.user_id — NOT NULL
- mission_num — bigint — Foreign key → mission.mission_num
- point_num — bigint
- point_change — inteager
review_num
- review_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- store_num — bigint
- review_content — varchar(200)
- review_picture — BLOB
- review_gpa — double(20)
store
- store_num — bigint — Primary key
- local_num — bigint — Foreign key → local.local_num
- store_name — varchar(50)
- store_location — varchar(50)
- store_picture — BLOB — 이미지 저장 변수 BLOB