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)