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)