Click here to register.

Database Schema Reference

This shows the database schema from the latest version of WebGUI.

AdSku

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
purchaseTemplate char(22) NO
manageTemplate char(22) NO
adSpace char(22) NO
priority int(11) YES 1
pricePerClick float YES 0
pricePerImpression float YES 0
clickDiscounts char(22) YES
impressionDiscounts char(22) YES
karma int(11) YES

Article

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
linkTitle varchar(255) YES
linkURL text YES
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 3600
storageId varchar(22) YES

AssetReport

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
settings mediumtext YES
templateId char(22) YES
paginateAfter bigint(20) YES

Calendar

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
defaultDate enum('current','first','last') YES current
defaultView enum('month','week','day','list') YES month
visitorCacheTimeout int(11) unsigned YES
templateIdMonth varchar(22) YES CalendarMonth000000001
templateIdWeek varchar(22) YES CalendarWeek0000000001
templateIdDay varchar(22) YES CalendarDay00000000001
templateIdEvent varchar(22) YES CalendarEvent000000001
templateIdEventEdit varchar(22) YES CalendarEventEdit00001
templateIdSearch varchar(22) YES CalendarSearch00000001
templateIdPrintMonth varchar(22) YES CalendarPrintMonth0001
templateIdPrintWeek varchar(22) YES CalendarPrintWeek00001
templateIdPrintDay varchar(22) YES CalendarPrintDay000001
templateIdPrintEvent varchar(22) YES CalendarPrintEvent0001
groupIdEventEdit varchar(22) YES 3
groupIdSubscribed varchar(22) YES
subscriberNotifyOffset int(11) YES
sortEventsBy enum('time','sequencenumber') YES time
listViewPageInterval bigint(20) YES
templateIdList varchar(22) YES
templateIdPrintList varchar(22) YES
icalInterval bigint(20) YES
workflowIdCommit varchar(22) YES
icalFeeds longtext YES

Carousel

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
items mediumtext YES
templateId char(22) YES
slideWidth int(11) YES
slideHeight int(11) YES
autoPlay int(11) YES
autoPlayInterval int(11) YES
richEditor char(22) YES

Collaboration

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
postGroupId varchar(22) YES 2
canStartThreadGroupId varchar(22) YES 2
karmaPerPost int(11) NO 0
collaborationTemplateId varchar(22) YES
threadTemplateId varchar(22) YES
postFormTemplateId varchar(22) YES
searchTemplateId varchar(22) YES
notificationTemplateId varchar(22) YES
sortBy varchar(35) YES assetData.revisionDate
sortOrder varchar(4) YES desc
usePreview int(11) NO 1
addEditStampToPosts int(11) NO 0
editTimeout int(11) NO 3600
attachmentsPerPost int(11) NO 0
filterCode varchar(30) YES javascript
useContentFilter int(11) NO 1
threads int(11) NO 0
views int(11) NO 0
replies int(11) NO 0
rating int(11) NO 0
lastPostId varchar(22) YES
lastPostDate bigint(20) YES
archiveAfter int(11) NO 31536000
postsPerPage int(11) NO 10
threadsPerPage int(11) NO 30
subscriptionGroupId varchar(22) YES
allowReplies int(11) NO 0
displayLastReply int(11) NO 0
richEditor varchar(22) YES PBrichedit000000000002
karmaRatingMultiplier int(11) NO 0
karmaSpentToRate int(11) NO 0
revisionDate bigint(20) NO PRI 0
avatarsEnabled int(11) NO 0
approvalWorkflow varchar(22) YES pbworkflow000000000003
threadApprovalWorkflow varchar(22) YES pbworkflow000000000003
defaultKarmaScale int(11) NO 1
mailServer varchar(255) YES
mailAccount varchar(255) YES
mailPassword varchar(255) YES
mailAddress varchar(255) YES
mailPrefix varchar(255) YES
getMail int(11) NO 0
getMailInterval char(64) YES
getMailCronId varchar(22) YES
visitorCacheTimeout int(11) NO 3600
autoSubscribeToThread int(11) NO 1
requireSubscriptionForEmailPosting int(11) NO 1
thumbnailSize int(11) NO 0
maxImageSize int(11) NO 0
enablePostMetaData int(11) NO 0
useCaptcha int(11) NO 0
groupToEditPost varchar(22) YES
archiveEnabled int(1) YES 1
postReceivedTemplateId varchar(22) YES default_post_received1
replyRichEditor char(22) YES PBrichedit000000000002
replyFilterCode char(30) YES javascript
unsubscribeTemplateId char(22) NO

Dashboard

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
adminsGroupId varchar(22) YES 4
usersGroupId varchar(22) YES 2
templateId varchar(22) YES DashboardViewTmpl00001
isInitialized tinyint(3) unsigned NO 0
assetsToHide text YES

Dashboard_dashlets

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
dashboardAssetId char(22) NO PRI
dashletAssetId char(22) NO PRI
isStatic tinyint(1) YES
isRequired tinyint(1) YES

Dashboard_userPrefs

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
dashboardAssetId char(22) NO PRI
dashletAssetId char(22) NO PRI
userId char(22) NO PRI
isMinimized tinyint(1) YES
properties longtext YES

DataForm

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
acknowledgement text YES
mailData int(11) NO 1
emailTemplateId varchar(22) YES
acknowlegementTemplateId varchar(22) YES
listTemplateId varchar(22) YES
assetId varchar(22) NO PRI
templateId varchar(22) YES
defaultView int(11) NO 0
revisionDate bigint(20) NO PRI 0
groupToViewEntries varchar(22) YES 7
mailAttachments int(11) YES 0
useCaptcha int(1) YES 0
storeData int(1) YES 1
fieldConfiguration longtext YES
tabConfiguration longtext YES
workflowIdAddEntry char(22) YES
htmlAreaRichEditor char(22) YES **Use_Default_Editor**

DataForm_entry

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
DataForm_entryId varchar(22) NO PRI
userId varchar(22) YES
username varchar(255) YES
ipAddress varchar(255) YES
assetId varchar(22) YES MUL
entryData longtext YES
submissionDate datetime YES

DataTable

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
data longtext YES
templateId varchar(22) YES

EMSBadge

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
price float NO 0
seatsAvailable int(11) NO 100
relatedBadgeGroups mediumtext YES
templateId varchar(22) NO
earlyBirdPrice float NO 0
earlyBirdPriceEndDate bigint(20) YES
preRegistrationPrice float NO 0
preRegistrationPriceEndDate bigint(20) YES

EMSBadgeGroup

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
badgeGroupId varchar(22) NO PRI
emsAssetId varchar(22) YES
name varchar(100) YES
ticketsPerBadge int(11) YES

EMSEventMetaField

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldId varchar(22) NO PRI
assetId varchar(22) YES
label varchar(100) YES
dataType varchar(20) YES
visible tinyint(4) YES 0
required tinyint(4) YES 0
possibleValues text YES
defaultValues text YES
sequenceNumber int(5) YES
helpText mediumtext YES

EMSRegistrant

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
badgeId varchar(22) NO PRI
userId varchar(22) YES
badgeNumber int(11) NO UNI auto_increment
badgeAssetId varchar(22) YES MUL
emsAssetId varchar(22) YES
name varchar(35) YES
address1 varchar(35) YES
address2 varchar(35) YES
address3 varchar(35) YES
city varchar(35) YES
state varchar(35) YES
zipcode varchar(35) YES
country varchar(35) YES
phoneNumber varchar(35) YES
organization varchar(35) YES
email varchar(255) YES
notes mediumtext YES
purchaseComplete tinyint(1) YES
hasCheckedIn tinyint(1) YES
transactionItemId varchar(22) YES

EMSRegistrantRibbon

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
badgeId varchar(22) NO PRI
ribbonAssetId varchar(22) NO PRI
transactionItemId varchar(22) YES

EMSRegistrantTicket

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
badgeId varchar(22) NO PRI
ticketAssetId varchar(22) NO PRI
purchaseComplete tinyint(1) YES
transactionItemId varchar(22) YES

EMSRegistrantToken

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
badgeId varchar(22) NO PRI
tokenAssetId varchar(22) NO PRI
quantity int(11) YES
transactionItemIds text YES

EMSRibbon

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
percentageDiscount float NO 10
price float NO 0

EMSSubmission

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
submissionId int(11) NO
submissionStatus char(30) YES
ticketId char(22) YES
description mediumtext YES
sku char(35) YES
vendorId char(22) YES
displayTitle tinyint(1) YES
shipsSeparately tinyint(1) YES
price float YES
seatsAvailable int(11) YES
startDate datetime YES
duration float YES
eventNumber int(11) YES
location char(100) YES
relatedBadgeGroups mediumtext YES
relatedRibbons mediumtext YES
eventMetaData mediumtext YES

