tb_food
Tables (3)
TB_FOOD (Untitled)
- FOOD_ID (Key) — number — Primary key — NOT NULL
- FOOD_NM (Field) — VARCHAR2(100)
- IMAGE (Field2) — VARCHAR2(300)
- DESCRIPTION (Field3) — VARCHAR2(1000)
- FOOD_LEVEL (Field4) — NUMBER
- COOKINGTIME (Field5) — NUMBER
- REG_DT (Field6) — DATE
- MODI_DT (Field7) — DATE
- TITLE (Field8) — VARCHAR2(200)
TB_INGREDIENT (Untitled2)
- INGREDIENT_ID (Key) — NUMBER — Primary key — NOT NULL
- FOOD_ID (Field) — NUMBER
- MAIN_INGREDIENT (Field2) — VARCHAR2(100)
- MAIN_AMOUNT (Field3) — VARCHAR2(100)
- MAIN_TYPE (Field4) — VARCHAR2(100)
- SEASONING_INGREDIENT (Field5) — VARCHAR2(100)
- SEASONING_AMOUNT (Field6) — VARCHAR2(100)
- SEASONING_TYPE (Field7) — VARCHAR2(100)
TB_STEP (Untitled3)
- STEP_ID (Key) — NUMBER — Primary key — NOT NULL
- FOOD_ID (Field) — NUMBER
- STEP_NUM (Field2) — NUMBER
- STEP_IMAGE (Field3) — VARCHAR2(300)
- STEP_DESCRIPTION (Field4) — VARCHAR2(1000)