Enterprise Schema

Project: SqlServer

Layout: Enterprise

 

Tip: Click on a table to jump to the field-level descriptions for the table.

 

 

ApplicationEnvironment

 

ApplicationEnvironmentIdentifier

uniqueidentifier NOT NULL DEFO newid()

ProductId

int NOT NULL

ApplicationEnvironmentName

nvarchar( 128 ) NOT NULL DEFO ''

ConfigConnectionString

nvarchar(max)

ConfigDatabaseServerId

int

ConfigDbInstalledVersion

nvarchar( 20 )

ConfigDbCurrentVersion

nvarchar( 20 )

ProductVersion

nvarchar( 20 )

FileVersion

nvarchar( 20 )

Indexes

 

PK_Enterprise_ApplicationEnvironment primary key

ON ApplicationEnvironmentIdentifier

Foreign Keys

 

FK_ApplicationEnvironment_Server

( ConfigDatabaseServerId ) ref DatabaseServer (DatabaseServerId)

FK_ApplicationEnvironment_Product

( ProductId ) ref Product (ProductId)

 

ApplicationEnvironmentProperty

 

ApplicationEnvironmentPropertyId

int NOT NULL AUTOINCREMENT

ApplicationEnvironmentIdentifier

uniqueidentifier NOT NULL

ApplicationEnvironmentPropertyNameId

int NOT NULL

PropertyValue

nvarchar(max) NOT NULL

Indexes

 

PK_ApplicationEnvironmentProperty primary key

ON ApplicationEnvironmentPropertyId

UC_ApplicationEnvironmentProperty_Property unique

ON ApplicationEnvironmentIdentifier, ApplicationEnvironmentPropertyNameId

Foreign Keys

 

FK_ApplicationEnvironmentProperty_Client

( ApplicationEnvironmentIdentifier ) ref ApplicationEnvironment (ApplicationEnvironmentIdentifier)

FK_ApplicationEnvironmentProperty_ClientPropertyName

( ApplicationEnvironmentPropertyNameId ) ref ApplicationEnvironmentPropertyName (ApplicationEnvironmentPropertyNameId)

 

ApplicationEnvironmentPropertyName

ApplicationEnvironmentPropertyNameId

int NOT NULL

PropertyName

nvarchar( 128 ) NOT NULL

Indexes

 

PK_ApplicationEnvironmentPropertyName primary key

ON ApplicationEnvironmentPropertyNameId

 

Audit

AuditId

bigint NOT NULL AUTOINCREMENT

AuditTableId

int NOT NULL

TableRecordPrimaryKeyID

nvarchar( 128 ) NOT NULL

ActivityType

char( 1 ) NOT NULL

ChangeDescription

xml NOT NULL

AuditDate

datetime DEFO getdate()

AuditUserNameHash

binary( 20 )

Indexes

 

PK_Enterprise_Audit primary key

ON AuditId

IX_Audit_Created_LastMod

ON AuditTableId, TableRecordPrimaryKeyID, AuditId

Foreign Keys

 

FK_Enterprise_Audit_AuditTable

( AuditTableId ) ref AuditTable (AuditTableId)

 

AuditTable

 

AuditTableId

int NOT NULL AUTOINCREMENT

TableSchema

nvarchar( 128 ) NOT NULL

TableName

nvarchar( 128 ) NOT NULL

Indexes

 

PK_Enterprise_AuditTable primary key

ON AuditTableId

 

CaseProductEnvironment

CaseProductEnvironmentId

int NOT NULL AUTOINCREMENT

CaseId

int NOT NULL

ProductId

int NOT NULL

ApplicationEnvironmentIdentifier

uniqueidentifier NOT NULL

Name

varchar( 128 ) NOT NULL

Notes

nvarchar(max)

GMTOffset

decimal( 4, 2 )

DatabaseServerId

int

DatabaseConnectionString

varchar(max)

DatabaseName

varchar( 128 )

IsDeleted

bit NOT NULL DEFO 0

Indexes

PK_CaseProductEnvironment primary key

ON CaseProductEnvironmentId

IXU_Enterprise_CPE

ON CaseId, ProductId, ApplicationEnvironmentIdentifier, Name

Foreign Keys

