rightfax database schema report - · pdf filerightfax database schema report tables, 64 items...

RightFax Database Schema Report

Tables, 64 items

Table: 'dbo.AdminPagerNotify', 13 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLOwner int NOT NULLFlags bigint NOT NULLType bigint NOT NULLd_data smallint NULLPagerID varchar(64) NULLServiceName varchar(22) NULLTypes1 bigint NULLTypes2 bigint NULLHeartBeatInterval int NULLQueueFaxDepth bigint NULLQueuePageDepth bigint NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.AdminPagerNotify'

Primary Key Name Field NamePK_AdminPagerNotify ID

Foreign keys for table 'dbo.AdminPagerNotify', 1 item

Foreign PrimaryAdminPagerNotify.Owner Users.handle

Indexes for table 'dbo.AdminPagerNotify', 1 item

Index Name Clustered Unique FieldsPK_AdminPagerNotify Yes Yes ID

Dependencies for table 'dbo.AdminPagerNotify', 8 items

Object Name Typedbo.CK_AdminPagerNotify_d_data_Unsigned check cnsdbo.CK_AdminPagerNotify_Flags_Unsigned check cnsdbo.CK_AdminPagerNotify_HeartBeatInterval_Unsigned check cnsdbo.CK_AdminPagerNotify_QueueFaxDepth_Unsigned check cnsdbo.CK_AdminPagerNotify_QueuePageDepth_Unsigned check cnsdbo.CK_AdminPagerNotify_Type_Unsigned check cnsdbo.CK_AdminPagerNotify_Types1_Unsigned check cnsdbo.CK_AdminPagerNotify_Types2_Unsigned check cns

Table: 'dbo.Audits', 7 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLAction nvarchar(80) NULL The audit event

type: Added,Modified, Deleted.

AuditedType nvarchar(80) NULL The type of recordaudited.

CreationTime datetime NULL The time this auditevent happened.

Creator nvarchar(128) NULL The persongenerating thisaudit event.

AuditedValue nvarchar(128) NULL The value that wasaudited.

ServerGUID uniqueidentifier NULL

Table: 'dbo.BillingCodes', 6 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLBillInfo1 varchar(16) NULLBillInfo2 varchar(16) NULLDescription varchar(120) NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.BillingCodes'

Primary Key Name Field NamePK_BillingCodes handle

Indexes for table 'dbo.BillingCodes', 6 items

Index Name Clustered Unique FieldsPK_BillingCodes Yes Yes handleIX_BillingCodes_BillInfo1_BillInfo2

No Yes BillInfo1, BillInfo2

IX_BillingCodes_BillInfo1

No No BillInfo1

IX_BillingCodes_BillInfo2

No No BillInfo2

IX_BillingCodes_Description

No No Description

Dependencies for table 'dbo.BillingCodes', 2 items

Object Name Typedbo.CK_BillingCodes_Flags_Unsigned check cnsdbo.fnGenerateObjectCounts table function

Table: 'dbo.Configuration', 13 fields

Field Name Type and Size Default Nullable DescriptionServerGUID uniqueidentifier NOT NULLBumpData varchar(193) NULLFlags bigint NULLReqFieldsSend binary(28) NULLReqFieldsRec binary(28) NULLBillDesc1 varchar(16) NULLBillDesc2 varchar(16) NULLVerifyCodes smallint NULLBumpRunDate datetime NULLObjectGuid uniqueidentifier (newid()) NULLFSRunning int NULLServerKey varchar(193) NULLClusterGUID uniqueidentifier NULL

Primary key for table 'dbo.Configuration'

Primary Key Name Field NamePK_Configuration ServerGUID

Indexes for table 'dbo.Configuration', 1 item

Index Name Clustered Unique FieldsPK_Configuration Yes Yes ServerGUID

Dependencies for table 'dbo.Configuration', 4 items

Object Name Typedbo.CK_Configuration_Flags_Unsigned check cnsdbo.fnGenerateObjectCounts table functiondbo.fnWorkRequestCounts table functiondbo.InsertBaseConfiguration stored procedure

Table: 'dbo.Contacts', 23 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwnerHandle int NOT NULLID varchar(18) NOT NULLName varchar(256) NULLCompany varchar(256) NULLAddress1 varchar(256) NULLAddress2 varchar(256) NULLAddress3 varchar(256) NULLCity varchar(256) NULLState varchar(50) NULLZip varchar(50) NULLPrimaryFax varchar(128) NULLSecondaryFax varchar(128) NULLPrimaryVoice varchar(128) NULLSecondaryVoice varchar(128) NULLMobilePhone varchar(128) NULLEmailAddress varchar(256) NULLNotes varchar(256) NULLBillInfo1 varchar(18) NULLBillInfo2 varchar(18) NULLFlags bigint NULLSecureCSID varchar(22) NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Contacts'

Primary Key Name Field NamePK_Contacts handle

Foreign keys for table 'dbo.Contacts', 1 item

Foreign PrimaryContacts.OwnerHandle Users.handle

Indexes for table 'dbo.Contacts', 4 items

Index Name Clustered Unique FieldsIX_Contacts_ID No Yes ID, OwnerHandlePK_Contacts No Yes handleIX_Contacts_OwnerHandle No No OwnerHandle

Dependencies for table 'dbo.Contacts', 7 items

Object Name Typedbo.CK_ContactsValidID check cnsdbo.ExpandedContacts view

dbo.fnGenerateGroupContents table functiondbo.fnGenerateObjectCounts table functiondbo.fnGetContentsOfDL inline functiondbo.RFView_UserPhoneEntries viewdbo.RFView_UserPhoneGroups view

Table: 'dbo.Delegates', 9 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLDelegator int NULLDelegatee int NULLReadPermissions bigint NULLWritePermissions bigint NULLDeletePermissions bigint NULLMiscPermissions bigint NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Delegates'

Primary Key Name Field NamePK_Delegates handle

Foreign keys for table 'dbo.Delegates', 2 items

Foreign PrimaryDelegates.Delegatee Users.handleDelegates.Delegator Users.handle

Indexes for table 'dbo.Delegates', 3 items

Index Name Clustered Unique FieldsPK_Delegates Yes Yes handleIX_Delegates_Delegatee No No DelegateeIX_Delegates_Delegator No No Delegator

Dependencies for table 'dbo.Delegates', 6 items

Object Name Typedbo.CK_Delegates_DeletePermissions_Unsigned check cnsdbo.CK_Delegates_Flags_Unsigned check cnsdbo.CK_Delegates_MiscPermissions_Unsigned check cnsdbo.CK_Delegates_ReadPermissions_Unsigned check cnsdbo.CK_Delegates_WritePermissions_Unsigned check cnsdbo.fnDelegatorsFromID inline function

Table: 'dbo.DistributionLists', 5 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLItemHandle int NOT NULLListHandle int NOT NULLContactType varchar(50) NOT NULLExtension int NULL Used to map

distribution listrelationships backto an extension forthe old API

Primary key for table 'dbo.DistributionLists'

Primary Key Name Field NamePK_DistributionLists ID

Foreign keys for table 'dbo.DistributionLists', 2 items

Foreign PrimaryDistributionLists.ItemHandle Contacts.handleDistributionLists.Extension ExtensionJoin.handle

Indexes for table 'dbo.DistributionLists', 3 items

Index Name Clustered Unique FieldsPK_DistributionLists Yes Yes IDIX_ContactsDistributionLists

No No ListHandle

IX_ContactsDistributionLists_ContactType

No No ContactType

Dependencies for table 'dbo.DistributionLists', 3 items

Object Name Typedbo.fnGenerateGroupContents table functiondbo.fnGetContentsOfDL inline functiondbo.RFView_UserPhoneGroups view

Table: 'dbo.DocFiles', 17 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLLinks int NULLJobID int NULLDocType int NULLBodyFilename varchar(14) NULLInputFilename varchar(14) NULLNumPages int NULLPaperNum smallint NULLPrintJobType smallint NULLFineMode smallint NULLBFTFile varchar(14) NULLBFTBytes bigint NULLOrigBFTName varchar(14) NULLImageBytes bigint NULLreserved varchar(12) NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.DocFiles'

Primary Key Name Field NamePK_DocFiles handle

Indexes for table 'dbo.DocFiles', 1 item

Index Name Clustered Unique FieldsPK_DocFiles Yes Yes handle

Dependencies for table 'dbo.DocFiles', 18 items

Object Name Typedbo.CK_FaxFiles_BFTBytes_Unsigned check cnsdbo.CK_FaxFiles_DocType_Unsigned check cnsdbo.CK_FaxFiles_Flags_Unsigned check cns

dbo.CK_FaxFiles_ImageBytes_Unsigned check cnsdbo.CK_FaxFiles_JobID_Unsigned check cnsdbo.CK_FaxFiles_Links_Unsigned check cnsdbo.CK_FaxFiles_NumPages_Unsigned check cnsdbo.DeleteAllDocuments stored proceduredbo.DeleteDocument stored proceduredbo.fnDocumentAttachmentStatus scalar functiondbo.fnDocumentPageCount scalar functiondbo.fnDocumentPDFStatus scalar functiondbo.fnFormatDocumentPageCount scalar functiondbo.fnGenerateDocumentCounts table functiondbo.fnGetFileFlagsFromDocumentHandle scalar functiondbo.fnViewDocTransactions table functiondbo.fnViewDocuments table functiondbo.PurgeDocument stored procedure

Table: 'dbo.Documents', 67 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwnerID int NOT NULLFlags bigint NULLDestination varchar(32) NULLToContactNum varchar(32) NULLToName varchar(60) NULLToCompany varchar(60) NULLToCityState varchar(60) NULLFromName varchar(60) NULLFromPhoneNum varchar(32) NULLBillInfo1 varchar(16) NULLBillInfo2 varchar(16) NULLFaxDIDNum varchar(32) NULLOperatorNum varchar(32) NULLGeneralFaxNum varchar(32) NULLCallBack smallint NULLCreationTime datetime NULLElapsedSendTime bigint NULLStatus int NULLErrorCode int NULLDisposition int NULLTermStat int NULLRemoteID varchar(22) NULLDocFileDBA int NULLNoteDBA int NULLFCSFile varchar(14) NULLFCSText varchar(14) NULLFaxID int NULLNotifyChannel int NULLPhoneUserID varchar(22) NULLPhoneEntryID varchar(18) NULLDelaySendUntilTime datetime NULLUniqueID varchar(16) NULLfcstype int NULLEmailType smallint NULLPriority smallint NULLSendChannel int NULLCustom1 int NULLBoardSrv int NULLOldStatus int NULLOldErrorCode int NULLPagesInFront int NULLMaxTries smallint NULLTryInterval smallint NULLFolderIndex int NULL

SendNotify int NULLSecureCSID varchar(22) NULLFromNameCont varchar(41) NULLAutoFwdCount smallint NULLHistChgDateTime datetime NULLTUIFaxDBA bigint NULLFRFlags2 bigint NULLCCListDBA bigint NULLCmdData varchar(14) NULLAltDestination varchar(32) NULLFCSBytes bigint NULLComment varchar(70) NULLExpiresIn int NULLRecNotType smallint NULLRecNotAddr varchar(32) NULLPrefContType smallint NULLFRReserved2 varchar(914) NULLServerGUID uniqueidentifier NULLMsgFromTransport varchar(32) NULLObjectGuid uniqueidentifier (newid()) NULLUsnCreated bigint ((0)) NULLUsnUpdated bigint ((0)) NULL

