community

Tables (9)

Comments (comments)

  • commentId (comment_id) — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • postId (post_id) — BIGINT — Foreign key → Posts.postId — NOT NULL
  • parentCommentId (parent_comment_id) — BIGINT — Foreign key → Comments.commentId — 대댓글 고려.
  • commentBody (comment_body) — text
  • createdAt (created_at) — DateTime
  • modified — boolean
  • modifiedAt (modified_at) — DateTime — NOT NULL
  • deleted — boolean
  • deletedAt (deleted_at) — DateTime — NOT NULL

Drafts (drafts)

  • draftId (draft_id) — BIGINT — Primary key — NOT NULL
  • authorId (author_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • title — varchar
  • postBody (post_body) — text — NOT NULL
  • postImage (post_image_url) — varchar
  • createdAt (created_at) — DateTime
  • updatedAt (updated_at) — DateTime — NOT NULL
  • version — int

PostDetail (post_details)

  • postId (post_id) — BIGINT — Foreign key → Posts.postId — NOT NULL
  • postBody (post_body) — text
  • postImage (post_image_url) — varchar — NOT NULL

PostRevision (post_revisions)

  • revisionId (revision_id) — BIGINT — Primary key — NOT NULL
  • postId (post_id) — BIGINT — Foreign key → Posts.postId — NOT NULL
  • title — varchar
  • postBody (post_body) — text
  • postImage (post_image_url) — varchar — NOT NULL
  • revision — int
  • createdAt (created_at) — DateTime

Post_likes (post_likes)

  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • postId (post_id) — BIGINT — Foreign key → Posts.postId — NOT NULL

Posts (posts)

  • postId (post_id) — BIGINT — Primary key — NOT NULL
  • authorId (author_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • title — varchar
  • postStatus (post_status) — Enum
  • createdAt (created_at) — DateTime
  • modified — boolean
  • modifiedAt (modified_at) — DateTime — NOT NULL
  • deletedAt (deleted_at) — DateTime — NOT NULL
  • blindedAt (blinded_at) — DateTime — NOT NULL
  • revision — int

Reports (post_reports)

  • reportId (report_id) — BIGINT — Primary key — NOT NULL
  • reporterId (reporter_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • postId (post_id) — BIGINT — Foreign key → Posts.postId — NOT NULL
  • reportReason (report_reason) — Enum
  • description — varchar
  • reportedAt (reported_at) — DateTime

User (users)

  • userId (user_id) — BIGINT — Primary key — NOT NULL — auto_increment
  • nickname — varchar
  • profileImage (profile_image_url) — varchar — NOT NULL
  • userStatus (user_status) — Enum
  • UserRole (user_role) — Enum

UserCredential (user_credentials)

  • userId (user_id) — BIGINT — Foreign key → User.userId — NOT NULL — auto_increment
  • email — varchar
  • password — varchar