EMSSubmissionForm

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
canSubmitGroupId char(22) YES
daysBeforeCleanup int(11) YES
deleteCreatedItems int(1) YES
formDescription text YES
submissionDeadline date YES
pastDeadlineMessage text YES

EMSTicket

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
price float NO 0
seatsAvailable int(11) NO 100
startDate datetime YES
duration float NO 1
eventNumber int(11) YES
location varchar(100) YES
relatedBadgeGroups mediumtext YES
relatedRibbons mediumtext YES
eventMetaData mediumtext YES

EMSToken

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
price float NO 0

Event

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
feedId varchar(22) YES
feedUid varchar(255) YES
startDate date YES
endDate date YES
userDefined1 text YES
userDefined2 text YES
userDefined3 text YES
userDefined4 text YES
userDefined5 text YES
recurId varchar(22) YES
description longtext YES
startTime time YES
endTime time YES
relatedLinks longtext YES
location varchar(255) YES
storageId varchar(22) YES
timeZone varchar(255) YES America/Chicago
sequenceNumber bigint(20) YES
iCalSequenceNumber int(11) YES

EventManagementSystem

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
timezone varchar(30) YES America/Chicago
templateId varchar(22) YES 2rC4ErZ3c77OJzJm7O5s3w
badgeBuilderTemplateId varchar(22) YES BMybD3cEnmXVk2wQ_qEsRQ
lookupRegistrantTemplateId varchar(22) YES OOyMH33plAy6oCj_QWrxtg
printBadgeTemplateId varchar(22) YES PsFn7dJt4wMwBa8hiE3hOA
printTicketTemplateId varchar(22) YES yBwydfooiLvhEFawJb0VTQ
printRemainingTicketsTemplateId char(22) NO hreA_bgxiTX-EzWCSZCZJw
badgeInstructions mediumtext YES
ribbonInstructions mediumtext YES
ticketInstructions mediumtext YES
tokenInstructions mediumtext YES
registrationStaffGroupId varchar(22) YES
scheduleTemplateId char(22) YES
scheduleColumnsPerPage int(11) YES
eventSubmissionTemplateId char(22) YES
eventSubmissionQueueTemplateId char(22) YES
eventSubmissionMainTemplateId char(22) YES
eventSubmissionGroups mediumtext YES
submittedLocationsList mediumtext YES

Event_recur

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
recurId varchar(22) NO PRI
recurType varchar(16) YES
pattern varchar(255) YES
startDate date YES
endDate varchar(10) YES

Event_relatedlink

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
eventlinkId varchar(22) YES
assetId varchar(22) YES
linkURL tinytext YES
linktext varchar(80) YES
groupIdView varchar(22) YES
sequenceNumber bigint(20) YES

FileAsset

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
storageId varchar(22) YES
filename varchar(255) YES
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 3600

FlatDiscount

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
templateId varchar(22) YES 63ix2-hU0FchXGIWkG3tow
mustSpend float NO 0
percentageDiscount int(3) NO 0
priceDiscount float NO 0
thankYouMessage mediumtext YES

Folder

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
visitorCacheTimeout int(11) NO 3600
sortAlphabetically int(11) NO 0
sortOrder enum('ASC','DESC') YES ASC

Fork

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
id char(22) NO PRI
userId char(22) YES
groupId char(22) YES
status longtext YES
error text YES
startTime bigint(20) YES
endTime bigint(20) YES
finished tinyint(1) YES 0
latch tinyint(1) YES 0
redirect char(255) YES

Gallery

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
groupIdAddComment varchar(22) YES
groupIdAddFile varchar(22) YES
imageResolutions text YES
imageViewSize int(11) YES
imageThumbnailSize int(11) YES
maxSpacePerUser varchar(20) YES
richEditIdComment varchar(22) YES
templateIdAddArchive varchar(22) YES
templateIdDeleteAlbum varchar(22) YES
templateIdDeleteFile varchar(22) YES
templateIdEditAlbum varchar(22) YES
templateIdEditFile varchar(22) YES
templateIdListAlbums varchar(22) YES
templateIdListAlbumsRss varchar(22) YES
templateIdListFilesForUser varchar(22) YES
templateIdListFilesForUserRss varchar(22) YES
templateIdMakeShortcut varchar(22) YES
templateIdSearch varchar(22) YES
templateIdViewSlideshow varchar(22) YES
templateIdViewThumbnails varchar(22) YES
templateIdViewAlbum varchar(22) YES
templateIdViewAlbumRss varchar(22) YES
templateIdViewFile varchar(22) YES
viewAlbumAssetId varchar(22) YES
viewDefault enum('album','list') YES
viewListOrderBy varchar(40) YES
viewListOrderDirection enum('ASC','DESC') YES
workflowIdCommit varchar(22) YES
templateIdEditComment varchar(22) YES
richEditIdAlbum varchar(22) YES
richEditIdFile varchar(22) YES
defaultFilesPerPage int(11) YES
imageDensity int(11) YES

GalleryAlbum

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
allowComments int(11) YES
assetIdThumbnail varchar(22) YES
userDefined1 text YES
userDefined2 text YES
userDefined3 text YES
userDefined4 text YES
userDefined5 text YES
othersCanAdd int(11) YES

GalleryFile

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
userDefined1 longtext YES
userDefined2 longtext YES
userDefined3 longtext YES
userDefined4 longtext YES
userDefined5 longtext YES
views bigint(20) YES 0
friendsOnly int(1) YES 0
rating int(1) YES 0

GalleryFile_comment

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
commentId varchar(22) NO PRI
userId varchar(22) YES
visitorIp varchar(255) YES
creationDate datetime YES
bodyText longtext YES

HelpDesk

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
viewTemplateId varchar(22) NO HELPDESK00000000000001
viewMyTemplateId varchar(22) NO HELPDESK00000000000002
viewAllTemplateId varchar(22) NO HELPDESK00000000000003
searchTemplateId varchar(22) NO HELPDESK00000000000004
manageMetaTemplateId varchar(22) NO HELPDESK00000000000005
editMetaFieldTemplateId varchar(22) NO HELPDESK00000000000006
notificationTemplateId varchar(22) NO HELPDESK00000000000007
editTicketTemplateId varchar(22) NO TICKET0000000000000001
viewTicketTemplateId varchar(22) NO TICKET0000000000000002
viewTicketRelatedFilesTemplateId varchar(22) NO TICKET0000000000000003
viewTicketUserListTemplateId varchar(22) NO TICKET0000000000000004
viewTicketCommentsTemplateId varchar(22) NO TICKET0000000000000005
viewTicketHistoryTemplateId varchar(22) NO TICKET0000000000000006
richEditIdPost varchar(22) NO PBrichedit000000000002
approvalWorkflow varchar(22) NO pbworkflow000000000003
groupToPost varchar(22) NO 3
groupToChangeStatus varchar(22) NO 3
karmaEnabled tinyint(4) YES 0
karmaPerPost int(11) NO 0
karmaToClose int(11) NO 0
defaultKarmaScale int(11) NO 1
sortColumn enum('ticketId','title','createdBy','creationDate','assignedTo','ticketStatus','lastReplyDate','karmaRank') YES creationDate
sortOrder enum('ASC','DESC') YES DESC
subscriptionGroup varchar(255) NO
mailServer varchar(255) YES
mailAccount varchar(255) YES
mailPassword varchar(255) YES
mailAddress varchar(255) YES
mailPrefix varchar(255) YES
getMail tinyint(4) NO 0
getMailInterval int(11) NO 300
getMailCronId varchar(22) YES
autoSubscribeToTicket tinyint(4) NO 1
requireSubscriptionForEmailPosting tinyint(4) NO 1
closeTicketsAfter int(11) NO 1209600

HelpDesk_metaField

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldId varchar(22) NO PRI
assetId varchar(22) NO
label varchar(100) YES
dataType varchar(20) YES
required tinyint(4) YES 0
searchable tinyint(4) YES 0
possibleValues text YES
defaultValues text YES
hoverHelp text YES
sequenceNumber int(5) YES
showInList int(1) YES
sortable tinyint(4) YES

HttpProxy

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
proxiedUrl text YES
timeout int(11) YES
removeStyle int(11) YES
filterHtml varchar(30) YES
followExternal int(11) YES
followRedirect int(11) YES
cacheHttp int(11) YES 0
useCache int(11) YES 0
debug int(11) YES 0
rewriteUrls int(11) YES
searchFor varchar(255) YES
stopAt varchar(255) YES
cookieJarStorageId varchar(22) YES
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 0
useAmpersand int(11) NO 0
urlPatternFilter mediumtext YES