Primary key for table 'dbo.Documents'

Primary Key Name Field NamePK_Documents handle

Foreign keys for table 'dbo.Documents', 3 items

Foreign PrimaryDocuments.DocFileDBA DocFiles.handleDocuments.NoteDBA Notes.handleDocuments.OwnerID Users.handle

Indexes for table 'dbo.Documents', 6 items

Index Name Clustered Unique FieldsPK_Documents Yes Yes handleIX_Documents_DocFileDBA No No DocFileDBAIX_Documents_Flags No No FlagsIX_Documents_OwnerID No No OwnerIDIX_Documents_OwnerID_Flags

No No OwnerID, Flags

Triggers for table 'dbo.Documents', 2 items

Name Type EnabledOnInsertDocumentsUsn after INSERT YesOnUpdateDocumentsUsn after UPDATE Yes

Dependencies for table 'dbo.Documents', 49 items

Object Name Typedbo.CK_Documents_AutoFwdCount_Unsigned check cnsdbo.CK_Documents_BoardSrv_Unsigned check cnsdbo.CK_Documents_CCListDBA_Unsigned check cnsdbo.CK_Documents_Custom1_Unsigned check cnsdbo.CK_Documents_Disposition_Unsigned check cnsdbo.CK_Documents_ElapsedSendTime_Unsigned check cnsdbo.CK_Documents_EmailType_Unsigned check cnsdbo.CK_Documents_ErrorCode_Unsigned check cnsdbo.CK_Documents_FaxID_Unsigned check cns

dbo.CK_Documents_FCSBytes_Unsigned check cnsdbo.CK_Documents_fcstype_Unsigned check cnsdbo.CK_Documents_Flags_Unsigned check cnsdbo.CK_Documents_FolderIndex_Unsigned check cnsdbo.CK_Documents_FRFlags2_Unsigned check cnsdbo.CK_Documents_MaxTries_Unsigned check cnsdbo.CK_Documents_NotifyChannel_Unsigned check cnsdbo.CK_Documents_OldErrorCode_Unsigned check cnsdbo.CK_Documents_OldStatus_Unsigned check cnsdbo.CK_Documents_PagesInFront_Unsigned check cnsdbo.CK_Documents_Priority_Unsigned check cnsdbo.CK_Documents_SendChannel_Unsigned check cnsdbo.CK_Documents_SendNotify_Unsigned check cnsdbo.CK_Documents_Status_Unsigned check cnsdbo.CK_Documents_TermStat_Unsigned check cnsdbo.CK_Documents_TryInterval_Unsigned check cnsdbo.CK_Documents_TUIFaxDBA_Unsigned check cnsdbo.DeleteAllDocuments stored proceduredbo.DeleteDocument stored proceduredbo.fnDocumentAttachmentStatus scalar functiondbo.fnDocumentPageCount scalar functiondbo.fnDocumentPDFStatus scalar functiondbo.fnDocumentPrintedStatus scalar functiondbo.fnDocumentSentReceivedStatus scalar functiondbo.fnDocumentType scalar functiondbo.fnDocumentViewedStatus scalar functiondbo.fnFormatDocumentPageCount scalar functiondbo.fnGenerateDocumentCounts table functiondbo.fnGenerateObjectCounts table functiondbo.fnGetAgedDocuments inline functiondbo.fnGetDocumentCountForUser scalar functiondbo.fnGetFileFlagsFromDocumentHandle scalar functiondbo.fnViewDocTransactions table functiondbo.fnViewDocuments table functiondbo.GetNextDocument stored proceduredbo.OnInsertDocumentsUsn triggerdbo.OnUpdateDocumentsUsn triggerdbo.PurgeDocument stored proceduredbo.UpdateHistChgDateTime stored proceduredbo.UsersFull view

Table: 'dbo.DTActivities', 65 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULL Primary key used to

identify thisactivity

ActID int NOT NULL Activity ID (0 to0xFFFF)

Marked smallint NOT NULL Set when a serverhas retrieved thisrecord fromDocTransport

Age smallint NULL Age of this recordin terms of numberof maintenancecycles it has beenthrough

Type smallint NULL Type of transportevent (e.g., remotesend, local receive,etc.)

Unit smallint NULL Local channelresponsible fororchestrating thisactivity

Pages smallint NULL Total number ofpages in thisactivity

BadPages smallint NULL Number of pages thatinvolved errors

GoodPages smallint NULL Number of pages thatwere handledsuccessfully

BoardType smallint NULL Type of board, ifany, involved inthis activity

CallStatus smallint NULL Status result of theactivity

CallLineStatus smallint NULL Status result of thecommunication medium

TransactionStatus smallint NULL Status result forthe transaction

TransactionLineStatus

smallint NULL Status result of thetransaction medium

SenderID varchar(48) NULL ID of sender forreceive transactions

CallType smallint NULL Flags regarding thetype of call

Destination varchar(260) NULL Destination ofrecipient foroutboundtransactions (e.g.,fax number, e-mailaddress, etc.)

Filename varchar(260) NULL Name of documentfile used intransaction

TransactionTime datetime NULL Time thistransaction began

TransactionDuration int NULL Duration oftransaction inseconds

ForeignReqID varchar(50) NULL ID of request inforeign system

ForeignDocID bigint NULL Integer ID ofdocument in foreignsystem

DocumentName varchar(64) NULL Friendly name fordocument

ForeignLoginID varchar(128) NULL Login ID used toauthenticate onforeign system

ForeignLoginPassword varchar(128) NULL Login password usedto authenticate onforeign system

BroadcastID int NULL ID of broadcast thatthis transaction ispart of

BroadcastIndex int NULL Index of broadcastthat thistransaction is partof

Progress int NULL Progress identifier(seeDTEnumActivitiesProgress)

TransportType varchar(32) NULL Type of thetransport used toperform thistransaction

TransportError bigint NULL Error code specificto the transportused for thistransaction

Flags int NULL Transaction specificflags

ANI varchar(32) NULL ANI information forthis transactionwhen available

AOCData1 bigint NULLAOCData2 bigint NULLAOCData3 bigint NULLISDNCauseValue int NULL Cause value for ISDN

onlyTransportMessage varchar(96) NULL Transport specific

message to record inDocument

RemoteServerName varchar(260) NULL Name of the remoteserver used in thistransaction

RemoteID char(10) NULL ID of thistransaction in theremote DocTransportwhen sending via orinto another server

RemoteProtocol int NULL Protocol used tocommunicate withremote DocTransportwhen sending via orinto another server

ToContactNum varchar(32) NULL Voice contact numberfor recipient

ToName varchar(60) NULL Recipient nameToCompany varchar(60) NULL Recipient company

informationBillInfo1 varchar(16) NULL Billing informationBillInfo2 varchar(16) NULL Billing informationSecureCSID varchar(22) NULL Identifier of

intended recipient'sequipment forverificationpurposes

AuditFlags bigint NULL Audit specific flagsSubscriberID bigint NULL Subscriber ID of

sender in RightFaxUniqueID varchar(16) NULL RightFax document

unique IDFromName varchar(60) NULL Sender nameSourceServerName varchar(260) NULL Originating server

nameUserID varchar(22) NULL RightFax User ID

this transaction wasmade on behalf of

ServerGUID uniqueidentifier NOT NULL GUID of DocTransportidentified inDTConfigurations

SendFlags bigint NULL Flags used inscheduling thisdocument

MinSendChannel int NULL Minimum channelnumber that thisdocument is allowedto be sent on(origin is 1; 0indicates all)

MaxSendChannel int NULL Maximum channelnumber that thisdocument is allowedto be sent on(origin is 1)

TimeScheduled datetime NULL Time this documentwas scheduled

QuickHeaderFormat varchar(134) NULL Formatting for faxquick headers

TTIHeaderID varchar(24) NULL Header field on theTTI line

Priority int NULL Document sendpriority

ExpirationTime datetime NULL Time this faxexpires (and, afterwhich, it should beaborted, ifpossible).

GroupID varchar(22) NULL RightFax sender'sRightFax group ID

DocumentFlags int NULL Flags specified bydocument server

QueueName varchar(30) NULL Name of schedulequeue

DTDialingRuleUsed int NULL

Primary key for table 'dbo.DTActivities'

Primary Key Name Field NamePK_DTActivities ID

Foreign keys for table 'dbo.DTActivities', 1 item

Foreign PrimaryDTActivities.ServerGUID DTConfigurations.ServerGUID

Indexes for table 'dbo.DTActivities', 5 items

Index Name Clustered Unique FieldsPK_DTActivities Yes Yes IDIX_DTActivities No No ActIDIX_DTActivities_Marked No No MarkedIX_DTActivities_QueueName

No No QueueName

IX_DTActivities_Type No No Type

Dependencies for table 'dbo.DTActivities', 5 items

Object Name Typedbo.fnCalculatePagesInFront scalar functiondbo.fnGenerateDTActivityCounts table functiondbo.GetDTActivitySend stored proceduredbo.PurgeDTActivities stored proceduredbo.RescheduleDTActivitySend stored procedure

Table: 'dbo.DTActivityState', 13 fields

Field Name Type and Size Default Nullable DescriptionServerGUID uniqueidentifier NOT NULLCurrentFile bigint NOT NULL Identifier of last

unique file numberused

CurrentID int NOT NULL Last ID used forDTActivities

TotalsReset datetime NOT NULL Time at which "All-time" totals waslast reset.

LocalDocsSent bigint NOT NULL Documents sentlocally since lastreset

LocalDocsReceived bigint NOT NULL Documents receivedlocally since lastreset

LocalPagesSent bigint NOT NULL Pages sent locallysince last reset

LocalPagesReceived bigint NOT NULL Pages recievedlocally since lastreset

RemoteDocsSent bigint NOT NULL Documents sentremotely since lastreset.

RemoteDocsReceived bigint NOT NULL Documents receivedremotely since lastreset.

RemotePagesSent bigint NOT NULL Pages sent remotelysince last reset

RemotePagesReceived bigint NOT NULL Pages recievedremotely since lastreset

LastPulseTime datetime ('01/01/2005') NOT NULL Pulse valueperiodically updatedby the correspondingDT to show signs oflife.

Primary key for table 'dbo.DTActivityState'

Primary Key Name Field NamePK_DTActivityState ServerGUID

Foreign keys for table 'dbo.DTActivityState', 1 item

Foreign PrimaryDTActivityState.ServerGUID DTConfigurations.ServerGUID

Indexes for table 'dbo.DTActivityState', 1 item

Index Name Clustered Unique FieldsPK_DTActivityState Yes Yes ServerGUID

Dependencies for table 'dbo.DTActivityState', 3 items

Object Name Typedbo.DTPulse stored proceduredbo.DTPulseExpired stored proceduredbo.DTSecondsSinceLastPulse stored procedure

