Refrigerator
Tables (14)
AUDITABLE
- 생성 날짜 (created_at) — NOTNULL
- 수정 날짜 (modified_at) — NOTNULL
Allergy_Food
- 알러지푸드ID (allergy_food_id) — NOTNULL — Primary key — NOT NULL
- 종류 (food_category) — NOTNULL
- 재료 이름 (food_name) — NOTNULL
- 회원ID (member_id) — NOTNULL — Foreign key → MEMBER.회원ID — NOT NULL
- 재료ID (food_id2) — NOTNULL — Foreign key → FOOD.재료ID — NOT NULL
BOARD
- 게시글ID (board_id) — NOTNULL — Primary key — NOT NULL
- 회원ID (member_id) — NOTNULL — Foreign key → MEMBER.회원ID — NOT NULL
- 메뉴 제목 (board_title) — NOTNULL
- 메뉴 내용 (board_content) — NOTNULL
- 메뉴 종류 (board_category) — NOTNULL
- 메뉴 재료 (food_content) — NOTNULL
- 레시피 내용 (recipe_content) — NOTNULL
- 이미지 (image_url) — NOTNULL
- 요리 시간 (cooking_time) — NOTNULL
- 음식량 (serving_size) — NOTNULL
- 난이도 (difficulty) — NOTNULL
- 좋아요 수 (board_like_count) — NOTNULL
BOARD_LIKE
- 좋아요ID (board_like_id) — NOTNULL — Primary key — NOT NULL
- 회원ID (member_id) — NOTNULL — Foreign key → MEMBER.회원ID — NOT NULL
- 게시글ID (board_id) — NOTNULL — Foreign key → BOARD.게시글ID — NOT NULL
FOOD
- 재료ID (food_id) — NOTNULL — Primary key — NOT NULL
- 재료 이름 (food_name) — NOTNULL
- 종류 (food_category) — NOTNULL
FOOD_MENU
- 푸드메뉴ID (food_menu_id) — NOTNULL — Primary key — NOT NULL
- 메뉴 (menu_id) — NOTNULL — Foreign key → MENU.메뉴ID — NOT NULL
- 재료ID (food_id) — NOTNULL — Foreign key → FOOD.재료ID — NOT NULL
- 재료 양 (food_quantity) — NOTNULL
MEMBER
- 회원ID (member_id) — NOTNULL — Primary key — NOT NULL
- 이메일 (email) — NOTNULL
- 비밀번호 (password) — NOTNULL
- 닉네임 (nickName) — NOTNULL
- 회원 상태 (member_status) — NOTNULL
MEMBER_FOOD
- 멤버푸드ID (member_food_id) — NOTNULL — Primary key — NOT NULL
- 회원ID (member_id) — NOTNULL — Foreign key → MEMBER.회원ID — NOT NULL
- 재료ID (food_id) — NOTNULL — Foreign key → FOOD.재료ID — NOT NULL
- 종류 (food_category) — NOTNULL
- 소비 기한 (expiration_date)
- 재료 이름 (food_name) — NOTNULL
- 메모 (memo)
- 재료 상태 (member_food_status) — NOTNULL
MENU
- 메뉴ID (menu_id) — NOTNULL — Primary key — NOT NULL
- 메뉴 제목 (menu_title) — NOTNULL
- 메뉴 설명 (menu_description) — NOTNULL
- 레시피 내용 (recipe_content) — NOTNULL
- 이미지 (image_url) — NOTNULL
- 메뉴 종류 (menu_category) — NOTNULL
- 요리 시간 (cooking_time) — NOTNULL
- 음식량 (serving_size) — NOTNULL
- 난이도 (dificulty) — NOTNULL
- 좋아요 수 (menu_like_count) — NOTNULL
MENU_LIKE
- 좋아요ID (menu_like_id) — NOTNULL — Primary key — NOT NULL
- 회원ID (member_id) — NOTNULL — Foreign key → MEMBER.회원ID — NOT NULL
- 레시피ID (menu_id) — NOTNULL — Foreign key → MENU.메뉴ID — NOT NULL
Menu_Category
- ID (menu_category_id) — NOTNULL — Primary key — NOT NULL
- 코드 (category_code) — NOTNULL
- 이름 (category_name) — NOTNULL
Menu_Cook_Time
- ID (id) — NOTNULL — Primary key — NOT NULL
- 코드 (cook_time_code) — NOTNULL
- 이름 (cook_time_name) — NOTNULL
Menu_Difficulty
- ID (menu_difficulty_id) — NOTNULL — Primary key — NOT NULL
- 코드 (difficulty_code) — NOTNULL
- 이름 (difficulty_name) — NOTNULL
Statistic
- ID (statistic_id) — NOTNULL — Primary key — NOT NULL
- 갯수 (count) — NOTNULL
- 설명 (description) — NOTNULL
- 입력타입 (d_type) — NOTNULL
- ID (menu_difficulty_id) — Foreign key → Menu_Difficulty.ID — NOT NULL
- ID (id2) — Foreign key → Menu_Cook_Time.ID — NOT NULL
- ID (menu_category_id) — Foreign key → Menu_Category.ID — NOT NULL
- 회원ID (member_id) — Foreign key → MEMBER.회원ID — NOT NULL