RightFax Database Schema Report Tables, 64 items Table: 'dbo.AdminPagerNotify', 13 fields Field Name ID Owner Flags Type d_data PagerID ServiceName Types1 Types2 HeartBeatInterval QueueFaxDepth QueuePageDepth ObjectGuid

Type and Size int identity int bigint bigint smallint varchar(64) varchar(22) bigint bigint int bigint bigint uniqueidentifier

Default

Nullable NOT NULL NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.AdminPagerNotify' Primary Key Name PK_AdminPagerNotify

Field Name ID

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

Primary Users.handle

Indexes for table 'dbo.AdminPagerNotify', 1 item Index Name PK_AdminPagerNotify

Clustered Yes

Unique Yes

Fields ID

Dependencies for table 'dbo.AdminPagerNotify', 8 items Object Name dbo.CK_AdminPagerNotify_d_data_Unsigned dbo.CK_AdminPagerNotify_Flags_Unsigned dbo.CK_AdminPagerNotify_HeartBeatInterval_Unsigned dbo.CK_AdminPagerNotify_QueueFaxDepth_Unsigned dbo.CK_AdminPagerNotify_QueuePageDepth_Unsigned dbo.CK_AdminPagerNotify_Type_Unsigned dbo.CK_AdminPagerNotify_Types1_Unsigned dbo.CK_AdminPagerNotify_Types2_Unsigned

Type check cns check cns check cns check cns check cns check cns check cns check cns

Table: 'dbo.Audits', 7 fields Field Name ID Action

Type and Size int identity nvarchar(80)

Default

Nullable NOT NULL NULL

AuditedType

nvarchar(80)

NULL

CreationTime

datetime

NULL

Description The audit event type: Added, Modified, Deleted. The type of record audited. The time this audit event happened.

Creator

nvarchar(128)

NULL

AuditedValue

nvarchar(128)

NULL

ServerGUID

uniqueidentifier

NULL

The person generating this audit event. The value that was audited.

Table: 'dbo.BillingCodes', 6 fields Field Name handle Flags BillInfo1 BillInfo2 Description ObjectGuid

Type and Size int identity bigint varchar(16) varchar(16) varchar(120) uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.BillingCodes' Primary Key Name PK_BillingCodes

Field Name handle

Indexes for table 'dbo.BillingCodes', 6 items Index Name PK_BillingCodes IX_BillingCodes_BillInfo 1_BillInfo2 IX_BillingCodes_BillInfo 1 IX_BillingCodes_BillInfo 2 IX_BillingCodes_Descript ion

Clustered Yes No

Unique Yes Yes

Fields handle BillInfo1, BillInfo2

No

No

BillInfo1

No

No

BillInfo2

No

No

Description

Dependencies for table 'dbo.BillingCodes', 2 items Object Name dbo.CK_BillingCodes_Flags_Unsigned dbo.fnGenerateObjectCounts

Type check cns table function

Table: 'dbo.Configuration', 13 fields Field Name ServerGUID BumpData Flags ReqFieldsSend ReqFieldsRec BillDesc1 BillDesc2 VerifyCodes BumpRunDate ObjectGuid FSRunning ServerKey ClusterGUID

Type and Size uniqueidentifier varchar(193) bigint binary(28) binary(28) varchar(16) varchar(16) smallint datetime uniqueidentifier int varchar(193) uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Primary key for table 'dbo.Configuration' Primary Key Name PK_Configuration

Field Name ServerGUID

Description

Indexes for table 'dbo.Configuration', 1 item Index Name PK_Configuration

Clustered Yes

Unique Yes

Fields ServerGUID

Dependencies for table 'dbo.Configuration', 4 items Object Name dbo.CK_Configuration_Flags_Unsigned dbo.fnGenerateObjectCounts dbo.fnWorkRequestCounts dbo.InsertBaseConfiguration

Type check cns table function table function stored procedure

Table: 'dbo.Contacts', 23 fields Field Name handle OwnerHandle ID Name Company Address1 Address2 Address3 City State Zip PrimaryFax SecondaryFax PrimaryVoice SecondaryVoice MobilePhone EmailAddress Notes BillInfo1 BillInfo2 Flags SecureCSID ObjectGuid

Type and Size int identity int varchar(18) varchar(256) varchar(256) varchar(256) varchar(256) varchar(256) varchar(256) varchar(50) varchar(50) varchar(128) varchar(128) varchar(128) varchar(128) varchar(128) varchar(256) varchar(256) varchar(18) varchar(18) bigint varchar(22) uniqueidentifier

Default

Nullable NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.Contacts' Primary Key Name PK_Contacts

Field Name handle

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

Primary Users.handle

Indexes for table 'dbo.Contacts', 4 items Index Name IX_Contacts_ID PK_Contacts IX_Contacts_OwnerHandle

Clustered No No No

Unique Yes Yes No

Dependencies for table 'dbo.Contacts', 7 items Object Name dbo.CK_ContactsValidID dbo.ExpandedContacts

Type check cns view

Fields ID, OwnerHandle handle OwnerHandle

dbo.fnGenerateGroupContents dbo.fnGenerateObjectCounts dbo.fnGetContentsOfDL dbo.RFView_UserPhoneEntries dbo.RFView_UserPhoneGroups

table function table function inline function view view

Table: 'dbo.Delegates', 9 fields Field Name handle Flags Delegator Delegatee ReadPermissions WritePermissions DeletePermissions MiscPermissions ObjectGuid

Type and Size int identity bigint int int bigint bigint bigint bigint uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.Delegates' Primary Key Name PK_Delegates

Field Name handle

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

Primary Users.handle Users.handle

Indexes for table 'dbo.Delegates', 3 items Index Name PK_Delegates IX_Delegates_Delegatee IX_Delegates_Delegator

Clustered Yes No No

Unique Yes No No

Fields handle Delegatee Delegator

Dependencies for table 'dbo.Delegates', 6 items Object Name dbo.CK_Delegates_DeletePermissions_Unsigned dbo.CK_Delegates_Flags_Unsigned dbo.CK_Delegates_MiscPermissions_Unsigned dbo.CK_Delegates_ReadPermissions_Unsigned dbo.CK_Delegates_WritePermissions_Unsigned dbo.fnDelegatorsFromID

Type check cns check cns check cns check cns check cns inline function

Table: 'dbo.DistributionLists', 5 fields Field Name ID ItemHandle ListHandle ContactType Extension

Type and Size int identity int int varchar(50) int

Default

Primary key for table 'dbo.DistributionLists'

Nullable NOT NULL NOT NULL NOT NULL NOT NULL NULL

Description

Used to map distribution list relationships back to an extension for the old API

Primary Key Name PK_DistributionLists

Field Name ID

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

Primary Contacts.handle ExtensionJoin.handle

Indexes for table 'dbo.DistributionLists', 3 items Index Name PK_DistributionLists IX_ContactsDistributionL ists IX_ContactsDistributionL ists_ContactType

Clustered Yes No

Unique Yes No

Fields ID ListHandle

No

No

ContactType

Dependencies for table 'dbo.DistributionLists', 3 items Object Name dbo.fnGenerateGroupContents dbo.fnGetContentsOfDL dbo.RFView_UserPhoneGroups

Type table function inline function view

Table: 'dbo.DocFiles', 17 fields Field Name handle Flags Links JobID DocType BodyFilename InputFilename NumPages PaperNum PrintJobType FineMode BFTFile BFTBytes OrigBFTName ImageBytes reserved ObjectGuid

Type and Size int identity bigint int int int varchar(14) varchar(14) int smallint smallint smallint varchar(14) bigint varchar(14) bigint varchar(12) uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.DocFiles' Primary Key Name PK_DocFiles

Field Name handle

Indexes for table 'dbo.DocFiles', 1 item Index Name PK_DocFiles

Clustered Yes

Unique Yes

Dependencies for table 'dbo.DocFiles', 18 items Object Name dbo.CK_FaxFiles_BFTBytes_Unsigned dbo.CK_FaxFiles_DocType_Unsigned dbo.CK_FaxFiles_Flags_Unsigned

Type check cns check cns check cns

Fields handle

dbo.CK_FaxFiles_ImageBytes_Unsigned dbo.CK_FaxFiles_JobID_Unsigned dbo.CK_FaxFiles_Links_Unsigned dbo.CK_FaxFiles_NumPages_Unsigned dbo.DeleteAllDocuments dbo.DeleteDocument dbo.fnDocumentAttachmentStatus dbo.fnDocumentPageCount dbo.fnDocumentPDFStatus dbo.fnFormatDocumentPageCount dbo.fnGenerateDocumentCounts dbo.fnGetFileFlagsFromDocumentHandle dbo.fnViewDocTransactions dbo.fnViewDocuments dbo.PurgeDocument

check cns check cns check cns check cns stored procedure stored procedure scalar function scalar function scalar function scalar function table function scalar function table function table function stored procedure

Table: 'dbo.Documents', 67 fields Field Name handle OwnerID Flags Destination ToContactNum ToName ToCompany ToCityState FromName FromPhoneNum BillInfo1 BillInfo2 FaxDIDNum OperatorNum GeneralFaxNum CallBack CreationTime ElapsedSendTime Status ErrorCode Disposition TermStat RemoteID DocFileDBA NoteDBA FCSFile FCSText FaxID NotifyChannel PhoneUserID PhoneEntryID DelaySendUntilTime UniqueID fcstype EmailType Priority SendChannel Custom1 BoardSrv OldStatus OldErrorCode PagesInFront MaxTries TryInterval FolderIndex

Type and Size int identity int bigint varchar(32) varchar(32) varchar(60) varchar(60) varchar(60) varchar(60) varchar(32) varchar(16) varchar(16) varchar(32) varchar(32) varchar(32) smallint datetime bigint int int int int varchar(22) int int varchar(14) varchar(14) int int varchar(22) varchar(18) datetime varchar(16) int smallint smallint int int int int int int smallint smallint int

Default

Nullable NOT NULL NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Description

