1
Tables (8)
tblConnectCommunityComment
- CommentId — varchar(32) — Primary key
- PostId — varchar(32)
- Status — int — NOT NULL
- Message — nvarchar(max)
- Sort — int
- RegisteredBy — int — NOT NULL
- RegisteredDate — datetime — NOT NULL
- ModifyDate — datetime
- ParentCommentId — varchar(32)
- PostId (PostId2) — varchar(32) — Foreign key → tblConnectCommunityPost.PostId — NOT NULL
tblConnectCommunityLike
- PostId — varchar(32) — Primary key — NOT NULL
- RegisteredBy — int — Primary key
- IPAddress — varchar(50)
- Country — varchar(2)
- RegisteredDate — datetime — NOT NULL
- PostId (PostId2) — varchar(32) — Foreign key → tblConnectCommunityPost.PostId — NOT NULL
tblConnectCommunityPost
- PostId — varchar(32) — Primary key — NOT NULL
- Title — nvarchar(150) — NOT NULL
- Content — nvarchar(max) — NOT NULL
- Status — int — NOT NULL
- CategoryId — varchar(32)
- RegisteredBy — int — NOT NULL
- RegisteredDate — datetime — NOT NULL
tblConnectCommunityPostTag
- PostId — varchar(32) — Primary key — NOT NULL
- Seq — int — Primary key — NOT NULL
- Tag — nvarchar(32) — NOT NULL
- PostId (PostId2) — varchar(32) — Foreign key → tblConnectCommunityPost.PostId — NOT NULL
tblConnectCommunityView
- PostId — varchar(32) — Primary key — NOT NULL
- RegisteredBy — int — Primary key
- IPAddress — varchar(50)
- Country — varchar(2)
- RegisteredDate — datetime — NOT NULL
- PostId (PostId2) — varchar(32) — Foreign key → tblConnectCommunityPost.PostId — NOT NULL
tblConnectUserActivityCommunityComment
- CommentId — varchar(32) — Primary key — NOT NULL
- RegisteredBy — int — Primary key
- LikeCount — int — NOT NULL
- RegisteredDate — datetime — NOT NULL
- UpdatedDate — datetime
- CommentId (CommentId2) — varchar(32) — Foreign key → tblConnectCommunityComment.CommentId
tblConnectUserActivityCommunityCommentLike
- CommentId — varchar(32) — Primary key — NOT NULL
- RegisteredBy — int
- IPAddress — varchar(50)
- Country — varchar(2)
- RegisteredDate — datetime — NOT NULL
- CommentId (CommentId2) — varchar(32) — Foreign key → tblConnectCommunityComment.CommentId
tblConnectUserActivityCommunityPost
- PostId — varchar(32) — Primary key — NOT NULL
- ViewCount — int — NOT NULL
- LikeCount — int — NOT NULL
- CommentCount — int — NOT NULL
- RegisteredBy — int
- RegisteredDate — datetime — NOT NULL
- UpdatedDate — datetime
- PostId (PostId2) — varchar(32) — Foreign key → tblConnectCommunityPost.PostId — NOT NULL