Original ProWikiQ
Tables (9)
Ancestors
- AncestorId (ancestorId) — bigint(20) — Primary key — 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
- AncestorId (ancestorId) — bigint(20) — Foreign key → Ancestors.AncestorId — 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 — 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
- AncestorId (ancestorId) — bigint(20) — Foreign key → Ancestors.AncestorId — NOT NULL
- ObjectName (objectName) — varchar(255) — NOT NULL
- CreatedAt (createdAt) — timestamp
- ModifiedAt (modifiedAt) — timestamp
- PageCategory (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
- UserPassword (userpassword) — varchar(255)
- UserPasswordHash (userpasswordHash) — varchar(255)
- UserEmail (useremail) — varchar(100)
- CreatedAt (createdAt) — timestamp
- ModifiedAt (modifiedAt) — timestamp
- UserPhoneNum (userPhoneNum) — 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)