Today_HomeBar

Tables (5)

INGREDIENTS (재료)

  • ING_ID — NUMBER
  • NAME — VARCHAR2(50) — NOT NULL
  • CATEGORY — VARCHAR2(30)

RECIPES (레시피)

  • RECIPE_ID — NUMBER
  • TITLE — VARCHAR2(100) — NOT NULL
  • DESCRIPTION — CLOB
  • WEATHER_TAG — VARCHAR2(50)
  • DIFFICULTY — VARCHAR2(20)
  • IMAGE_URL — VARCHAR2(500)
  • CREATED_AT — TIMESTAMP

RECIPE_STEPS (레시피별 상세 단계)

  • STEP_ID — NUMBER
  • RECIPE_ID — NUMBER — Foreign key → RECIPES.RECIPE_ID
  • STEP_ORDER — NUMBER — NOT NULL
  • CONTENT — VARCHAR2(1000) — NOT NULL
  • ANIMATION_TYPE — VARCHAR2(50)

USERS (회원)

  • USER_ID — NUMBER
  • EMAIL — VARCHAR2(100) — NOT NULL
  • NICKNAME — VARCHAR2(50) — NOT NULL
  • PASSWORD — VARCHAR2(255) — NOT NULL
  • CREATED_AT — TIMESTAMP

USER_INVENTORY (보유 재료)

  • INVENTORY_ID — NUMBER
  • USER_ID — NUMBER — Foreign key → USERS.USER_ID
  • ING_ID — NUMBER — Foreign key → INGREDIENTS.ING_ID
  • UPDATED_AT — TIMESTAMP