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