Table: 'dbo.DTConfigurations', 4 fields, Each row in this table definesserver specific settings

Field Name Type and Size Default Nullable DescriptionServerGUID uniqueidentifier NOT NULL Server identifier

used to relate rowsto particularservers

ServerName varchar(260) NULL Optional name ofthis server (forreference only)

ImageDir varchar(260) NULL Path to the server'simage dir. This isthe same dir for allDT's connected tothe same servergroup but each DTcould have adifferent path toaccess it.

FilenamePrefix char(2) NULL

Primary key for table 'dbo.DTConfigurations'

Primary Key Name Field NamePK_DTConfigurations ServerGUID

Indexes for table 'dbo.DTConfigurations', 1 item

Index Name Clustered Unique FieldsPK_DTConfigurations Yes Yes ServerGUID

Dependencies for table 'dbo.DTConfigurations', 2 items

Object Name Typedbo.DTPulseExpired stored proceduredbo.DTSetFilenamePrefix stored procedure

Table: 'dbo.DTConfigurationsDialingRules', 7 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLServerGUID uniqueidentifier NOT NULLDTDialingRulesID int NOT NULLEnabled bit ((1)) NULLTimeAvailable datetime ((0)) NULLDownReason varchar(128) NULLDisabledReason bigint NULL

Primary key for table 'dbo.DTConfigurationsDialingRules'

Primary Key Name Field NamePK_DTConfigurationsDialingRules ID

Foreign keys for table 'dbo.DTConfigurationsDialingRules', 2 items

Foreign PrimaryDTConfigurationsDialingRules.ServerGUID DTConfigurations.ServerGUIDDTConfigurationsDialingRules.DTDialingRulesID DTDialingRules.ID

Indexes for table 'dbo.DTConfigurationsDialingRules', 1 item

Index Name Clustered Unique FieldsPK_DTConfigurationsDialingRules

Yes Yes ID

Table: 'dbo.DTDestinationGroups', 9 fields, This table describes"prefix" or destination tables.

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLName varchar(50) NOT NULL Name of this table

for reference in UIand queries

IsExtConnection bit NULLExtConnection varchar(256) NULL Optional external

data sourceconnection string

ExtTable varchar(256) NULL Name of table inexternal datasource

ExtColumn varchar(50) NULL Name of columncontainingdestination addressin external datasource

ExtPK varchar(50) NULLCondition varchar(256) NULL Condition binding

data in ExtTable tothis destinationsgroup

ServerGUID uniqueidentifier NULL Optional identifierof a specific serverto associate thisrecord with. Thisallows separatetables with the samename to exist onmultiple servers inthe same database.

Primary key for table 'dbo.DTDestinationGroups'

Primary Key Name Field NamePK_DTDestinationGroups ID

Foreign keys for table 'dbo.DTDestinationGroups', 1 item

Foreign PrimaryDTDestinationGroups.ServerGUID DTConfigurations.ServerGUID

Indexes for table 'dbo.DTDestinationGroups', 3 items

Index Name Clustered Unique FieldsPK_DTDestinationGroups Yes Yes IDIX_DTDestinationGroups_NameServerGUID

No Yes Name, ServerGUID

Table: 'dbo.DTDestinations', 3 fields, Destinations table containingdata for non-external destination groups

Field Name Type and Size Default Nullable Description

ID int identity NOT NULL Primary key fordeletion or otheruniqueidentification

Destination varchar(50) NOT NULL Destination addressOwnerID int NOT NULL ID of

DTDestinationGroupsrow that owns thisaddress

Primary key for table 'dbo.DTDestinations'

Primary Key Name Field NamePK_DTDestinations ID

Foreign keys for table 'dbo.DTDestinations', 1 item

Foreign PrimaryDTDestinations.OwnerID DTDestinationGroups.ID

Indexes for table 'dbo.DTDestinations', 1 item

Index Name Clustered Unique FieldsPK_DTDestinations Yes Yes ID

Table: 'dbo.DTDialingRules', 33 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLSourceServer varchar(48) NULLPattern varchar(64) NULLDestinationServer varchar(48) NULLProtocol int NULLPriorityDelta smallint NULLFlags bigint NULLPriorityMask int NULLStartChannel int NULLTimeOfDayMask_0 bigint NULLTimeOfDayMask_1 bigint NULLTimeOfDayMask_2 bigint NULLTimeOfDayMask_3 bigint NULLTimeOfDayMask_4 bigint NULLTimeOfDayMask_5 bigint NULLTimeOfDayMask_6 bigint NULLBeginDelete smallint NULLBeginReplace varchar(48) NULLEndDelete smallint NULLEndReplace varchar(48) NULLUserID varchar(128) NULLGroupID varchar(128) NULLEndChannel int NULLComment varchar(64) NULLMinQueueDepth bigint NULLExtraWeight bigint NULLDelayHour int NULLFaxSize smallint NULLMLAccount varchar(12) NULLMLPassCode varchar(12) NULLMLDocAccount varchar(32) NULLDNDNotifyList varchar(128) NULLNotifySender int NULL

Primary key for table 'dbo.DTDialingRules'

Primary Key Name Field NamePK_DTDialingRules ID

Indexes for table 'dbo.DTDialingRules', 1 item

Index Name Clustered Unique FieldsPK_DTDialingRules Yes Yes ID

Table: 'dbo.DTRxDocs', 10 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULL Primary keyDTActivitiesID int NOT NULL Indicates which

DTActivities entrythis receiveddocument correspondsto

Dequeued bit ((0)) NOT NULL Indicates whetherthis entry has beendequeued

Filename varchar(260) NOT NULL Name of thecorresponding filein the imagedirectory

RoutingInfo varchar(256) NULL Routing info (suchas DID number or e-mail address)

RoutingInfoValid bit NOT NULLError bigint NOT NULL Error, if any, in

receiving thisdocument

ServerGUID uniqueidentifier NOT NULL GUID of server thatreceived thisdocument

TimeZoneBias smallint NOT NULL Number of minutes oftimezone biasaccumulated throughserver routing

ReceiveType smallint NOT NULL Type of receive

Primary key for table 'dbo.DTRxDocs'

Primary Key Name Field NamePK_DTRxDocs ID

Foreign keys for table 'dbo.DTRxDocs', 2 items

Foreign PrimaryDTRxDocs.DTActivitiesID DTActivities.IDDTRxDocs.ServerGUID DTConfigurations.ServerGUID

Indexes for table 'dbo.DTRxDocs', 1 item

Index Name Clustered Unique FieldsPK_DTRxDocs Yes Yes ID

Dependencies for table 'dbo.DTRxDocs', 1 item

Object Name Typedbo.GetNextRxDoc stored procedure

Table: 'dbo.EnumEventsType', 3 fields

Field Name Type and Size Default Nullable DescriptionType int NOT NULL Event type

identifierName varchar(64) NOT NULL Name for this typeDescription varchar(256) NOT NULL Description for this

type

Primary key for table 'dbo.EnumEventsType'

Primary Key Name Field NamePK_EnumEventsType Type

Indexes for table 'dbo.EnumEventsType', 2 items

Index Name Clustered Unique FieldsPK_EnumEventsType Yes Yes TypeIX_EnumEventsType No Yes Type

Dependencies for table 'dbo.EnumEventsType', 2 items

Object Name Typedbo.EventsAll viewdbo.EventsTotals view

Table: 'dbo.ErrorLog', 2 fields

Field Name Type and Size Default Nullable Descriptionhandle smallint identity NOT NULLDescription varchar(256) NOT NULL

Primary key for table 'dbo.ErrorLog'

Primary Key Name Field NamePK_ErrorLog handle

Indexes for table 'dbo.ErrorLog', 1 item

Index Name Clustered Unique FieldsPK_ErrorLog Yes Yes handle

Table: 'dbo.Events', 14 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLType int NOT NULL The type of eventRetries smallint NOT NULL Number of times this

event has beenreposted

EnqueueTime datetime NOT NULL Time this event wasenqueued

DequeueTime datetime NOT NULL When this eventshould be dequeued. Events that are notto be delayed usethe current time

DocumentHandle int NULL Handle to thedocument in theDocuments table thatthis event affects

UserHandle int NULL Handle to the userin the Users tablethat this eventcorresponds to

Msg varchar(128) NULL Text message for theevent

Parm0 int NULL General purpose datavalue for the event

Parm1 int NULLParm2 int NULLParm3 int NULLServerGUID uniqueidentifier NOT NULL Server that posted

this event (but notnecessarily who willprocess it)

Dequeued bit ((0)) NOT NULL

Primary key for table 'dbo.Events'

Primary Key Name Field NamePK_Events ID

Foreign keys for table 'dbo.Events', 3 items

Foreign PrimaryEvents.DocumentHandle Documents.handleEvents.Type EnumEventsType.TypeEvents.UserHandle Users.handle

Indexes for table 'dbo.Events', 5 items

Index Name Clustered Unique FieldsPK_Events Yes Yes IDIX_Events No No DequeueTime, EnqueueTimeIX_Events_DocumentHandle No No DocumentHandleIX_Events_Type No No Type

Dependencies for table 'dbo.Events', 4 items

Object Name Typedbo.DeleteDocument stored proceduredbo.EventsAll viewdbo.EventsTotals viewdbo.GetNextEvent stored procedure

Table: 'dbo.ExtensionJoin', 3 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwner int NULLType bigint NULL

Primary key for table 'dbo.ExtensionJoin'

Primary Key Name Field NamePK_ExtensionJoin handle

Indexes for table 'dbo.ExtensionJoin', 3 items

Index Name Clustered Unique FieldsPK_ExtensionJoin Yes Yes handleIX_ExtensionJoin_Owner No No Owner

IX_ExtensionJoin_Type No No Type

Dependencies for table 'dbo.ExtensionJoin', 1 item

Object Name Typedbo.CK_ExtensionJoin_Type_Unsigned check cns

Table: 'dbo.Forms', 12 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFTFlags bigint NULLFTNum smallint NULLFTCode varchar(16) NULLFTName varchar(40) NULLFTFilename varchar(20) NULLFTStartPage smallint NULLFTNumPages smallint NULLFTNextType smallint NULLFTSecurityID varchar(20) NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Forms'

Primary Key Name Field NamePK_Forms handle

Indexes for table 'dbo.Forms', 17 items

Index Name Clustered Unique FieldsPK_Forms Yes Yes handleIX_Forms_FTCode No Yes FTCode, ServerGUIDIX_Forms_FTNum No Yes FTNum, ServerGUIDForms2 No No ServerGUID, handle,

FTFlags, FTNum, FTCode,FTName, FTFilename,FTStartPage, FTNumPages,FTNextType, FTSecurityID

IX_Forms_ServerGUID No No ServerGUID

Dependencies for table 'dbo.Forms', 3 items

Object Name Typedbo.CK_Forms_FTFlags_Unsigned check cnsdbo.fnGenerateObjectCounts table functiondbo.InsertBaseServerSpecificData stored procedure

Table: 'dbo.GlobalConfiguration', 4 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLCurrentUSN bigint ((0)) NOT NULLDBVersion varchar(16) NULLCurrentFile bigint ((0)) NOT NULL

