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