ImageAsset

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
thumbnailSize int(11) NO 50
parameters text YES
revisionDate bigint(20) NO PRI 0
annotations mediumtext YES

InOutBoard

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
statusList text YES
reportViewerGroup varchar(22) YES 3
inOutGroup varchar(22) YES 2
inOutTemplateId varchar(22) YES IOB0000000000000000001
reportTemplateId varchar(22) YES IOB0000000000000000002
paginateAfter int(11) NO 50
reportPaginateAfter int(11) NO 50

InOutBoard_delegates

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) YES
delegateUserId varchar(22) YES
assetId varchar(22) YES

InOutBoard_status

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) YES
userId varchar(22) YES
status varchar(255) YES
dateStamp int(11) NO
message text YES

InOutBoard_statusLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) YES
userId varchar(22) YES
status varchar(255) YES
dateStamp int(11) NO
message text YES
createdBy varchar(22) YES

KarmaGifter

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO
revisionDate bigint(20) unsigned NO
templateId varchar(22) NO
topUserLimit int(11) YES
allowGiftFrom varchar(22) NO
allowGiftTo varchar(22) NO

Layout

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
templateId varchar(22) YES
contentPositions text YES
assetsToHide text YES
revisionDate bigint(20) NO PRI 0
assetOrder varchar(20) YES asc
mobileTemplateId char(22) YES PBtmpl0000000000000054

Map

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
groupIdAddPoint char(22) YES
mapApiKey text YES
mapHeight char(12) YES
mapWidth char(12) YES
startLatitude float YES
startLongitude float YES
startZoom tinyint(3) unsigned YES
templateIdEditPoint char(22) YES
templateIdView char(22) YES
templateIdViewPoint char(22) YES
workflowIdPoint char(22) YES

MapPoint

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
latitude double YES
longitude double YES
website char(255) YES
address1 char(255) YES
address2 char(255) YES
city char(255) YES
region char(255) YES
zipCode char(255) YES
country char(255) YES
phone char(255) YES
fax char(255) YES
email char(255) YES
storageIdPhoto char(22) YES
userDefined1 char(255) YES
userDefined2 char(255) YES
userDefined3 char(255) YES
userDefined4 char(255) YES
userDefined5 char(255) YES
isGeocoded tinyint(1) YES

Matrix

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
detailTemplateId varchar(22) YES
compareTemplateId varchar(22) YES
searchTemplateId varchar(22) YES
categories text YES
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
maxComparisons int(11) NO 10
maxComparisonsPrivileged int(11) NO 10
defaultSort char(22) NO score
compareColorNo char(22) YES #ffaaaa
compareColorLimited char(22) NO #ffffaa
compareColorCostsExtra char(22) NO #ffffaa
compareColorFreeAddOn char(22) NO #ffffaa
compareColorYes char(22) NO #aaffaa
submissionApprovalWorkflowId char(22) NO
ratingsDuration int(11) NO 7776000
editListingTemplateId char(22) YES
groupToAdd char(22) YES 2
screenshotsConfigTemplateId char(22) YES
screenshotsTemplateId char(22) YES
statisticsCacheTimeout int(11) NO 3600
maxScreenshotWidth int(11) YES
maxScreenshotHeight int(11) YES
listingsCacheTimeout int(11) NO 3600
maxComparisonsGroup char(22) YES
maxComparisonsGroupInt int(11) YES

MatrixListing

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
screenshots char(22) YES
description text YES
version char(255) YES
views int(11) YES
compares int(11) YES
clicks int(11) YES
viewsLastIp char(255) YES
comparesLastIp char(255) YES
clicksLastIp char(255) YES
lastUpdated int(11) YES
maintainer char(22) YES
manufacturerName char(255) YES
manufacturerURL char(255) YES
productURL char(255) YES
score int(11) YES

MatrixListing_attribute

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
matrixId char(22) NO
matrixListingId char(22) NO PRI
attributeId char(22) NO PRI
value char(255) YES

MatrixListing_rating

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
timeStamp int(11) NO 0
category varchar(255) YES
rating int(11) NO 1
listingId varchar(22) YES
ipAddress varchar(15) YES
assetId varchar(22) YES
userId varchar(22) YES

MatrixListing_ratingSummary

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
listingId varchar(22) NO PRI
category varchar(255) NO PRI
meanValue decimal(3,2) YES
medianValue int(11) YES
countValue int(11) YES
assetId varchar(22) YES

Matrix_attribute

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
attributeId char(22) NO PRI
category varchar(255) YES MUL
name varchar(255) YES
description text YES
fieldType char(255) NO MatrixCompare
defaultValue varchar(255) YES
assetId varchar(22) YES
options text YES

MessageBoard

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
visitorCacheTimeout int(11) NO 3600

MultiSearch

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
templateId varchar(22) YES MultiSearchTmpl0000001
predefinedSearches text YES
cacheTimeout int(11) NO 3600

Navigation

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
assetsToInclude text YES
startType varchar(35) YES
startPoint varchar(255) YES
descendantEndPoint int(11) NO 55
showSystemPages int(11) NO 0
showHiddenPages int(11) NO 0
showUnprivilegedPages int(11) NO 0
templateId varchar(22) YES
ancestorEndPoint int(11) NO 55
revisionDate bigint(20) NO PRI 0
mimeType varchar(50) YES text/html
reversePageLoop tinyint(1) YES 0

Newsletter

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
newsletterTemplateId varchar(22) YES newsletter000000000001
mySubscriptionsTemplateId varchar(22) YES newslettersubscrip0001
newsletterHeader mediumtext YES
newsletterFooter mediumtext YES
newsletterCategories text YES

Newsletter_subscriptions

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
userId varchar(22) NO PRI
subscriptions text YES
lastTimeSent bigint(20) NO MUL 0

PA_lastLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId char(22) NO PRI
assetId char(22) NO
sessionId char(22) NO PRI
timeStamp bigint(20) YES
url char(255) NO

PM_project

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
projectId varchar(22) NO PRI
assetId varchar(22) YES
name varchar(255) YES
description text YES
startDate bigint(20) YES
endDate bigint(20) YES
projectManager varchar(22) YES
durationUnits enum('hours','days') YES hours
hoursPerDay float YES
targetBudget float(15,2) YES 0.00
percentComplete float NO 0
parentId varchar(22) YES
creationDate bigint(20) NO
createdBy varchar(22) YES
lastUpdatedBy varchar(22) YES
lastUpdateDate bigint(20) NO
projectObserver varchar(22) YES 7

PM_task

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
taskId varchar(22) NO PRI
projectId varchar(22) YES
taskName varchar(255) YES
duration float YES
startDate bigint(20) YES
endDate bigint(20) YES
dependants varchar(50) YES
parentId varchar(22) YES
percentComplete float YES
sequenceNumber int(11) NO 1
creationDate bigint(20) NO
createdBy varchar(22) YES
lastUpdatedBy varchar(22) YES
lastUpdateDate bigint(20) NO
lagTime bigint(20) YES 0
taskType enum('timed','progressive','milestone') NO timed

PM_taskResource

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
taskResourceId varchar(22) NO PRI
taskId varchar(22) YES MUL
sequenceNumber int(11) NO
resourceKind enum('user','group') NO
resourceId varchar(22) YES

PM_wobject

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
projectDashboardTemplateId varchar(22) YES ProjectManagerTMPL0001
projectDisplayTemplateId varchar(22) YES ProjectManagerTMPL0002
ganttChartTemplateId varchar(22) YES ProjectManagerTMPL0003
editTaskTemplateId varchar(22) YES ProjectManagerTMPL0004
groupToAdd varchar(22) YES 3
revisionDate bigint(20) NO PRI
resourcePopupTemplateId varchar(22) YES ProjectManagerTMPL0005
resourceListTemplateId varchar(22) YES ProjectManagerTMPL0006

Photo

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
exifData longtext YES
location varchar(255) YES

Photo_rating

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) YES MUL
userId varchar(22) YES
visitorIp varchar(255) YES
rating int(11) YES

Poll

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
active int(11) NO 1
graphWidth int(11) NO 150
voteGroup varchar(22) YES
question varchar(255) YES
a1 varchar(255) YES
a2 varchar(255) YES
a3 varchar(255) YES
a4 varchar(255) YES
a5 varchar(255) YES
a6 varchar(255) YES
a7 varchar(255) YES
a8 varchar(255) YES
a9 varchar(255) YES
a10 varchar(255) YES
a11 varchar(255) YES
a12 varchar(255) YES
a13 varchar(255) YES
a14 varchar(255) YES
a15 varchar(255) YES
a16 varchar(255) YES
a17 varchar(255) YES
a18 varchar(255) YES
a19 varchar(255) YES
a20 varchar(255) YES
karmaPerVote int(11) NO 0
randomizeAnswers int(11) NO 0
assetId varchar(22) NO PRI
templateId varchar(22) YES
revisionDate bigint(20) NO PRI 0
graphConfiguration blob YES
generateGraph tinyint(1) YES

