3WDJ 2-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_id) — INT(11) — 외래 키 → Users.User Id — NOT NULL
- Review Id (review_id) — 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)
- Eaten Entered (eaten_entered) — DATETIME
- Eaten Start (eaten_start) — DATETIME
- Eaten End (eaten_end) — DATETIME
- User Id (user_id) — INT(11) — 외래 키 → Users.User Id — NOT NULL
- Food Id (food_id) — INT(11) — 외래 키 → Foods.Food Id
- Store Id (stored_id) — INT(11) — 외래 키 → Stores.Store Id
- Nutrient Id (nutrient_id) — INT(11) — 외래 키 → Nutrients.Nutrient Id
Foods (food)
- Food Id (food_id) — INT(11) — 기본 키 — NOT NULL
- Food Name (food_name) — VARCHAR(255) — NOT NULL
- Food Price (food_price) — INTEGER
- Store Id (stored_id) — INT(11) — 외래 키 → Stores.Store Id — NOT NULL
Nutrients (nutrient)
- Nutrient Id (nutrient_id) — INT(11) — 기본 키 — NOT NULL
- Nutrient Calorie (nutrient_calorie) — FLOAT
- Nutrient Carbohydrate (nutrient_carbohydrate) — FLOAT
- Nutrient Protein (nutrient_protein) — FLOAT
- Nutrient Fat (nutrient_fat) — FLOAT
- Nutrient Salt (nutrient_salt) — FLOAT
- Nutrient Cholesterol (nutrient_cholesterol) — FLOAT
- Nutrient Dietary Fiber (nutrient_dietary_fiber) — FLOAT
- Nutrient Potassium (nutrient_potassium) — FLOAT
- Food Id (food_id) — INT(11) — 외래 키 → Foods.Food Id — NOT NULL
Recipes (recipe)
- Recipe Id (recipe_id) — INT(11) — 기본 키 — NOT NULL
- Recipe (recipe) — TEXT
- Recipe Image (recipe_image) — VARCHAR(255)
- Food Id (food_id) — INT(11) — 외래 키 → Foods.Food Id — NOT NULL
Reviews (review)
- Review Id (review_id) — INT(11) — 기본 키 — NOT NULL
- Review Title (review_title) — VARCHAR(255) — NOT NULL
- Review Content (review_content) — VARCHAR(255) — NOT NULL
- Review Star Rating (review_star_rating) — FLOAT
- Review Image Route (review_image_route) — VARCHAR(255)
- User Id (user_id) — 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 Address (store_address) — VARCHAR(255)
- Store Gps Latitude (store_gps_latitude) — VARCHAR(255)
- Store Gps Longitude (store_gps_longitude) — VARCHAR(255)
- Store StarRating (store_star_rating) — FLOAT
- Store Category (store_category) — VARCHAR(255) — NOT NULL — 한식, 양식, 중식, 일식 등
- Store Model Route (store_model_route) — VARCHAR(255) — NOT NULL
- Store Image (store_image) — VARCHAR(255)
- Store Issuance Number (store_issuance_number) — INTEGER
Users (user)
- User Id (user_id) — INT(11) — 기본 키 — NOT NULL
- User Name (user_name) — VARCHAR(255) — NOT NULL
- User Email (user_eamil) — VARCHAR(255) — 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 Activity Index (user_activity_index) — VARCHAR(255)
- User Character Image (user_character_image) — VARCHAR(255)
- User Character Color (user_character_color) — CHAR(7)