umc_week1_2
Tables (9)
category
- category_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- food_name — ENUM('한식', '일식', '중식', '양식', '치킨', '분식', '고기/구이', '도시락', '야식(족발/보쌈)'
- 아시안푸드) — NULL
inquiry
- inquiry_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- inquiry_name — varchar(30)
- inquiry_content — varchar(200)
- inquiry_picture — BLOB
- inquiry_answer_status — BOOLEAN
- inquiry_answer_content — varchar(200)
local
- local_num — bigint — Primary key — NOT NULL
mission
- mission_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- mission_content — varchar(50)
- mission_completed — BOOLEAN
- mission_point — INTEGER
notification
- notification_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- new_event_status — BOOLEAN
- review_event_status — BOOLEAN
- inquiry_history_status — BOOLEAN
point
- point_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- mission_num — bigint — Foreign key → mission.mission_num — NOT NULL
- point_change — INTEGER
review_num
- review_num — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- store_num — bigint — Foreign key → store.store_num
- review_content — varchar(200)
- review_picture — BLOB
- review_gpa — double(5,2)
store
- store_num — bigint — Primary key — NOT NULL
- local_num — bigint — Foreign key → local.local_num
- store_name — varchar(50)
- store_location — varchar(50)
- store_picture — BLOB — 이미지 저장 변수 blob
user
- user_id — bigint — Primary key — NOT NULL
- user_password — varchar(30)
- user_name — varchar(20)
- user_phone_num — varchar(20)
- user_gender — varchar(5)
- user_email — varchar(40)
- user_point — bigint
- user_address — varchar(40)