Poll_answer

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
answer char(3) YES
userId varchar(22) YES
ipAddress varchar(50) YES
assetId varchar(22) YES

Post

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
threadId varchar(22) YES MUL
username varchar(30) YES
content mediumtext YES
views int(11) NO 0
contentType varchar(35) YES mixed
userDefined1 mediumtext YES
userDefined2 mediumtext YES
userDefined3 mediumtext YES
userDefined4 mediumtext YES
userDefined5 mediumtext YES
storageId varchar(22) NO
rating int(11) NO 0
revisionDate bigint(20) NO PRI 0
originalEmail mediumtext YES

Post_rating

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO MUL
userId varchar(22) NO
ipAddress varchar(15) NO
dateOfRating bigint(20) YES
rating int(11) NO 0

Product

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
image1 varchar(255) YES
image2 varchar(255) YES
image3 varchar(255) YES
brochure varchar(255) YES
manual varchar(255) YES
warranty varchar(255) YES
assetId varchar(22) NO PRI
templateId varchar(22) NO
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 3600
thankYouMessage mediumtext YES
accessoryJSON longtext YES
benefitJSON longtext YES
featureJSON longtext YES
relatedJSON longtext YES
specificationJSON longtext YES
variantsJSON longtext YES
isShippingRequired int(11) YES

RichEdit

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
askAboutRichEdit int(11) NO 0
preformatted int(11) NO 0
editorWidth int(11) NO 0
editorHeight int(11) NO 0
sourceEditorWidth int(11) NO 0
sourceEditorHeight int(11) NO 0
useBr int(11) NO 0
nowrap int(11) NO 0
removeLineBreaks int(11) NO 0
npwrap int(11) NO 0
directionality char(3) NO ltr
toolbarLocation varchar(6) NO bottom
cssFile varchar(255) YES
validElements mediumtext YES
toolbarRow1 mediumtext YES
toolbarRow2 mediumtext YES
toolbarRow3 mediumtext YES
enableContextMenu int(11) NO 0
revisionDate bigint(20) NO PRI 0
disableRichEditor int(11) YES 0
inlinePopups int(11) NO 0
allowMedia int(11) YES

SQLReport

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
dbQuery1 mediumtext YES
paginateAfter int(11) NO 50
preprocessMacros1 int(11) YES 0
debugMode int(11) NO 0
databaseLinkId1 varchar(22) NO
placeholderParams1 mediumtext YES
preprocessMacros2 int(11) YES 0
dbQuery2 mediumtext YES
placeholderParams2 mediumtext YES
databaseLinkId2 varchar(22) NO
preprocessMacros3 int(11) YES 0
dbQuery3 mediumtext YES
placeholderParams3 mediumtext YES
databaseLinkId3 varchar(22) NO
preprocessMacros4 int(11) YES 0
dbQuery4 mediumtext YES
placeholderParams4 mediumtext YES
databaseLinkId4 varchar(22) NO
preprocessMacros5 int(11) YES 0
dbQuery5 mediumtext YES
placeholderParams5 mediumtext YES
databaseLinkId5 varchar(22) NO
assetId varchar(22) NO PRI
templateId varchar(22) NO
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 0
prequeryStatements1 mediumtext YES
prequeryStatements2 mediumtext YES
prequeryStatements3 mediumtext YES
prequeryStatements4 mediumtext YES
prequeryStatements5 mediumtext YES
downloadType varchar(255) YES
downloadFilename varchar(255) YES
downloadTemplateId varchar(22) YES
downloadMimeType varchar(255) YES
downloadUserGroup varchar(22) YES

Shelf

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
templateId varchar(22) NO nFen0xjkZn8WkpM93C9ceQ

Shortcut

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
overrideTitle int(11) NO 0
overrideDescription int(11) NO 0
overrideTemplate int(11) NO 0
overrideDisplayTitle int(11) NO 0
overrideTemplateId varchar(22) NO
shortcutByCriteria int(11) NO 0
resolveMultiples varchar(30) YES mostRecent
shortcutCriteria mediumtext NO
assetId varchar(22) NO PRI
templateId varchar(22) NO
shortcutToAssetId varchar(22) NO
disableContentLock int(11) NO 0
revisionDate bigint(20) NO PRI 0
prefFieldsToShow mediumtext YES
prefFieldsToImport mediumtext YES
showReloadIcon tinyint(3) unsigned NO 0

Shortcut_overrides

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
fieldName varchar(255) NO PRI
newValue mediumtext YES

StockData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
templateId varchar(22) NO StockListTMPL000000001
displayTemplateId varchar(22) NO StockListTMPL000000002
defaultStocks mediumtext YES
source varchar(50) YES usa
failover int(11) YES 1
revisionDate bigint(20) NO PRI 0
cacheTimeout bigint(20) YES

Story

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
headline char(255) YES
subtitle char(255) YES
byline char(255) YES
location char(255) YES
highlights text YES
story mediumtext YES
photo longtext YES

StoryArchive

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
storiesPerPage int(11) YES
groupToPost char(22) YES
templateId char(22) YES
storyTemplateId char(22) YES
editStoryTemplateId char(22) YES
keywordListTemplateId char(22) YES
archiveAfter int(11) YES
richEditorId char(22) YES
approvalWorkflowId char(22) YES pbworkflow000000000003
photoWidth int(11) YES
storySortOrder char(22) YES
photoHeight int(11) YES

StoryTopic

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
storiesPer int(11) YES
storiesShort int(11) YES
templateId char(22) YES
storyTemplateId char(22) YES
storySortOrder char(22) YES

Subscription

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
templateId varchar(22) NO
thankYouMessage mediumtext YES
price float NO 0
subscriptionGroup varchar(22) NO 2
duration varchar(12) NO Monthly
executeOnSubscription varchar(255) YES
karma int(6) YES 0
recurringSubscription tinyint(1) NO 1
redeemSubscriptionCodeTemplateId char(22) NO

Subscription_code

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
code varchar(64) NO PRI
batchId varchar(22) NO
status varchar(10) NO Unused
dateUsed bigint(20) YES
usedBy varchar(22) YES

Subscription_codeBatch

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
batchId varchar(22) NO PRI
name varchar(255) YES
description mediumtext YES
subscriptionId varchar(22) NO
expirationDate bigint(20) NO
dateCreated bigint(20) NO

Survey

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
groupToTakeSurvey char(22) NO 2
groupToEditSurvey char(22) NO 3
groupToViewReports char(22) NO 3
overviewTemplateId char(22) NO
maxResponsesPerUser int(11) NO 1
gradebookTemplateId char(22) NO
assetId char(22) NO PRI
templateId char(22) NO
revisionDate bigint(20) NO PRI 0
surveyEditTemplateId char(22) YES
answerEditTemplateId char(22) YES
questionEditTemplateId char(22) YES
sectionEditTemplateId char(22) YES
surveyTakeTemplateId char(22) YES
surveyQuestionsId char(22) YES
exitURL text YES
surveyJSON longtext YES
timeLimit mediumint(8) unsigned NO
showProgress tinyint(3) unsigned NO 0
showTimeLimit tinyint(3) unsigned NO 0
doAfterTimeLimit char(22) YES
onSurveyEndWorkflowId char(22) YES
quizModeSummary tinyint(3) YES
surveySummaryTemplateId char(22) YES
allowBackBtn tinyint(3) YES
feedbackTemplateId char(22) YES
testResultsTemplateId char(22) YES

Survey_answer_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
Survey_id varchar(22) NO
Survey_questionId varchar(22) NO
Survey_answerId varchar(22) NO PRI
sequenceNumber int(11) NO 1
gotoQuestion varchar(22) YES
answer varchar(255) YES
isCorrect int(11) NO 0

Survey_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
questionOrder varchar(30) YES
groupToTakeSurvey varchar(22) NO 2
groupToViewReports varchar(22) NO 3
mode varchar(30) YES
Survey_id varchar(22) NO
anonymous char(1) NO 0
questionsPerPage int(11) NO 1
responseTemplateId varchar(22) NO
overviewTemplateId varchar(22) NO
maxResponsesPerUser int(11) NO 1
questionsPerResponse int(11) NO 9999999
gradebookTemplateId varchar(22) NO
assetId varchar(22) NO PRI
templateId varchar(22) NO
revisionDate bigint(20) NO PRI 0
defaultSectionId varchar(22) NO