SendNotify SecureCSID FromNameCont AutoFwdCount HistChgDateTime TUIFaxDBA FRFlags2 CCListDBA CmdData AltDestination FCSBytes Comment ExpiresIn RecNotType RecNotAddr PrefContType FRReserved2 ServerGUID MsgFromTransport ObjectGuid UsnCreated UsnUpdated

int varchar(22) varchar(41) smallint datetime bigint bigint bigint varchar(14) varchar(32) bigint varchar(70) int smallint varchar(32) smallint varchar(914) uniqueidentifier varchar(32) uniqueidentifier bigint bigint

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid()) ((0)) ((0))

Primary key for table 'dbo.Documents' Primary Key Name PK_Documents

Field Name handle

Foreign keys for table 'dbo.Documents', 3 items Foreign Documents.DocFileDBA Documents.NoteDBA Documents.OwnerID

Primary DocFiles.handle Notes.handle Users.handle

Indexes for table 'dbo.Documents', 6 items Index Name PK_Documents IX_Documents_DocFileDBA IX_Documents_Flags IX_Documents_OwnerID IX_Documents_OwnerID_Fla gs

Clustered Yes No No No No

Unique Yes No No No No

Fields handle DocFileDBA Flags OwnerID OwnerID, Flags

Triggers for table 'dbo.Documents', 2 items Name OnInsertDocumentsUsn OnUpdateDocumentsUsn

Type after INSERT after UPDATE

Enabled Yes Yes

Dependencies for table 'dbo.Documents', 49 items Object Name dbo.CK_Documents_AutoFwdCount_Unsigned dbo.CK_Documents_BoardSrv_Unsigned dbo.CK_Documents_CCListDBA_Unsigned dbo.CK_Documents_Custom1_Unsigned dbo.CK_Documents_Disposition_Unsigned dbo.CK_Documents_ElapsedSendTime_Unsigned dbo.CK_Documents_EmailType_Unsigned dbo.CK_Documents_ErrorCode_Unsigned dbo.CK_Documents_FaxID_Unsigned

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns

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

check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns stored procedure stored procedure scalar function scalar function scalar function scalar function scalar function scalar function scalar function scalar function table function table function inline function scalar function scalar function table function table function stored procedure trigger trigger stored procedure stored procedure view

Table: 'dbo.DTActivities', 65 fields Field Name ID

Type and Size int identity

Default

Nullable NOT NULL

ActID

int

NOT NULL

Marked

smallint

NOT NULL

Age

smallint

NULL

Type

smallint

NULL

Description Primary key used to identify this activity Activity ID (0 to 0xFFFF) Set when a server has retrieved this record from DocTransport Age of this record in terms of number of maintenance cycles it has been through Type of transport event (e.g., remote send, local receive, etc.)

Unit

smallint

NULL

Pages

smallint

NULL

BadPages

smallint

NULL

GoodPages

smallint

NULL

BoardType

smallint

NULL

CallStatus

smallint

NULL

CallLineStatus

smallint

NULL

TransactionStatus

smallint

NULL

TransactionLineStatu s SenderID

smallint

NULL

varchar(48)

NULL

CallType

smallint

NULL

Destination

varchar(260)

NULL

Filename

varchar(260)

NULL

TransactionTime

datetime

NULL

TransactionDuration

int

NULL

ForeignReqID

varchar(50)

NULL

ForeignDocID

bigint

NULL

DocumentName

varchar(64)

NULL

ForeignLoginID

varchar(128)

NULL

ForeignLoginPassword varchar(128)

NULL

BroadcastID

int

NULL

BroadcastIndex

int

NULL

Local channel responsible for orchestrating this activity Total number of pages in this activity Number of pages that involved errors Number of pages that were handled successfully Type of board, if any, involved in this activity Status result of the activity Status result of the communication medium Status result for the transaction Status result of the transaction medium ID of sender for receive transactions Flags regarding the type of call Destination of recipient for outbound transactions (e.g., fax number, e-mail address, etc.) Name of document file used in transaction Time this transaction began Duration of transaction in seconds ID of request in foreign system Integer ID of document in foreign system Friendly name for document Login ID used to authenticate on foreign system Login password used to authenticate on foreign system ID of broadcast that this transaction is part of Index of broadcast that this transaction is part of

Progress

int

NULL

TransportType

varchar(32)

NULL

TransportError

bigint

NULL

Flags

int

NULL

ANI

varchar(32)

NULL

AOCData1 AOCData2 AOCData3 ISDNCauseValue

bigint bigint bigint int

NULL NULL NULL NULL

TransportMessage

varchar(96)

NULL

RemoteServerName

varchar(260)

NULL

RemoteID

char(10)

NULL

RemoteProtocol

int

NULL

ToContactNum

varchar(32)

NULL

ToName ToCompany

varchar(60) varchar(60)

NULL NULL

BillInfo1 BillInfo2 SecureCSID

varchar(16) varchar(16) varchar(22)

NULL NULL NULL

AuditFlags SubscriberID

bigint bigint

NULL NULL

UniqueID

varchar(16)

NULL

FromName SourceServerName

varchar(60) varchar(260)

NULL NULL

UserID

varchar(22)

NULL

ServerGUID

uniqueidentifier

NOT NULL

Progress identifier (see DTEnumActivitiesProg ress) Type of the transport used to perform this transaction Error code specific to the transport used for this transaction Transaction specific flags ANI information for this transaction when available

Cause value for ISDN only Transport specific message to record in Document Name of the remote server used in this transaction ID of this transaction in the remote DocTransport when sending via or into another server Protocol used to communicate with remote DocTransport when sending via or into another server Voice contact number for recipient Recipient name Recipient company information Billing information Billing information Identifier of intended recipient's equipment for verification purposes Audit specific flags Subscriber ID of sender in RightFax RightFax document unique ID Sender name Originating server name RightFax User ID this transaction was made on behalf of GUID of DocTransport identified in DTConfigurations

SendFlags

bigint

NULL

MinSendChannel

int

NULL

MaxSendChannel

int

NULL

TimeScheduled

datetime

NULL

QuickHeaderFormat

varchar(134)

NULL

TTIHeaderID

varchar(24)

NULL

Priority

int

NULL

ExpirationTime

datetime

NULL

GroupID

varchar(22)

NULL

DocumentFlags

int

NULL

QueueName

varchar(30)

NULL

DTDialingRuleUsed

int

NULL

Flags used in scheduling this document Minimum channel number that this document is allowed to be sent on (origin is 1; 0 indicates all) Maximum channel number that this document is allowed to be sent on (origin is 1) Time this document was scheduled Formatting for fax quick headers Header field on the TTI line Document send priority Time this fax expires (and, after which, it should be aborted, if possible). RightFax sender's RightFax group ID Flags specified by document server Name of schedule queue

Primary key for table 'dbo.DTActivities' Primary Key Name PK_DTActivities

Field Name ID

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

Primary DTConfigurations.ServerGUID

Indexes for table 'dbo.DTActivities', 5 items Index Name PK_DTActivities IX_DTActivities IX_DTActivities_Marked IX_DTActivities_QueueNam e IX_DTActivities_Type

Clustered Yes No No No

Unique Yes No No No

Fields ID ActID Marked QueueName

No

No

Type

Dependencies for table 'dbo.DTActivities', 5 items Object Name dbo.fnCalculatePagesInFront dbo.fnGenerateDTActivityCounts dbo.GetDTActivitySend dbo.PurgeDTActivities dbo.RescheduleDTActivitySend

Type scalar function table function stored procedure stored procedure stored procedure

Table: 'dbo.DTActivityState', 13 fields Field Name ServerGUID CurrentFile

Type and Size uniqueidentifier bigint

Default

Nullable NOT NULL NOT NULL

CurrentID

int

NOT NULL

TotalsReset

datetime

NOT NULL

LocalDocsSent

bigint

NOT NULL

LocalDocsReceived

bigint

NOT NULL

LocalPagesSent

bigint

NOT NULL

LocalPagesReceived

bigint

NOT NULL

RemoteDocsSent

bigint

NOT NULL

RemoteDocsReceived

bigint

NOT NULL

RemotePagesSent

bigint

NOT NULL

RemotePagesReceived

bigint

NOT NULL

LastPulseTime

datetime

('01/01/2005')

NOT NULL

Description Identifier of last unique file number used Last ID used for DTActivities Time at which "Alltime" totals was last reset. Documents sent locally since last reset Documents received locally since last reset Pages sent locally since last reset Pages recieved locally since last reset Documents sent remotely since last reset. Documents received remotely since last reset. Pages sent remotely since last reset Pages recieved remotely since last reset Pulse value periodically updated by the corresponding DT to show signs of life.

Primary key for table 'dbo.DTActivityState' Primary Key Name PK_DTActivityState

Field Name ServerGUID

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

Primary DTConfigurations.ServerGUID

Indexes for table 'dbo.DTActivityState', 1 item Index Name PK_DTActivityState

Clustered Yes

Unique Yes

Dependencies for table 'dbo.DTActivityState', 3 items Object Name dbo.DTPulse dbo.DTPulseExpired dbo.DTSecondsSinceLastPulse

Type stored procedure stored procedure stored procedure

Fields ServerGUID

Table: 'dbo.DTConfigurations', 4 fields, Each row in this table defines server specific settings Field Name ServerGUID

Type and Size uniqueidentifier

Default

Nullable NOT NULL

ServerName

varchar(260)

NULL

ImageDir

varchar(260)

NULL

FilenamePrefix

char(2)

NULL

Description Server identifier used to relate rows to particular servers Optional name of this server (for reference only) Path to the server's image dir. This is the same dir for all DT's connected to the same server group but each DT could have a different path to access it.

Primary key for table 'dbo.DTConfigurations' Primary Key Name PK_DTConfigurations

Field Name ServerGUID

Indexes for table 'dbo.DTConfigurations', 1 item Index Name PK_DTConfigurations

Clustered Yes

Unique Yes

Fields ServerGUID

Dependencies for table 'dbo.DTConfigurations', 2 items Object Name dbo.DTPulseExpired dbo.DTSetFilenamePrefix

Type stored procedure stored procedure

