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