AlgoEat

Tables (4)

ChoiceLogs (피드백)

  • Log_id (로그 아이디) — INT — Primary key — NOT NULL
  • ActionType (사용자의 반응) — ENUM(Good, Bad)
  • Log_Date (로그 발생일자) — DATETIME
  • User_id (유저 아이디) — INT — Foreign key → User.User_id — NOT NULL
  • Food_id (음식 아이디(고유번호)) — INT — Foreign key → Food.Food_id — NOT NULL

Food (음식)

  • Food_id (음식 아이디(고유번호)) — INT — Primary key — NOT NULL
  • Name (음식 이름) — VARCHAR(50)
  • Calories (음식 열량) — SMALLINT
  • Carbs (탄수화물) — DECIMAL(5, 2)
  • Protein (단백질) — DECIMAL(5, 2)
  • fat (지방) — DECIMAL(5, 2)
  • Image_url (음식 이미지) — VARCHAR
  • Nation (국가 계열(음식)) — VARCHAR
  • Type (조리방식) — VARCHAR
  • Ingredient (주재료) — VARCHAR
  • Taste (맛) — JSON/VARCHAR
  • Category (음식 분류) — VARCHAR
  • User_BlackList (유저_차단내역) — VARCHAR — Foreign key → User.User_id — NOT NULL
  • User_Preference (유저_추천) — VARCHAR — Foreign key → User.User_id — NOT NULL

History (유저식사기록)

  • History_id (기록_아이디) — BIGINT — Primary key — NOT NULL
  • EatDate (먹은기록) — DATETIME
  • Quantity (식사량(인분)) — DECIMAL(3,1)
  • User_id (유저 아이디) — INT — Foreign key → User.User_id — NOT NULL
  • Food_id (음식 아이디(고유번호)) — INT — Foreign key → Food.Food_id — NOT NULL

User (사용자)

  • User_id (유저 아이디) — INT — Primary key — NOT NULL
  • Email (이메일(아이디)) — VARCHAR(50)
  • Password (비밀번호) — VARCHAR(255)
  • Gender (성별) — ENUM
  • Age (나이) — TINYINT
  • Height (키) — DECIMAL(5,2)
  • Weight (몸무게) — DECIMAL(5,2)
  • NickName (별칭) — VARCHAR(10)
  • BlackList (차단내역) — VARCHAR
  • Preference (추천) — VARCHAR