exp
Tables (12)
AssetFile
- id — BIGINT — Primary key — NOT NULL — storedPath
- original_name — VARCHAR(200) — NOT NULL — extension
- stored_path — VARCHAR(500) — NOT NULL — sizeBytes
- extension — VARCHAR(30) — NOT NULL — purpose
- size_bytes — BIGINT — NOT NULL — resourceType
- purpose — VARCHAR(30) — NOT NULL — resourceId
- resource_type — VARCHAR(30) — NOT NULL — uploadedBy
- resource_id — BIGINT — NOT NULL — deleted
- uploaded_by — BIGINT — Foreign key → User.id — NOT NULL — createdAt
- deleted — BOOLEAN — NOT NULL — updatedAt
- created_at — TIMESTAMP — NOT NULL — id
- updated_at — TIMESTAMP — NOT NULL — title
Category
- id — BIGINT — Primary key — NOT NULL — name
- name — VARCHAR(50) — NOT NULL — parentId
- parent_id — BIGINT — Foreign key → Category.id — depth
- depth — INT — NOT NULL — sortOrder
- sort_order — INT — NOT NULL — createdAt
- created_at — TIMESTAMP — NOT NULL — updatedAt
- updated_at — TIMESTAMP — NOT NULL — id
Comment
- id — BIGINT — Primary key — NOT NULL — updatedAt
- post_id — BIGINT — Foreign key → Post.id — NOT NULL — id
- author_id — BIGINT — Foreign key → User.id — NOT NULL — title
- parent_id — BIGINT — Foreign key → Comment.id — content
- content — VARCHAR(2000) — NOT NULL — assetType
- deleted — BOOLEAN — NOT NULL — preferredStyle
- created_at — TIMESTAMP — NOT NULL — engine
- updated_at — TIMESTAMP — NOT NULL — deadline
Message
- id — BIGINT — NOT NULL — content
- sender_id — BIGINT — Foreign key → User.id — NOT NULL — userNickname
- receiver_id — BIGINT — Foreign key → User.id — NOT NULL — status
- content — TEXT — NOT NULL — createdAt
- is_read — BOOLEAN — NOT NULL — updatedAt
- created_at — TIMESTAMP — NOT NULL
Post
- id — BIGINT — Primary key — NOT NULL — authorId
- title — VARCHAR(100) — NOT NULL — categoryId
- content — TEXT — NOT NULL — thumbnailFileId
- author_id — BIGINT — Foreign key → User.id — NOT NULL — linkedRequestId
- category_id — BIGINT — Foreign key → Category.id — NOT NULL — viewCount
- thumbnail_file_id — BIGINT — Foreign key → AssetFile.id — likeCount
- linked_request_id — BIGINT — Foreign key → RequestPost.id — deleted
- view_count — BIGINT — NOT NULL — createdAt
- like_count — BIGINT — NOT NULL — updatedAt
- deleted — BOOLEAN — NOT NULL — id
- created_at — TIMESTAMP — NOT NULL — name
- updated_at — TIMESTAMP — NOT NULL — createdAt
PostLike
- id — BIGINT — Primary key — NOT NULL — postId
- user_id — BIGINT — Foreign key → User.id — NOT NULL — authorId
- post_id — BIGINT — Foreign key → Post.id — NOT NULL — parentId
- created_at — TIMESTAMP — NOT NULL — content
- updated_at — TIMESTAMP — NOT NULL — deleted
PostTag
- post_id — BIGINT — Foreign key → Post.id — NOT NULL — createdAt
- tag_id — BIGINT — Foreign key → Tag.id — NOT NULL — updatedAt
RequestComment
- id — BIGINT — Primary key — NOT NULL — senderId
- request_id — BIGINT — Foreign key → RequestPost.id — NOT NULL — receiverId
- author_id — BIGINT — Foreign key → User.id — NOT NULL — content
- parent_id — BIGINT — Foreign key → RequestComment.id — isRead
- content — VARCHAR(2000) — NOT NULL — createdAt
- deleted — BOOLEAN — NOT NULL — updatedAt
- created_at — TIMESTAMP — NOT NULL — id
- updated_at — TIMESTAMP — NOT NULL — userId
RequestPost
- id — BIGINT — Primary key — NOT NULL — requesterId
- title — VARCHAR(100) — NOT NULL — assigneeId
- content — TEXT — NOT NULL — linkedPostId
- asset_type — VARCHAR(60) — deleted
- preferred_style — VARCHAR(60) — createdAt
- engine — VARCHAR(60) — updatedAt
- deadline — DATE — id
- status — VARCHAR(20) — NOT NULL — requestId
- requester_id — BIGINT — Foreign key → User.id — NOT NULL — authorId
- assignee_id — BIGINT — Foreign key → User.id — parentId
- linked_post_id — BIGINT — Foreign key → Post.id — content
- deleted — BOOLEAN — NOT NULL — deleted
- created_at — TIMESTAMP — NOT NULL — createdAt
- updated_at — TIMESTAMP — NOT NULL — updatedAt
Tag
- id — BIGINT — Primary key — NOT NULL — postId
- name — VARCHAR(30) — NOT NULL — tagId
- created_at — TIMESTAMP — NOT NULL — id
- updated_at — TIMESTAMP — NOT NULL — userId
User
- id — BIGINT — Primary key — NOT NULL — id
- email — VARCHAR(50) — NOT NULL — email
- password — VARCHAR(255) — password
- name — VARCHAR(50) — NOT NULL — name
- nickname — VARCHAR(30) — NOT NULL — nickname
- major — VARCHAR(50) — major
- provider — VARCHAR(20) — NOT NULL — provider
- provider_subject — VARCHAR(100) — providerSubject
- avatar_path — VARCHAR(255) — avatarPath
- role — VARCHAR(20) — NOT NULL — role
- created_at — TIMESTAMP — NOT NULL — createdAt
- updated_at — TIMESTAMP — NOT NULL — updatedAt