mohaemukzip_demoday

Tables (18)

Category (세부 카테고리 및 태그)

  • id (세부 카테고리 id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(50) — NOT NULL — 예: "국/찌개", "볶음", "혼밥"
  • type (타입) — enum(DISH_TYPE, SITUATION) — NOT NULL

Dish (요리명)

  • id (요리명id) — bigint — Primary key — NOT NULL
  • name (요리명) — varchar(50) — NOT NULL

DishCategory (요리명 카테고리 관계)

  • id (레시피-카테고리id) — bigint — Primary key — NOT NULL
  • categoyId (세부 카테고리 id) — bigint — Foreign key → Category.id — NOT NULL
  • dishId (요리명id) — bigint — Foreign key → Dish.id — NOT NULL

Member (회원)

  • id (유저id) — bigint — Primary key — NOT NULL
  • nickname (닉네임) — varchar(50)
  • role (역할) — enum
  • inactiveDate (활동시간) — Date
  • loginId (로그인id) — bigint
  • password (비밀번호) — varchar(50) — NOT NULL
  • loginType (로그인 타입) — enum(GENERAL, KAKAO, GOOGLE, APPLE) — NOT NULL
  • oauthId (소셜로그인id) — bigint
  • fridge_score (냉장고 점수) — INT — NOT NULL

Member_Mission (회원미션)

  • member_mission_id (Key) — bigint — Primary key — NOT NULL
  • memberId (회원 id) — bigint — Foreign key → Member.id — NOT NULL
  • missionId (미션 id) — bigint — Foreign key → Mission.mission_id — NOT NULL
  • assignedDate (오늘의 퀘스트 날짜) — LocalDate — NOT NULL
  • status (상태) — enum(ASSIGNED, COMPLETED, FAILED) — NOT NULL

Member_Term (약관동의이력)

  • id (동의id) — bigint — Primary key — NOT NULL
  • termId (약관id) — bigint — Foreign key → Terms.id — NOT NULL
  • memberId (유저id) — bigint — Foreign key → Member.id — NOT NULL
  • isAgreed (동의여부) — tinyint — NOT NULL
  • agreedAt (시간) — datetime — NOT NULL

Member_recipes (저장레시피)

  • id (저장 레시피 id) — bigint — Primary key — NOT NULL
  • memberId (회원id) — bigint — Foreign key → Member.id — NOT NULL
  • recipeId (레시피 id) — bigint — Foreign key → Recipe.id — NOT NULL

Mission (미션)

  • mission_id (Key) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • reward (보상 포인트) — int
  • description (내용) — text
  • dishId (미션의 요리Id) — bigint — NOT NULL

Recipe (레시피)

  • id (레시피id) — bigint — Primary key — NOT NULL
  • dishId (요리명id) — bigint — Foreign key → Dish.id — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • level (레벨) — double — NOT NULL
  • ratingCount (평가수) — INT — NOT NULL — Default 0
  • time (영상 길이) — varchar(255)
  • cookingTime (조리 시간) — INT
  • channel (채널명) — varchar(255)
  • channelId (채널 id) — varchar(255)
  • views (조회수) — bigint
  • imageUrl (썸네일url) — varchar
  • category (카테고리) — enum(한식, 중식, 일식, 양식, 동남아)
  • videoId (비디오id) — varchar(255) — NOT NULL
  • videoUrl (비디오url) — varchar(255) — NOT NULL
  • channelProfileImageUrl (채널 프로필이미지url) — varchar(255)

RecipeStep (레시피 단계)

  • recipe_step_id (레시피 단계 id) — bigint — Primary key — NOT NULL
  • summaryId (요약id) — bigint — Foreign key → Summaries.id — NOT NULL
  • stepNumber (스텝 번호) — INT
  • title (제목) — varchar(255)
  • description (설명) — varchar(255)
  • videoTime (영상 시간) — INT

Summaries (요약레시피)

  • id (요약id) — bigint — Primary key — NOT NULL
  • recipeId (레시피id) — bigint — Foreign key → Recipe.id — NOT NULL

Terms (약관)

  • id (약관id) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • content (본문내용) — text
  • isRequired (필수(1)/선택(0)) — NOT NULL

cooking_record (완료한 레시피)

  • cooking_record_id (Key) — Primary key — NOT NULL
  • memberId (회원id) — bigint — Foreign key → Member.id — NOT NULL
  • recipe_id (레시피id) — bigint — Foreign key → Recipe.id — NOT NULL
  • rating (Field) — Integer — NOT NULL

ingredient_request (재료 요청)

  • id (즐겨찾기id) — bigint — Primary key — NOT NULL
  • memberId (회원id) — bigint — Foreign key → Member.id — NOT NULL
  • ingredientId (재료id) — bigint — Foreign key → ingredients.id — NOT NULL
  • ingredientName (재료 이름) — varchar(255)

ingredients (재료)

  • id (재료id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(50)
  • unit (단위(개/g)) — enum
  • weight (기본량) — double
  • category (카테고리) — enum — NOT NULL
  • expirationDays (유통기한) — INT

member_favorites (사용자 즐겨찾기 재료)

  • id (즐겨찾기id) — bigint — Primary key — NOT NULL
  • memberId (회원id) — bigint — Foreign key → Member.id — NOT NULL
  • ingredientId (재료id) — bigint — Foreign key → ingredients.id — NOT NULL

member_ingredient (냉장고에 있는 재료)

  • id (냉장고재료id) — bigint — Primary key — NOT NULL
  • memberId (회원id) — bigint — Foreign key → Member.id — NOT NULL
  • ingredientId (재료id) — bigint — Foreign key → ingredients.id — NOT NULL
  • expireDate (소비기한) — Date
  • storageType (보관방법) — enum(FRIDGE, FREEZER, PANTRY) — NOT NULL
  • weight (수량/무게) — double

recipe_ingredients (레시피 재료)

  • id (냉장고재료id) — bigint — Primary key — NOT NULL
  • recipeId (레시피id) — bigint — Foreign key → Recipe.id — NOT NULL
  • ingredientId (재료id) — bigint — Foreign key → ingredients.id — NOT NULL
  • amout (수량) — double