Table: 'dbo.DTConfigurationsDialingRules', 7 fields Field Name ID ServerGUID DTDialingRulesID Enabled TimeAvailable DownReason DisabledReason

Type and Size int identity uniqueidentifier int bit datetime varchar(128) bigint

Default

Nullable NOT NULL NOT NULL NOT NULL NULL NULL NULL NULL

((1)) ((0))

Primary key for table 'dbo.DTConfigurationsDialingRules' Primary Key Name PK_DTConfigurationsDialingRules

Field Name ID

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

Primary DTConfigurations.ServerGUID DTDialingRules.ID

Indexes for table 'dbo.DTConfigurationsDialingRules', 1 item

Description

Index Name PK_DTConfigurationsDiali ngRules

Clustered Yes

Unique Yes

Fields ID

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

Type and Size int identity varchar(50)

Default

Nullable NOT NULL NOT NULL

IsExtConnection ExtConnection

bit varchar(256)

NULL NULL

ExtTable

varchar(256)

NULL

ExtColumn

varchar(50)

NULL

ExtPK Condition

varchar(50) varchar(256)

NULL NULL

ServerGUID

uniqueidentifier

NULL

Description Name of this table for reference in UI and queries Optional external data source connection string Name of table in external datasource Name of column containing destination address in external data source Condition binding data in ExtTable to this destinations group Optional identifier of a specific server to associate this record with. This allows separate tables with the same name to exist on multiple servers in the same database.

Primary key for table 'dbo.DTDestinationGroups' Primary Key Name PK_DTDestinationGroups

Field Name ID

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

Primary DTConfigurations.ServerGUID

Indexes for table 'dbo.DTDestinationGroups', 3 items Index Name PK_DTDestinationGroups IX_DTDestinationGroups_N ameServerGUID

Clustered Yes No

Unique Yes Yes

Fields ID Name, ServerGUID

Table: 'dbo.DTDestinations', 3 fields, Destinations table containing data for non-external destination groups Field Name

Type and Size

Default

Nullable

Description

ID

int identity

NOT NULL

Destination OwnerID

varchar(50) int

NOT NULL NOT NULL

Primary key for deletion or other unique identification Destination address ID of DTDestinationGroups row that owns this address

Primary key for table 'dbo.DTDestinations' Primary Key Name PK_DTDestinations

Field Name ID

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

Primary DTDestinationGroups.ID

Indexes for table 'dbo.DTDestinations', 1 item Index Name PK_DTDestinations

Clustered Yes

Unique Yes

Fields ID

Table: 'dbo.DTDialingRules', 33 fields Field Name ID SourceServer Pattern DestinationServer Protocol PriorityDelta Flags PriorityMask StartChannel TimeOfDayMask_0 TimeOfDayMask_1 TimeOfDayMask_2 TimeOfDayMask_3 TimeOfDayMask_4 TimeOfDayMask_5 TimeOfDayMask_6 BeginDelete BeginReplace EndDelete EndReplace UserID GroupID EndChannel Comment MinQueueDepth ExtraWeight DelayHour FaxSize MLAccount MLPassCode MLDocAccount DNDNotifyList NotifySender

Type and Size int identity varchar(48) varchar(64) varchar(48) int smallint bigint int int bigint bigint bigint bigint bigint bigint bigint smallint varchar(48) smallint varchar(48) varchar(128) varchar(128) int varchar(64) bigint bigint int smallint varchar(12) varchar(12) varchar(32) varchar(128) int

Default

Primary key for table 'dbo.DTDialingRules'

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Description

Primary Key Name PK_DTDialingRules

Field Name ID

Indexes for table 'dbo.DTDialingRules', 1 item Index Name PK_DTDialingRules

Clustered Yes

Unique Yes

Fields ID

Table: 'dbo.DTRxDocs', 10 fields Field Name ID DTActivitiesID

Type and Size int identity int

Default

Nullable NOT NULL NOT NULL

Dequeued

bit

((0))

NOT NULL

Filename

varchar(260)

NOT NULL

RoutingInfo

varchar(256)

NULL

RoutingInfoValid Error

bit bigint

NOT NULL NOT NULL

ServerGUID

uniqueidentifier

NOT NULL

TimeZoneBias

smallint

NOT NULL

ReceiveType

smallint

NOT NULL

Description Primary key Indicates which DTActivities entry this received document corresponds to Indicates whether this entry has been dequeued Name of the corresponding file in the image directory Routing info (such as DID number or email address) Error, if any, in receiving this document GUID of server that received this document Number of minutes of timezone bias accumulated through server routing Type of receive

Primary key for table 'dbo.DTRxDocs' Primary Key Name PK_DTRxDocs

Field Name ID

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

Primary DTActivities.ID DTConfigurations.ServerGUID

Indexes for table 'dbo.DTRxDocs', 1 item Index Name PK_DTRxDocs

Clustered Yes

Unique Yes

Dependencies for table 'dbo.DTRxDocs', 1 item Object Name dbo.GetNextRxDoc

Type stored procedure

Fields ID

Table: 'dbo.EnumEventsType', 3 fields Field Name Type

Type and Size int

Name Description

varchar(64) varchar(256)

Default

Nullable NOT NULL

Description Event type identifier Name for this type Description for this type

NOT NULL NOT NULL

Primary key for table 'dbo.EnumEventsType' Primary Key Name PK_EnumEventsType

Field Name Type

Indexes for table 'dbo.EnumEventsType', 2 items Index Name PK_EnumEventsType IX_EnumEventsType

Clustered Yes No

Unique Yes Yes

Fields Type Type

Dependencies for table 'dbo.EnumEventsType', 2 items Object Name dbo.EventsAll dbo.EventsTotals

Type view view

Table: 'dbo.ErrorLog', 2 fields Field Name handle Description

Type and Size smallint identity varchar(256)

Default

Nullable NOT NULL NOT NULL

Description

Primary key for table 'dbo.ErrorLog' Primary Key Name PK_ErrorLog

Field Name handle

Indexes for table 'dbo.ErrorLog', 1 item Index Name PK_ErrorLog

Clustered Yes

Unique Yes

Fields handle

Table: 'dbo.Events', 14 fields Field Name ID Type Retries

Type and Size int identity int smallint

Default

Nullable NOT NULL NOT NULL NOT NULL

EnqueueTime

datetime

NOT NULL

DequeueTime

datetime

NOT NULL

DocumentHandle

int

NULL

Description The type of event Number of times this event has been reposted Time this event was enqueued When this event should be dequeued. Events that are not to be delayed use the current time Handle to the document in the Documents table that this event affects

UserHandle

int

NULL

Msg

varchar(128)

NULL

Parm0

int

NULL

Parm1 Parm2 Parm3 ServerGUID

int int int uniqueidentifier

NULL NULL NULL NOT NULL

Dequeued

bit

((0))

Handle to the user in the Users table that this event corresponds to Text message for the event General purpose data value for the event

Server that posted this event (but not necessarily who will process it)

NOT NULL

Primary key for table 'dbo.Events' Primary Key Name PK_Events

Field Name ID

Foreign keys for table 'dbo.Events', 3 items Foreign Events.DocumentHandle Events.Type Events.UserHandle

Primary Documents.handle EnumEventsType.Type Users.handle

Indexes for table 'dbo.Events', 5 items Index Name PK_Events IX_Events IX_Events_DocumentHandle IX_Events_Type

Clustered Yes No No No

Unique Yes No No No

Fields ID DequeueTime, EnqueueTime DocumentHandle Type

Dependencies for table 'dbo.Events', 4 items Object Name dbo.DeleteDocument dbo.EventsAll dbo.EventsTotals dbo.GetNextEvent

Type stored procedure view view stored procedure

Table: 'dbo.ExtensionJoin', 3 fields Field Name handle Owner Type

Type and Size int identity int bigint

Default

Nullable NOT NULL NULL NULL

Description

Primary key for table 'dbo.ExtensionJoin' Primary Key Name PK_ExtensionJoin

Field Name handle

Indexes for table 'dbo.ExtensionJoin', 3 items Index Name PK_ExtensionJoin IX_ExtensionJoin_Owner

Clustered Yes No

Unique Yes No

Fields handle Owner

IX_ExtensionJoin_Type

No

No

Type

Dependencies for table 'dbo.ExtensionJoin', 1 item Object Name dbo.CK_ExtensionJoin_Type_Unsigned

Type check cns

Table: 'dbo.Forms', 12 fields Field Name handle FTFlags FTNum FTCode FTName FTFilename FTStartPage FTNumPages FTNextType FTSecurityID ServerGUID ObjectGuid

Type and Size int identity bigint smallint varchar(16) varchar(40) varchar(20) smallint smallint smallint varchar(20) uniqueidentifier uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.Forms' Primary Key Name PK_Forms

Field Name handle

Indexes for table 'dbo.Forms', 17 items Index Name PK_Forms IX_Forms_FTCode IX_Forms_FTNum Forms2

Clustered Yes No No No

Unique Yes Yes Yes No

IX_Forms_ServerGUID

No

No

Fields handle FTCode, ServerGUID FTNum, ServerGUID ServerGUID, handle, FTFlags, FTNum, FTCode, FTName, FTFilename, FTStartPage, FTNumPages, FTNextType, FTSecurityID ServerGUID

Dependencies for table 'dbo.Forms', 3 items Object Name dbo.CK_Forms_FTFlags_Unsigned dbo.fnGenerateObjectCounts dbo.InsertBaseServerSpecificData

Type check cns table function stored procedure

Table: 'dbo.GlobalConfiguration', 4 fields Field Name ID CurrentUSN DBVersion CurrentFile

Type and Size int identity bigint varchar(16) bigint

Default

Nullable NOT NULL NOT NULL NULL NOT NULL

((0)) ((0))

Primary key for table 'dbo.GlobalConfiguration' Primary Key Name PK_GlobalConfiguration

Indexes for table 'dbo.GlobalConfiguration', 1 item

Field Name ID

Description

Index Name PK_GlobalConfiguration

Clustered Yes

Unique Yes

Fields ID

