4team
Tables (7)
Comment (Untitled6)
- comment_idx (Key) — INT(10) — Primary key — NOT NULL
- mem_idx (Key2) — INT(10) — Foreign key → Member.mem_idx — NOT NULL
- Field
- Field2
- Field3
Comment_FoodRecipe (Untitled5)
- mem_idx (Key2) — INT(10) — Foreign key → Member.mem_idx — NOT NULL
- Recipe_idx (Key3) — INT(10) — Foreign key → FoodRecipe.Recipe_idx — NOT NULL
- comment_idx (Key4) — INT(10) — Foreign key → Comment.comment_idx — NOT NULL
FoodRecipe (Untitled2)
- Recipe_idx (Key) — INT(10) — Primary key — NOT NULL
- mem_idx (Key2) — INT(10) — Foreign key → Member.mem_idx — NOT NULL
- (Field)
- Field2
- Field3
- Field4
- Field5
- Field6
Ingredient (Untitled7)
- Refri_idx (Key) — INT(10) — Foreign key → MyRefri.Refri_idx — NOT NULL
- Recipe_idx (Key3) — INT(10) — Foreign key → FoodRecipe.Recipe_idx — NOT NULL
Member (Untitled)
- mem_idx (Key) — INT(10) — Primary key — NOT NULL
- memid (Field) — VARCHAR(32)
- mempwd (Field2) — VARCHAR(32)
- memname (Field3) — VARCHAR(32)
- gender (Field4) — VARCHAR(32)
- birth (Field5) — DATE
- mobile (Field6) — VARCHAR(32)
- email (Field7) — VARCHAR(32)
- addr01 (Field8) — VARCHAR(128)
- addr02 (Field9) — VARCHAR(128)
- regdate (Field10) — DATETIME
- Field11 — DATETIME
MyRefri (Untitled4)
- Refri_idx (Key) — INT(10) — Primary key — NOT NULL
- mem_idx (Key2) — INT(10) — Foreign key → Member.mem_idx — NOT NULL
- (Field)
- Field2
Review (Untitled3)
- Rev_idx (Key) — INT(10) — Primary key — NOT NULL
- mem_idx (Key2) — INT(10) — Foreign key → Member.mem_idx — NOT NULL
- Recipe_idx (Key3) — INT(10) — Foreign key → FoodRecipe.Recipe_idx — NOT NULL
- (Field)
- Field2