SunFlower

Tables (6)

Comment

  • Key (comment_id) — BIG INT — Primary key — NOT NULL
  • post_id — BIG INT — Foreign key → Post.post_id — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → User.Key — NOT NULL
  • Field (commemt_contents) — VARCHAR — NOT NULL
  • Field (create_at) — DATE — NOT NULL
  • Field (modified_at) — DATE — NOT NULL

Post

  • post_id — BIG INT — Primary key — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → User.Key — NOT NULL
  • Field4 (post_contents) — VARCHAR — NOT NULL
  • Field (menu_list) — VARCHAR — NOT NULL
  • Field (meal_count) — VARCHAR — NOT NULL
  • Field (like_count) — INT
  • Field (nu_carbs) — INT
  • Field (nu_protein) — INT
  • Field2 (nu_fat) — INT
  • Field3 (nu_kcal) — INT — NOT NULL
  • Field (created_at) — DATE — NOT NULL
  • Field2 (modified_at) — DATE — NOT NULL

Untitled (Nutrition)

  • Key (nutrition_id) — BIG INT — Primary key — NOT NULL
  • Field (food_name) — VARCHAR — NOT NULL
  • Field (food_code) — VARCHAR — NOT NULL
  • Field (nu_carbs) — DOUBLE
  • Field2 (nu_protein) — DOUBLE
  • Field3 (nu_fat) — DOUBLE
  • Field (nu_kcal) — DOUBLE — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → User.Key — NOT NULL

Untitled (Likes)

  • Key (post_like_id) — BIG INT — Primary key — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → User.Key — NOT NULL
  • post_id — BIG INT — Foreign key → Post.post_id — NOT NULL
  • Field (create_at) — DATE — NOT NULL
  • Field (modified_at) — DATE — NOT NULL

Untitled (Post_Image)

  • Key (post_image_id) — BIG INT — Primary key — NOT NULL
  • post_id — BIG INT — Foreign key → Post.post_id — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → Post.Key — NOT NULL
  • Field (post_image_url) — BIG INT — NOT NULL
  • Field (create_at) — DATE — NOT NULL
  • Field (modified_at) — DATE — NOT NULL

User

  • Key (user_id) — BIG INT — Primary key — NOT NULL
  • Field (email_id) — VARCHAR — NOT NULL
  • Field2 (password) — VARCHAR — NOT NULL
  • Field (nickname) — VARCHAR — NOT NULL
  • Field2 (gender) — VARCHAR — NOT NULL
  • Field (role) — VARCHAR — NOT NULL
  • Field (user_contents) — VARCHAR
  • Field (user_image) — VARCHAR
  • Field (kakao_id) — VARCHAR
  • Field (status) — VARCHAR — NOT NULL
  • Field (created_at) — DATE — NOT NULL
  • Field (modified_at) — DATE — NOT NULL