Dependencies for table 'dbo.GlobalConfiguration', 2 items Object Name dbo.GetNextFile dbo.spGetNextUsn

Type stored procedure stored procedure

Table: 'dbo.Globalization', 4 fields Field Name Namespace LocKey IsoLanguageName Data

Type and Size nvarchar(100) nvarchar(100) nvarchar(6) ntext

Default

Nullable NOT NULL NOT NULL NOT NULL NULL

Description

Primary key for table 'dbo.Globalization' Primary Key Name PK_Globalization

Field Names Namespace, LocKey, IsoLanguageName

Indexes for table 'dbo.Globalization', 3 items Index Name PK_Globalization

Clustered Yes

Unique Yes

Fields Namespace, LocKey, IsoLanguageName

Dependencies for table 'dbo.Globalization', 9 items Object Name dbo.fnGetChildrenOfFolder dbo.fnGetChildrenOfFolder2 dbo.fnGetFolderFromID dbo.fnGetFolderNameFromID dbo.fnGetGammaString dbo.fnGetHangupStatusString dbo.fnGetTermStatString dbo.fnGetUntranslatedStringsForLanguage dbo.GetUntranslatedStringsForAllLanguages

Type inline function table function table function scalar function scalar function scalar function scalar function inline function stored procedure

Table: 'dbo.Groups', 28 fields Field Name handle Flags GroupID Admin AltAdmin GroupFCS NotifyType RecvDocAge SentDocAge DelDocAge GroupRoutingCode SFDType SFDFlags ChangeTag MaxConcurrentPages MaxConcurrentDocs ConcurrentDelayTime

Type and Size int identity bigint varchar(22) varchar(22) varchar(22) varchar(14) int int int int bigint int int bigint int int smalldatetime

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Description

ConcurrentStartTime ConcurrentEndTime NewDocAge FailedDocAge INCSentDocAge FCSDlgCtrl1 FCSDlgCtrl2 HotLinkDocAge ObjectGuid UsnCreated UsnUpdated

smalldatetime smalldatetime int int int bigint bigint int uniqueidentifier bigint bigint

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid()) ((0)) ((0))

Primary key for table 'dbo.Groups' Primary Key Name PK_Groups

Field Name handle

Indexes for table 'dbo.Groups', 3 items Index Name PK_Groups IX_Groups_GroupID IX_Groups_GroupRoutingCo de

Clustered Yes No No

Unique Yes Yes No

Fields handle GroupID GroupRoutingCode

Triggers for table 'dbo.Groups', 2 items Name OnInsertGroupsUsn OnUpdateGroupsUsn

Type after INSERT after UPDATE

Enabled Yes Yes

Dependencies for table 'dbo.Groups', 30 items Object Name dbo.CK_Groups_ChangeTag_Unsigned dbo.CK_Groups_DelDocAge_Unsigned dbo.CK_Groups_FailedDocAge_Unsigned dbo.CK_Groups_FCSDlgCtrl1_Unsigned dbo.CK_Groups_FCSDlgCtrl2_Unsigned dbo.CK_Groups_Flags_Unsigned dbo.CK_Groups_GroupRoutingCode_Unsigned dbo.CK_Groups_HotLinkDocAge_Unsigned dbo.CK_Groups_INCSentDocAge_Unsigned dbo.CK_Groups_MaxConcurrentDocs_Unsigned dbo.CK_Groups_MaxConcurrentPages_Unsigned dbo.CK_Groups_NewDocAge_Unsigned dbo.CK_Groups_NotifyType_Unsigned dbo.CK_Groups_RecvDocAge_Unsigned dbo.CK_Groups_SentDocAge_Unsigned dbo.CK_Groups_SFDFlags_Unsigned dbo.CK_Groups_SFDType_Unsigned dbo.fnGetAgedDocuments dbo.fnGetGroupIDFromUserHandle dbo.fnGetGroupsAdminedBy dbo.fnGroupHandleFromID dbo.fnGroupMembersFromID dbo.fnViewUserSettings dbo.GroupsFull dbo.InsertBaseRecords dbo.OnInsertGroupsUsn dbo.OnUpdateGroupsUsn dbo.OnUpdateUsersUsn dbo.PurgeDocuments

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns inline function scalar function inline function scalar function inline function table function view stored procedure trigger trigger trigger stored procedure

dbo.UsersFull

view

Table: 'dbo.HangupStatusToStatusCode', 2 fields Field Name HangupStatus StatusCode

Type and Size int int

Default

Nullable NOT NULL NOT NULL

Description

Primary key for table 'dbo.HangupStatusToStatusCode' Primary Key Name PK_HangupStatusToStatusCode

Field Names HangupStatus, StatusCode

Indexes for table 'dbo.HangupStatusToStatusCode', 2 items Index Name PK_HangupStatusToStatusC ode

Clustered Yes

Unique Yes

Fields HangupStatus, StatusCode

Dependencies for table 'dbo.HangupStatusToStatusCode', 1 item Object Name dbo.fnGetHangupStatusString

Type scalar function

Table: 'dbo.History', 5 fields Field Name handle Owner TRDateTime TRRecType ObjectGuid

Type and Size int identity int datetime smallint uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.History' Primary Key Name PK_History

Field Name handle

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

Primary Documents.handle

Indexes for table 'dbo.History', 2 items Index Name PK_History IX_History_Owner

Clustered Yes No

Unique Yes No

Fields handle Owner

Triggers for table 'dbo.History', 1 item Name OnInsertHistory

Type after INSERT

Enabled Yes

Dependencies for table 'dbo.History', 4 items Object Name dbo.CK_History_TRRecType_Unsigned dbo.fnDocumentCountMatchingAniRecords dbo.fnGetHistoryCountForDocument dbo.fnViewDocTransactions

Type check cns scalar function scalar function table function

Table: 'dbo.HistoryApproved', 4 fields Field Name Flags ApproverID Notes handle

Type and Size bigint varchar(22) varchar(454) int

Default

Nullable NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryApproved' Primary Key Name PK_HistoryApproved

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryApproved', 1 item Index Name PK_HistoryApproved

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryApproved', 1 item Object Name dbo.CK_HistoryApproved_Flags_Unsigned

Type check cns

Table: 'dbo.HistoryConversionError', 5 fields Field Name ConvType Error1 Error2 ErrorMsg handle

Type and Size varchar(64) bigint bigint varchar(384) int

Default

Nullable NULL NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryConversionError' Primary Key Name PK_HistoryConversionError

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryConversionError', 1 item Index Name PK_HistoryConversionErro r

Clustered Yes

Unique Yes

Dependencies for table 'dbo.HistoryConversionError', 2 items Object Name dbo.CK_HistoryConversionError_Error1_Unsigned dbo.CK_HistoryConversionError_Error2_Unsigned

Table: 'dbo.HistoryDisapproved', 4 fields

Type check cns check cns

Fields handle

Field Name Flags ApproverID Notes handle

Type and Size bigint varchar(22) varchar(454) int

Default

Nullable NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryDisapproved' Primary Key Name PK_HistoryDisapproved

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryDisapproved', 1 item Index Name PK_HistoryDisapproved

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryDisapproved', 1 item Object Name dbo.CK_HistoryDisapproved_Flags_Unsigned

Type check cns

Table: 'dbo.HistoryFileRouted', 4 fields Field Name Flags Error RoutePath handle

Type and Size bigint bigint varchar(256) int

Default

Nullable NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryFileRouted' Primary Key Name PK_HistoryFileRouted

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryFileRouted', 1 item Index Name PK_HistoryFileRouted

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryFileRouted', 2 items Object Name dbo.CK_HistoryFileRouted_Error_Unsigned dbo.CK_HistoryFileRouted_Flags_Unsigned

Type check cns check cns

Table: 'dbo.HistoryGeneric', 18 fields Field Name GenType UserID ErrCode

Type and Size bigint varchar(22) bigint

Default

Nullable NULL NULL NULL

Description

Number1 Number2 Number3 Number4 Number5 Number6 Number7 Number8 String1 String2 String3 String4 String5 String6 handle

bigint bigint bigint bigint bigint bigint bigint bigint varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) varchar(32) int

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NOT NULL

Primary key for table 'dbo.HistoryGeneric' Primary Key Name PK_HistoryGeneric

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryGeneric', 1 item Index Name PK_HistoryGeneric

Clustered Yes

Unique Yes

Fields handle

Table: 'dbo.HistoryInterConnect', 5 fields Field Name Flags FromServer Msg handle Error

Type and Size bigint varchar(256) varchar(128) int bigint

Default

Nullable NULL NULL NULL NOT NULL NULL

Description

Primary key for table 'dbo.HistoryInterConnect' Primary Key Name PK_HistoryInterConnect

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryInterConnect', 1 item Index Name PK_HistoryInterConnect

Clustered Yes

Unique Yes

Dependencies for table 'dbo.HistoryInterConnect', 1 item Object Name dbo.CK_HistoryInterConnect_Flags_Unsigned

Table: 'dbo.HistoryLoc', 5 fields

Type check cns

Fields handle

Field Name GenType LangID ShortMsg DetailMsg handle

Type and Size bigint int varchar(32) varchar(144) int identity

Default

Nullable NOT NULL NOT NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryLoc' Primary Key Name PK_HistoryLoc

Field Name handle

Indexes for table 'dbo.HistoryLoc', 1 item Index Name PK_HistoryLoc

Clustered Yes

Unique Yes

Fields handle

Table: 'dbo.HistoryNetForward', 5 fields Field Name Flags PrevOwnerID UsersForwardedTo Notes handle

Type and Size bigint varchar(22) varchar(128) varchar(128) int

Default

Nullable NULL NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryNetForward' Primary Key Name PK_HistoryNetForward

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryNetForward', 1 item Index Name PK_HistoryNetForward

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryNetForward', 1 item Object Name dbo.CK_HistoryNetForward_Flags_Unsigned

Type check cns

Table: 'dbo.HistoryOCR', 4 fields Field Name TimeToOCR Error1 Msg handle

Type and Size int bigint varchar(128) int

Default

Nullable NULL NULL NULL NOT NULL

