HistoricData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigint identity 8 √ null
CLEAR_AUDIT_DEMOGRAPHICS.RECORD_ID Implied ConstraintR
CLEAR_AUDIT_REFERRALS.RECORD_ID Implied ConstraintR
IxView_MacmillanExportAudit.RECORD_ID Implied ConstraintR
ltblSNOMedCT.CT_Concept_ID Implied ConstraintR
tblAUDIT.RECORD_ID Implied ConstraintR
ReferralID int 4 null
ReferralTypeID int 4 null
HistoricDataReferralType.ID HistoricData_ReferralTypeIDR
RecordID varchar 255 null
RecordTypeID int 4 null
HistoricDataRecordType.ID HistoricData_RecordTypeIDR
ReleaseBuildID int 4 null
HistoricDataReleaseBuild.ID HistoricData_ReleaseBuildIDR
DateChanged date 20 null
FieldNameID int 4 null
HistoricDataFieldName.ID HistoricData_FieldNameIDR
OldFieldValue nvarchar 1073741823 null
NewFieldValue nvarchar 1073741823 √ null
WorkItemNumber int 4 null

Indexes

Constraint Name Type Sort Column(s)
HistoricData_ID Primary key Asc ID

Relationships

Close relationships within degrees of separation