Survey_questionResponse_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
Survey_id varchar(22) NO
Survey_questionId varchar(22) NO PRI
Survey_answerId varchar(22) NO PRI
Survey_responseId varchar(22) NO PRI
response mediumtext YES
comment mediumtext YES
dateOfResponse bigint(20) NO 0

Survey_questionTypes

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
questionType char(56) NO PRI
answers text NO

Survey_question_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
Survey_id varchar(22) NO
Survey_questionId varchar(22) NO PRI
question mediumtext YES
sequenceNumber int(11) NO 1
allowComment int(11) NO 0
randomizeAnswers int(11) NO 0
answerFieldType varchar(35) YES
gotoQuestion varchar(22) YES
Survey_sectionId varchar(22) NO

Survey_response

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO
Survey_responseId char(22) NO PRI
userId char(22) YES
username char(255) YES
ipAddress char(15) YES
startDate bigint(20) NO 0
endDate bigint(20) NO 0
isComplete int(11) NO 0
anonId varchar(255) YES
responseJSON longtext YES
revisionDate bigint(20) NO 0

Survey_response_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
Survey_id varchar(22) NO
Survey_responseId varchar(22) NO PRI
userId varchar(22) YES
username varchar(255) YES
ipAddress varchar(15) YES
startDate bigint(20) NO 0
endDate bigint(20) NO 0
isComplete int(11) NO 0

Survey_section_old

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
Survey_id varchar(22) NO
Survey_sectionId varchar(22) NO PRI
sectionName mediumtext YES
sequenceNumber int(11) NO 1

Survey_tempReport

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
Survey_responseId char(22) NO PRI
order smallint(5) unsigned NO PRI
sectionNumber smallint(5) unsigned NO
sectionName text YES
questionNumber smallint(5) unsigned NO
questionName text YES
questionComment mediumtext YES
answerNumber smallint(5) unsigned YES
answerValue mediumtext YES
answerComment mediumtext YES
entryDate bigint(20) unsigned NO
isCorrect tinyint(3) unsigned YES
value int(11) YES
fileStoreageId char(22) YES

Survey_test

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
testId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
assetId char(255) YES MUL
name char(255) YES
test mediumtext NO

SyndicatedContent

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
rssUrl mediumtext YES
maxHeadlines int(11) NO 0
assetId varchar(22) NO PRI
templateId varchar(22) NO
revisionDate bigint(20) NO PRI 0
hasTerms varchar(255) NO
cacheTimeout int(11) NO 3600
processMacroInRssUrl int(11) YES 0
sortItems char(255) YES

TT_projectList

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
projectId varchar(22) NO PRI
assetId varchar(22) YES
projectName varchar(255) NO
creationDate bigint(20) NO
createdBy varchar(22) NO
lastUpdatedBy varchar(22) NO
lastUpdateDate bigint(20) NO

TT_projectResourceList

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
projectId varchar(22) NO PRI
resourceId varchar(22) NO PRI

TT_projectTasks

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
taskId varchar(22) NO PRI
projectId varchar(22) NO
taskName varchar(255) NO

TT_report

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
reportId varchar(22) NO
assetId varchar(22) NO
startDate varchar(10) NO
endDate varchar(10) NO
reportComplete int(11) NO 0
resourceId varchar(22) NO
creationDate bigint(20) NO
createdBy varchar(22) NO
lastUpdatedBy varchar(22) NO
lastUpdateDate bigint(20) NO

TT_timeEntry

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
entryId varchar(22) NO PRI
projectId varchar(22) NO
taskId varchar(22) NO
taskDate varchar(10) NO
hours float YES 0
comments text YES
reportId varchar(22) NO

TT_wobject

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
userViewTemplateId varchar(22) NO TimeTrackingTMPL000001
managerViewTemplateId varchar(22) NO TimeTrackingTMPL000002
timeRowTemplateId varchar(22) NO TimeTrackingTMPL000003
pmAssetId varchar(22) YES
groupToManage varchar(22) NO 3
revisionDate bigint(20) NO PRI
pmIntegration int(11) NO 0

Thingy

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
templateId varchar(22) NO
defaultThingId varchar(22) YES

ThingyRecord

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
templateIdView char(22) YES
thingId char(22) YES
thingFields longtext YES
thankYouText longtext YES
price float YES
duration bigint(20) YES
fieldPrice longtext YES

ThingyRecord_record

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
recordId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
transactionId char(255) YES
assetId char(255) YES
expires bigint(20) NO 0
userId char(255) YES
fields longtext YES
isHidden tinyint(1) NO 0
sentExpiresNotice tinyint(1) NO 0

Thread

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
replies int(11) NO 0
lastPostId varchar(22) NO
lastPostDate bigint(20) YES
isLocked int(11) NO 0
isSticky int(11) NO 0
subscriptionGroupId varchar(22) NO
revisionDate bigint(20) NO PRI 0
karma int(11) NO 0
karmaScale int(11) NO 1
karmaRank float(11,6) YES
threadRating int(11) YES 0

Thread_read

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
threadId varchar(22) NO MUL
userId varchar(22) NO

Ticket

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
ticketId mediumint(9) NO
ticketStatus varchar(30) NO pending
assigned tinyint(1) NO 0
assignedTo varchar(22) YES
assignedBy varchar(22) YES
dateAssigned bigint(20) YES
storageId varchar(22) YES
isPrivate tinyint(1) NO 0
solutionSummary longtext YES
comments longtext YES
averageRating float YES 0
lastReplyDate bigint(20) YES
lastReplyBy varchar(22) YES
resolvedBy varchar(22) YES
resolvedDate bigint(20) YES
karma int(11) NO 0
karmaScale int(11) NO 1
karmaRank float YES
subscriptionGroup varchar(255) NO

Ticket_collabRef

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
origAssetId varchar(22) NO PRI
mapToAssetId varchar(22) NO

Ticket_history

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
historyId varchar(22) NO PRI
userId varchar(22) NO
assetId varchar(22) NO
actionTaken varchar(255) NO
dateStamp bigint(20) NO

Ticket_metaData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldId varchar(22) NO PRI
assetId varchar(22) NO PRI
value mediumtext YES

Ticket_searchIndex

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
parentId varchar(22) NO
lineage varchar(255) NO
url varchar(255) NO
ticketId mediumint(9) NO
creationDate bigint(20) NO
createdBy varchar(22) NO
synopsis text NO
title varchar(255) NO
keywords varchar(255) NO
isPrivate tinyint(1) NO 0
assignedTo varchar(22) YES
assignedBy varchar(22) YES
dateAssigned bigint(20) YES
ticketStatus varchar(30) NO
solutionSummary longtext YES
averageRating float YES 0
lastReplyDate bigint(20) YES
lastReplyBy varchar(22) YES
karmaRank float YES
field_ixW3ZZQh8lW7cyldFuucGw varchar(255) YES
field_x4cwnyK4PojAzYggVYxlzg varchar(255) YES
field_z9BG53aHhWI5jsJv1mJ_VA varchar(255) YES
field_ZxCeRBH4iWhrlx-GHHbJyw varchar(255) YES
field_7Rxd2VZfcghSn1lVODmpfw char(255) YES
field_6ccdzFmU56xDuInvrggmWg char(255) YES
field_0l4yWH8r0okkhce3kepD_A char(255) YES

UserList

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
templateId varchar(22) YES
showGroupId varchar(22) YES
hideGroupId varchar(22) YES
usersPerPage int(11) YES
alphabet text YES
alphabetSearchField varchar(128) YES
showOnlyVisibleAsNamed int(11) YES
sortBy varchar(128) YES
sortOrder varchar(4) YES
overridePublicEmail int(11) YES
overridePublicProfile int(11) YES

WCCVote

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
wobjectId varchar(22) NO PRI
entries mediumtext YES

WCCVote_answer

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
entry varchar(255) YES
entryNumber int(11) YES
utility int(11) NO 5
creativity int(11) NO 5
elegance int(11) NO 5
totalscore int(11) NO 15
userId varchar(22) YES
dateStamp bigint(20) YES
wobjectId varchar(22) YES
ipAddress varchar(255) YES

WeatherData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) unsigned NO PRI 0
templateId varchar(22) NO WeatherDataTmpl0000001
locations mediumtext YES
partnerId varchar(100) YES
licenseKey varchar(100) YES
cacheTimeout bigint(20) YES

WgStats

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI

WikiMaster

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
groupToEditPages varchar(22) NO 2
groupToAdminister varchar(22) NO 3
richEditor varchar(22) NO PBrichedit000000000002
frontPageTemplateId varchar(22) NO WikiFrontTmpl000000001
pageTemplateId varchar(22) NO WikiPageTmpl0000000001
pageEditTemplateId varchar(22) NO WikiPageEditTmpl000001
recentChangesTemplateId varchar(22) NO WikiRCTmpl000000000001
mostPopularTemplateId varchar(22) NO WikiMPTmpl000000000001
pageHistoryTemplateId varchar(22) NO WikiPHTmpl000000000001
searchTemplateId varchar(22) NO WikiSearchTmpl00000001
recentChangesCount int(11) NO 50
recentChangesCountFront int(11) NO 10
mostPopularCount int(11) NO 50
mostPopularCountFront int(11) NO 10
thumbnailSize int(11) NO 0
maxImageSize int(11) NO 0
approvalWorkflow varchar(22) NO pbworkflow000000000003
useContentFilter int(11) YES 0
filterCode varchar(30) YES javascript
byKeywordTemplateId varchar(22) NO WikiKeyword00000000001
allowAttachments int(11) NO 0
topLevelKeywords longtext YES

WikiMasterKeywords

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
keyword char(64) NO PRI
subKeyword char(64) NO PRI

WikiPage

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
content mediumtext YES
views bigint(20) NO 0
isProtected int(11) NO 0
actionTaken varchar(35) NO
actionTakenBy varchar(22) NO
isFeatured int(1) YES

Workflow

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
workflowId varchar(22) NO PRI
title varchar(255) NO Untitled
description text YES
enabled int(11) NO 0
type varchar(255) NO None
mode varchar(20) NO parallel

WorkflowActivity

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
activityId varchar(22) NO PRI
workflowId varchar(22) NO
title varchar(255) NO Untitled
description text YES
sequenceNumber int(11) NO 1
className varchar(255) YES

WorkflowActivityData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
activityId varchar(22) NO PRI
name varchar(255) NO PRI
value text YES

WorkflowInstance

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
instanceId varchar(22) NO PRI
workflowId varchar(22) NO
currentActivityId varchar(22) NO
priority int(11) NO 2
className varchar(255) YES
methodName varchar(255) YES
parameters longtext YES
runningSince bigint(20) YES
lastUpdate bigint(20) YES
lastStatus varchar(15) YES
noSession tinyint(1) NO 0

WorkflowInstanceScratch

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
instanceId varchar(22) NO PRI
name varchar(255) NO PRI
value text YES

WorkflowSchedule

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
taskId varchar(22) NO PRI
title varchar(255) NO Untitled
enabled int(11) NO 0
runOnce int(11) NO 0
minuteOfHour char(255) NO 0
hourOfDay char(255) NO *
dayOfMonth char(255) NO *
monthOfYear char(255) NO *
dayOfWeek char(255) NO *
workflowId varchar(22) NO
className varchar(255) YES
methodName varchar(255) YES
priority int(11) NO 2
parameters longtext YES

ZipArchiveAsset

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
templateId varchar(22) NO
showPage varchar(255) NO index.html
revisionDate bigint(20) NO PRI

adSkuPurchase

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
adSkuPurchaseId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
isDeleted tinyint(1) NO 0
clicksPurchased bigint(20) YES
dateOfPurchase bigint(20) YES
impressionsPurchased bigint(20) YES
transactionItemId char(22) YES
userId char(22) YES
adId char(22) YES
storedImage char(22) YES

adSpace

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
adSpaceId varchar(22) NO PRI
name varchar(35) NO UNI
title varchar(255) NO
description text YES
minimumImpressions int(11) NO 1000
minimumClicks int(11) NO 1000
width int(11) NO 468
height int(11) NO 60

address

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
addressId varchar(22) NO PRI
addressBookId varchar(22) NO MUL
label varchar(35) YES
firstName varchar(35) YES
lastName varchar(35) YES
address1 varchar(35) YES
address2 varchar(35) YES
address3 varchar(35) YES
city varchar(35) YES
state varchar(35) YES
country varchar(35) YES
code varchar(35) YES
phoneNumber varchar(35) YES
organization char(255) YES
email char(255) YES
isProfile tinyint(4) YES 0

addressBook

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
addressBookId varchar(22) NO PRI
userId varchar(22) YES
defaultAddressId char(22) YES

advertisement

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
adId varchar(22) NO PRI
adSpaceId varchar(22) NO MUL
ownerUserId varchar(22) NO
isActive int(11) NO 0
title varchar(255) NO
type varchar(15) NO text
storageId varchar(22) YES
adText varchar(255) YES
url text YES
richMedia text YES
borderColor varchar(7) NO #000000
textColor varchar(7) NO #000000
backgroundColor varchar(7) NO #ffffff
clicks int(11) NO 0
clicksBought int(11) NO 0
impressions int(11) NO 0
impressionsBought int(11) NO 0
priority int(11) NO 0
nextInPriority bigint(20) NO 0
renderedAd text YES

analyticRule

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
ruleId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
bucketName char(255) YES
regexp char(255) NO .+

asset

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
parentId varchar(22) NO MUL
lineage varchar(255) NO UNI
state varchar(35) NO MUL
className varchar(255) NO MUL
creationDate bigint(20) NO 997995720
createdBy varchar(22) NO 3
stateChanged varchar(22) NO 997995720
stateChangedBy varchar(22) NO 3
isLockedBy varchar(22) YES
isSystem int(11) NO 0
lastExportedAs varchar(255) YES

assetAspectComments

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
comments longtext YES
averageCommentRating int(11) YES

assetAspectRssFeed

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
itemsPerFeed int(11) YES 25
feedCopyright text YES
feedTitle text YES
feedDescription mediumtext YES
feedImage char(22) YES
feedImageLink text YES
feedImageDescription mediumtext YES
feedHeaderLinks char(32) YES rss atom

assetAspect_Subscribable

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
revisionDate bigint(20) NO PRI
subscriptionGroupId char(22) YES
subscriptionTemplateId char(22) YES

assetData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
revisedBy varchar(22) NO
tagId varchar(22) NO
status varchar(35) NO pending
title varchar(255) NO untitled
menuTitle varchar(255) NO untitled
url varchar(255) NO MUL
ownerUserId varchar(22) NO
groupIdView varchar(22) NO
groupIdEdit varchar(22) NO
synopsis mediumtext YES
newWindow int(11) NO 0
isHidden int(11) NO 0
isPackage int(11) NO 0
isPrototype int(11) NO 0
encryptPage int(11) NO 0
assetSize int(11) NO 0
extraHeadTags mediumtext YES
skipNotification int(11) NO 0
isExportable int(11) NO 1
inheritUrlFromParent int(11) NO 0
lastModified bigint(20) YES
extraHeadTagsPacked longtext YES
usePackedHeadTags int(1) YES

assetHistory

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO
userId varchar(22) NO
dateStamp bigint(20) NO 0
actionTaken varchar(255) NO
url varchar(255) YES

assetIndex

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId char(22) NO PRI
title char(255) YES
synopsis char(255) YES
url char(255) NO PRI
creationDate bigint(20) YES
revisionDate bigint(20) YES
ownerUserId char(22) YES
groupIdView char(22) YES
groupIdEdit char(22) YES
className char(255) YES
isPublic int(11) NO 1
keywords mediumtext YES MUL
lineage char(255) YES
subId char(255) YES

assetKeyword

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
keyword varchar(64) NO PRI
assetId varchar(22) NO PRI

assetVersionTag

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
tagId varchar(22) NO PRI
name varchar(255) NO
isCommitted int(11) NO 0
creationDate bigint(20) NO 0
createdBy varchar(22) NO
commitDate bigint(20) NO 0
committedBy varchar(22) NO
isLocked int(11) NO 0
lockedBy varchar(22) NO
groupToUse varchar(22) NO
workflowId varchar(22) NO
workflowInstanceId varchar(22) YES
comments mediumtext YES
startTime datetime YES
endTime datetime YES
isSiteWide tinyint(1) NO 0

authentication

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO PRI
authMethod varchar(30) NO PRI
fieldName varchar(128) NO PRI
fieldData mediumtext YES

bazaar

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
groupToUpload varchar(22) NO 2
listLimit int(11) NO 50

bazaarItem

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
product varchar(22) YES
screenshots varchar(22) YES
releaseDate date YES
requirements mediumtext YES
versionNumber varchar(30) YES
releaseNotes mediumtext YES
supportUrl text YES
demoUrl text YES
moreInfoUrl text YES
price float NO 0
downloadPeriod bigint(20) NO 31536000
groupToDownload varchar(22) NO 7
groupToSubscribe varchar(22) YES
views int(11) NO 0
downloads int(11) NO 0

bucketLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId char(22) NO
Bucket char(255) YES
duration int(11) YES
timeStamp datetime YES

cache

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
namespace char(128) NO PRI
cacheKey char(128) NO PRI
expires bigint(20) NO
size int(11) NO
content mediumblob YES