FK_CaseProductEnvironment_Environment

( ApplicationEnvironmentIdentifier ) ref ApplicationEnvironment (ApplicationEnvironmentIdentifier)

FK_CaseProductEnvironment_Case

( CaseId ) ref Cases (CaseId)

FK_CaseProductEnvironment_DatabaseServer

( DatabaseServerId ) ref DatabaseServer (DatabaseServerId)

FK_CaseProductEnvironment_Product

( ProductId ) ref Product (ProductId)

Constraints

CK_CaseProductEnvironment

NOT [Name] like 'eCapture Integration Tests%'

 

CaseProductEnvironmentPin

CaseProductEnvironmentPinId

int NOT NULL AUTOINCREMENT

UserId

uniqueidentifier NOT NULL

CaseProductEnvironmentId

int NOT NULL

Indexes

PK_Enterprise_CaseProductEnvironmentPin primary key

ON CaseProductEnvironmentPinId

 

CaseProductEnvironmentProperty

CaseProductEnvironmentPropertyId

int NOT NULL AUTOINCREMENT

CaseProductEnvironmentId

int NOT NULL

CaseProductEnvironmentPropertyNameId

int NOT NULL

PropertyValue

nvarchar(max) NOT NULL

Indexes

PK_CaseProductEnvironmentProperty primary key

ON CaseProductEnvironmentPropertyId

IX_CaseProductEnvironmentProperty_IdName

ON CaseProductEnvironmentId, CaseProductEnvironmentPropertyNameId

Foreign Keys

FK_CaseProductEnvironmentProperty_Environment

( CaseProductEnvironmentId ) ref CaseProductEnvironment (CaseProductEnvironmentId)

FK_CaseProductEnvironmentProperty_Name

( CaseProductEnvironmentPropertyNameId ) ref CaseProductEnvironmentPropertyName (CaseProductEnvironmentPropertyNameId)

 

CaseProductEnvironmentPropertyName

CaseProductEnvironmentPropertyNameId

int NOT NULL

PropertyName

nvarchar( 128 ) NOT NULL

Indexes

PK_CaseProductEnvironmentPropertyName primary key

ON CaseProductEnvironmentPropertyNameId

IX_CaseProductEnvironmentPropertyName_PropertyName

ON PropertyName

 

Cases

CaseId

int NOT NULL AUTOINCREMENT

CaseName

nvarchar( 100 ) NOT NULL

MatterNumber

nvarchar( 128 )

IsDeleted

bit NOT NULL DEFO 0

ClientId

int NOT NULL

Indexes

PK_Case primary key

ON CaseId

Foreign Keys

FK_Cases_Client

( ClientId ) ref Client (ClientId)

Constraints

CK_Cases

NOT [CaseName] like 'eCapture Integration Test%'

 

Client

ClientId

int NOT NULL AUTOINCREMENT

ManagingClientId

int NOT NULL

Name

nvarchar( 256 ) NOT NULL

IsDeleted

bit NOT NULL

Indexes

PK_Client primary key

ON ClientId

Foreign Keys

FK_Client_ManagingClient

( ManagingClientId ) ref ManagingClient (ManagingClientId)

Constraints

CK_Client

NOT [Name] like 'eCapture Integration Test%'

 

ClientProperty

ClientPropertyId

int NOT NULL AUTOINCREMENT

ClientId

int NOT NULL

ClientPropertyNameId

int NOT NULL

PropertyValue

nvarchar(max) NOT NULL

ApplicationEnvironmentIdentifier

uniqueidentifier NOT NULL DEFO newid()

Indexes

PK_ClientProperty primary key

ON ClientPropertyId

IXU_ClientProperty_ValuePer

ON ClientId, ClientPropertyNameId, ApplicationEnvironmentIdentifier

Foreign Keys

FK_ClientProperty_ApplicationEnvironment

( ApplicationEnvironmentIdentifier ) ref ApplicationEnvironment (ApplicationEnvironmentIdentifier)

FK_ClientProperty_Client

( ClientId ) ref Client (ClientId)

FK_ClientProperty_ClientPropertyName

( ClientPropertyNameId ) ref ClientPropertyName (ClientPropertyNameId)

 

ClientPropertyName

