tastylog2

Tables (6)

Category

  • category_id — BIGINT — Primary key — NOT NULL — 카테고리Id
  • category_name — VARCHAR(225) — 카테고리명

Member (Members)

  • member_id — BIGINT — Primary key — NOT NULL — 고객 ID
  • member_name — VARCHAR(225) — NOT NULL — 고객이름
  • member_email — VARCHAR(225) — NOT NULL — 고객 이메일
  • oauth_provider — VARCHAR(50) — NOT NULL — OAUTH 제공자
  • oauth_id — VARCHAR(225) — NOT NULL — OAUTH ID
  • password — VARCHAR(225)

Recipe

  • recipe_id — BIGINT — Primary key — NOT NULL — 레시피 ID
  • recipe_title — VARCHAR(255) — NOT NULL — 레시피명
  • URL — VARCHAR(255) — URL
  • recipe_content — TEXT — 요리법
  • recipe_created — TIMESTAMP — NOT NULL — 레시피 생성날짜
  • recipe_amount — VARCHAR(50) — 레시피인분
  • recipe_time — VARCHAR(50) — 레시피소요시간
  • recipe_difficulty — VARCHAR(50) — 레시피 난이도
  • recipe_main_image — VARCHAR(225) — 레시피 메인 이미지
  • recipe_tip — TEXT — 팁/주의사항
  • recipe_image — VARCHAR(225) — 레시피 이미지
  • member_id — BIGINT — Foreign key → Member.member_id — NOT NULL — 고객 ID
  • category_id — BIGINT — Foreign key → Category.category_id — NOT NULL — 카테고리 ID

Recipe_Ingredient

  • ingredient_id — BIGINT — Primary key — NOT NULL — 레시피재료ID
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
  • ingredient_name — VARCHAR(225) — 재료이름
  • ingredient_quantity — VARCHAR(50) — 재료단위/양

Recipe_Step

  • recipe_step_id — BIGINT — Primary key — NOT NULL — 레시피단계ID
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
  • step_content — TEXT — 요리순서설명
  • step_image — VARCHAR(225) — 단계이미지
  • step_order — INT — 순서
  • step_time — LocalTime

Recipe_spice

  • recipe_spice_id — BIGINT — Primary key — NOT NULL — 레시피양념ID
  • recipe_id — BIGINT — Foreign key → Recipe.recipe_id — NOT NULL — 레시피 ID
  • spice_name — VARCHAR(225) — 양념이름
  • spice_quantity — VARCHAR(50) — 재료타입/양