mohaemukzip_submit

Tables (16)

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

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

CookingRecord (완료한 레시피)

  • 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 (난이도) — Integer — NOT NULL

Ingredients (재료)

  • id (재료id) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(50)
  • unit (단위(개/g)) — enum
  • weight (기본량) — double
  • category (카테고리) — enum — 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)
  • level (레벨) — INT
  • score (점수) — 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

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.id — NOT NULL
  • isCompleted (미션 성공여부) — boolean — 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 (미션)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • reward (보상 포인트) — int
  • explain (내용) — text

Recipe (레시피)

  • id (레시피id) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(100) — NOT NULL
  • level (레벨) — Double — NOT NULL
  • ratingCount (평가수) — Integer — NOT NULL — Default 0
  • time (소요시간) — String
  • channel (채널) — varchar(50)
  • channelId (Field) — String
  • views (조회수) — Long
  • imageUrl (썸네일url) — varchar
  • category (카테고리) — enum(한식, 중식, 일식, 양식, 동남아)
  • videoId (video id) — varchar(50) — NOT NULL
  • videoUrl (video url) — varchar(50) — NOT NULL
  • channelProfileImageUrl (채널 프로필 이미지) — varchar(50)

RecipeCategory (레시피 카테고리 관계)

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

RecipeStep (레시피 단계)

  • recipe_step_id (레시피 단계 id) — bigint — Primary key — NOT NULL
  • summaryId (요약id) — bigint — Foreign key → Summaries.id — NOT NULL
  • stepNumber (단계 번호) — NOT NULL
  • title (제목) — text — NOT NULL
  • description (설명) — text — NOT NULL

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

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