Primary key for table 'dbo.HistoryOCR' Primary Key Name PK_HistoryOCR

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

Field Name handle

Description

Foreign HistoryOCR.handle

Primary History.handle

Indexes for table 'dbo.HistoryOCR', 1 item Index Name PK_HistoryOCR

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryOCR', 1 item Object Name dbo.CK_HistoryOCR_Error1_Unsigned

Type check cns

Table: 'dbo.HistoryPrint', 9 fields Field Name Flags TimeToPrint Error1 Error2 PagesPrinted CopiesPrinted NetPrintID Msg handle

Type and Size bigint int bigint bigint int int varchar(10) varchar(128) int

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistoryPrint' Primary Key Name PK_HistoryPrint

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryPrint', 1 item Index Name PK_HistoryPrint

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryPrint', 5 items Object Name dbo.CK_HistoryPrint_CopiesPrinted_Unsigned dbo.CK_HistoryPrint_Error1_Unsigned dbo.CK_HistoryPrint_Error2_Unsigned dbo.CK_HistoryPrint_Flags_Unsigned dbo.CK_HistoryPrint_PagesPrinted_Unsigned

Type check cns check cns check cns check cns check cns

Table: 'dbo.HistoryRoute', 4 fields Field Name Flags PrevOwnerID Notes handle

Type and Size bigint varchar(22) varchar(454) int

Default

Nullable NULL NULL NULL NOT NULL

Primary key for table 'dbo.HistoryRoute' Primary Key Name

Field Name

Description

PK_HistoryRoute

handle

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

Primary History.handle

Indexes for table 'dbo.HistoryRoute', 1 item Index Name PK_HistoryRoute

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryRoute', 1 item Object Name dbo.CK_HistoryRoute_Flags_Unsigned

Type check cns

Table: 'dbo.HistorySecureDocs', 9 fields Field Name Flags SMTPSender SMTPHost RemoteIP UserAgent CurrentStatus TermStat ExtendStatus handle

Type and Size bigint varchar(64) varchar(64) varchar(32) varchar(64) varchar(32) int varchar(202) int

Default

Nullable NULL NULL NULL NULL NULL NULL NULL NULL NOT NULL

Description

Primary key for table 'dbo.HistorySecureDocs' Primary Key Name PK_HistorySecureDocs

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistorySecureDocs', 1 item Index Name PK_HistorySecureDocs

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistorySecureDocs', 2 items Object Name dbo.CK_HistorySecureDocs_Flags_Unsigned dbo.CK_HistorySecureDocs_TermStat_Unsigned

Type check cns check cns

Table: 'dbo.HistoryTRX', 24 fields Field Name ElapsedTime HangupStatus BadPageCount ChannelUsed Disposition TermStat RemoteID

Type and Size int smallint int int int int varchar(22)

Default

Nullable NULL NULL NULL NULL NULL NULL NULL

Description

BoardType GoodPageCount CXMessageID FaxNumber MsgFromTransport RemoteServer ANI AOCData ISDNCauseVal Reserved Flags GammaErr BTCallResult_Status BTCallResult_LineSta tus BTFaxResult_Status BTFaxResult_LineStat us handle

int int varchar(32) varchar(32) varchar(96) varchar(48) varchar(32) binary(3) int smallint int int smallint smallint

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

smallint smallint

NULL NULL

int

NOT NULL

Primary key for table 'dbo.HistoryTRX' Primary Key Name PK_HistoryTRX

Field Name handle

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

Primary History.handle

Indexes for table 'dbo.HistoryTRX', 1 item Index Name PK_HistoryTRX

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.HistoryTRX', 13 items Object Name dbo.CK_HistoryTRX_BadPageCount_Unsigned dbo.CK_HistoryTRX_BoardType_Unsigned dbo.CK_HistoryTRX_ChannelUsed_Unsigned dbo.CK_HistoryTRX_Disposition_Unsigned dbo.CK_HistoryTRX_ElapsedTime_Unsigned dbo.CK_HistoryTRX_Flags_Unsigned dbo.CK_HistoryTRX_GammaErr_Unsigned dbo.CK_HistoryTRX_GoodPageCount_Unsigned dbo.CK_HistoryTRX_HangupStatus_Unsigned dbo.CK_HistoryTRX_ISDNCauseVal_Unsigned dbo.CK_HistoryTRX_TermStat_Unsigned dbo.fnDocumentCountMatchingAniRecords dbo.fnViewDocTransactions

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns scalar function table function

Table: 'dbo.LibraryDocuments', 18 fields Field Name handle Flags ObjectID Filename Description NumPages TimesRequestedFOD TimesUsedLAN

Type and Size int identity bigint varchar(22) varchar(14) varchar(36) int bigint bigint

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL

Description

EmbargoDate ExpireDate ParentFolder FolderID TimesRequestedWEB LastUsed FodPassword reserved ServerGUID ObjectGuid

datetime datetime bigint bigint bigint datetime varchar(63) varchar(1000) uniqueidentifier uniqueidentifier

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Primary key for table 'dbo.LibraryDocuments' Primary Key Name PK_LibraryDocuments

Field Name handle

Indexes for table 'dbo.LibraryDocuments', 5 items Index Name PK_LibraryDocuments IX_LibraryDocuments_Obje ctID IX_LibraryDocuments IX_LibraryDocuments_Serv erGUID

Clustered Yes No

Unique Yes Yes

Fields handle ObjectID, ServerGUID

No No

No No

ObjectID ServerGUID

Dependencies for table 'dbo.LibraryDocuments', 9 items Object Name dbo.CK_LibraryDocuments_Flags_Unsigned dbo.CK_LibraryDocuments_FolderID_Unsigned dbo.CK_LibraryDocuments_NumPages_Unsigned dbo.CK_LibraryDocuments_ParentFolder_Unsigned dbo.CK_LibraryDocuments_TimesRequestedFOD_Unsigned dbo.CK_LibraryDocuments_TimesRequestedWEB_Unsigned dbo.CK_LibraryDocuments_TimesUsedLAN_Unsigned dbo.fnGenerateObjectCounts dbo.InsertBaseServerSpecificData

Type check cns check cns check cns check cns check cns check cns check cns table function stored procedure

Table: 'dbo.Locks', 8 fields Field Name ServerGUID UserID Module BlockReads BlockWrites FSRecognized FDRecognized ObjectGuid

Type and Size uniqueidentifier varchar(22) varchar(128) bit bit bit bit uniqueidentifier

Default

Nullable NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NULL

(newid())

Description

Primary key for table 'dbo.Locks' Primary Key Name PK_Locks

Field Name ServerGUID

Indexes for table 'dbo.Locks', 1 item Index Name PK_Locks

Clustered Yes

Table: 'dbo.NewDocAttachments', 12 fields

Unique Yes

Fields ServerGUID

Field Name handle NewDocHandle Dir

Type and Size int identity int varchar(260)

Default

Nullable NOT NULL NOT NULL NULL

FileName

varchar(260)

NOT NULL

Password

varchar(256)

NULL

Native

bit

NULL

NativeFileName

varchar(260)

NULL

AltBody

bit

NULL

DeleteSource

bit

NOT NULL

Lib

bit

NULL

Usage

varchar(50)

NULL

ObjectGuid

uniqueidentifier

(newid())

Description

The RightFax dir (e.g., outgoing) containing FileName. Null indicates FileName is a full path. Source file name of this attachment. Password for creating or opening encrypted documents Indicates whether this document is to be attached in its native form. If Native, name of file when in transport. Indicates whether this document is to be an alternate body (e-mail and Native only). Indicates whether to delete the source file after processing Indicates this attachment is a RightFax Library Document Indicates how this lib document is being used (e.g., Web = WebClient/Util, FOD = Fax On Demand, LAN = Win32 Client)

NULL

Primary key for table 'dbo.NewDocAttachments' Primary Key Name PK_NewDocAttachments

Field Name handle

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

Primary NewDocs.handle

Indexes for table 'dbo.NewDocAttachments', 1 item Index Name PK_NewDocAttachments

Clustered Yes

Unique Yes

Dependencies for table 'dbo.NewDocAttachments', 2 items Object Name dbo.fnGenerateDocumentCounts

Type table function

Fields handle

dbo.fnGetAttachmentCountForDoc

scalar function

Table: 'dbo.NewDocRecipients', 35 fields Field Name handle NewDocHandle Type

Type and Size int identity int varchar(50)

Default

Nullable NOT NULL NOT NULL NOT NULL

BillInfo1 BillInfo2 DelaySendUntil

varchar(16) varchar(16) datetime

NULL NULL NULL

FromName FromDestination

varchar(60) varchar(256)

NULL NULL

FromPhoneNum ToDestination ToAltDestination

varchar(32) varchar(256) varchar(256)

NULL NULL NULL

ToCityState

varchar(60)

NULL

ToCompany

varchar(60)

NULL

ToContactNum

varchar(32)

NULL

ToName SecureCSID

varchar(60) varchar(22)

NULL NULL

Priority

tinyint

NULL

JobID

varchar(16)

NULL

CompletionEvent

bit

NULL

CoverSheet

bit

NULL

AutoDeleteSuccess

bit

NULL

AutoDeleteFailure

bit

NULL

RecipientNotifyType

varchar(50)

NULL

Description

Recipient Type (e.g., Fax, SMS, Email) Accounting code #1 Accounting code #2 Null if ASAP, else time fax should be sent (delay send) (GMT0) Source name From address (destination for response) Source voice number Destination address Alternate destination address Destination location name Destination voice number Destination company name Destination name Null if secure sending is not enabled Fax job priority level - see PRIORITY_* in rfapi.h Unique user or system provided id for fax job Null = use default, 0 = No complete event, 1 = fire complete event Null = use default, 0 = No cover sheet, 1 = cover sheet Null = use default, 0 = no delete on success, 1 = delete on sucess Null = use default, 0 = no delete on failure, 1 = delete on failure (currently, if this is set to 1, AutoDeleteSuccess must also be 1) Type of recipient notification to use (e.g., SMS) or NULL if none

