Database Schema Reference
This shows the database schema from the latest version of WebGUI.
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) |
NO |
|
|
|
| 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 |
|
|
|
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) |
NO |
|
|
|
| lastUpdated |
datetime |
YES |
|
|
|
| lastResult |
varchar(255) |
YES |
|
|
|
| feedType |
varchar(30) |
NO |
|
|
|
Collaboration
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| assetId |
varchar(22) |
NO |
PRI |
|
|
| postGroupId |
varchar(22) |
NO |
|
2 |
|
| canStartThreadGroupId |
varchar(22) |
NO |
|
2 |
|
| karmaPerPost |
int(11) |
NO |
|
0 |
|
| collaborationTemplateId |
varchar(22) |
NO |
|
|
|
| threadTemplateId |
varchar(22) |
NO |
|
|
|
| postFormTemplateId |
varchar(22) |
NO |
|
|
|
| searchTemplateId |
varchar(22) |
NO |
|
|
|
| notificationTemplateId |
varchar(22) |
NO |
|
|
|
| sortBy |
varchar(35) |
NO |
|
assetData.revisionDate |
|
| sortOrder |
varchar(4) |
NO |
|
desc |
|
| usePreview |
int(11) |
NO |
|
1 |
|
| addEditStampToPosts |
int(11) |
NO |
|
0 |
|
| editTimeout |
int(11) |
NO |
|
3600 |
|
| attachmentsPerPost |
int(11) |
NO |
|
0 |
|
| filterCode |
varchar(30) |
NO |
|
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) |
NO |
|
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) |
NO |
|
pbworkflow000000000003 |
|
| threadApprovalWorkflow |
varchar(22) |
NO |
|
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) |
NO |
|
|
|
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) |
NO |
|
4 |
|
| usersGroupId |
varchar(22) |
NO |
|
2 |
|
| templateId |
varchar(22) |
NO |
|
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) |
NO |
|
|
|
| acknowlegementTemplateId |
varchar(22) |
NO |
|
|
|
| listTemplateId |
varchar(22) |
NO |
|
|
|
| assetId |
varchar(22) |
NO |
PRI |
|
|
| templateId |
varchar(22) |
NO |
|
|
|
| defaultView |
int(11) |
NO |
|
0 |
|
| revisionDate |
bigint(20) |
NO |
PRI |
0 |
|
| groupToViewEntries |
varchar(22) |
NO |
|
7 |
|
| mailAttachments |
int(11) |
YES |
|
0 |
|
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) |
NO |
|
|
|
| username |
varchar(255) |
YES |
|
|
|
| ipAddress |
varchar(255) |
YES |
|
|
|
| submissionDate |
bigint(20) |
NO |
|
0 |
|
| assetId |
varchar(22) |
NO |
|
|
|
DataForm_entryData
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| DataForm_entryId |
varchar(22) |
NO |
PRI |
|
|
| DataForm_fieldId |
varchar(22) |
NO |
PRI |
|
|
| value |
text |
YES |
|
|
|
| assetId |
varchar(22) |
NO |
|
|
|
DataForm_field
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| DataForm_fieldId |
varchar(22) |
NO |
PRI |
|
|
| sequenceNumber |
int(11) |
NO |
|
0 |
|
| name |
varchar(255) |
NO |
|
|
|
| status |
varchar(35) |
YES |
|
|
|
| type |
varchar(30) |
NO |
|
|
|
| possibleValues |
text |
YES |
|
|
|
| defaultValue |
text |
YES |
|
|
|
| width |
int(11) |
YES |
|
|
|
| subtext |
mediumtext |
YES |
|
|
|
| rows |
int(11) |
YES |
|
|
|
| isMailField |
int(11) |
NO |
|
0 |
|
| label |
varchar(255) |
YES |
|
|
|
| DataForm_tabId |
varchar(22) |
NO |
|
0 |
|
| vertical |
smallint(1) |
YES |
|
1 |
|
| extras |
varchar(128) |
YES |
|
|
|
| assetId |
varchar(22) |
NO |
MUL |
|
|
DataForm_tab
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| label |
varchar(255) |
NO |
|
|
|
| subtext |
text |
YES |
|
|
|
| sequenceNumber |
int(11) |
NO |
|
0 |
|
| DataForm_tabId |
varchar(22) |
NO |
|
|
|
| assetId |
varchar(22) |
NO |
|
|
|
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) |
NO |
|
|
|
| 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 |
|
|
| displayTemplateId |
varchar(22) |
YES |
|
|
|
| checkoutTemplateId |
varchar(22) |
YES |
|
|
|
| managePurchasesTemplateId |
varchar(22) |
YES |
|
|
|
| viewPurchaseTemplateId |
varchar(22) |
YES |
|
|
|
| searchTemplateId |
varchar(22) |
YES |
|
|
|
| paginateAfter |
int(11) |
YES |
|
10 |
|
| groupToAddEvents |
varchar(22) |
YES |
|
|
|
| groupToApproveEvents |
varchar(22) |
YES |
|
|
|
| globalPrerequisites |
tinyint(4) |
YES |
|
1 |
|
| globalMetadata |
tinyint(4) |
YES |
|
1 |
|
| badgePrinterTemplateId |
varchar(22) |
NO |
|
emsbadgeprintout000000 |
|
| ticketPrinterTemplateId |
varchar(22) |
NO |
|
emsticketprintout00000 |
|
EventManagementSystem_badges
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| badgeId |
varchar(22) |
NO |
PRI |
|
|
| userId |
varchar(22) |
YES |
|
|
|
| createdByUserId |
varchar(22) |
YES |
|
|
|
| firstName |
varchar(100) |
YES |
|
|
|
| lastName |
varchar(100) |
YES |
|
|
|
| address |
varchar(100) |
YES |
|
|
|
| city |
varchar(100) |
YES |
|
|
|
| state |
varchar(50) |
YES |
|
|
|
| zipCode |
varchar(15) |
YES |
|
|
|
| country |
varchar(255) |
YES |
|
|
|
| phone |
varchar(50) |
YES |
|
|
|
| email |
varchar(255) |
YES |
|
|
|
| assetId |
varchar(22) |
YES |
|
|
|
EventManagementSystem_discountPasses
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| passId |
varchar(22) |
NO |
PRI |
|
|
| name |
varchar(100) |
YES |
|
|
|
| amount |
varchar(22) |
YES |
|
|
|
| type |
varchar(10) |
YES |
|
|
|
EventManagementSystem_metaData
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| fieldId |
varchar(22) |
NO |
PRI |
|
|
| productId |
varchar(22) |
NO |
PRI |
|
|
| fieldData |
text |
YES |
|
|
|
EventManagementSystem_metaField
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| fieldId |
varchar(22) |
NO |
PRI |
|
|
| assetId |
varchar(22) |
YES |
|
|
|
| name |
varchar(50) |
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 |
|
|
|
| autoSearch |
tinyint(4) |
YES |
|
0 |
|
EventManagementSystem_prerequisiteEvents
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| prerequisiteId |
varchar(22) |
NO |
PRI |
|
|
| requiredProductId |
varchar(22) |
NO |
PRI |
|
|
EventManagementSystem_prerequisites
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| prerequisiteId |
varchar(22) |
NO |
PRI |
|
|
| operator |
varchar(100) |
YES |
|
|
|
| name |
varchar(40) |
YES |
|
|
|
| assetId |
varchar(22) |
YES |
|
|
|
EventManagementSystem_products
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| productId |
varchar(22) |
NO |
PRI |
|
|
| assetId |
varchar(22) |
YES |
|
|
|
| startDate |
bigint(20) |
YES |
|
|
|
| endDate |
bigint(20) |
YES |
|
|
|
| maximumAttendees |
int(11) |
YES |
|
|
|
| approved |
tinyint(4) |
YES |
|
|
|
| sequenceNumber |
int(11) |
YES |
|
|
|
| imageId |
varchar(22) |
YES |
|
|
|
| prerequisiteId |
varchar(22) |
YES |
|
|
|
| passId |
text |
YES |
|
|
|
| passType |
varchar(10) |
YES |
|
|
|
EventManagementSystem_purchases
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| purchaseId |
varchar(22) |
NO |
PRI |
|
|
| transactionId |
varchar(22) |
YES |
|
|
|
EventManagementSystem_registrations
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| registrationId |
varchar(22) |
NO |
PRI |
|
|
| productId |
varchar(22) |
YES |
|
|
|
| purchaseId |
varchar(22) |
YES |
|
|
|
| badgeId |
varchar(22) |
YES |
|
|
|
| returned |
tinyint(4) |
YES |
|
0 |
|
| assetId |
varchar(22) |
YES |
|
|
|
EventManagementSystem_sessionPurchaseRef
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| sessionId |
varchar(22) |
NO |
PRI |
|
|
| purchaseId |
varchar(22) |
NO |
PRI |
|
|
| badgeId |
varchar(22) |
NO |
PRI |
|
|
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) |
NO |
|
|
|
| assetId |
varchar(22) |
NO |
|
|
|
| linkURL |
tinytext |
YES |
|
|
|
| linktext |
varchar(80) |
YES |
|
|
|
| groupIdView |
varchar(22) |
NO |
|
|
|
| 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) |
NO |
|
|
|
| filename |
varchar(255) |
NO |
|
|
|
| templateId |
varchar(22) |
NO |
|
|
|
| revisionDate |
bigint(20) |
NO |
PRI |
0 |
|
| cacheTimeout |
int(11) |
NO |
|
3600 |
|
Folder
| Field Name | Field Type | Can be null? | Is it a key? | Default Value | Extra Attributes |
| assetId |
varchar(22) |
NO |
PRI |
|
|
| templateId |
varchar(22) |
NO |
|
|
|
| revisionDate |
bigint(20) |
NO |
PRI |
0 |
|
| visitorCacheTimeout |
int(11) |
NO |
|
3600 |
|
| sortAlphabetically |
int(11) |
NO |
|
0 |
|
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 |
|
|
|
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 |
|
|
|
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) |
NO |
|
|
|
| assetId |
varchar(22) |
NO |
PRI |
|
|
| templateId |
varchar(22) |
NO |
|
|
|
| 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) |
NO |
|
|
|
| errorMessage |
varchar(128) |
YES |
|
|
|
| recipe |
varchar(15) |
NO |
|
|
|
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 |
|
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) |
NO |
|
3 |
|
| inOutGroup |
varchar(22) |
NO |
|
2 |
|
| inOutTemplateId |
varchar(22) |
NO |
|
IOB0000000000000000001 |
|
| reportTemplateId |
varchar(22) |
NO |
|
IOB0000000000000000002 |
|
| paginateAfter |
int(11) |
NO |