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