RecipientNotifyDesti nation

varchar(256)

NULL

PreferredContentType

varchar(50)

NULL

OwnerPassword

varchar(256)

NULL

UserPassword

varchar(256)

NULL

PermAllowPrinting

bit

NULL

PermAllowModificatio bit n

NULL

PermAllowExtraction

bit

NULL

PermAllowAnnotation

bit

NULL

PermAllowSaveAs

bit

NULL

CC

bit

NULL

Certified

bit

NULL

ObjectGuid

uniqueidentifier

(newid())

Recipient notification destination address Type of file we prefer to send (e.g., G3, TXT, PDF) Owner password for document body (Secure PDF only) User password for document body (Secure PDF only) Allow printing of document body (Secure PDF only) Allow modification document body (Secure PDF only) Allow copying/extraction of document body (Secure PDF only) Allow annotation of document body (Secure PDF only) Allow document body (Secure PDF only) to be saved as another file name Indicates the recipient is a CC recipient (a recipient receiving a Carbon Copy) Indicates use of Certified Delivery (applies to Type = "Email" only)

NULL

Primary key for table 'dbo.NewDocRecipients' Primary Key Name PK_NewDocRecipients

Field Name handle

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

Primary NewDocs.handle

Indexes for table 'dbo.NewDocRecipients', 1 item Index Name PK_NewDocRecipients

Clustered Yes

Unique Yes

Dependencies for table 'dbo.NewDocRecipients', 2 items Object Name dbo.fnGenerateDocumentCounts dbo.fnGetRecipientCountForDoc

Table: 'dbo.NewDocs', 23 fields

Type table function scalar function

Fields handle

Field Name handle UserHandle

Type and Size int identity int

Default

DocumentHandle

int

NULL

Ready

bit

NULL

Notes

varchar(1470)

NULL

Subject BodyCoverPDF

varchar(512) bit

NULL NULL

NotesTXT

bit

NULL

HoldForPreview

bit

NULL

FineBody

bit

NULL

FineCover

bit

NULL

SmartResume

bit

NULL

Forward

bit

NULL

FolderIndex

int

NULL

CreationTime

datetime

NULL

CoverTemplate

varchar(260)

NULL

Comment

varchar(70)

NULL

ServerGUID

uniqueidentifier

NULL

FromOperatorNum

varchar(32)

NULL

FromGeneralFaxNum

varchar(50)

NULL

ObjectGuid

uniqueidentifier

(newid())

Nullable NOT NULL NOT NULL

NULL

Description Owner from Users table. Referenced Document (see Forward) Set when NewDoc and related data are ready. Document will not be created until this is set. Note text for FCS or SMS content. Subject text. Requests a PDF of the body and/or cover Requests a TXT of the notes Requests the document be held for preview before sending Indicates to use 200x200 dpi for the G3 body (normal is 200x100) Indicates to use 200x200 dpi for the G3 cover sheet (normal is 200x100) Set when the fax should use partialretries Indicates that this document is to be a forward of the document referred to by DocumentHandle Index of the user's folder where this document will reside (0 is Main) The time this document was created Name of the cover sheet template to use. Null indicates use user/system default. Comment for owner's convenience--this value is not transmitted Identifies the server this document is to processed by Source generic voice number Source generic fax number

FormID

varchar(16)

NULL

NeedsApproval

bit

NULL

The ID or Code of the Form to overlay on the new document. Null or empty string for none. Indicates that the document request requires approval.

Primary key for table 'dbo.NewDocs' Primary Key Name PK_NewDocs

Field Name handle

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

Primary Users.handle

Indexes for table 'dbo.NewDocs', 1 item Index Name PK_NewDocs

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.NewDocs', 2 items Object Name dbo.fnGenerateDocumentCounts dbo.fnGenerateObjectCounts

Type table function table function

Table: 'dbo.Notes', 3 fields Field Name handle Text ObjectGuid

Type and Size int identity varchar(1470) uniqueidentifier

Default

Nullable NOT NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.Notes' Primary Key Name PK_Notes

Field Name handle

Indexes for table 'dbo.Notes', 1 item Index Name PK_Notes

Clustered Yes

Unique Yes

Fields handle

Dependencies for table 'dbo.Notes', 1 item Object Name dbo.PurgeDocument

Type stored procedure

Table: 'dbo.Printers', 13 fields Field Name handle Flags NetPrintID Description ServerName QueueName

Type and Size int identity bigint varchar(10) varchar(48) varchar(48) varchar(48)

Default

Nullable NOT NULL NULL NULL NULL NULL NULL

Description

PrinterType Spooled NovellFormType DefSize DefSource ServerGUID ObjectGuid

smallint smallint smallint smallint smallint uniqueidentifier uniqueidentifier

NULL NULL NULL NULL NULL NULL NULL

(newid())

Primary key for table 'dbo.Printers' Primary Key Name PK_Printers

Field Name handle

Indexes for table 'dbo.Printers', 15 items Index Name PK_Printers IX_Printers_NetPrintID IX_Printers_Load

Clustered Yes No No

Unique Yes Yes No

IX_Printers_ServerGUID

No

No

Fields handle NetPrintID ServerGUID, handle, Flags, NetPrintID, Description, ServerName, QueueName, PrinterType, Spooled, NovellFormType, DefSize, DefSource ServerGUID

Dependencies for table 'dbo.Printers', 2 items Object Name dbo.CK_Printers_Flags_Unsigned dbo.fnGenerateObjectCounts

Type check cns table function

Table: 'dbo.RequestStatus', 7 fields Field Name handle Flags Item Status UserID ServerGUID ObjectGuid

Type and Size int identity bigint int smallint varchar(22) uniqueidentifier uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.RequestStatus' Primary Key Name PK_RequestStatus

Field Name handle

Indexes for table 'dbo.RequestStatus', 1 item Index Name PK_RequestStatus

Clustered Yes

Unique Yes

Dependencies for table 'dbo.RequestStatus', 2 items Object Name dbo.CK_RequestStatus_Flags_Unsigned dbo.DeleteDocument

Table: 'dbo.SecureDocsContacts', 6 fields

Type check cns stored procedure

Fields handle

Field Name WM_UID WM_EMail WM_Password WM_Date REMOTE_ADDR Admin

Type and Size numeric() identity(18) varchar(250) varchar(250) datetime varchar(50) tinyint

Default

Nullable NOT NULL

Description

NOT NULL NOT NULL NULL NULL NULL

Primary key for table 'dbo.SecureDocsContacts' Primary Key Name PK_SecureDocsContacts

Field Name WM_UID

Indexes for table 'dbo.SecureDocsContacts', 1 item Index Name PK_SecureDocsContacts

Clustered No

Unique Yes

Fields WM_UID

Table: 'dbo.SecureDocsRecipients', 3 fields Field Name Handle Recipient TimeStmp

Type and Size int varchar(255) datetime

Default

Nullable NOT NULL NOT NULL NOT NULL

(getdate())

Description

Primary key for table 'dbo.SecureDocsRecipients' Primary Key Name PK_SecureDocsRecipients

Field Name Handle

Indexes for table 'dbo.SecureDocsRecipients', 3 items Index Name PK_SecureDocsRecipients IX_SecureDocsRecipients

Clustered No Yes

Unique Yes No

Fields Handle TimeStmp, Recipient

Table: 'dbo.Signatures', 11 fields Field Name handle Flags SignID SignOwner SignFile SignDesc SignUsers_0 SignUsers_1 SignUsers_2 ServerGUID ObjectGuid

Type and Size int identity bigint varchar(22) varchar(22) varchar(14) varchar(36) varchar(22) varchar(22) varchar(22) uniqueidentifier uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.Signatures' Primary Key Name PK_Signatures

Field Name handle

Indexes for table 'dbo.Signatures', 14 items Index Name PK_Signatures

Clustered Yes

Unique Yes

Fields handle

IX_Signatures_SignID IX_Signatures_Load

No No

Yes No

IX_Signatures_ServerGUID IX_Signatures_SignOwner

No No

No No

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

Dependencies for table 'dbo.Signatures', 2 items Object Name dbo.CK_Signatures_Flags_Unsigned dbo.fnGenerateObjectCounts

Type check cns table function

Table: 'dbo.StatDescs', 8 fields, Descriptions for statistics created by RightFax services Field Name ID ModuleName

Type and Size int identity varchar(128)

Default

Nullable NOT NULL NOT NULL

StatisticName IndexingFormat

varchar(128) varchar(128)

NOT NULL NULL

Expiration

int

NULL

RequiresAdmin

bit

NOT NULL

MinValue

varchar(50)

NULL

MaxValue

varchar(50)

NULL

Description Primary Key Name of module hosting statistic Name of statistic Format for indexing or null, if none. Expiration of values in seconds or null, if never. True to indicate this statistic can only be viewed by administrators Minimum value this statistic is expected to have or null if none. Maximum value this statistic is expected to have or null if none.

Primary key for table 'dbo.StatDescs' Primary Key Name PK_StatDescs

Field Name ID

Indexes for table 'dbo.StatDescs', 3 items Index Name PK_StatDescs IX_StatDescs

Clustered Yes No

Unique Yes Yes

Fields ID ModuleName, StatisticName

Table: 'dbo.StatLives', 6 fields Field Name Instance ModuleName

Type and Size uniqueidentifier varchar(128)

Default

Nullable NOT NULL NOT NULL

Description Execution instance. Name of the host module whose lifetime is being tracked.

ConfigurationInstanc e

varchar(50)

NOT NULL

FirstPulse

datetime

NOT NULL

LastPulse NextPulse

datetime datetime

NOT NULL NOT NULL

Service configuration instance (e.g., the 1 in WorkSrv1). First pulse received. Last pulse received. Next time the host anticipated it would pulse.

Primary key for table 'dbo.StatLives' Primary Key Name PK_StatLives

Field Name Instance

Indexes for table 'dbo.StatLives', 3 items Index Name PK_StatLives IX_StatLives IX_StatLives_ModuleName

Clustered Yes No No

Unique Yes Yes No

Fields Instance Instance ModuleName

