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