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