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

Feedback

  • id — BIGINT — NOT NULL

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