ProWikiQ

Tables (9)

Ancestors

  • AncestorId (ancestorId) — bigint(20) — Primary key — NOT NULL
  • ObjectId (objectId) — bigint(20) — Foreign key → Object.ObjectId — NOT NULL
  • ParentFolder (parentFolder) — Object

BrowserList

  • BrowserListFormId (browserListFormId) — bigint(20) — Foreign key → BrowserListForm.BrowserListFormId — NOT NULL
  • PageId (pageId) — bigint(20) — Foreign key → WikiPage.PageId — NOT NULL
  • ObjectId (objectId) — bigint(20) — Foreign key → Object.ObjectId — NOT NULL
  • PageTitle (pageTitle) — String
  • CreatedAt (createdAt) — timestamp
  • ModifiedAt (modifiedAt) — timestamp
  • PageCategory (pageCategory) — String
  • TargetDay (targetDay) — timestamp
  • FinishedDay (finishedDay) — timestamp
  • isFolder — boolean

BrowserListForm

  • BrowserListFormId (browserListFormId) — bigint(20) — Primary key — NOT NULL
  • UserId (userId) — bigint(20) — Foreign key → User.UserId — NOT NULL
  • ListTitle (listTitle) — String
  • ListCategory (listCategory) — String

ChangeRequest

  • ChangeRequestId (changeRequestId) — bigint(20) — Primary key — NOT NULL
  • UserId (userId) — bigint(20) — Foreign key → User.UserId — NOT NULL
  • PageId (pageId) — bigint(20) — Foreign key → WikiPage.PageId — NOT NULL
  • RoleId (roleId) — bigint(20) — Foreign key → Role.RoleId — NOT NULL
  • RevisionName (revisionName) — String
  • CreatedAt (createdAt) — timestamp
  • ModifiedAt (modifiedAt) — timestamp
  • RevisionDescription (revisionDescription) — String

Object

  • ObjectId (objectId) — bigint(20) — Primary key — NOT NULL
  • ObjectName (objectName) — varchar(255) — NOT NULL
  • CreatedAt (createdAt) — timestamp
  • ModifiedAt (modifiedAt) — timestamp
  • ObjectCategory (objectCategory) — String
  • FileType (fileType) — varchar(255)
  • Size (size) — bigint
  • isFolder — boolean
  • FileUrl (fileUrl) — String — NOT NULL
  • ParentFolder (parentFolder) — Object
  • Field

Request

  • RequestId (requestId) — bigint(20) — Primary key — NOT NULL
  • UserId (userId) — bigint(20) — Foreign key → User.UserId — NOT NULL
  • RoleId (roleId) — Long — Foreign key → Role.RoleId — NOT NULL
  • RequestTitle (requestTitle) — String — NOT NULL
  • Content (content) — String
  • CreatedAt (createdAt) — timestamp — NOT NULL
  • ModifiedAt (modifiedAt) — timestamp
  • TargetDay (targetDay) — timestamp
  • FinishedDay (finishedDay) — timestamp
  • RequestValue (requestValue) — String
  • RequestAnswer (requestAnswer) — boolean

Role

  • RoleId (roleId) — bigint(20) — Primary key — NOT NULL
  • RoleName (roleName) — String
  • ParentRole (parentRole) — Role

User

  • UserId (userId) — bigint(20) — Primary key — NOT NULL
  • RoleId (roleId) — bigint(20) — Foreign key → Role.RoleId — NOT NULL
  • Password (password) — varchar(255)
  • PasswordHash (passwordHash) — varchar(255)
  • Email (email) — varchar(100)
  • CreatedAt (createdAt) — timestamp
  • ModifiedAt (modifiedAt) — timestamp
  • PhoneNum (phoneNum) — int(11)
  • Status (status) — varchar(20)
  • Class (class) — varchar(20)

WikiPage

  • PageId (pageId) — bigint(20) — Primary key — NOT NULL
  • CreatedUserId (userId) — bigint(20) — Foreign key → User.UserId — NOT NULL
  • ObjectId (objectId) — bigint(20) — Foreign key → Object.ObjectId — NOT NULL
  • PageTitle (pageTitle) — varchar(255)
  • PageContent (pageContent) — String
  • CreatedAt (createdAt) — timestamp
  • ModifiedAt (modifiedAt) — timestamp
  • PageCategory (pageCategory) — varchar(255)
  • PagePath (pagePath) — varchar(255)
  • PageFilePath (pageFilePath) — varchar(255)