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

AdSku

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

Calendar

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

Collaboration

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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	int(11)	NO		300
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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

DataForm

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
data	longtext	YES
templateId	varchar(22)	YES

EMSBadge

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
badgeGroupId	varchar(22)	NO	PRI
emsAssetId	varchar(22)	YES
name	varchar(100)	YES

EMSEventMetaField

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
badgeId	varchar(22)	NO	PRI
ribbonAssetId	varchar(22)	NO	PRI
transactionItemId	varchar(22)	YES

EMSRegistrantTicket

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
badgeId	varchar(22)	NO	PRI
ticketAssetId	varchar(22)	NO	PRI
purchaseComplete	tinyint(1)	YES
transactionItemId	varchar(22)	YES

EMSRegistrantToken

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
badgeId	varchar(22)	NO	PRI
tokenAssetId	varchar(22)	NO	PRI
quantity	int(11)	YES
transactionItemIds	text	YES

EMSRibbon

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
percentageDiscount	float	NO		10
price	float	NO		0

EMSSubmission

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
price	float	NO		0

Event

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
recurId	varchar(22)	NO	PRI
recurType	varchar(16)	YES
pattern	varchar(255)	YES
startDate	date	YES
endDate	varchar(10)	YES

Event_relatedlink

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

Gallery

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	YES
delegateUserId	varchar(22)	YES
assetId	varchar(22)	YES

InOutBoard_status

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	YES
userId	varchar(22)	YES
status	varchar(255)	YES
dateStamp	int(11)	NO
message	text	YES

InOutBoard_statusLog

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
latitude	float	YES
longitude	float	YES
website	char(255)	YES
address1	char(35)	YES
address2	char(35)	YES
city	char(35)	YES
region	char(35)	YES
zipCode	char(35)	YES
country	char(35)	YES
phone	char(22)	YES
fax	char(22)	YES
email	char(35)	YES
storageIdPhoto	char(22)	YES
userDefined1	text	YES
userDefined2	text	YES
userDefined3	text	YES
userDefined4	text	YES
userDefined5	text	YES

Matrix

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
matrixId	char(22)	NO
matrixListingId	char(22)	NO	PRI
attributeId	char(22)	NO	PRI
value	char(255)	YES

MatrixListing_rating

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
templateId	varchar(22)	YES
revisionDate	bigint(20)	NO	PRI	0
visitorCacheTimeout	int(11)	NO		3600

MultiSearch

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
userId	varchar(22)	NO	PRI
subscriptions	text	YES
lastTimeSent	bigint(20)	NO	MUL	0

PM_project

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
exifData	longtext	YES
location	varchar(255)	YES

Photo_rating

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	YES	MUL
userId	varchar(22)	YES
visitorIp	varchar(255)	YES
rating	int(11)	YES

Poll

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
answer	char(3)	YES
userId	varchar(22)	YES
ipAddress	varchar(50)	YES
assetId	varchar(22)	YES

Post

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI	0
templateId	varchar(22)	NO		nFen0xjkZn8WkpM93C9ceQ

Shortcut

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
fieldName	varchar(255)	NO	PRI
newValue	mediumtext	YES

StockData

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

Story

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

StoryTopic

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

Subscription

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
questionType	char(56)	NO	PRI
answers	text	NO

Survey_question_old

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
Survey_id	varchar(22)	NO
Survey_sectionId	varchar(22)	NO	PRI
sectionName	mediumtext	YES
sequenceNumber	int(11)	NO		1

Survey_tempReport

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
projectId	varchar(22)	NO	PRI
resourceId	varchar(22)	NO	PRI

TT_projectTasks

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
taskId	varchar(22)	NO	PRI
projectId	varchar(22)	NO
taskName	varchar(255)	NO

TT_report

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
templateId	varchar(22)	NO
defaultThingId	varchar(22)	YES

ThingyRecord

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
threadId	varchar(22)	NO	MUL
userId	varchar(22)	NO

Ticket

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
origAssetId	varchar(22)	NO	PRI
mapToAssetId	varchar(22)	NO

Ticket_history

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
fieldId	varchar(22)	NO	PRI
assetId	varchar(22)	NO	PRI
value	mediumtext	YES

Ticket_searchIndex

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

UserList

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
wobjectId	varchar(22)	NO	PRI
entries	mediumtext	YES

WCCVote_answer

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

WgStats

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI

WikiMaster

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
keyword	char(64)	NO	PRI
subKeyword	char(64)	NO	PRI

WikiPage

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
activityId	varchar(22)	NO	PRI
name	varchar(255)	NO	PRI
value	text	YES

WorkflowInstance

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
instanceId	varchar(22)	NO	PRI
name	varchar(255)	NO	PRI
value	text	YES

WorkflowSchedule

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
templateId	varchar(22)	NO
showPage	varchar(255)	NO		index.html
revisionDate	bigint(20)	NO	PRI

adSkuPurchase

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

addressBook

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
addressBookId	varchar(22)	NO	PRI
userId	varchar(22)	YES
defaultAddressId	char(22)	YES

advertisement

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
comments	longtext	YES
averageCommentRating	int(11)	YES

assetAspectRssFeed

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
subscriptionGroupId	char(22)	YES
subscriptionTemplateId	char(22)	YES