Primary key for table 'dbo.GlobalConfiguration'

Primary Key Name Field NamePK_GlobalConfiguration ID

Indexes for table 'dbo.GlobalConfiguration', 1 item

Index Name Clustered Unique FieldsPK_GlobalConfiguration Yes Yes ID

Dependencies for table 'dbo.GlobalConfiguration', 2 items

Object Name Typedbo.GetNextFile stored proceduredbo.spGetNextUsn stored procedure

Table: 'dbo.Globalization', 4 fields

Field Name Type and Size Default Nullable DescriptionNamespace nvarchar(100) NOT NULLLocKey nvarchar(100) NOT NULLIsoLanguageName nvarchar(6) NOT NULLData ntext NULL

Primary key for table 'dbo.Globalization'

Primary Key Name Field NamesPK_Globalization Namespace, LocKey, IsoLanguageName

Indexes for table 'dbo.Globalization', 3 items

Index Name Clustered Unique FieldsPK_Globalization Yes Yes Namespace, LocKey,

IsoLanguageName

Dependencies for table 'dbo.Globalization', 9 items

Object Name Typedbo.fnGetChildrenOfFolder inline functiondbo.fnGetChildrenOfFolder2 table functiondbo.fnGetFolderFromID table functiondbo.fnGetFolderNameFromID scalar functiondbo.fnGetGammaString scalar functiondbo.fnGetHangupStatusString scalar functiondbo.fnGetTermStatString scalar functiondbo.fnGetUntranslatedStringsForLanguage inline functiondbo.GetUntranslatedStringsForAllLanguages stored procedure

Table: 'dbo.Groups', 28 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLGroupID varchar(22) NULLAdmin varchar(22) NULLAltAdmin varchar(22) NULLGroupFCS varchar(14) NULLNotifyType int NULLRecvDocAge int NULLSentDocAge int NULLDelDocAge int NULLGroupRoutingCode bigint NULLSFDType int NULLSFDFlags int NULLChangeTag bigint NULLMaxConcurrentPages int NULLMaxConcurrentDocs int NULLConcurrentDelayTime smalldatetime NULL

ConcurrentStartTime smalldatetime NULLConcurrentEndTime smalldatetime NULLNewDocAge int NULLFailedDocAge int NULLINCSentDocAge int NULLFCSDlgCtrl1 bigint NULLFCSDlgCtrl2 bigint NULLHotLinkDocAge int NULLObjectGuid uniqueidentifier (newid()) NULLUsnCreated bigint ((0)) NULLUsnUpdated bigint ((0)) NULL

Primary key for table 'dbo.Groups'

Primary Key Name Field NamePK_Groups handle

Indexes for table 'dbo.Groups', 3 items

Index Name Clustered Unique FieldsPK_Groups Yes Yes handleIX_Groups_GroupID No Yes GroupIDIX_Groups_GroupRoutingCode

No No GroupRoutingCode

Triggers for table 'dbo.Groups', 2 items

Name Type EnabledOnInsertGroupsUsn after INSERT YesOnUpdateGroupsUsn after UPDATE Yes

Dependencies for table 'dbo.Groups', 30 items

Object Name Typedbo.CK_Groups_ChangeTag_Unsigned check cnsdbo.CK_Groups_DelDocAge_Unsigned check cnsdbo.CK_Groups_FailedDocAge_Unsigned check cnsdbo.CK_Groups_FCSDlgCtrl1_Unsigned check cnsdbo.CK_Groups_FCSDlgCtrl2_Unsigned check cnsdbo.CK_Groups_Flags_Unsigned check cnsdbo.CK_Groups_GroupRoutingCode_Unsigned check cnsdbo.CK_Groups_HotLinkDocAge_Unsigned check cnsdbo.CK_Groups_INCSentDocAge_Unsigned check cnsdbo.CK_Groups_MaxConcurrentDocs_Unsigned check cnsdbo.CK_Groups_MaxConcurrentPages_Unsigned check cnsdbo.CK_Groups_NewDocAge_Unsigned check cnsdbo.CK_Groups_NotifyType_Unsigned check cnsdbo.CK_Groups_RecvDocAge_Unsigned check cnsdbo.CK_Groups_SentDocAge_Unsigned check cnsdbo.CK_Groups_SFDFlags_Unsigned check cnsdbo.CK_Groups_SFDType_Unsigned check cnsdbo.fnGetAgedDocuments inline functiondbo.fnGetGroupIDFromUserHandle scalar functiondbo.fnGetGroupsAdminedBy inline functiondbo.fnGroupHandleFromID scalar functiondbo.fnGroupMembersFromID inline functiondbo.fnViewUserSettings table functiondbo.GroupsFull viewdbo.InsertBaseRecords stored proceduredbo.OnInsertGroupsUsn triggerdbo.OnUpdateGroupsUsn triggerdbo.OnUpdateUsersUsn triggerdbo.PurgeDocuments stored procedure

dbo.UsersFull view

Table: 'dbo.HangupStatusToStatusCode', 2 fields

Field Name Type and Size Default Nullable DescriptionHangupStatus int NOT NULLStatusCode int NOT NULL

Primary key for table 'dbo.HangupStatusToStatusCode'

Primary Key Name Field NamesPK_HangupStatusToStatusCode HangupStatus, StatusCode

Indexes for table 'dbo.HangupStatusToStatusCode', 2 items

Index Name Clustered Unique FieldsPK_HangupStatusToStatusCode

Yes Yes HangupStatus, StatusCode

Dependencies for table 'dbo.HangupStatusToStatusCode', 1 item

Object Name Typedbo.fnGetHangupStatusString scalar function

Table: 'dbo.History', 5 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwner int NULLTRDateTime datetime NULLTRRecType smallint NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.History'

Primary Key Name Field NamePK_History handle

Foreign keys for table 'dbo.History', 1 item

Foreign PrimaryHistory.Owner Documents.handle

Indexes for table 'dbo.History', 2 items

Index Name Clustered Unique FieldsPK_History Yes Yes handleIX_History_Owner No No Owner

Triggers for table 'dbo.History', 1 item

Name Type EnabledOnInsertHistory after INSERT Yes

Dependencies for table 'dbo.History', 4 items

Object Name Typedbo.CK_History_TRRecType_Unsigned check cnsdbo.fnDocumentCountMatchingAniRecords scalar functiondbo.fnGetHistoryCountForDocument scalar functiondbo.fnViewDocTransactions table function

Table: 'dbo.HistoryApproved', 4 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLApproverID varchar(22) NULLNotes varchar(454) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryApproved'

Primary Key Name Field NamePK_HistoryApproved handle

Foreign keys for table 'dbo.HistoryApproved', 1 item

Foreign PrimaryHistoryApproved.handle History.handle

Indexes for table 'dbo.HistoryApproved', 1 item

Index Name Clustered Unique FieldsPK_HistoryApproved Yes Yes handle

Dependencies for table 'dbo.HistoryApproved', 1 item

Object Name Typedbo.CK_HistoryApproved_Flags_Unsigned check cns

Table: 'dbo.HistoryConversionError', 5 fields

Field Name Type and Size Default Nullable DescriptionConvType varchar(64) NULLError1 bigint NULLError2 bigint NULLErrorMsg varchar(384) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryConversionError'

Primary Key Name Field NamePK_HistoryConversionError handle

Foreign keys for table 'dbo.HistoryConversionError', 1 item

Foreign PrimaryHistoryConversionError.handle History.handle

Indexes for table 'dbo.HistoryConversionError', 1 item

Index Name Clustered Unique FieldsPK_HistoryConversionError

Yes Yes handle

Dependencies for table 'dbo.HistoryConversionError', 2 items

Object Name Typedbo.CK_HistoryConversionError_Error1_Unsigned check cnsdbo.CK_HistoryConversionError_Error2_Unsigned check cns

Table: 'dbo.HistoryDisapproved', 4 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLApproverID varchar(22) NULLNotes varchar(454) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryDisapproved'

Primary Key Name Field NamePK_HistoryDisapproved handle

Foreign keys for table 'dbo.HistoryDisapproved', 1 item

Foreign PrimaryHistoryDisapproved.handle History.handle

Indexes for table 'dbo.HistoryDisapproved', 1 item

Index Name Clustered Unique FieldsPK_HistoryDisapproved Yes Yes handle

Dependencies for table 'dbo.HistoryDisapproved', 1 item

Object Name Typedbo.CK_HistoryDisapproved_Flags_Unsigned check cns

Table: 'dbo.HistoryFileRouted', 4 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLError bigint NULLRoutePath varchar(256) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryFileRouted'

Primary Key Name Field NamePK_HistoryFileRouted handle

Foreign keys for table 'dbo.HistoryFileRouted', 1 item

Foreign PrimaryHistoryFileRouted.handle History.handle

Indexes for table 'dbo.HistoryFileRouted', 1 item

Index Name Clustered Unique FieldsPK_HistoryFileRouted Yes Yes handle

Dependencies for table 'dbo.HistoryFileRouted', 2 items

Object Name Typedbo.CK_HistoryFileRouted_Error_Unsigned check cnsdbo.CK_HistoryFileRouted_Flags_Unsigned check cns

Table: 'dbo.HistoryGeneric', 18 fields

Field Name Type and Size Default Nullable DescriptionGenType bigint NULLUserID varchar(22) NULLErrCode bigint NULL

Number1 bigint NULLNumber2 bigint NULLNumber3 bigint NULLNumber4 bigint NULLNumber5 bigint NULLNumber6 bigint NULLNumber7 bigint NULLNumber8 bigint NULLString1 varchar(32) NULLString2 varchar(32) NULLString3 varchar(32) NULLString4 varchar(32) NULLString5 varchar(32) NULLString6 varchar(32) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryGeneric'

Primary Key Name Field NamePK_HistoryGeneric handle

Foreign keys for table 'dbo.HistoryGeneric', 1 item

Foreign PrimaryHistoryGeneric.handle History.handle

Indexes for table 'dbo.HistoryGeneric', 1 item

Index Name Clustered Unique FieldsPK_HistoryGeneric Yes Yes handle

Table: 'dbo.HistoryInterConnect', 5 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLFromServer varchar(256) NULLMsg varchar(128) NULLhandle int NOT NULLError bigint NULL

Primary key for table 'dbo.HistoryInterConnect'

Primary Key Name Field NamePK_HistoryInterConnect handle

Foreign keys for table 'dbo.HistoryInterConnect', 1 item

Foreign PrimaryHistoryInterConnect.handle History.handle

Indexes for table 'dbo.HistoryInterConnect', 1 item

Index Name Clustered Unique FieldsPK_HistoryInterConnect Yes Yes handle

Dependencies for table 'dbo.HistoryInterConnect', 1 item

Object Name Typedbo.CK_HistoryInterConnect_Flags_Unsigned check cns

Table: 'dbo.HistoryLoc', 5 fields

Field Name Type and Size Default Nullable DescriptionGenType bigint NOT NULLLangID int NOT NULLShortMsg varchar(32) NULLDetailMsg varchar(144) NULLhandle int identity NOT NULL

Primary key for table 'dbo.HistoryLoc'

