chapter3-team3
Tables (3)
comments (Untitled3)
- Key (id) — number — Primary key — NOT NULL
- Key (postId) — number — Foreign key → post.Key — NOT NULL
- Key (userId) — number — Foreign key → post.Key — NOT NULL
- Field (commet) — string
- Field (createdAt) — date
- Field (updatedAt) — date
post (Untitled2)
- Key (id) — number — Primary key — NOT NULL
- Key (userId) — number — Foreign key → users.Key — NOT NULL
- Field (title) — string
- Field (content) — string
- Field (createdAt) — date
- Field (updatedAt) — date
users (Untitled)
- Key (id) — number — Primary key — NOT NULL
- Field (nickName) — string
- Field2 (password) — string
- Field3 (profileUrl) — string
- Field4 (createdAt) — date
- Field (updatedAt) — date