Bob mate

Tables (18)

Breakfast (Untitled6)

  • breakfastId (Key) — bigint(20) — Primary key — NOT NULL
  • Field
  • recmeenuId (Key2) — bigInt(20) — Foreign key → Recommned_Menu.recmeenuId — NOT NULL

Comment (Untitled9)

  • commentsId (Key) — bigInt(20) — Primary key — NOT NULL
  • food_input (Field) — varchar(30)
  • recmeenuId (Key2) — bigInt(20) — Foreign key → Recommned_Menu.recmeenuId — NOT NULL

ContensImage (Untitled13)

  • videoImageId (Key) — bigint(20) — Primary key — NOT NULL
  • videoId (Key2) — bigint(30) — Foreign key → Video_Contents.videoId — NOT NULL

Dinner

  • DinnerId (Key) — bigInt(20) — Primary key — NOT NULL
  • dinnerMenu (Field) — varchar(50)
  • recmeenuId (Key2) — bigInt(20) — Foreign key → Recommned_Menu.recmeenuId — NOT NULL

FoodImage (CopyOfUntitled63)

  • imageId (Key) — bigint(20) — Primary key — NOT NULL
  • imageName (Field) — varchar(50)
  • snackId (Key2) — bigInt(20) — Foreign key → Snack.snackId — NOT NULL
  • breakfastId (Key3) — bigint(20) — Foreign key → Breakfast.breakfastId — NOT NULL
  • lunchId (Key4) — bigint(20) — Foreign key → Lunch.lunchId — NOT NULL
  • DinnerId (Key5) — bigInt(20) — Foreign key → Dinner.DinnerId — NOT NULL

Likes (Untitled11)

  • likesId (Key) — bigInt(20) — Primary key — NOT NULL

Lunch (Untitled7)

  • lunchId (Key) — bigint(20) — Primary key — NOT NULL
  • Field
  • recmeenuId (Key2) — bigInt(20) — Foreign key → Recommned_Menu.recmeenuId — NOT NULL

Member (Untitled)

  • userId (Key) — bigInt(20) — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • email (Field2) — varchar(20)
  • password (Field3) — varchar(20)
  • phone (Field4) — varchar(20)
  • user_image (Key2) — bigInt(20) — Foreign key → UserProfileImage.user_image — NOT NULL

Prefer_Contents (Untitled10)

  • preferenceId (Key) — bigint(20) — Primary key — NOT NULL
  • prefer_content (Field) — varchar(100)
  • userId (Key2) — bigInt(20) — Foreign key → Member.userId — NOT NULL

Recommend_Contents (Untitled8)

  • rec_id (Key) — bigInt(20) — Primary key — NOT NULL
  • userId (Key2) — bigInt(20) — Foreign key → Member.userId — NOT NULL
  • rec_Like_id (Key3) — Foreign key → Recommend_LikesYN.rec_Like_id — NOT NULL

Recommend_LikesYN (Untitled15)

  • rec_Like_id (Key) — Primary key — NOT NULL
  • likes (Field) — varchar(1)

Recommned_Menu (Untitled5)

  • recmeenuId (Key) — bigInt(20) — Primary key — NOT NULL
  • userId (Key2) — bigInt(20) — Foreign key → Member.userId — NOT NULL

Snack

  • snackId (Key) — bigInt(20) — Primary key — NOT NULL
  • snackMenu (Field) — vaarchar(20)
  • recmeenuId (Key2) — bigInt(20) — Foreign key → Recommned_Menu.recmeenuId — NOT NULL

TextImage (Untitled14)

  • TextImageId (Key) — bigint(20) — Primary key — NOT NULL
  • textId (Key2) — bigint(20) — Foreign key → Text_contents.textId — NOT NULL

Text_contents (Untitled4)

  • textId (Key) — bigint(20) — Primary key — NOT NULL
  • content_text (Field) — varchar(200)
  • likesId (Key2) — bigInt(20) — Foreign key → Likes.likesId — NOT NULL
  • rec_id (Key3) — bigInt(20) — Foreign key → Recommend_Contents.rec_id — NOT NULL

UserProfileImage (Untitled12)

  • user_image (Key) — bigInt(20) — Primary key — NOT NULL
  • image (Field)

Video_Contents (Untitled3)

  • videoId (Key) — bigint(30) — Primary key — NOT NULL
  • content_video (Field) — varchar(200)
  • likesId (Key2) — bigInt(20) — Foreign key → Likes.likesId — NOT NULL
  • rec_id (Key3) — bigInt(20) — Foreign key → Recommend_Contents.rec_id — NOT NULL

socialLogin (Untitled2)

  • userId (Key) — bigInt(20) — Primary key — NOT NULL
  • snsType (Field) — varchar(20)
  • userId (Key2) — bigInt(20) — Foreign key → Member.userId — NOT NULL