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