3WDJ 2-1

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) — NOT NULL
  • Store Gps Latitude (store_gps_latitude) — VARCHAR(255)
  • Store Gps Longitude (store_gps_longitude) — VARCHAR(255)
  • Store Gps (store_gps) — 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
  • 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 Character Image (user_character_image) — VARCHAR(255)
  • User Character Color (user_character_color) — CHAR(7)