Table: 'dbo.StatRangeValues', 4 fields Field Name ID StatDescsID

Type and Size int identity int

Default

Nullable NOT NULL NOT NULL

Indexer

varchar(50)

NOT NULL

Data

varchar(128)

NOT NULL

Description ID of item in StatDescs table this range value is an instance of Specific statistic index for range values that are index range values or null, if none Value of this range value

Primary key for table 'dbo.StatRangeValues' Primary Key Name PK_StatRangeValues

Field Name ID

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

Primary StatDescs.ID

Indexes for table 'dbo.StatRangeValues', 4 items Index Name PK_StatRangeValues IX_StatRangeValues

Clustered Yes No

Unique Yes Yes

Fields ID StatDescsID, Indexer, Data

Table: 'dbo.StatValues', 6 fields, Values for statistics output by RightFax services Field Name ID

Type and Size int identity

Default

Nullable NOT NULL

Description

StatDescsID

int

NOT NULL

StatLivesInstance Recorded

uniqueidentifier datetime

NOT NULL NOT NULL

Indexer

varchar(128)

NOT NULL

Data

varchar(128)

NOT NULL

ID of item in StatDescs table this value is an instance of Time this statistic was recorded Specific statistic index for statistics that are indexable or null, if none Value of this statistic

Primary key for table 'dbo.StatValues' Primary Key Name PK_StatValues

Field Name ID

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

Primary StatDescs.ID StatLives.Instance

Indexes for table 'dbo.StatValues', 2 items Index Name PK_StatValues IX_StatValues

Clustered Yes No

Unique Yes No

Fields ID Recorded

Dependencies for table 'dbo.StatValues', 1 item Object Name dbo.GetStatistics

Type stored procedure

Table: 'dbo.SystemMessages', 9 fields Field Name SysMsgType SysMsgDBA SysMsgUserID handle

Type and Size int int varchar(22) int identity

SysMsgInfo SysMsgUL1 ServerGUID ObjectGuid Dequeued

varchar(24) bigint uniqueidentifier uniqueidentifier bit

Default

Nullable NULL NULL NULL NOT NULL

Description Handle to the fax Handle of object this message refers to, if any

NULL NULL NULL NULL NOT NULL

(newid()) ((0))

Primary key for table 'dbo.SystemMessages' Primary Key Name PK_SystemMessages

Field Name handle

Indexes for table 'dbo.SystemMessages', 8 items Index Name PK_SystemMessages

Clustered Yes

Unique Yes

Fields handle

IX_SystemMessages

No

No

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

Dependencies for table 'dbo.SystemMessages', 4 items Object Name dbo.CK_SystemMessages_SysMsgType_Unsigned dbo.CK_SystemMessages_SysMsgUL1_Unsigned dbo.DeleteDocument dbo.GetNextSystemMessage

Type check cns check cns stored procedure stored procedure

Table: 'dbo.TermStatToStatusCode', 3 fields Field Name handle StatusCode Description

Type and Size int int varchar(40)

Default

Nullable NOT NULL NULL NULL

Description

Primary key for table 'dbo.TermStatToStatusCode' Primary Key Name PK_TermStatToStatusCode

Field Name handle

Indexes for table 'dbo.TermStatToStatusCode', 1 item Index Name PK_TermStatToStatusCode

Clustered Yes

Unique Yes

Fields handle

Table: 'dbo.TimeEvents', 7 fields Field Name handle EventDateTime TimedFRDBA Converting NumPages ServerGUID ObjectGuid

Type and Size int identity datetime int smallint smallint uniqueidentifier uniqueidentifier

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL

(newid())

Description

Primary key for table 'dbo.TimeEvents' Primary Key Name PK_TimeEvents

Field Name handle

Indexes for table 'dbo.TimeEvents', 3 items Index Name Clustered PK_TimeEvents Yes IX_TimeEvents_EventDateT No ime IX_TimeEvents_TimedFRDBANo

Unique Yes No

Fields handle EventDateTime

No

TimedFRDBA

Table: 'dbo.UserFolders', 8 fields Field Name handle Owner Flags Type

Type and Size int identity int bigint bigint

Default

Nullable NOT NULL NULL NULL NULL

Description

FolderName ID ParentID ObjectGuid

varchar(255) bigint bigint uniqueidentifier

NULL NOT NULL NULL NOT NULL

(newid())

Primary key for table 'dbo.UserFolders' Primary Key Name PK_UserFolders

Field Name handle

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

Primary Users.handle

Indexes for table 'dbo.UserFolders', 7 items Index Name PK_UserFolders IX_UserFolders_FolderNam e_ParentID_Owner IX_UserFolders_Owner_ID IX_UserFolders

Clustered Yes No

Unique Yes Yes

No No

Yes No

Fields handle FolderName, ParentID, Owner Owner, ID Owner

Dependencies for table 'dbo.UserFolders', 9 items Object Name dbo.CK_UserFolders_Flags_Unsigned dbo.CK_UserFolders_ID_Unsigned dbo.CK_UserFolders_ParentID_Unsigned dbo.CK_UserFolders_Type_Unsigned dbo.fnGetChildrenOfFolder dbo.fnGetChildrenOfFolder2 dbo.fnGetFolderFromID dbo.fnGetFolderNameFromID dbo.InsertBaseRecords

Type check cns check cns check cns check cns inline function table function table function scalar function stored procedure

Table: 'dbo.UserPagerNotify', 10 fields Field Name ID Owner Flags Type PagerID ServiceName Types1 Types2 CSIDList ObjectGuid

Type and Size int identity int bigint bigint varchar(64) varchar(22) bigint bigint varchar(256) uniqueidentifier

Default

Nullable NOT NULL NOT NULL NULL NOT NULL NULL NULL NULL NULL NULL NULL

(newid())

Primary key for table 'dbo.UserPagerNotify' Primary Key Name PK_UserPagerNotify

Field Name ID

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

Indexes for table 'dbo.UserPagerNotify', 1 item

Primary Users.handle

Description

Index Name PK_UserPagerNotify

Clustered Yes

Unique Yes

Fields ID

Dependencies for table 'dbo.UserPagerNotify', 4 items Object Name dbo.CK_UserPagerNotify_Flags_Unsigned dbo.CK_UserPagerNotify_Type_Unsigned dbo.CK_UserPagerNotify_Types1_Unsigned dbo.CK_UserPagerNotify_Types2_Unsigned

Type check cns check cns check cns check cns

Table: 'dbo.UserRouteType', 3 fields Field Name handle RouteType RouteTypeDescription

Type and Size int varchar(10) varchar(30)

Default

Nullable NOT NULL NULL NULL

Description

Primary key for table 'dbo.UserRouteType' Primary Key Name PK_UserRouteType

Field Name handle

Indexes for table 'dbo.UserRouteType', 1 item Index Name PK_UserRouteType

Clustered Yes

Unique Yes

Fields handle

Table: 'dbo.Users', 84 fields Field Name handle GroupID UserFlags UserID UserName Password UserDIDNumber FCSModelName NotifyType STDIDNum STGenFaxNum STCallback STOperNum STFromName STFromPhone STToFaxNum STToContactNum STToName STToCompany STToCityState AutoPrintNetPrintID DefaultPrinter WebImageFormat LastUpgradedFolderID AutoSentPrinter AutoPrintFlags SubscriberID UserFlags2 HighestPriority DefaultPriority NewDocNotifyUser

Type and Size int identity int bigint varchar(22) varchar(29) varchar(34) bigint varchar(14) int varchar(32) varchar(32) smallint varchar(32) varchar(60) varchar(32) varchar(32) varchar(32) varchar(60) varchar(60) varchar(60) varchar(10) varchar(10) smallint smallint varchar(10) int bigint bigint smallint smallint varchar(22)

Default

Nullable NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Description

RouteType RouteFmt AFPhone SendNotify ReceiveNotify UpdateInterval AutoDelete DefaultViewScale AutoOCRFlags AutoOCRLayout AutoOCRFormat AutoOCRExt AFUser RouteDeleteAfter ChangeTag RouteInfo NWDSName Folders OtherPBID_0 OtherPBID_1 OtherPBID_2 OtherPBID_3 OtherPBPass_0 OtherPBPass_1 OtherPBPass_2 OtherPBPass_3 RPOStartPage RPOEndPage RPOFlags RPORes RPOSize RPOSource RPOOutputBin RPODuplex RPOSecurityCode RPOCopies EmailRouteForm RPOAcctCode RPOPriority RPOOther DefaultBI1 DefaultBI2 SID EmailAddr SMSServiceID MobileAddr NotifyInfo ObjectGuid UsnCreated UsnUpdated SyncGuid SyncSource SyncUSN

smallint smallint varchar(32) int int int int int int smallint smallint varchar(4) smallint smallint bigint varchar(100) varchar(80) varchar(256) varchar(22) varchar(22) varchar(22) varchar(22) varchar(34) varchar(34) varchar(34) varchar(34) smallint smallint smallint smallint smallint smallint smallint smallint int smallint smallint binary(8) smallint smallint varchar(16) varchar(16) varchar(88) varchar(256) varchar(22) varchar(32) varchar(100) uniqueidentifier bigint bigint varchar(128) varchar(32) bigint

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid()) ((0)) ((0))

Primary key for table 'dbo.Users' Primary Key Name PK_Users

Field Name handle

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

Primary Groups.handle

Indexes for table 'dbo.Users', 10 items Index Name PK_Users IX_Users_UserID IX_Users_GroupID IX_Users_NotifyInfo IX_Users_NWDSName IX_Users_RouteInfo IX_Users_SID IX_Users_SMSServiceID IX_Users_SuberscriberID IX_Users_UserDIDNumber

Clustered Yes No No No No No No No No No

Unique Yes Yes No No No No No No No No

Fields handle UserID GroupID NotifyInfo NWDSName RouteInfo SID SMSServiceID SubscriberID UserDIDNumber

Triggers for table 'dbo.Users', 2 items Name OnInsertUsersUsn OnUpdateUsersUsn

Type after INSERT after UPDATE

Enabled Yes Yes

