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