Primary Key Name Field NamePK_HistoryLoc handle

Indexes for table 'dbo.HistoryLoc', 1 item

Index Name Clustered Unique FieldsPK_HistoryLoc Yes Yes handle

Table: 'dbo.HistoryNetForward', 5 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLPrevOwnerID varchar(22) NULLUsersForwardedTo varchar(128) NULLNotes varchar(128) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryNetForward'

Primary Key Name Field NamePK_HistoryNetForward handle

Foreign keys for table 'dbo.HistoryNetForward', 1 item

Foreign PrimaryHistoryNetForward.handle History.handle

Indexes for table 'dbo.HistoryNetForward', 1 item

Index Name Clustered Unique FieldsPK_HistoryNetForward Yes Yes handle

Dependencies for table 'dbo.HistoryNetForward', 1 item

Object Name Typedbo.CK_HistoryNetForward_Flags_Unsigned check cns

Table: 'dbo.HistoryOCR', 4 fields

Field Name Type and Size Default Nullable DescriptionTimeToOCR int NULLError1 bigint NULLMsg varchar(128) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryOCR'

Primary Key Name Field NamePK_HistoryOCR handle

Foreign keys for table 'dbo.HistoryOCR', 1 item

Foreign PrimaryHistoryOCR.handle History.handle

Indexes for table 'dbo.HistoryOCR', 1 item

Index Name Clustered Unique FieldsPK_HistoryOCR Yes Yes handle

Dependencies for table 'dbo.HistoryOCR', 1 item

Object Name Typedbo.CK_HistoryOCR_Error1_Unsigned check cns

Table: 'dbo.HistoryPrint', 9 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NOT NULLTimeToPrint int NULLError1 bigint NULLError2 bigint NULLPagesPrinted int NULLCopiesPrinted int NULLNetPrintID varchar(10) NULLMsg varchar(128) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryPrint'

Primary Key Name Field NamePK_HistoryPrint handle

Foreign keys for table 'dbo.HistoryPrint', 1 item

Foreign PrimaryHistoryPrint.handle History.handle

Indexes for table 'dbo.HistoryPrint', 1 item

Index Name Clustered Unique FieldsPK_HistoryPrint Yes Yes handle

Dependencies for table 'dbo.HistoryPrint', 5 items

Object Name Typedbo.CK_HistoryPrint_CopiesPrinted_Unsigned check cnsdbo.CK_HistoryPrint_Error1_Unsigned check cnsdbo.CK_HistoryPrint_Error2_Unsigned check cnsdbo.CK_HistoryPrint_Flags_Unsigned check cnsdbo.CK_HistoryPrint_PagesPrinted_Unsigned check cns

Table: 'dbo.HistoryRoute', 4 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLPrevOwnerID varchar(22) NULLNotes varchar(454) NULLhandle int NOT NULL

Primary key for table 'dbo.HistoryRoute'

Primary Key Name Field Name

PK_HistoryRoute handle

Foreign keys for table 'dbo.HistoryRoute', 1 item

Foreign PrimaryHistoryRoute.handle History.handle

Indexes for table 'dbo.HistoryRoute', 1 item

Index Name Clustered Unique FieldsPK_HistoryRoute Yes Yes handle

Dependencies for table 'dbo.HistoryRoute', 1 item

Object Name Typedbo.CK_HistoryRoute_Flags_Unsigned check cns

Table: 'dbo.HistorySecureDocs', 9 fields

Field Name Type and Size Default Nullable DescriptionFlags bigint NULLSMTPSender varchar(64) NULLSMTPHost varchar(64) NULLRemoteIP varchar(32) NULLUserAgent varchar(64) NULLCurrentStatus varchar(32) NULLTermStat int NULLExtendStatus varchar(202) NULLhandle int NOT NULL

Primary key for table 'dbo.HistorySecureDocs'

Primary Key Name Field NamePK_HistorySecureDocs handle

Foreign keys for table 'dbo.HistorySecureDocs', 1 item

Foreign PrimaryHistorySecureDocs.handle History.handle

Indexes for table 'dbo.HistorySecureDocs', 1 item

Index Name Clustered Unique FieldsPK_HistorySecureDocs Yes Yes handle

Dependencies for table 'dbo.HistorySecureDocs', 2 items

Object Name Typedbo.CK_HistorySecureDocs_Flags_Unsigned check cnsdbo.CK_HistorySecureDocs_TermStat_Unsigned check cns

Table: 'dbo.HistoryTRX', 24 fields

Field Name Type and Size Default Nullable DescriptionElapsedTime int NULLHangupStatus smallint NULLBadPageCount int NULLChannelUsed int NULLDisposition int NULLTermStat int NULLRemoteID varchar(22) NULL

BoardType int NULLGoodPageCount int NULLCXMessageID varchar(32) NULLFaxNumber varchar(32) NULLMsgFromTransport varchar(96) NULLRemoteServer varchar(48) NULLANI varchar(32) NULLAOCData binary(3) NULLISDNCauseVal int NULLReserved smallint NULLFlags int NULLGammaErr int NULLBTCallResult_Status smallint NULLBTCallResult_LineStatus

smallint NULL

BTFaxResult_Status smallint NULLBTFaxResult_LineStatus

smallint NULL

handle int NOT NULL

Primary key for table 'dbo.HistoryTRX'

Primary Key Name Field NamePK_HistoryTRX handle

Foreign keys for table 'dbo.HistoryTRX', 1 item

Foreign PrimaryHistoryTRX.handle History.handle

Indexes for table 'dbo.HistoryTRX', 1 item

Index Name Clustered Unique FieldsPK_HistoryTRX Yes Yes handle

Dependencies for table 'dbo.HistoryTRX', 13 items

Object Name Typedbo.CK_HistoryTRX_BadPageCount_Unsigned check cnsdbo.CK_HistoryTRX_BoardType_Unsigned check cnsdbo.CK_HistoryTRX_ChannelUsed_Unsigned check cnsdbo.CK_HistoryTRX_Disposition_Unsigned check cnsdbo.CK_HistoryTRX_ElapsedTime_Unsigned check cnsdbo.CK_HistoryTRX_Flags_Unsigned check cnsdbo.CK_HistoryTRX_GammaErr_Unsigned check cnsdbo.CK_HistoryTRX_GoodPageCount_Unsigned check cnsdbo.CK_HistoryTRX_HangupStatus_Unsigned check cnsdbo.CK_HistoryTRX_ISDNCauseVal_Unsigned check cnsdbo.CK_HistoryTRX_TermStat_Unsigned check cnsdbo.fnDocumentCountMatchingAniRecords scalar functiondbo.fnViewDocTransactions table function

Table: 'dbo.LibraryDocuments', 18 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLObjectID varchar(22) NULLFilename varchar(14) NULLDescription varchar(36) NULLNumPages int NULLTimesRequestedFOD bigint NULLTimesUsedLAN bigint NULL

EmbargoDate datetime NULLExpireDate datetime NULLParentFolder bigint NULLFolderID bigint NULLTimesRequestedWEB bigint NULLLastUsed datetime NULLFodPassword varchar(63) NULLreserved varchar(1000) NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.LibraryDocuments'

Primary Key Name Field NamePK_LibraryDocuments handle

Indexes for table 'dbo.LibraryDocuments', 5 items

Index Name Clustered Unique FieldsPK_LibraryDocuments Yes Yes handleIX_LibraryDocuments_ObjectID

No Yes ObjectID, ServerGUID

IX_LibraryDocuments No No ObjectIDIX_LibraryDocuments_ServerGUID

No No ServerGUID

Dependencies for table 'dbo.LibraryDocuments', 9 items

Object Name Typedbo.CK_LibraryDocuments_Flags_Unsigned check cnsdbo.CK_LibraryDocuments_FolderID_Unsigned check cnsdbo.CK_LibraryDocuments_NumPages_Unsigned check cnsdbo.CK_LibraryDocuments_ParentFolder_Unsigned check cnsdbo.CK_LibraryDocuments_TimesRequestedFOD_Unsigned check cnsdbo.CK_LibraryDocuments_TimesRequestedWEB_Unsigned check cnsdbo.CK_LibraryDocuments_TimesUsedLAN_Unsigned check cnsdbo.fnGenerateObjectCounts table functiondbo.InsertBaseServerSpecificData stored procedure

Table: 'dbo.Locks', 8 fields

Field Name Type and Size Default Nullable DescriptionServerGUID uniqueidentifier NOT NULLUserID varchar(22) NOT NULLModule varchar(128) NOT NULLBlockReads bit NOT NULLBlockWrites bit NOT NULLFSRecognized bit NOT NULLFDRecognized bit NOT NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Locks'

Primary Key Name Field NamePK_Locks ServerGUID

Indexes for table 'dbo.Locks', 1 item

Index Name Clustered Unique FieldsPK_Locks Yes Yes ServerGUID

Table: 'dbo.NewDocAttachments', 12 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLNewDocHandle int NOT NULLDir varchar(260) NULL The RightFax dir

(e.g., outgoing)containing FileName. Null indicatesFileName is a fullpath.

FileName varchar(260) NOT NULL Source file name ofthis attachment.

Password varchar(256) NULL Password forcreating or openingencrypted documents

Native bit NULL Indicates whetherthis document is tobe attached in itsnative form.

NativeFileName varchar(260) NULL If Native, name offile when intransport.

AltBody bit NULL Indicates whetherthis document is tobe an alternate body(e-mail and Nativeonly).

DeleteSource bit NOT NULL Indicates whether todelete the sourcefile afterprocessing

Lib bit NULL Indicates thisattachment is aRightFax LibraryDocument

Usage varchar(50) NULL Indicates how thislib document isbeing used (e.g.,Web =WebClient/Util, FOD= Fax On Demand, LAN= Win32 Client)

ObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.NewDocAttachments'

Primary Key Name Field NamePK_NewDocAttachments handle

Foreign keys for table 'dbo.NewDocAttachments', 1 item

Foreign PrimaryNewDocAttachments.NewDocHandle NewDocs.handle

Indexes for table 'dbo.NewDocAttachments', 1 item

Index Name Clustered Unique FieldsPK_NewDocAttachments Yes Yes handle

Dependencies for table 'dbo.NewDocAttachments', 2 items

Object Name Typedbo.fnGenerateDocumentCounts table function

dbo.fnGetAttachmentCountForDoc scalar function

Table: 'dbo.NewDocRecipients', 35 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLNewDocHandle int NOT NULLType varchar(50) NOT NULL Recipient Type

(e.g., Fax, SMS, E-mail)

BillInfo1 varchar(16) NULL Accounting code #1BillInfo2 varchar(16) NULL Accounting code #2DelaySendUntil datetime NULL Null if ASAP, else

time fax should besent (delay send)(GMT0)

FromName varchar(60) NULL Source nameFromDestination varchar(256) NULL From address

(destination forresponse)

FromPhoneNum varchar(32) NULL Source voice numberToDestination varchar(256) NULL Destination addressToAltDestination varchar(256) NULL Alternate

destination addressToCityState varchar(60) NULL Destination location

nameToCompany varchar(60) NULL Destination voice

numberToContactNum varchar(32) NULL Destination company