cart

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
cartId varchar(22) NO PRI
sessionId varchar(22) NO MUL
shippingAddressId varchar(22) YES
shipperId varchar(22) YES
posUserId char(22) YES
creationDate int(20) YES
billingAddressId char(22) YES
gatewayId char(22) YES

cartItem

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
itemId varchar(22) NO PRI
cartId varchar(22) NO MUL
assetId varchar(22) NO
dateAdded datetime NO
options longtext YES
configuredTitle varchar(255) YES
shippingAddressId varchar(22) YES
quantity int(11) NO 1

databaseLink

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
databaseLinkId varchar(22) NO PRI
title varchar(255) YES
DSN varchar(255) YES
username varchar(255) YES
identifier varchar(255) YES
allowedKeywords mediumtext YES
allowMacroAccess int(11) NO 0
additionalParameters varchar(255) NO

deltaLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId char(22) NO
assetId char(22) NO
delta int(11) YES
timeStamp bigint(20) YES
url char(255) NO

donation

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
defaultPrice float NO 100
thankYouMessage mediumtext YES
templateId varchar(22) NO

filePumpBundle

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
bundleId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
bundleName char(255) NO New bundle
lastModified bigint(20) NO 0
lastBuild bigint(20) NO 0
jsFiles longtext NO
cssFiles longtext NO
otherFiles longtext NO

friendInvitations

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
inviteId varchar(22) NO PRI
inviterId varchar(22) NO
friendId varchar(22) NO
dateSent datetime NO
comments varchar(255) NO
messageId varchar(22) NO

groupGroupings

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
groupId varchar(22) NO PRI
inGroup varchar(22) NO PRI

groupings

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
groupId varchar(22) NO PRI
userId varchar(22) NO PRI
expireDate bigint(20) NO 2114402400
groupAdmin int(11) NO 0

groups

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
groupId varchar(22) NO PRI
groupName varchar(100) YES MUL
description varchar(255) YES
expireOffset int(11) NO 314496000
karmaThreshold int(11) NO 1000000000
ipFilter mediumtext YES
dateCreated int(11) NO 997938000
lastUpdated int(11) NO 997938000
deleteOffset int(11) NO 14
expireNotifyOffset int(11) NO -14
expireNotifyMessage mediumtext YES
expireNotify int(11) NO 0
scratchFilter mediumtext YES
autoAdd int(11) NO 0
autoDelete int(11) NO 0
databaseLinkId varchar(22) NO
groupCacheTimeout int(11) NO 3600
dbQuery mediumtext YES
isEditable int(11) NO 1
showInForms int(11) NO 1
ldapGroup varchar(255) YES
ldapGroupProperty varchar(255) YES
ldapRecursiveProperty varchar(255) YES
ldapLinkId varchar(22) YES
ldapRecursiveFilter mediumtext YES
isAdHocMailGroup tinyint(4) NO 0

imageColor

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
colorId varchar(22) NO PRI
name varchar(255) NO untitled
fillTriplet char(7) NO #000000
fillAlpha char(2) NO 00
strokeTriplet char(7) NO #000000
strokeAlpha char(2) NO 00

imageFont

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fontId varchar(22) NO PRI
name varchar(255) YES
storageId varchar(22) YES
filename varchar(255) YES

imagePalette

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
paletteId varchar(22) NO PRI
name varchar(255) NO untitled

imagePaletteColors

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
paletteId varchar(22) NO PRI
colorId varchar(22) NO
paletteOrder int(11) NO PRI

inbox

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
messageId varchar(22) NO PRI
status varchar(15) NO pending
dateStamp bigint(20) NO
completedOn bigint(20) YES MUL
completedBy varchar(22) YES
userId varchar(22) YES MUL
groupId varchar(22) YES MUL
subject varchar(255) NO No Subject
message mediumtext YES
sentBy varchar(22) NO 3

inbox_messageState

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
messageId char(22) NO PRI
userId char(22) NO PRI
isRead tinyint(4) NO 0
repliedTo tinyint(4) NO 0
deleted tinyint(4) NO 0

incrementer

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
incrementerId varchar(50) NO PRI
nextValue int(11) NO 1

karmaLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO
amount int(11) NO 1
source varchar(255) YES
description mediumtext YES
dateModified bigint(20) NO 0

ldapLink

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
ldapLinkId varchar(22) NO PRI
ldapLinkName varchar(255) NO
ldapUrl varchar(255) NO
connectDn varchar(255) NO
identifier varchar(255) NO
ldapUserRDN varchar(255) YES
ldapIdentity varchar(255) YES
ldapIdentityName varchar(255) YES
ldapPasswordName varchar(255) YES
ldapSendWelcomeMessage char(2) YES
ldapWelcomeMessage mediumtext YES
ldapAccountTemplate varchar(22) NO
ldapCreateAccountTemplate varchar(22) NO
ldapLoginTemplate varchar(22) NO
ldapGlobalRecursiveFilter mediumtext YES
ldapDeactivateAccountTemplate char(22) NO

mailQueue

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
messageId varchar(22) NO PRI
message mediumtext YES
toGroup varchar(22) YES
isInbox tinyint(4) YES 0

metaData_classes

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
className char(255) YES
fieldId char(22) YES

metaData_properties

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldId varchar(22) NO PRI
fieldName varchar(100) NO UNI
description mediumtext NO
fieldType varchar(30) YES
possibleValues mediumtext YES
defaultValue varchar(255) YES

metaData_values

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldId varchar(22) NO PRI
value varchar(255) YES
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0

oldtransaction

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
transactionId varchar(22) NO PRI
userId varchar(22) NO
amount float NO 0
gatewayId varchar(128) YES
gateway varchar(64) NO
recurring tinyint(1) NO 0
initDate int(11) NO 0
completionDate int(11) YES 0
status varchar(10) NO Pending
lastPayedTerm int(6) NO 0
shippingCost varchar(9) YES 0.00
shippingMethod varchar(15) YES
shippingOptions mediumtext YES
shippingStatus varchar(15) YES NotShipped
trackingNumber varchar(255) YES
XID varchar(100) YES
authcode varchar(100) YES
message mediumtext YES

oldtransactionitem

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
transactionId varchar(22) NO
itemName varchar(64) NO
amount float NO 0
quantity int(4) NO 0
itemId varchar(64) NO
itemType varchar(40) NO

passiveAnalyticsStatus

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
startDate datetime YES
endDate datetime YES
running int(2) YES 0
userId char(255) NO

passiveLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId char(22) NO
assetId char(22) NO
sessionId char(22) NO
timeStamp bigint(20) YES
url char(255) NO

passiveProfileAOI

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO PRI
fieldId varchar(22) NO PRI
value varchar(100) NO PRI
count int(11) YES

passiveProfileLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
passiveProfileLogId varchar(22) NO PRI
userId varchar(22) NO
sessionId varchar(22) NO
assetId varchar(22) NO
dateOfEntry bigint(20) NO 0

paymentGateway

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
paymentGatewayId varchar(22) NO PRI
className varchar(255) YES
options longtext YES

redirect

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
redirectUrl mediumtext YES
revisionDate bigint(20) NO PRI 0
redirectType int(11) NO 302

replacements

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
replacementId varchar(22) NO PRI
searchFor varchar(255) YES
replaceWith mediumtext YES

search

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
classLimiter text YES
searchRoot varchar(22) NO PBasset000000000000001
templateId varchar(22) NO PBtmpl0000000000000200
useContainers int(11) NO 0
paginateAfter int(11) NO 25

settings

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
name varchar(255) NO PRI
value mediumtext YES

shipper

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
shipperId varchar(22) NO PRI
className varchar(255) YES
options longtext YES

shopCredit

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
creditId varchar(22) NO PRI
userId varchar(22) NO MUL
amount float NO 0
comment text YES
dateOfAdjustment datetime YES

sku

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI
description mediumtext YES
sku varchar(35) NO MUL
vendorId varchar(22) NO MUL defaultvendor000000000
displayTitle tinyint(1) NO 1
overrideTaxRate tinyint(1) NO 0
taxRateOverride float NO 0
taxConfiguration longtext YES
shipsSeparately tinyint(1) NO

snippet

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetId varchar(22) NO PRI
snippet mediumtext YES
mimeType varchar(50) NO text/html
revisionDate bigint(20) NO PRI 0
cacheTimeout int(11) NO 3600
snippetPacked longtext YES
usePacked int(1) YES
templateParser char(255) YES

taxDriver

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
className char(255) NO PRI
options longtext YES

tax_eu_vatNumbers

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId char(22) NO PRI
countryCode char(3) NO
vatNumber char(20) NO PRI
viesValidated tinyint(1) YES
viesErrorCode int(3) YES
approved tinyint(1) YES

