todoAPP

Tables (4)

Comment (-)

  • Key (Commentid) — bigint — Primary key — NOT NULL
  • Key (Userid) — bigint — Foreign key → User.Key — NOT NULL
  • Key (Todoid) — bigint — Foreign key → Todo.Key — NOT NULL
  • Field (Contents) — varchar
  • Field (CreatedAt) — TIMESTAMP

File (n)

  • Key (FileId) — bigint — Primary key — NOT NULL
  • Key (Commentid) — bigint — Foreign key → Comment.Key — NOT NULL
  • Field (Filename) — varchar
  • Field (extension) — varchar
  • Field (size) — int
  • Field (CreatedAt) — timestamp
  • Field (content) — blob

Todo (?)

  • Key (Todoid) — bigint — Primary key — NOT NULL
  • Key (Userid) — bigint — Foreign key → User.Key — NOT NULL
  • Field (Title) — varchar
  • Field (Contents) — varchar
  • Field (Username) — varchar
  • Field (Password) — varchar
  • Field (CreatedAt) — TIMESTAMP

User (m)

  • Key (Userid) — bigint — Primary key — NOT NULL
  • Field (Nickname) — varchar
  • Field (Username) — varchar
  • Field (Password) — varchar
  • Field (role) — varchar