ClientPropertyNameId

int NOT NULL

PropertyName

nvarchar( 128 ) NOT NULL

Indexes

PK_ManagingClientPropertyName_0 primary key

ON ClientPropertyNameId

 

Command

Id

bigint NOT NULL AUTOINCREMENT

CommandId

uniqueidentifier NOT NULL

CommandType

nvarchar( 60 ) NOT NULL

CommandBody

nvarchar(max) NOT NULL

MetaData

nvarchar(max)

Status

nvarchar( 40 ) NOT NULL

Errors

nvarchar(max)

Username

nvarchar( 256 ) NOT NULL

SubmittedOn

datetimeoffset( 34 ) NOT NULL

SendNotifications

bit NOT NULL

Indexes

PK__Command__3214EC070F975522 primary key

ON Id

 

ConfigurationSetting

ConfigurationSettingId

int NOT NULL AUTOINCREMENT

KeyName

nvarchar( 250 ) NOT NULL

Value

nvarchar(max)

Indexes

PK_Enterprise_ConfigurationSetting primary key

ON ConfigurationSettingId

IXU_Enterprise_ConfigurationSetting_UniqueKey unique

ON KeyName

 

CopyStation

Id

int NOT NULL AUTOINCREMENT

Name

nvarchar( 255 ) NOT NULL

MachineName

nvarchar( 1024 )

IpAddress

nvarchar( 15 )

Indexes

PK_ENTERPRISE_COPYSTATION_ID primary key

ON Id

CK_CopyStation_ColumnMachineNameUnique unique

ON MachineName, IpAddress

Constraints

CK_CopyStation_ColumnLocationNotNull

[MachineName] IS NOT NULL OR [IpAddress] IS NOT NULL

CK_CopyStation_ColumnLocationNotNull

[MachineName] IS NOT NULL OR [IpAddress] IS NOT NULL

 

DatabaseServer

DatabaseServerId

int NOT NULL AUTOINCREMENT

ServerName

nvarchar( 128 ) NOT NULL

ServerAddress

varchar( 128 )

DefaultConnectionString

nvarchar( 2000 ) NOT NULL

Indexes

PK_Enterprise_DatabaseServer primary key

ON DatabaseServerId

IXU_Enterprise_ServerName unique

ON ServerName

 

DatabaseVersion

VersionId

int NOT NULL AUTOINCREMENT

VersionNumber

nvarchar( 25 ) NOT NULL

VersionUpdateDate

datetime NOT NULL DEFO getdate()

Indexes

PK_Enterprise_DatabaseVersion primary key

ON VersionId

 

ErrorLogEntry

ErrorLogEntryId

int NOT NULL AUTOINCREMENT

ErrorDate

datetime DEFO getdate()

RequestId

uniqueidentifier NOT NULL

ExceptionMessage

nvarchar(max)

InnerExceptionMessage

nvarchar(max)

StackTrace

nvarchar(max)

TargetSite

nvarchar(max)

BaseExceptionMessage

nvarchar(max)

LineNumber

int NOT NULL

ErrorDetails

varchar(max)

Indexes

PK_Enterprise_ErrorLogEntry primary key

ON ErrorLogEntryId

 

GlobalSetting

GlobalSettingId

int NOT NULL AUTOINCREMENT

CurrentGlobalValue

nvarchar( 256 ) NOT NULL

LastGlobalValue

nvarchar( 256 )

ModifiedDate

datetime NOT NULL

ModifiedBy

nvarchar( 250 ) NOT NULL

 

InstalledComponent

InstalledComponentId

int NOT NULL AUTOINCREMENT

Name

nvarchar( 50 ) NOT NULL

InstalledComponentTypeId

int NOT NULL

LastCheckIn

datetime NOT NULL

InstanceCount

int NOT NULL

Version

nvarchar( 50 )

HostName

nvarchar( 50 )

IpAddress1

nvarchar( 50 )

IpAddress2

nvarchar( 50 )

Port

int NOT NULL

OperatingSystem

nvarchar( 150 )

TotalCores

int NOT NULL

RamGB

int NOT NULL

ApplicationEnvironmentIdentifier

uniqueidentifier

IsOnline

bit NOT NULL DEFO 1

