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)