todo

Tables (4)

File (Untitled4)

  • fid (Key) — Primary key — NOT NULL
  • tid (Key2) — Foreign key → Todo.tid — NOT NULL
  • filename (Field)
  • uuid (Field2)
  • Field3
  • Field4

Member (Untitled2)

  • mid (Key) — Primary key — NOT NULL
  • name (Field2)
  • password (Field)
  • role (Field3)
  • createdate (Field4)
  • updatedate (Field5)

Reply (Untitled3)

  • rid (Key) — Primary key — NOT NULL
  • mid (Key2) — Foreign key → Member.mid — NOT NULL
  • tid (Key3) — Foreign key → Todo.tid — NOT NULL
  • contents (Field)
  • createdate (Field2)
  • updatedate (Field3)

Todo (Untitled)

  • tid (Key) — Primary key — NOT NULL
  • mid (Key2) — Foreign key → Member.mid — NOT NULL
  • mid (Field2)
  • title (Field)
  • contents (Field3)
  • createdate (Field4)
  • updatedate (Field5)