Endpoint

nvarchar( 1024 )

ComponentIdentifier

uniqueidentifier

Status

nvarchar( 50 )

Indexes

PK_Enterprise_InstalledComponent primary key

ON InstalledComponentId

idx_InstalledComponent_ApplicationId

ON ApplicationEnvironmentIdentifier

Foreign Keys

FK_InstalledComponent_ApplicationEnvironment

( ApplicationEnvironmentIdentifier ) ref ApplicationEnvironment (ApplicationEnvironmentIdentifier)

FK_Enterprise_InstalledComponent_InstalledComponentType

( InstalledComponentTypeId ) ref InstalledComponentType (InstalledComponentTypeId)

 

InstalledComponentType

InstalledComponentTypeId

int NOT NULL

Descr

varchar( 100 ) NOT NULL

Indexes

PK_Enterprise_InstalledComponentType primary key

ON InstalledComponentTypeId

 

ManagingClient

ManagingClientId

int NOT NULL AUTOINCREMENT

Name

nvarchar( 256 ) NOT NULL

Notes

nvarchar(max)

IndexDirectory

nvarchar( 256 )

ExhibitPath

nvarchar( 256 )

IsHost

bit NOT NULL

IsDeleted

bit NOT NULL

Indexes

PK_ManagingClient primary key

ON ManagingClientId

IXU_ManagingClient_Name unique

ON Name

 

ManagingClientProperty

ManagingClientPropertyId

int NOT NULL AUTOINCREMENT

ManagingClientId

int NOT NULL

ManagingClientPropertyNameId

int NOT NULL

ProductId

int

PropertyValue

nvarchar(max) NOT NULL

Indexes

PK_ManagingClientProperty primary key

ON ManagingClientPropertyId

UC_ManagingClientProperty_Property_Product unique

ON ManagingClientId, ProductId, ManagingClientPropertyNameId

Foreign Keys

FK_ManagingClientProperty_Client

( ManagingClientId ) ref ManagingClient (ManagingClientId)

FK_ManagingClientProperty_ClientPropertyName

( ManagingClientPropertyNameId ) ref ManagingClientPropertyName (ManagingClientPropertyNameId)

FK_ManagingClientProperty_Product

( ProductId ) ref Product (ProductId)

 

ManagingClientPropertyName

ManagingClientPropertyNameId

int NOT NULL

PropertyName

nvarchar( 128 ) NOT NULL

Indexes

PK_ManagingClientPropertyName primary key

ON ManagingClientPropertyNameId

 

OpenCaseProductEnvironmentLog

OpenCaseProductEnvironmentLogId

int NOT NULL AUTOINCREMENT

UserId

uniqueidentifier NOT NULL

CaseProductEnvironmentId

int NOT NULL

Indexes

PK_Enterprise_OpenCaseProductEnvironmentLog primary key

ON OpenCaseProductEnvironmentLogId

 

Product

ProductId

int NOT NULL

Name

nvarchar( 50 ) NOT NULL

Indexes

PK_Product primary key

ON ProductId

 

ReviewUserSession

ReviewUserSessionId

uniqueidentifier NOT NULL DEFO newsequentialid()

Username

nvarchar( 100 ) NOT NULL

ClientId

nvarchar( 100 ) NOT NULL

CaseProductEnvironmentId

int

AuthSessionId

int NOT NULL

LoginDate

datetime NOT NULL

LastCommunicationDate

datetime NOT NULL

Ip

varchar( 45 ) NOT NULL

Message

nvarchar( 1000 )

HasAcknowledgedMessage

bit NOT NULL

Indexes

PK_Enterprise_ReviewUserSession primary key

ON ReviewUserSessionId

 

Session

SessionId

bigint NOT NULL AUTOINCREMENT

ClientId

nvarchar( 100 ) NOT NULL

Username

nvarchar( 100 ) NOT NULL

RefreshToken

nvarchar( 100 ) NOT NULL

SerializedAuthTicket

nvarchar(max) NOT NULL

IssuedDate

datetime DEFO getutcdate()

Indexes

PK_Enterprise_Session primary key

ON SessionId

 

View vAuditCreatedByModifiedBy

________________

Enterprise 2017.4.0