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)