nameToName varchar(60) NULL Destination nameSecureCSID varchar(22) NULL Null if secure

sending is notenabled

Priority tinyint NULL Fax job prioritylevel - seePRIORITY_* inrfapi.h

JobID varchar(16) NULL Unique user orsystem provided idfor fax job

CompletionEvent bit NULL Null = use default,0 = No completeevent, 1 = firecomplete event

CoverSheet bit NULL Null = use default,0 = No cover sheet,1 = cover sheet

AutoDeleteSuccess bit NULL Null = use default,0 = no delete onsuccess, 1 = deleteon sucess

AutoDeleteFailure bit NULL Null = use default,0 = no delete onfailure, 1 = deleteon failure(currently, if thisis set to 1,AutoDeleteSuccessmust also be 1)

RecipientNotifyType varchar(50) NULL Type of recipientnotification to use(e.g., SMS) or NULLif none

RecipientNotifyDestination

varchar(256) NULL Recipientnotificationdestination address

PreferredContentType varchar(50) NULL Type of file weprefer to send(e.g., G3, TXT, PDF)

OwnerPassword varchar(256) NULL Owner password fordocument body(Secure PDF only)

UserPassword varchar(256) NULL User password fordocument body(Secure PDF only)

PermAllowPrinting bit NULL Allow printing ofdocument body(Secure PDF only)

PermAllowModification

bit NULL Allow modificationdocument body(Secure PDF only)

PermAllowExtraction bit NULL Allowcopying/extractionof document body(Secure PDF only)

PermAllowAnnotation bit NULL Allow annotation ofdocument body(Secure PDF only)

PermAllowSaveAs bit NULL Allow document body(Secure PDF only) tobe saved as anotherfile name

CC bit NULL Indicates therecipient is a CCrecipient (arecipient receivinga Carbon Copy)

Certified bit NULL Indicates use ofCertified Delivery(applies to Type ="Email" only)


Primary key for table 'dbo.NewDocRecipients'

Primary Key Name Field NamePK_NewDocRecipients handle

Foreign keys for table 'dbo.NewDocRecipients', 1 item

Foreign PrimaryNewDocRecipients.NewDocHandle NewDocs.handle

Indexes for table 'dbo.NewDocRecipients', 1 item

Index Name Clustered Unique FieldsPK_NewDocRecipients Yes Yes handle

Dependencies for table 'dbo.NewDocRecipients', 2 items

Object Name Typedbo.fnGenerateDocumentCounts table functiondbo.fnGetRecipientCountForDoc scalar function

Table: 'dbo.NewDocs', 23 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLUserHandle int NOT NULL Owner from Users

table.DocumentHandle int NULL Referenced Document

(see Forward)Ready bit NULL Set when NewDoc and

related data areready. Documentwill not be createduntil this is set.

Notes varchar(1470) NULL Note text for FCS orSMS content.

Subject varchar(512) NULL Subject text.BodyCoverPDF bit NULL Requests a PDF of

the body and/orcover

NotesTXT bit NULL Requests a TXT ofthe notes

HoldForPreview bit NULL Requests thedocument be held forpreview beforesending

FineBody bit NULL Indicates to use200x200 dpi for theG3 body (normal is200x100)

FineCover bit NULL Indicates to use200x200 dpi for theG3 cover sheet(normal is 200x100)

SmartResume bit NULL Set when the faxshould use partial-retries

Forward bit NULL Indicates that thisdocument is to be aforward of thedocument referred toby DocumentHandle

FolderIndex int NULL Index of the user'sfolder where thisdocument will reside(0 is Main)

CreationTime datetime NULL The time thisdocument was created

CoverTemplate varchar(260) NULL Name of the coversheet template touse. Null indicatesuse user/systemdefault.

Comment varchar(70) NULL Comment for owner'sconvenience--thisvalue is nottransmitted

ServerGUID uniqueidentifier NULL Identifies theserver this documentis to processed by

FromOperatorNum varchar(32) NULL Source generic voicenumber

FromGeneralFaxNum varchar(50) NULL Source generic faxnumber


FormID varchar(16) NULL The ID or Code ofthe Form to overlayon the new document. Null or emptystring for none.

NeedsApproval bit NULL Indicates that thedocument requestrequires approval.

Primary key for table 'dbo.NewDocs'

Primary Key Name Field NamePK_NewDocs handle

Foreign keys for table 'dbo.NewDocs', 1 item

Foreign PrimaryNewDocs.UserHandle Users.handle

Indexes for table 'dbo.NewDocs', 1 item

Index Name Clustered Unique FieldsPK_NewDocs Yes Yes handle

Dependencies for table 'dbo.NewDocs', 2 items

Object Name Typedbo.fnGenerateDocumentCounts table functiondbo.fnGenerateObjectCounts table function

Table: 'dbo.Notes', 3 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLText varchar(1470) NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Notes'

Primary Key Name Field NamePK_Notes handle

Indexes for table 'dbo.Notes', 1 item

Index Name Clustered Unique FieldsPK_Notes Yes Yes handle

Dependencies for table 'dbo.Notes', 1 item

Object Name Typedbo.PurgeDocument stored procedure

Table: 'dbo.Printers', 13 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLNetPrintID varchar(10) NULLDescription varchar(48) NULLServerName varchar(48) NULLQueueName varchar(48) NULL

PrinterType smallint NULLSpooled smallint NULLNovellFormType smallint NULLDefSize smallint NULLDefSource smallint NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Printers'

Primary Key Name Field NamePK_Printers handle

Indexes for table 'dbo.Printers', 15 items

Index Name Clustered Unique FieldsPK_Printers Yes Yes handleIX_Printers_NetPrintID No Yes NetPrintIDIX_Printers_Load No No ServerGUID, handle,

Flags, NetPrintID,Description, ServerName,QueueName, PrinterType,Spooled, NovellFormType,DefSize, DefSource

IX_Printers_ServerGUID No No ServerGUID

Dependencies for table 'dbo.Printers', 2 items

Object Name Typedbo.CK_Printers_Flags_Unsigned check cnsdbo.fnGenerateObjectCounts table function

Table: 'dbo.RequestStatus', 7 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLItem int NULLStatus smallint NULLUserID varchar(22) NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.RequestStatus'

Primary Key Name Field NamePK_RequestStatus handle

Indexes for table 'dbo.RequestStatus', 1 item

Index Name Clustered Unique FieldsPK_RequestStatus Yes Yes handle

Dependencies for table 'dbo.RequestStatus', 2 items

Object Name Typedbo.CK_RequestStatus_Flags_Unsigned check cnsdbo.DeleteDocument stored procedure

Table: 'dbo.SecureDocsContacts', 6 fields

Field Name Type and Size Default Nullable DescriptionWM_UID numeric()

identity(18)NOT NULL

WM_EMail varchar(250) NOT NULLWM_Password varchar(250) NOT NULLWM_Date datetime NULLREMOTE_ADDR varchar(50) NULLAdmin tinyint NULL

Primary key for table 'dbo.SecureDocsContacts'

Primary Key Name Field NamePK_SecureDocsContacts WM_UID

Indexes for table 'dbo.SecureDocsContacts', 1 item

Index Name Clustered Unique FieldsPK_SecureDocsContacts No Yes WM_UID

Table: 'dbo.SecureDocsRecipients', 3 fields

Field Name Type and Size Default Nullable DescriptionHandle int NOT NULLRecipient varchar(255) NOT NULLTimeStmp datetime (getdate()) NOT NULL

Primary key for table 'dbo.SecureDocsRecipients'

Primary Key Name Field NamePK_SecureDocsRecipients Handle

Indexes for table 'dbo.SecureDocsRecipients', 3 items

Index Name Clustered Unique FieldsPK_SecureDocsRecipients No Yes HandleIX_SecureDocsRecipients Yes No TimeStmp, Recipient

Table: 'dbo.Signatures', 11 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLFlags bigint NULLSignID varchar(22) NULLSignOwner varchar(22) NULLSignFile varchar(14) NULLSignDesc varchar(36) NULLSignUsers_0 varchar(22) NULLSignUsers_1 varchar(22) NULLSignUsers_2 varchar(22) NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.Signatures'

Primary Key Name Field NamePK_Signatures handle

Indexes for table 'dbo.Signatures', 14 items

Index Name Clustered Unique FieldsPK_Signatures Yes Yes handle

IX_Signatures_SignID No Yes SignIDIX_Signatures_Load No No ServerGUID, handle,

Flags, SignID,SignOwner, SignFile,SignDesc, SignUsers_0,SignUsers_1, SignUsers_2

IX_Signatures_ServerGUID No No ServerGUIDIX_Signatures_SignOwner No No SignOwner

Dependencies for table 'dbo.Signatures', 2 items

Object Name Typedbo.CK_Signatures_Flags_Unsigned check cnsdbo.fnGenerateObjectCounts table function

Table: 'dbo.StatDescs', 8 fields, Descriptions for statistics createdby RightFax services

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULL Primary KeyModuleName varchar(128) NOT NULL Name of module

hosting statisticStatisticName varchar(128) NOT NULL Name of statisticIndexingFormat varchar(128) NULL Format for indexing

or null, if none.Expiration int NULL Expiration of values

in seconds or null,if never.

RequiresAdmin bit NOT NULL True to indicatethis statistic canonly be viewed byadministrators

MinValue varchar(50) NULL Minimum value thisstatistic isexpected to have ornull if none.

MaxValue varchar(50) NULL Maximum value thisstatistic isexpected to have ornull if none.

Primary key for table 'dbo.StatDescs'

Primary Key Name Field NamePK_StatDescs ID

Indexes for table 'dbo.StatDescs', 3 items

Index Name Clustered Unique FieldsPK_StatDescs Yes Yes IDIX_StatDescs No Yes ModuleName,

StatisticName

Table: 'dbo.StatLives', 6 fields

Field Name Type and Size Default Nullable DescriptionInstance uniqueidentifier NOT NULL Execution instance.ModuleName varchar(128) NOT NULL Name of the host

module whoselifetime is beingtracked.

ConfigurationInstance

varchar(50) NOT NULL Serviceconfigurationinstance (e.g., the1 in WorkSrv1).

FirstPulse datetime NOT NULL First pulsereceived.

LastPulse datetime NOT NULL Last pulse received.NextPulse datetime NOT NULL Next time the host

anticipated it wouldpulse.

Primary key for table 'dbo.StatLives'

Primary Key Name Field NamePK_StatLives Instance

Indexes for table 'dbo.StatLives', 3 items

Index Name Clustered Unique FieldsPK_StatLives Yes Yes InstanceIX_StatLives No Yes InstanceIX_StatLives_ModuleName No No ModuleName

Table: 'dbo.StatRangeValues', 4 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLStatDescsID int NOT NULL ID of item in

StatDescs table thisrange value is aninstance of

Indexer varchar(50) NOT NULL Specific statisticindex for rangevalues that areindex range valuesor null, if none

Data varchar(128) NOT NULL Value of this rangevalue

Primary key for table 'dbo.StatRangeValues'

Primary Key Name Field NamePK_StatRangeValues ID

Foreign keys for table 'dbo.StatRangeValues', 1 item