Dependencies for table 'dbo.Users', 57 items Object Name dbo.CK_Users_AFUser_Unsigned dbo.CK_Users_AutoDelete_Unsigned dbo.CK_Users_AutoOCRFlags_Unsigned dbo.CK_Users_AutoOCRFormat_Unsigned dbo.CK_Users_AutoOCRLayout_Unsigned dbo.CK_Users_AutoPrintFlags_Unsigned dbo.CK_Users_ChangeTag_Unsigned dbo.CK_Users_DefaultPriority_Unsigned dbo.CK_Users_DefaultViewScale_Unsigned dbo.CK_Users_EmailRouteForm_Unsigned dbo.CK_Users_HighestPriority_Unsigned dbo.CK_Users_LastUpgradedFolderID_Unsigned dbo.CK_Users_NotifyType_Unsigned dbo.CK_Users_ReceiveNotify_Unsigned dbo.CK_Users_RouteDeleteAfter_Unsigned dbo.CK_Users_RouteFmt_Unsigned dbo.CK_Users_RouteType_Unsigned dbo.CK_Users_RPOCopies_Unsigned dbo.CK_Users_RPODuplex_Unsigned dbo.CK_Users_RPOFlags_Unsigned dbo.CK_Users_RPOOther_Unsigned dbo.CK_Users_RPOOutputBin_Unsigned dbo.CK_Users_RPOPriority_Unsigned dbo.CK_Users_RPORes_Unsigned dbo.CK_Users_RPOSecurityCode_Unsigned dbo.CK_Users_RPOSize_Unsigned dbo.CK_Users_RPOSource_Unsigned dbo.CK_Users_SendNotify_Unsigned dbo.CK_Users_SubscriberID_Unsigned dbo.CK_Users_UpdateInterval_Unsigned dbo.CK_Users_UserDIDNumber_Unsigned dbo.CK_Users_UserFlags_Unsigned dbo.CK_Users_UserFlags2_Unsigned dbo.CK_Users_WebImageFormat_Unsigned dbo.fnDelegatorsFromID dbo.fnGenerateGroupContents dbo.fnGenerateObjectCounts dbo.fnGetAgedDocuments dbo.fnGetGroupIDFromUserHandle dbo.fnGetUserCountForGroup

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns inline function table function table function inline function scalar function scalar function

dbo.fnGroupMembers dbo.fnGroupMembersFromID dbo.fnIsAdmin dbo.fnUserHandleFromID dbo.fnUserIDFromHandle dbo.fnUserNameFromHandle dbo.fnViewDocTransactions dbo.fnViewDocuments dbo.fnViewUserSettings dbo.GroupsFull dbo.InsertBaseRecords dbo.OnInsertUsersUsn dbo.OnUpdateDocumentsUsn dbo.OnUpdateUsersUsn dbo.RFView_UserPhoneEntries dbo.RFView_UserPhoneGroups dbo.UsersFull

inline function inline function scalar function scalar function scalar function scalar function table function table function table function view stored procedure trigger trigger trigger view view view

Table: 'dbo.UserViews', 23 fields Field Name handle Owner ID ViewName Comment AndFlags AndNotFlags OrFlags OrNotFlags AndFlags2 AndNotFlags2 OrFlags2 OrNotFlags2 StartTime EndTime StatusList StatusNotList DocTypes UserIDList GroupIDList GeneralList AniMatch ObjectGuid

Type and Size int identity int bigint varchar(255) varchar(255) bigint bigint bigint bigint bigint bigint bigint bigint datetime datetime varchar(255) varchar(255) int varchar(255) varchar(255) varchar(500) varchar(32) uniqueidentifier

Default

Nullable NOT NULL NULL NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NOT NULL

(newid())

Description

Primary key for table 'dbo.UserViews' Primary Key Name PK_UserViews

Field Name handle

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

Primary Users.handle

Indexes for table 'dbo.UserViews', 5 items Index Name Clustered PK_UserViews Yes IX_UserViews_Owner_ID No IX_UserViews_ViewName_OwNo ner

Unique Yes Yes Yes

Fields handle Owner, ID ViewName, Owner

Dependencies for table 'dbo.UserViews', 11 items Object Name dbo.CK_UserViews_AndFlags_Unsigned dbo.CK_UserViews_AndFlags2_Unsigned dbo.CK_UserViews_AndNotFlags_Unsigned dbo.CK_UserViews_AndNotFlags2_Unsigned dbo.CK_UserViews_ID_Unsigned dbo.CK_UserViews_OrFlags_Unsigned dbo.CK_UserViews_OrFlags2_Unsigned dbo.CK_UserViews_OrNotFlags_Unsigned dbo.CK_UserViews_OrNotFlags2_Unsigned dbo.fnGetUserViewFromID dbo.fnGetUserViews

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns table function inline function

Table: 'dbo.WorkRequests', 94 fields Field Name handle BaseFlags BaseRequestType hOwner BaseRequestTime BaseRequestKey1 BaseRecType ServerGUID SourceDir OutputDir OutputFile FineMode CoverSheet UserID FormNum MergeOpts FormHeight Print_PrinterID Print_StartPage Print_EndPage Print_PrintCover Print_Flags Print_Res Print_Size Print_Source Print_DeleteDoc Print_UserID Print_ZeroByte Print_OutputBin Print_JobType Print_Priority Print_AcctCode Print_SecurityCode Print_Duplex Print_Copies DeleteDoc MsgType MsgText Network PostOffice FileFormat OCRError GenMailType EmailRouteForm MailAddrCont

Type and Size int identity bigint bigint int datetime varchar(10) bigint uniqueidentifier varchar(128) varchar(128) varchar(14) bit bit varchar(22) smallint smallint smallint varchar(10) smallint smallint smallint smallint tinyint tinyint tinyint bit varchar(22) smallint smallint smallint smallint binary(8) int smallint smallint bit smallint varchar(200) varchar(20) varchar(20) int smallint smallint smallint varchar(52)

Default

Nullable NOT NULL NOT NULL NULL NOT NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Description

MailAddr ToName Destination FilePath NotifyType NotifyChannel ProdDoc BillInfo1 BillInfo2 PhoneNum OCRFlags Startpage Endpage Layout Format OutputName LogicalSourceDir_0 LogicalSourceDir_1 LogicalSourceDir_2 LogicalSourceDir_3 LogicalSourceDir_4 LogicalSourceDir_5 LogicalSourceDir_6 LogicalSourceDir_7 LogicalSourceDir_8 LogicalSourceDir_9 LogicalSourceDir_10 LogicalSourceDir_11 SourceFile_0 SourceFile_1 SourceFile_2 SourceFile_3 SourceFile_4 SourceFile_5 SourceFile_6 SourceFile_7 SourceFile_8 SourceFile_9 SourceFile_10 SourceFile_11 AltAddress RetryCount WhenToTry ReplyType MessageID NextUserID UID ObjectGuid ArchiveFax

varchar(100) varchar(60) varchar(32) varchar(72) int int bit varchar(16) varchar(16) varchar(32) smallint smallint smallint smallint smallint varchar(14) smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint smallint varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(14) varchar(100) smallint bigint int varchar(16) varchar(22) uniqueidentifier uniqueidentifier smallint

NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

(newid())

Primary key for table 'dbo.WorkRequests' Primary Key Name PK_WorkRequests

Field Name handle

Indexes for table 'dbo.WorkRequests', 2 items Index Name Clustered PK_WorkRequests Yes IX_WorkRequests_BaseRequ No estTime

Dependencies for table 'dbo.WorkRequests', 24 items

Unique Yes No

Fields handle BaseRequestTime

Object Name dbo.CK_WorkRequests dbo.CK_WorkRequests_BaseFlags_Unsigned dbo.CK_WorkRequests_BaseRecType_Unsigned dbo.CK_WorkRequests_BaseRequestType_Unsigned dbo.CK_WorkRequests_EmailRouteForm_Unsigned dbo.CK_WorkRequests_FileFormat_Unsigned dbo.CK_WorkRequests_GenMailType_Unsigned dbo.CK_WorkRequests_NotifyChannel_Unsigned dbo.CK_WorkRequests_NotifyType_Unsigned dbo.CK_WorkRequests_Print_Copies_Unsigned dbo.CK_WorkRequests_Print_Duplex_Unsigned dbo.CK_WorkRequests_Print_Flags_Unsigned dbo.CK_WorkRequests_Print_JobType_Unsigned dbo.CK_WorkRequests_Print_OutputBin_Unsigned dbo.CK_WorkRequests_Print_PrintCover_Unsigned dbo.CK_WorkRequests_Print_Priority_Unsigned dbo.CK_WorkRequests_Print_SecurityCode_Unsigned dbo.CK_WorkRequests_Print_ZeroByte_Unsigned dbo.CK_WorkRequests_ReplyType_Unsigned dbo.CK_WorkRequests_WhenToTry_Unsigned dbo.DeleteDocument dbo.fnGenerateObjectCounts dbo.fnWorkRequestCounts dbo.PurgeDocument

Type check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns check cns stored procedure table function table function stored procedure

Views, 15 items View: '50 801 103 12 re."dbo.CurrentWorkRequestCounts"' Field Name

Type and Size

View: 'COLUMN."dbo.DocumentCounts"' Field Name

Type and Size

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

Type and Size

View: 'TABLE."dbo.EventsAll"' Field Name

Type and Size

View: 'S."dbo.EventsTotals"' Field Name

Type and Size

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

Type and Size

View: 'COLUMN."dbo.GlobalizationUntranslated"' Field Name

Type and Size

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

Type and Size

View: 'dbo.ObjectCounts' Field Name CountOf Server Total

Type and Size varchar(25) NULL varchar(40) NULL int NULL

View: 'Indicates this attachment is a RightFax Library Document."dbo.RFView_DocTransactions"' Field Name

Type and Size

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

Type and Size

View: 'COLUMN."dbo.RFView_UserPhoneEntries"' Field Name

Type and Size

View: 'Lib."dbo.RFView_UserPhoneGroups"' Field Name

Type and Size

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

Type and Size

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

Type and Size