Database Schema Reference

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	varchar(22)	NO	PRI
revisionDate	bigint(20)	NO	PRI
purchaseTemplate	varchar(22)	NO
manageTemplate	varchar(22)	NO
adSpace	varchar(22)	NO
priority	int(11)	YES		1
pricePerClick	float	YES		0
pricePerImpression	float	YES		0
clickDiscounts	varchar(1024)	YES
impressionDiscounts	varchar(1024)	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) unsigned	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

Calendar_feeds

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
feedId	varchar(22)	NO	PRI
assetId	varchar(22)	NO	PRI
url	varchar(255)	YES
lastUpdated	datetime	YES
lastResult	varchar(255)	YES
feedType	varchar(30)	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

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	varchar(22)	YES		PBrichedit000000000002
replyFilterCode	varchar(30)	YES		javascript

Dashboard

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

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

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) unsigned	NO	PRI
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
groupToApproveEvents	varchar(22)	YES
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
badgeInstructions	mediumtext	YES
ribbonInstructions	mediumtext	YES
ticketInstructions	mediumtext	YES
tokenInstructions	mediumtext	YES
registrationStaffGroupId	varchar(22)	YES
scheduleTemplateId	char(22)	YES
scheduleColumnsPerPage	int(11)	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

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

ITransact_recurringStatus

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
gatewayId	varchar(128)	NO	PRI
initDate	bigint(20)	NO		0
lastTransaction	bigint(20)	NO		0
status	varchar(10)	YES
errorMessage	varchar(128)	YES
recipe	varchar(15)	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	varchar(255)	YES
address1	varchar(255)	YES
address2	varchar(255)	YES
city	varchar(255)	YES
state	varchar(255)	YES
zipCode	varchar(255)	YES
country	varchar(255)	YES
phone	varchar(255)	YES
fax	varchar(255)	YES
email	varchar(255)	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) unsigned	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	mediumtext	YES
benefitJSON	mediumtext	YES
featureJSON	mediumtext	YES
relatedJSON	mediumtext	YES
specificationJSON	mediumtext	YES
variantsJSON	mediumtext	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

SQLForm_fieldOrder

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
assetId	varchar(22)	NO
fieldId	varchar(22)	NO
rank	int(11)	NO		0

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	int(11)	NO	PRI

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

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	varchar(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	varchar(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

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

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

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

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

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	text	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	text	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
costPerImpression	decimal(11,2)	NO		0.00
minimumImpressions	int(11)	NO		1000
costPerClick	decimal(11,2)	NO		0.00
minimumClicks	int(11)	NO		1000
width	int(11)	NO		468
height	int(11)	NO		60
groupToPurchase	varchar(22)	NO		3

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
sessionId	varchar(22)	YES	MUL
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	mediumtext	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

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	PRI
revisionDate	bigint(20)	NO	PRI

automatChange

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
changeId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
objectId	char(22)	YES
objectType	varchar(255)	YES
name	varchar(255)	YES
action	varchar(255)	YES
actionTakenBy	varchar(22)	YES

automatCustomer

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
customerId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
userId	char(22)	NO	MUL
name	varchar(255)	YES
notes	longtext	YES
isDeleted	tinyint(1)	NO		0

automatDomainName

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
domainNameId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
customerId	char(22)	YES	MUL
name	varchar(255)	YES
ttl	bigint(20)	NO		14400
isDnsEnabled	tinyint(1)	NO		0
notes	longtext	YES
isDeleted	tinyint(1)	NO		0

automatDomainRecord

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
domainRecordId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
domainNameId	char(22)	YES	MUL
name	varchar(255)	YES
ttl	bigint(20)	NO		14400
type	varchar(255)	NO		A
ip	varchar(255)	YES
notes	longtext	YES
attachedToSiteId	char(22)	YES
attachedToMailServerId	char(22)	YES

automatMailServer

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
mailServerId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
siteId	char(22)	YES	MUL
hostname	varchar(255)	NO		mail
everyoneDotNetClientId	varchar(255)	YES
mailAdminPassword	varchar(255)	YES
mailAccountCount	bigint(20)	NO		0
notes	longtext	YES
isDeleted	tinyint(1)	NO		0

automatServer

Field Name	Field Type	Can be null?	Is it a key?	Default Value	Extra Attributes
serverId	varchar(22)	NO	PRI
sequenceNumber	int(11)	NO		1
dateCreated	datetime	YES
lastUpdated	datetime	YES
customerId	char(22)