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