tax_generic_rates

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
taxId varchar(22) NO PRI
country varchar(100) NO
state varchar(100) YES
city varchar(100) YES
code varchar(100) YES
taxRate float NO 0

template

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
template mediumtext YES
namespace varchar(35) NO MUL Page
isEditable int(11) NO 1
showInForms int(11) NO 1
assetId varchar(22) NO PRI
revisionDate bigint(20) NO PRI 0
parser varchar(255) NO WebGUI::Asset::Template::HTMLTemplate
isDefault int(1) YES 0
templatePacked longtext YES
usePacked int(1) YES
storageIdExample char(22) YES
attachmentsJson longtext YES

transaction

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
transactionId varchar(22) NO PRI
originatingTransactionId varchar(22) YES
isSuccessful tinyint(1) NO 0
orderNumber int(11) NO UNI auto_increment
transactionCode varchar(100) YES
statusCode varchar(35) YES
statusMessage varchar(255) YES
userId varchar(22) NO
username varchar(35) NO
amount float YES
shopCreditDeduction float YES
shippingAddressId varchar(22) YES
shippingAddressName varchar(35) YES
shippingAddress1 varchar(35) YES
shippingAddress2 varchar(35) YES
shippingAddress3 varchar(35) YES
shippingCity varchar(35) YES
shippingState varchar(35) YES
shippingCountry varchar(35) YES
shippingCode varchar(35) YES
shippingPhoneNumber varchar(35) YES
shippingDriverId varchar(22) YES
shippingDriverLabel varchar(35) YES
shippingPrice float YES
paymentAddressId varchar(22) YES
paymentAddressName varchar(35) YES
paymentAddress1 varchar(35) YES
paymentAddress2 varchar(35) YES
paymentAddress3 varchar(35) YES
paymentCity varchar(35) YES
paymentState varchar(35) YES
paymentCountry varchar(35) YES
paymentCode varchar(35) YES
paymentPhoneNumber varchar(35) YES
paymentDriverId varchar(22) YES
paymentDriverLabel varchar(35) YES
taxes float YES
dateOfPurchase datetime YES
isRecurring tinyint(1) YES
notes mediumtext YES
cashierUserId char(22) YES
shippingOrganization char(35) YES
paymentOrganization char(35) YES

transactionItem

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
itemId varchar(22) NO PRI
transactionId varchar(22) NO MUL
assetId varchar(22) YES
configuredTitle varchar(255) YES
options longtext YES
shippingAddressId varchar(22) YES
shippingName varchar(35) YES
shippingAddress1 varchar(35) YES
shippingAddress2 varchar(35) YES
shippingAddress3 varchar(35) YES
shippingCity varchar(35) YES
shippingState varchar(35) YES
shippingCountry varchar(35) YES
shippingCode varchar(35) YES
shippingPhoneNumber varchar(35) YES
shippingTrackingNumber varchar(255) YES
orderStatus varchar(35) NO NotShipped
lastUpdated datetime YES
quantity int(11) NO 1
price float YES
vendorId varchar(22) NO MUL defaultvendor000000000
vendorPayoutStatus char(10) YES NotPaid
vendorPayoutAmount decimal(8,2) YES 0.00
taxRate decimal(6,3) YES
taxConfiguration longtext YES
shippingOrganization char(35) YES

userInvitations

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
inviteId varchar(22) NO PRI
userId varchar(22) NO
dateSent date YES
email varchar(255) NO
newUserId varchar(22) YES
dateCreated date YES

userLoginLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO MUL
status varchar(30) YES
timeStamp int(11) YES MUL
ipAddress varchar(128) YES
userAgent mediumtext YES
sessionId varchar(22) YES MUL
lastPageViewed int(11) YES

userProfileCategory

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
profileCategoryId varchar(22) NO PRI
label varchar(255) NO Undefined
shortLabel char(255) YES
sequenceNumber int(11) NO 1
visible int(11) NO 1
editable int(11) NO 1
protected int(11) NO 0

userProfileData

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO PRI
email char(255) YES MUL
firstName char(255) YES
middleName char(255) YES
lastName char(255) YES
icq char(255) YES
aim char(255) YES
msnIM char(255) YES
yahooIM char(255) YES
cellPhone char(255) YES
pager char(255) YES
emailToPager char(255) YES
language char(255) YES
homeAddress char(255) YES
homeCity char(255) YES
homeState char(255) YES
homeZip char(255) YES
homeCountry char(255) YES
homePhone char(255) YES
workAddress char(255) YES
workCity char(255) YES
workState char(255) YES
workZip char(255) YES
workCountry char(255) YES
workPhone char(255) YES
gender char(255) YES
birthdate bigint(20) YES
homeURL char(255) YES
workURL char(255) YES
workName char(255) YES
timeZone char(255) YES
dateFormat char(255) YES
timeFormat char(255) YES
discussionLayout char(255) YES
firstDayOfWeek char(255) YES
uiLevel char(255) YES
alias char(255) YES
signature longtext YES
publicProfile longtext YES
toolbar char(255) YES
photo char(22) YES
avatar char(22) YES
department char(255) YES
N_BNB3AxRafkdhc56J2fngcontentPositions char(255) YES
skypeId char(255) YES
homepage char(255) YES
allowPrivateMessages longtext YES
ableToBeFriend tinyint(4) YES
showMessageOnLoginSeen bigint(20) YES
showOnline tinyint(1) YES
versionTagMode char(255) YES
wg_privacySettings longtext YES
receiveInboxEmailNotifications tinyint(1) YES
receiveInboxSmsNotifications tinyint(1) YES
comments longtext YES
assetManagerSortColumn char(255) YES
assetManagerSortDirection char(255) YES

userProfileField

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
fieldName varchar(128) NO PRI
label varchar(255) NO Undefined
visible int(11) NO 0
required int(11) NO 0
fieldType varchar(128) NO text
possibleValues mediumtext YES
dataDefault mediumtext YES
sequenceNumber int(11) NO 1
profileCategoryId varchar(22) NO
protected int(11) NO 0
editable int(11) NO 1
forceImageOnly int(11) YES 1
showAtRegistration int(11) NO 0
requiredForPasswordRecovery int(11) NO 0
extras text YES
defaultPrivacySetting char(128) YES

userSession

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
sessionId varchar(22) NO PRI
expires int(11) YES MUL
lastPageView int(11) YES
adminOn int(11) NO 0
lastIP varchar(50) YES
userId varchar(22) NO

userSessionScratch

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
sessionId varchar(22) NO PRI
name varchar(255) NO PRI
value mediumtext YES

users

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
userId varchar(22) NO PRI
username varchar(100) YES UNI
authMethod varchar(30) NO WebGUI
dateCreated int(11) NO 1019867418
lastUpdated int(11) NO 1019867418
karma int(11) NO 0
status varchar(35) NO Active
referringAffiliate varchar(22) NO
friendsGroup varchar(22) NO

vendor

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
vendorId varchar(22) NO PRI
dateCreated datetime YES
name varchar(255) YES
userId varchar(22) NO MUL 3
preferredPaymentType varchar(255) YES
paymentInformation text YES
paymentAddressId varchar(22) YES
url text YES

vendorPayoutLog

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
payoutId char(22) NO PRI
isSuccessful tinyint(1) NO
errorCode char(10) YES
errorMessage char(255) YES
paypalTimestamp char(20) NO
amount decimal(7,2) NO
currency char(3) NO
correlationId char(13) NO
paymentInformation char(255) NO

vendorPayoutLog_items

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
payoutId char(22) NO PRI
transactionItemId char(22) NO PRI
amount decimal(7,2) NO

webguiVersion

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
webguiVersion varchar(10) YES
versionType varchar(30) YES
dateApplied int(11) YES

webgui_asset_stats

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
assetSubmissionId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
submissionId char(22) YES
quantity bigint(20) YES
className char(255) YES

webgui_stats

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
submissionId char(22) NO PRI
sequenceNumber int(11) NO 1
dateCreated datetime YES
lastUpdated datetime YES
siteId char(22) YES
webguiVersion char(255) YES
perlVersion char(255) YES
apacheVersion char(255) YES
osType char(255) YES
userCount bigint(20) YES
groupCount bigint(20) YES
assetCount bigint(20) YES
packageCount bigint(20) YES

wobject

Field NameField TypeCan be null?Is it a key?Default ValueExtra Attributes
displayTitle int(11) NO 1
description mediumtext YES
assetId varchar(22) NO PRI
styleTemplateId varchar(22) NO
printableStyleTemplateId varchar(22) NO
revisionDate bigint(20) NO PRI 0
mobileStyleTemplateId char(22) YES PBtmpl0000000000000060