Kingdom's assignment
Tables (3)
Comment
- CommentId — INT
- PostId — INT — NOT NULL
- UserId — INT — NOT NULL
- Content — TEXT — NOT NULL
- CommentDate — datetime
Post
- PostId — INT
- UserId — INT — NOT NULL
- Title — VARCHAR(100) — NOT NULL
- Content — TEXT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- Writer — varchar(20)
- view — Int
- comment_view — Int
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(30)
- password — VARCHAR(20) — NOT NULL