Blog_Blue
Tables (4)
Comment (comments)
- ID (id) — uint — Primary key — NOT NULL
- UserID (user_id) — uint — Foreign key → User.ID — NOT NULL
- PostID (id2) — string — Foreign key → Post.ID — NOT NULL
- Content (contents) — string
- CreatedAt (created_at) — bigint
- UpdatedAt (updated_at) — bigint
- DeletedAt (deleted_at) — bigint
Like (likes)
- ID (id) — int — Primary key — NOT NULL
- PostID (post_id) — uid — Foreign key → Post.ID — NOT NULL
- UserID (user_id) — int — Foreign key → User.ID — NOT NULL
- CreatedAt (created_at) — bigint
Post (posts)
- ID (id) — stirng — Primary key — NOT NULL
- AuthorID (author_id) — int — Foreign key → User.ID — NOT NULL
- Title (title) — string
- Content (content) — string
- Created_at (created_at) — bigint
- Updated_at (updated_at) — bigint
- Deleted_at (deleted_at) — bigint
User (users)
- ID (id) — uint — Primary key — NOT NULL
- Email (email) — string
- Password (password) — string
- UserName (user_name) — string
- CreatedAt (joined_at) — bigint
- UpdatedAt (updated_at) — bigint
- DeletedAt (deleted_at) — bigint