assetData

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO
userId	varchar(22)	NO
dateStamp	bigint(20)	NO		0
actionTaken	varchar(255)	NO
url	varchar(255)	YES

assetIndex

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	char(22)	NO	PRI
title	char(255)	YES
synopsis	char(255)	YES
url	char(255)	YES
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

assetKeyword

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
keyword	varchar(64)	NO	PRI
assetId	varchar(22)	NO	PRI

assetVersionTag

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	NO	PRI
authMethod	varchar(30)	NO	PRI
fieldName	varchar(128)	NO	PRI
fieldData	mediumtext	YES

automat

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO
revisionDate	bigint(20)	YES

bazaar

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
groupToUpload	varchar(22)	NO		2
listLimit	int(11)	NO		50

bazaarItem

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	char(22)	NO
Bucket	char(22)	NO
duration	int(11)	YES
timeStamp	datetime	YES

cache

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
namespace	char(128)	NO	PRI
cacheKey	char(128)	NO	PRI
expires	bigint(20)	NO
size	int(11)	NO
content	mediumblob	YES

cart

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	char(22)	NO
assetId	char(22)	NO
delta	int(11)	YES
timeStamp	bigint(20)	YES
url	char(255)	NO

donation

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
defaultPrice	float	NO		100
thankYouMessage	mediumtext	YES
templateId	varchar(22)	NO

filePumpBundle

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
groupId	varchar(22)	NO	PRI
inGroup	varchar(22)	NO	PRI

groupings

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
groupId	varchar(22)	NO	PRI
userId	varchar(22)	NO	PRI
expireDate	bigint(20)	NO		2114402400
groupAdmin	int(11)	NO		0

groups

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
fontId	varchar(22)	NO	PRI
name	varchar(255)	YES
storageId	varchar(22)	YES
filename	varchar(255)	YES

imagePalette

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
paletteId	varchar(22)	NO	PRI
name	varchar(255)	NO		untitled

imagePaletteColors

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
paletteId	varchar(22)	NO	PRI
colorId	varchar(22)	NO
paletteOrder	int(11)	NO	PRI

inbox

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
incrementerId	varchar(50)	NO	PRI
nextValue	int(11)	NO		1

karmaLog

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	NO
amount	int(11)	NO		1
source	varchar(255)	YES
description	mediumtext	YES
dateModified	bigint(20)	NO		0

ldapLink

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
messageId	varchar(22)	NO	PRI
message	mediumtext	YES
toGroup	varchar(22)	YES
isInbox	tinyint(4)	YES		0

metaData_properties

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
fieldId	varchar(22)	NO	PRI
value	varchar(255)	YES
assetId	varchar(22)	NO	PRI

oldtransaction

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
startDate	datetime	YES
endDate	datetime	YES
running	int(2)	YES		0
userId	char(255)	NO

passiveLog

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	char(22)	NO
assetId	char(22)	NO
sessionId	char(22)	NO
timeStamp	bigint(20)	YES
url	char(255)	NO

passiveProfileAOI

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	NO	PRI
fieldId	varchar(22)	NO	PRI
value	varchar(100)	NO	PRI
count	int(11)	YES

passiveProfileLog

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
paymentGatewayId	varchar(22)	NO	PRI
className	varchar(255)	YES
options	longtext	YES

redirect

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
redirectUrl	mediumtext	YES
revisionDate	bigint(20)	NO	PRI	0
redirectType	int(11)	NO		302

replacements

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
replacementId	varchar(22)	NO	PRI
searchFor	varchar(255)	YES
replaceWith	mediumtext	YES

search

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
name	varchar(255)	NO	PRI
value	mediumtext	YES

shipper

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
shipperId	varchar(22)	NO	PRI
className	varchar(255)	YES
options	longtext	YES

shopCredit

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
creditId	varchar(22)	NO	PRI
userId	varchar(22)	NO	MUL
amount	float	NO		0
comment	text	YES
dateOfAdjustment	datetime	YES

sku

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO	PRI
snippet	mediumtext	YES
processAsTemplate	int(11)	NO		0
mimeType	varchar(50)	NO		text/html
revisionDate	bigint(20)	NO	PRI	0
cacheTimeout	int(11)	NO		3600
snippetPacked	longtext	YES
usePacked	int(1)	YES

taxDriver

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
className	char(255)	NO	PRI
options	longtext	YES

tax_eu_vatNumbers

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

transactionItem

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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

userInvitations

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	NO
status	varchar(30)	YES
timeStamp	int(11)	YES
ipAddress	varchar(128)	YES
userAgent	mediumtext	YES
sessionId	varchar(22)	YES	MUL
lastPageViewed	int(11)	YES

userProfileCategory

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
userId	varchar(22)	NO	PRI
email	char(255)	YES
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

userProfileField

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
sessionId	varchar(22)	NO	PRI
name	varchar(255)	NO	PRI
value	mediumtext	YES

users

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
payoutId	char(22)	NO	PRI
transactionItemId	char(22)	NO	PRI
amount	decimal(7,2)	NO

webguiVersion

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
webguiVersion	varchar(10)	YES
versionType	varchar(30)	YES
dateApplied	int(11)	YES

webgui_asset_stats

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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 Name	Field Type	Can be null?	Is it a key?	Default Value	Extra 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