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