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