food

Tables (6)

CATEGORY (Untitled7)

  • ID (Key) — AUTO INCREMENT — Primary key — NOT NULL
  • CATEGORY_NAME (Field) — VAR(50)

COMMENT (Untitled5)

  • ID (Key) — AUTO INCREMENT — Primary key — NOT NULL
  • USERS_ID (pr) — INT — Foreign key → USERS.ID — NOT NULL
  • RECIPE_ID (pr2) — INT — Foreign key → RECIPE.USERS_ID — NOT NULL
  • CONTEXT (Field) — TEXT

MENU (Untitled2)

  • ID (Key) — AUTO INCREMENT — Primary key — NOT NULL
  • CATEGORY_ID (Key2) — INT — Foreign key → CATEGORY.ID — NOT NULL
  • MENU_NAME (Field2) — VAR(50)

RECIPE (Untitled3)

  • ID (Key) — AUTO INCREMENT — Primary key — NOT NULL
  • USERS_ID (pr) — INT — Foreign key → USERS.ID — NOT NULL
  • MENU_ID (Key2222) — INT — Foreign key — NOT NULL
  • TITLE (Field2) — CHAR(50)
  • ING_NAME (Field) — CHAR(50)
  • COOK_TOOL (Field3) — CHAR(50)
  • TIME (Field4) — INTEGER
  • IMAGE (Field5) — IMG

RECIPE_PROCESS (Untitled10)

  • ID (Key2) — AUTO INCREMENT — Primary key — NOT NULL
  • RECIPE_ID (pr) — INT — Foreign key → RECIPE.USERS_ID — NOT NULL
  • PROCESS (Field2) — TEXT

USERS (Untitled)

  • ID (pr) — AUTO INCREMENT — Primary key — NOT NULL
  • PW (Field) — VAR(50)
  • USERS_NAME (Field3) — CHAR(50)
  • EMAIL (Field4) — VAR(50)