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