gege

Tables (9)

Admin (admin)

  • adminId (admin_id) — not null — Primary key — NOT NULL
  • role — not null
  • userId (user_id) — not null — Foreign key → User.userId — NOT NULL

Category (category)

  • categoryId (category_id) — not null — Primary key — NOT NULL
  • parentId (parent_id) — not null — Foreign key → Category.categoryId — NOT NULL

FileComment (filecomment)

  • fileCommentId (file_comment_id) — not null — Primary key — NOT NULL
  • filePostId (file_post_id) — not null — Foreign key → FilePost.filePostId — NOT NULL

FilePost (filepost)

  • filePostId (file_post_id) — not null — Primary key — NOT NULL
  • tadId (tagi_d) — not null — Foreign key → Tag.tadId — NOT NULL
  • userId (user_id) — not null — Foreign key → User.userId — NOT NULL
  • categoryId (category_id) — not null — Foreign key → Category.categoryId — NOT NULL
  • requestPostId (request_post_id) — not null — Foreign key → RequestPost.requestPostId — NOT NULL

RequestComment (requestcomment)

  • requestCommendId (request_comment_id) — not null — Primary key — NOT NULL
  • requestPostId (request_post_id) — not null — Foreign key → RequestPost.requestPostId — NOT NULL

RequestPost (requestpost)

  • requestPostId (request_post_id) — not null — Primary key — NOT NULL
  • userId (user_id) — not null — Foreign key → User.userId — NOT NULL

Tag (tag)

  • tadId (tagi_d) — not null — Primary key — NOT NULL
  • Field
  • Field2

UploadDetail (uploaddetail)

  • uploadDetailId (upload_detail_id) — not null — Primary key — NOT NULL
  • originName (origin_name) — not null
  • originExt (origin_ext) — not null
  • fileName (file_name) — not null
  • fileExt (file_ext) — not null
  • fileSize (file_size) — not null
  • createdAt (created_at) — not null
  • updatedAt (updated_at) — not null
  • filePostId (file_post_id) — not null — Foreign key → FilePost.filePostId — NOT NULL

User (user)

  • userId (user_id) — not null — Primary key — NOT NULL
  • userCode (user_code) — not null
  • class — not null