Food Recommend
Tables (6)
Content (게시글)
- user_id (Key) — Primary key — NOT NULL
- content_id (Key2) — Primary key — NOT NULL
- user_share_id (Key3) — Primary key — NOT NULL
- author_id (Field11)
- category (Field)
- location_id (Field9)
- created_date (Field2)
- cooked (Field3)
- vote_count (Field10)
- title (Field4)
- text (Field5)
- file_url (Field7)
- user_share_url (Field8)
- shareNum (Field6)
ContentVote (Untitled2)
- id (Key) — Primary key — NOT NULL
- contentId (Key2) — Primary key — NOT NULL
- voteUser (Field)
User_rank (유저등급)
- user_id (Key2) — Primary key — NOT NULL
- user_rank (Field)
recommend Content (Untitled)
- user_id (Key) — Primary key — NOT NULL
- content_id (Key2) — Primary key — NOT NULL
- food_name (Field2)
- food_kcal (Field3)
- food_carbon (Field4)
- food_fat (Field5)
- food_sugar (Field6)
- clicked_date (Field7)
user (유저)
- user_id (Key) — Long — Primary key — NOT NULL
- nick_name (Key2) — String — Primary key — NOT NULL
- 이메일 (Field) — String
- 생성일자 (Field2) — LocalDateTime
- MBTI (Field3) — String
- 성별 (Field4) — byte
user_recommend_input (user feature)
- user_id (Key) — Primary key — NOT NULL
- user_nick_name (Key2) — Primary key — NOT NULL
- cooked_category (Field)
- selected_kcal (Field2)
- selected_carbon (Field3)
- selected_protein (Field4)
- selected_fat (Field5)