Foreign PrimaryStatRangeValues.StatDescsID StatDescs.ID

Indexes for table 'dbo.StatRangeValues', 4 items

Index Name Clustered Unique FieldsPK_StatRangeValues Yes Yes IDIX_StatRangeValues No Yes StatDescsID, Indexer,

Data

Table: 'dbo.StatValues', 6 fields, Values for statistics output byRightFax services

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULL

StatDescsID int NOT NULL ID of item inStatDescs table thisvalue is an instanceof

StatLivesInstance uniqueidentifier NOT NULLRecorded datetime NOT NULL Time this statistic

was recordedIndexer varchar(128) NOT NULL Specific statistic

index for statisticsthat are indexableor null, if none

Data varchar(128) NOT NULL Value of thisstatistic

Primary key for table 'dbo.StatValues'

Primary Key Name Field NamePK_StatValues ID

Foreign keys for table 'dbo.StatValues', 2 items

Foreign PrimaryStatValues.StatDescsID StatDescs.IDStatValues.StatLivesInstance StatLives.Instance

Indexes for table 'dbo.StatValues', 2 items

Index Name Clustered Unique FieldsPK_StatValues Yes Yes IDIX_StatValues No No Recorded

Dependencies for table 'dbo.StatValues', 1 item

Object Name Typedbo.GetStatistics stored procedure

Table: 'dbo.SystemMessages', 9 fields

Field Name Type and Size Default Nullable DescriptionSysMsgType int NULLSysMsgDBA int NULL Handle to the faxSysMsgUserID varchar(22) NULLhandle int identity NOT NULL Handle of object

this message refersto, if any

SysMsgInfo varchar(24) NULLSysMsgUL1 bigint NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULLDequeued bit ((0)) NOT NULL

Primary key for table 'dbo.SystemMessages'

Primary Key Name Field NamePK_SystemMessages handle

Indexes for table 'dbo.SystemMessages', 8 items

Index Name Clustered Unique FieldsPK_SystemMessages Yes Yes handle

IX_SystemMessages No No SysMsgDBA, SysMsgType,SysMsgUserID, handle,SysMsgInfo, SysMsgUL1,ServerGUID

Dependencies for table 'dbo.SystemMessages', 4 items

Object Name Typedbo.CK_SystemMessages_SysMsgType_Unsigned check cnsdbo.CK_SystemMessages_SysMsgUL1_Unsigned check cnsdbo.DeleteDocument stored proceduredbo.GetNextSystemMessage stored procedure

Table: 'dbo.TermStatToStatusCode', 3 fields

Field Name Type and Size Default Nullable Descriptionhandle int NOT NULLStatusCode int NULLDescription varchar(40) NULL

Primary key for table 'dbo.TermStatToStatusCode'

Primary Key Name Field NamePK_TermStatToStatusCode handle

Indexes for table 'dbo.TermStatToStatusCode', 1 item

Index Name Clustered Unique FieldsPK_TermStatToStatusCode Yes Yes handle

Table: 'dbo.TimeEvents', 7 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLEventDateTime datetime NULLTimedFRDBA int NULLConverting smallint NULLNumPages smallint NULLServerGUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.TimeEvents'

Primary Key Name Field NamePK_TimeEvents handle

Indexes for table 'dbo.TimeEvents', 3 items

Index Name Clustered Unique FieldsPK_TimeEvents Yes Yes handleIX_TimeEvents_EventDateTime

No No EventDateTime

IX_TimeEvents_TimedFRDBANo No TimedFRDBA

Table: 'dbo.UserFolders', 8 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwner int NULLFlags bigint NULLType bigint NULL

FolderName varchar(255) NULLID bigint NOT NULLParentID bigint NULLObjectGuid uniqueidentifier (newid()) NOT NULL

Primary key for table 'dbo.UserFolders'

Primary Key Name Field NamePK_UserFolders handle

Foreign keys for table 'dbo.UserFolders', 1 item

Foreign PrimaryUserFolders.Owner Users.handle

Indexes for table 'dbo.UserFolders', 7 items

Index Name Clustered Unique FieldsPK_UserFolders Yes Yes handleIX_UserFolders_FolderName_ParentID_Owner

No Yes FolderName, ParentID,Owner

IX_UserFolders_Owner_ID No Yes Owner, IDIX_UserFolders No No Owner

Dependencies for table 'dbo.UserFolders', 9 items

Object Name Typedbo.CK_UserFolders_Flags_Unsigned check cnsdbo.CK_UserFolders_ID_Unsigned check cnsdbo.CK_UserFolders_ParentID_Unsigned check cnsdbo.CK_UserFolders_Type_Unsigned check cnsdbo.fnGetChildrenOfFolder inline functiondbo.fnGetChildrenOfFolder2 table functiondbo.fnGetFolderFromID table functiondbo.fnGetFolderNameFromID scalar functiondbo.InsertBaseRecords stored procedure

Table: 'dbo.UserPagerNotify', 10 fields

Field Name Type and Size Default Nullable DescriptionID int identity NOT NULLOwner int NOT NULLFlags bigint NULLType bigint NOT NULLPagerID varchar(64) NULLServiceName varchar(22) NULLTypes1 bigint NULLTypes2 bigint NULLCSIDList varchar(256) NULLObjectGuid uniqueidentifier (newid()) NULL

Primary key for table 'dbo.UserPagerNotify'

Primary Key Name Field NamePK_UserPagerNotify ID

Foreign keys for table 'dbo.UserPagerNotify', 1 item

Foreign PrimaryUserPagerNotify.Owner Users.handle

Indexes for table 'dbo.UserPagerNotify', 1 item

Index Name Clustered Unique FieldsPK_UserPagerNotify Yes Yes ID

Dependencies for table 'dbo.UserPagerNotify', 4 items

Object Name Typedbo.CK_UserPagerNotify_Flags_Unsigned check cnsdbo.CK_UserPagerNotify_Type_Unsigned check cnsdbo.CK_UserPagerNotify_Types1_Unsigned check cnsdbo.CK_UserPagerNotify_Types2_Unsigned check cns

Table: 'dbo.UserRouteType', 3 fields

Field Name Type and Size Default Nullable Descriptionhandle int NOT NULLRouteType varchar(10) NULLRouteTypeDescription varchar(30) NULL

Primary key for table 'dbo.UserRouteType'

Primary Key Name Field NamePK_UserRouteType handle

Indexes for table 'dbo.UserRouteType', 1 item

Index Name Clustered Unique FieldsPK_UserRouteType Yes Yes handle

Table: 'dbo.Users', 84 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLGroupID int NULLUserFlags bigint NULLUserID varchar(22) NULLUserName varchar(29) NULLPassword varchar(34) NULLUserDIDNumber bigint NULLFCSModelName varchar(14) NULLNotifyType int NULLSTDIDNum varchar(32) NULLSTGenFaxNum varchar(32) NULLSTCallback smallint NULLSTOperNum varchar(32) NULLSTFromName varchar(60) NULLSTFromPhone varchar(32) NULLSTToFaxNum varchar(32) NULLSTToContactNum varchar(32) NULLSTToName varchar(60) NULLSTToCompany varchar(60) NULLSTToCityState varchar(60) NULLAutoPrintNetPrintID varchar(10) NULLDefaultPrinter varchar(10) NULLWebImageFormat smallint NULLLastUpgradedFolderID smallint NULLAutoSentPrinter varchar(10) NULLAutoPrintFlags int NULLSubscriberID bigint NULLUserFlags2 bigint NULLHighestPriority smallint NULLDefaultPriority smallint NULLNewDocNotifyUser varchar(22) NULL

RouteType smallint NULLRouteFmt smallint NULLAFPhone varchar(32) NULLSendNotify int NULLReceiveNotify int NULLUpdateInterval int NULLAutoDelete int NULLDefaultViewScale int NULLAutoOCRFlags int NULLAutoOCRLayout smallint NULLAutoOCRFormat smallint NULLAutoOCRExt varchar(4) NULLAFUser smallint NULLRouteDeleteAfter smallint NULLChangeTag bigint NULLRouteInfo varchar(100) NULLNWDSName varchar(80) NULLFolders varchar(256) NULLOtherPBID_0 varchar(22) NULLOtherPBID_1 varchar(22) NULLOtherPBID_2 varchar(22) NULLOtherPBID_3 varchar(22) NULLOtherPBPass_0 varchar(34) NULLOtherPBPass_1 varchar(34) NULLOtherPBPass_2 varchar(34) NULLOtherPBPass_3 varchar(34) NULLRPOStartPage smallint NULLRPOEndPage smallint NULLRPOFlags smallint NULLRPORes smallint NULLRPOSize smallint NULLRPOSource smallint NULLRPOOutputBin smallint NULLRPODuplex smallint NULLRPOSecurityCode int NULLRPOCopies smallint NULLEmailRouteForm smallint NULLRPOAcctCode binary(8) NULLRPOPriority smallint NULLRPOOther smallint NULLDefaultBI1 varchar(16) NULLDefaultBI2 varchar(16) NULLSID varchar(88) NULLEmailAddr varchar(256) NULLSMSServiceID varchar(22) NULLMobileAddr varchar(32) NULLNotifyInfo varchar(100) NULLObjectGuid uniqueidentifier (newid()) NULLUsnCreated bigint ((0)) NULLUsnUpdated bigint ((0)) NULLSyncGuid varchar(128) NULLSyncSource varchar(32) NULLSyncUSN bigint NULL

Primary key for table 'dbo.Users'

Primary Key Name Field NamePK_Users handle

Foreign keys for table 'dbo.Users', 1 item

Foreign PrimaryUsers.GroupID Groups.handle

Indexes for table 'dbo.Users', 10 items

Index Name Clustered Unique FieldsPK_Users Yes Yes handleIX_Users_UserID No Yes UserIDIX_Users_GroupID No No GroupIDIX_Users_NotifyInfo No No NotifyInfoIX_Users_NWDSName No No NWDSNameIX_Users_RouteInfo No No RouteInfoIX_Users_SID No No SIDIX_Users_SMSServiceID No No SMSServiceIDIX_Users_SuberscriberID No No SubscriberIDIX_Users_UserDIDNumber No No UserDIDNumber

Triggers for table 'dbo.Users', 2 items

Name Type EnabledOnInsertUsersUsn after INSERT YesOnUpdateUsersUsn after UPDATE Yes

Dependencies for table 'dbo.Users', 57 items

