temp_assetBox
Tables (11)
Admin (Untitled)
- Admin_Id (Key) — Long — Primary key — NOT NULL
- name (Field) — Varchar
- Role (Field2)
- UserID (Key2) — Long — Foreign key → User.UserID — NOT NULL
Category (category)
- Id (Key) — Long — Primary key — NOT NULL
- code (Key2) — String — Primary key — NOT NULL
- Layer (Field) — int
- name (Field2) — String
- parentId (Key3) — Long — Foreign key → Category.Id — NOT NULL
- code (Key22) — String — Foreign key → Category.code — NOT NULL
FilePost (post_file)
- Id (Key) — Long — Primary key — NOT NULL
- name (Field2)
- code (Field3)
- Is_open (Field4) — boolean
- UserID (Key2) — Long — Foreign key → User.UserID — NOT NULL
- RequestID (Key3) — Long — Foreign key → RequestPost.ID — NOT NULL
- categoryID (Key4) — Long — Foreign key → Category.Id — NOT NULL
- code (Key22) — String — Foreign key → Category.code — NOT NULL
FilePostComment (file_comment)
- Id (Key) — Long — Primary key — NOT NULL
- contain_text (Field) — Text
- createdAt (Field2) — DateTime
- editedAt (Field3) — Datetime
- ParentId (Key2) — Long — Foreign key → FilePostComment.Id — NOT NULL
- filepostId (Key3) — Long — Foreign key → FilePost.Id — NOT NULL
RequestPost (post_request)
- ID (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- contain_text (Field2) — Text
- CreatedAt (Field3) — DateTime
- editedAt (Field4) — DateTime
RequestPostcomment (request_comment)
- Id (Key) — Long — Primary key — NOT NULL
- Field
- ParentId (Key2) — Long — Foreign key → RequestPostcomment.Id — NOT NULL
- ID (Key3) — Long — Foreign key → RequestPost.ID — NOT NULL
Tag (tag)
- Id (Key) — Long — Primary key — NOT NULL
- code (Key3) — String — Primary key — NOT NULL
- name (Field)
- Id (Key2) — Long — Foreign key → Category.Id — NOT NULL
- code (Key22) — String — Foreign key → Category.code — NOT NULL
UploadFile (file_upload)
- Id (Key) — Primary key — NOT NULL
- OriginName (Field) — Varchar
- OriginExt (Field2) — Varchar
- FileName (Field3) — varchar
- fileSize (Field4) — Long
- createdAt (Field5) — Datetime
- updatedAt (Field6) — Datetime
- FilePostId (Key2) — Long — Foreign key → FilePost.Id — NOT NULL
- s3FileId (Key3) — Long — Foreign key → s3File.Id — NOT NULL
User
- UserID (Key) — Long — Primary key — NOT NULL
- name (Field)
- Class (Field2) — enum
- createdAt (Field3) — DateTime
- UpdatedAt (Field4) — DateTime
- Userprofile_id (Key2) — Long — Foreign key → Userprofile.Id — NOT NULL
- email (Field5) — text
- phoneNumber (Field6)
Userprofile (user_profile)
- Id (Key) — Long — Primary key — NOT NULL
- Field
- Id (Key2) — Long — Foreign key → s3File.Id — NOT NULL
- s3FileId (Field2)
s3File (file)
- Id (Key) — Long — Primary key — NOT NULL
- Link_text (Field) — Text
- OriginExt (Field2) — Varchar