3WDJ - 2
3 WD-J 2조 DB 모델링
테이블 (8)
Comments (comment)
- Comment Id (comment_id) — INT(11) — 기본 키 — NOT NULL
- Comment (comment) — VARCHAR(255) — NOT NULL
- User Id (user_id2) — INT(11) — 외래 키 → Users.User Id — NOT NULL
- Review Id (review_id2) — INT(11) — 외래 키 → Reviews.Review Id — NOT NULL
Food eaten (foodeaten)
- Eaten Id (eaten_id) — INT(11) — 기본 키 — NOT NULL
- Eaten Food Image (eaten_food_image) — VARCHAR(255) — NOT NULL
- Eaten Entered (eaten_entered) — DATETIME — NOT NULL
- Eaten Start (eaten_start) — DATETIME — NOT NULL
- Eaten End (eaten_end) — DATETIME
- User Id (user_id2) — INT(11) — 외래 키 → Users.User Id — NOT NULL
- Food Id (food_id2) — INT(11) — 외래 키 → Foods.Food Id — NOT NULL
- Store Id (stored_id2) — INT(11) — 외래 키 → Stores.Store Id — NOT NULL
Foods (food)
- Food Id (food_id) — INT(11) — 기본 키 — NOT NULL
- Food Name (food_name) — VARCHAR(255) — NOT NULL
- Food Price (food_price) — INT
- Calorie (calorie) — FLOAT
- Carbohydrate (carbohydrate) — FLOAT
- Protein (protein) — FLOAT
- Fat (fat) — FLOAT
- Salt (salt) — FLOAT
- Cholesterol (cholesterol) — FLOAT
- Dietary Fiber (dietary_fiber) — FLOAT
- Potassium (potassium) — FLOAT
- Store Id (stored_id) — INT(11) — 외래 키 → Stores.Store Id — NOT NULL
Recipes (recipe)
- Recipe Id (recipe_id) — INT(11) — 기본 키 — NOT NULL
- Recipe (recipe) — TEXT
- Food Id (food_id2) — INT(11) — 외래 키 → Foods.Food Id — NOT NULL
Recommends (Untitled8)
- Recommend Id (recommend_id) — INT(11) — 기본 키 — NOT NULL
- Meal Time (meal_time) — INT(1)
- Food Id (food_id) — INT(11)
- Address (address) — VARCHAR(255)
Reviews (review)
- Review Id (review_id) — INT(11) — 기본 키 — NOT NULL
- Review Star Rating (review_star_rating) — FLOAT
- Review Title (review_title) — VARCHAR(255) — NOT NULL
- Review Contents (review_contents) — VARCHAR(255) — NOT NULL
- Review Image Route (review_image_route) — VARCHAR(255)
- User Id (user_id2) — INT(11) — 외래 키 → Users.User Id — NOT NULL
- Store Id (stored_id) — INT(11) — 외래 키 → Stores.Store Id — NOT NULL
Stores (store)
- Store Id (stored_id) — INT(11) — 기본 키 — NOT NULL
- Store Name (store_name) — VARCHAR(255) — NOT NULL
- Store Gps (store_gps) — VARCHAR(255) — NOT NULL
- Store Address (store_address) — VARCHAR(255) — NOT NULL
- Store StarRating (store_star_rating) — FLOAT
- Store Category (store_category) — VARCHAR(255) — NOT NULL
- Store Model Route (store_model_route) — VARCHAR(255) — NOT NULL
Users (user)
- User Id (user_id) — INT(11) — 기본 키 — NOT NULL
- User Name (user_name) — VARCHAR(255) — NOT NULL
- User Email (user_eamil) — VARCHAR(100) — NOT NULL
- User Password (user_password) — VARCHAR(255) — NOT NULL
- User Birthday (user_birthday) — DATE — NOT NULL
- User Height (user_height) — FLOAT — NOT NULL
- User Weigth (user_weight) — FLOAT — NOT NULL
- User Gender (user_gender) — CHAR(1) — NOT NULL
- User Character Image (user_character_image) — VARCHAR(255)
- User Character Color (user_character_color) — CHAR(7)