Object Name Typedbo.CK_Users_AFUser_Unsigned check cnsdbo.CK_Users_AutoDelete_Unsigned check cnsdbo.CK_Users_AutoOCRFlags_Unsigned check cnsdbo.CK_Users_AutoOCRFormat_Unsigned check cnsdbo.CK_Users_AutoOCRLayout_Unsigned check cnsdbo.CK_Users_AutoPrintFlags_Unsigned check cnsdbo.CK_Users_ChangeTag_Unsigned check cnsdbo.CK_Users_DefaultPriority_Unsigned check cnsdbo.CK_Users_DefaultViewScale_Unsigned check cnsdbo.CK_Users_EmailRouteForm_Unsigned check cnsdbo.CK_Users_HighestPriority_Unsigned check cnsdbo.CK_Users_LastUpgradedFolderID_Unsigned check cnsdbo.CK_Users_NotifyType_Unsigned check cnsdbo.CK_Users_ReceiveNotify_Unsigned check cnsdbo.CK_Users_RouteDeleteAfter_Unsigned check cnsdbo.CK_Users_RouteFmt_Unsigned check cnsdbo.CK_Users_RouteType_Unsigned check cnsdbo.CK_Users_RPOCopies_Unsigned check cnsdbo.CK_Users_RPODuplex_Unsigned check cnsdbo.CK_Users_RPOFlags_Unsigned check cnsdbo.CK_Users_RPOOther_Unsigned check cnsdbo.CK_Users_RPOOutputBin_Unsigned check cnsdbo.CK_Users_RPOPriority_Unsigned check cnsdbo.CK_Users_RPORes_Unsigned check cnsdbo.CK_Users_RPOSecurityCode_Unsigned check cnsdbo.CK_Users_RPOSize_Unsigned check cnsdbo.CK_Users_RPOSource_Unsigned check cnsdbo.CK_Users_SendNotify_Unsigned check cnsdbo.CK_Users_SubscriberID_Unsigned check cnsdbo.CK_Users_UpdateInterval_Unsigned check cnsdbo.CK_Users_UserDIDNumber_Unsigned check cnsdbo.CK_Users_UserFlags_Unsigned check cnsdbo.CK_Users_UserFlags2_Unsigned check cnsdbo.CK_Users_WebImageFormat_Unsigned check cnsdbo.fnDelegatorsFromID inline functiondbo.fnGenerateGroupContents table functiondbo.fnGenerateObjectCounts table functiondbo.fnGetAgedDocuments inline functiondbo.fnGetGroupIDFromUserHandle scalar functiondbo.fnGetUserCountForGroup scalar function

dbo.fnGroupMembers inline functiondbo.fnGroupMembersFromID inline functiondbo.fnIsAdmin scalar functiondbo.fnUserHandleFromID scalar functiondbo.fnUserIDFromHandle scalar functiondbo.fnUserNameFromHandle scalar functiondbo.fnViewDocTransactions table functiondbo.fnViewDocuments table functiondbo.fnViewUserSettings table functiondbo.GroupsFull viewdbo.InsertBaseRecords stored proceduredbo.OnInsertUsersUsn triggerdbo.OnUpdateDocumentsUsn triggerdbo.OnUpdateUsersUsn triggerdbo.RFView_UserPhoneEntries viewdbo.RFView_UserPhoneGroups viewdbo.UsersFull view

Table: 'dbo.UserViews', 23 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLOwner int NULLID bigint NOT NULLViewName varchar(255) NULLComment varchar(255) NULLAndFlags bigint NULLAndNotFlags bigint NULLOrFlags bigint NULLOrNotFlags bigint NULLAndFlags2 bigint NULLAndNotFlags2 bigint NULLOrFlags2 bigint NULLOrNotFlags2 bigint NULLStartTime datetime NULLEndTime datetime NULLStatusList varchar(255) NULLStatusNotList varchar(255) NULLDocTypes int NULLUserIDList varchar(255) NULLGroupIDList varchar(255) NULLGeneralList varchar(500) NULLAniMatch varchar(32) NULLObjectGuid uniqueidentifier (newid()) NOT NULL

Primary key for table 'dbo.UserViews'

Primary Key Name Field NamePK_UserViews handle

Foreign keys for table 'dbo.UserViews', 1 item

Foreign PrimaryUserViews.Owner Users.handle

Indexes for table 'dbo.UserViews', 5 items

Index Name Clustered Unique FieldsPK_UserViews Yes Yes handleIX_UserViews_Owner_ID No Yes Owner, IDIX_UserViews_ViewName_Owner

No Yes ViewName, Owner

Dependencies for table 'dbo.UserViews', 11 items

Object Name Typedbo.CK_UserViews_AndFlags_Unsigned check cnsdbo.CK_UserViews_AndFlags2_Unsigned check cnsdbo.CK_UserViews_AndNotFlags_Unsigned check cnsdbo.CK_UserViews_AndNotFlags2_Unsigned check cnsdbo.CK_UserViews_ID_Unsigned check cnsdbo.CK_UserViews_OrFlags_Unsigned check cnsdbo.CK_UserViews_OrFlags2_Unsigned check cnsdbo.CK_UserViews_OrNotFlags_Unsigned check cnsdbo.CK_UserViews_OrNotFlags2_Unsigned check cnsdbo.fnGetUserViewFromID table functiondbo.fnGetUserViews inline function

Table: 'dbo.WorkRequests', 94 fields

Field Name Type and Size Default Nullable Descriptionhandle int identity NOT NULLBaseFlags bigint NOT NULLBaseRequestType bigint NULLhOwner int NOT NULLBaseRequestTime datetime NULLBaseRequestKey1 varchar(10) NULLBaseRecType bigint NULLServerGUID uniqueidentifier NULLSourceDir varchar(128) NULLOutputDir varchar(128) NULLOutputFile varchar(14) NULLFineMode bit NULLCoverSheet bit NULLUserID varchar(22) NULLFormNum smallint NULLMergeOpts smallint NULLFormHeight smallint NULLPrint_PrinterID varchar(10) NULLPrint_StartPage smallint NULLPrint_EndPage smallint NULLPrint_PrintCover smallint NULLPrint_Flags smallint NULLPrint_Res tinyint NULLPrint_Size tinyint NULLPrint_Source tinyint NULLPrint_DeleteDoc bit NULLPrint_UserID varchar(22) NULLPrint_ZeroByte smallint NULLPrint_OutputBin smallint NULLPrint_JobType smallint NULLPrint_Priority smallint NULLPrint_AcctCode binary(8) NULLPrint_SecurityCode int NULLPrint_Duplex smallint NULLPrint_Copies smallint NULLDeleteDoc bit NULLMsgType smallint NULLMsgText varchar(200) NULLNetwork varchar(20) NULLPostOffice varchar(20) NULLFileFormat int NULLOCRError smallint NULLGenMailType smallint NULLEmailRouteForm smallint NULLMailAddrCont varchar(52) NULL

MailAddr varchar(100) NULLToName varchar(60) NULLDestination varchar(32) NULLFilePath varchar(72) NULLNotifyType int NULLNotifyChannel int NULLProdDoc bit NULLBillInfo1 varchar(16) NULLBillInfo2 varchar(16) NULLPhoneNum varchar(32) NULLOCRFlags smallint NULLStartpage smallint NULLEndpage smallint NULLLayout smallint NULLFormat smallint NULLOutputName varchar(14) NULLLogicalSourceDir_0 smallint NULLLogicalSourceDir_1 smallint NULLLogicalSourceDir_2 smallint NULLLogicalSourceDir_3 smallint NULLLogicalSourceDir_4 smallint NULLLogicalSourceDir_5 smallint NULLLogicalSourceDir_6 smallint NULLLogicalSourceDir_7 smallint NULLLogicalSourceDir_8 smallint NULLLogicalSourceDir_9 smallint NULLLogicalSourceDir_10 smallint NULLLogicalSourceDir_11 smallint NULLSourceFile_0 varchar(14) NULLSourceFile_1 varchar(14) NULLSourceFile_2 varchar(14) NULLSourceFile_3 varchar(14) NULLSourceFile_4 varchar(14) NULLSourceFile_5 varchar(14) NULLSourceFile_6 varchar(14) NULLSourceFile_7 varchar(14) NULLSourceFile_8 varchar(14) NULLSourceFile_9 varchar(14) NULLSourceFile_10 varchar(14) NULLSourceFile_11 varchar(14) NULLAltAddress varchar(100) NULLRetryCount smallint NULLWhenToTry bigint NULLReplyType int NULLMessageID varchar(16) NULLNextUserID varchar(22) NULLUID uniqueidentifier NULLObjectGuid uniqueidentifier (newid()) NULLArchiveFax smallint NULL

Primary key for table 'dbo.WorkRequests'

Primary Key Name Field NamePK_WorkRequests handle

Indexes for table 'dbo.WorkRequests', 2 items

Index Name Clustered Unique FieldsPK_WorkRequests Yes Yes handleIX_WorkRequests_BaseRequestTime

No No BaseRequestTime

Dependencies for table 'dbo.WorkRequests', 24 items

Object Name Typedbo.CK_WorkRequests check cnsdbo.CK_WorkRequests_BaseFlags_Unsigned check cnsdbo.CK_WorkRequests_BaseRecType_Unsigned check cnsdbo.CK_WorkRequests_BaseRequestType_Unsigned check cnsdbo.CK_WorkRequests_EmailRouteForm_Unsigned check cnsdbo.CK_WorkRequests_FileFormat_Unsigned check cnsdbo.CK_WorkRequests_GenMailType_Unsigned check cnsdbo.CK_WorkRequests_NotifyChannel_Unsigned check cnsdbo.CK_WorkRequests_NotifyType_Unsigned check cnsdbo.CK_WorkRequests_Print_Copies_Unsigned check cnsdbo.CK_WorkRequests_Print_Duplex_Unsigned check cnsdbo.CK_WorkRequests_Print_Flags_Unsigned check cnsdbo.CK_WorkRequests_Print_JobType_Unsigned check cnsdbo.CK_WorkRequests_Print_OutputBin_Unsigned check cnsdbo.CK_WorkRequests_Print_PrintCover_Unsigned check cnsdbo.CK_WorkRequests_Print_Priority_Unsigned check cnsdbo.CK_WorkRequests_Print_SecurityCode_Unsigned check cnsdbo.CK_WorkRequests_Print_ZeroByte_Unsigned check cnsdbo.CK_WorkRequests_ReplyType_Unsigned check cnsdbo.CK_WorkRequests_WhenToTry_Unsigned check cnsdbo.DeleteDocument stored proceduredbo.fnGenerateObjectCounts table functiondbo.fnWorkRequestCounts table functiondbo.PurgeDocument stored procedure

Views, 15 items

View: '50 801 103 12 re."dbo.CurrentWorkRequestCounts"'

Field Name Type and Size

View: 'COLUMN."dbo.DocumentCounts"'


View: '463 642 Td."dbo.DTActivityCounts"'


View: 'TABLE."dbo.EventsAll"'


View: 'S."dbo.EventsTotals"'


View: '51 438 Td."dbo.ExpandedContacts"'


View: 'COLUMN."dbo.GlobalizationUntranslated"'


View: '0 -6 Td."dbo.GroupsFull"'


View: 'dbo.ObjectCounts'

Field Name Type and SizeCountOf varchar(25) NULLServer varchar(40) NULLTotal int NULL

View: 'Indicates this attachment is a RightFax LibraryDocument."dbo.RFView_DocTransactions"'


View: '/F1 10 Tf."dbo.RFView_Documents"'


View: 'COLUMN."dbo.RFView_UserPhoneEntries"'


View: 'Lib."dbo.RFView_UserPhoneGroups"'


View: '0.000000 0.000000 0.000000 rg."dbo.RFView_UserSettings"'


View: '153 801 103 12 re."dbo.UsersFull"'
