123
Tables (3)
Comment
- id — bigint — Primary key — NOT NULL
- id (postId) — bigint — Foreign key → Post.id — NOT NULL
- Field (content) — text
- Field3 (createdAt) — datetime
Post
- id — bigint — Primary key — NOT NULL
- id (authorId) — bigint — Foreign key → User.id — NOT NULL
- Field (title) — varchar(50)
- Field2 (content) — text
- Field3 (published) — tinyint(1)
- Field (createdAt) — datetime
- id (id2) — bigint — Foreign key → User.id — NOT NULL
User
- id — bigint — Primary key — NOT NULL
- Field (email) — varchar(255)
- Field2 (password) — varchar(255)
- Field3 (name) — varchar(20)
- Field (createdAt) — datetime