Diagnostic Schema

Project: SqlServer

Layout: Diagnostic

 

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

 

 

DiagnosticPackage

DiagnosticPackageId

int NOT NULL AUTOINCREMENT

DiagnosticPackageName

nvarchar( 50 ) NOT NULL

HostName

nvarchar( 50 ) NOT NULL

ProductName

nvarchar( 50 ) NOT NULL

Version

nvarchar( 50 ) NOT NULL

DiagnosticDate

datetime NOT NULL

Indexes

 

PK_Diagnostic_DiagnosticPackage primary key

ON DiagnosticPackageId

 

DiagnosticResult

 

DiagnosticResultId

int NOT NULL AUTOINCREMENT

DiagnosticPackageId

int NOT NULL

DiagnosticName

nvarchar( 100 ) NOT NULL

DiagnosticStatusTypeId

int NOT NULL

Message

nvarchar( 300 )

DiagnosticLog

nvarchar(max)

Indexes

 

PK_Diagnostic_DiagnosticResult primary key

ON DiagnosticResultId

Foreign Keys

 

FK_Diagnostic_DiagnosticResult_DiagnosticPackage

( DiagnosticPackageId ) ref DiagnosticPackage (DiagnosticPackageId)

FK_Diagnostic_DiagnosticResult_DiagnosticStatusType

( DiagnosticStatusTypeId ) ref DiagnosticStatusType (DiagnosticStatusTypeId)

 

 

DiagnosticStatusType

DiagnosticStatusTypeId

int NOT NULL

DiagnosticStatusTypeName

nvarchar( 50 ) NOT NULL

Indexes

 

PK_Diagnostic_DiagnosticStatusType primary key

ON DiagnosticStatusTypeId