board
Tables (5)
CommentLikes
- CommentLikeId — INT
- CommentId — INT — NOT NULL
- UserId — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
Comments
- CommentId — INT
- PostId — INT — NOT NULL
- UserId — INT — NOT NULL
- ParentCommentId — INT
- Content — NVARCHAR(MAX) — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- UpdatedAt — DATETIME
PostLikes
- PostLikeId — INT
- PostId — INT — NOT NULL
- UserId — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
Posts
- PostId — INT
- UserId — INT — NOT NULL
- Title — NVARCHAR(200) — NOT NULL
- Content — NVARCHAR(MAX) — NOT NULL
- ViewCount — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- UpdatedAt — DATETIME
Users
- UserId — INT
- UserName — NVARCHAR(100) — NOT NULL
- Email — NVARCHAR(200) — NOT NULL
- Password — NVARCHAR(255) — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- UpdatedAt — DATETIME