tblAUDIT_RECORD


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuditID int identity 4 √ null
tblAO_ASSESSMENT.AuditID Implied ConstraintR
tblAO_COMPLICATIONS_TREATMENT.AuditID Implied ConstraintR
tblAO_MSCC.AuditID Implied ConstraintR
tblAO_NEUTROPENIC_SEPSIS.AuditID Implied ConstraintR
tblAO_OUTCOME.AuditID Implied ConstraintR
tblAO_REFERRAL.AuditID Implied ConstraintR
UserID varchar 50 null
AuditTypeID int 4 null
ltblAUDIT_TYPE.AuditTypeID FK_tblAUDIT_RECORD_ltblAUDIT_TYPER
AuditRecordTypeID int 4 null
ltblAUDIT_RECORD_TYPE.AuditRecordTypeID FK_tblAUDIT_RECORD_ltblAUDIT_RECORD_TYPER
ReferralID int 4 null
RecordID int 4 √ null
AuditDate datetime 16,3 null

Indexes

Constraint Name Type Sort Column(s)
PK_tblAUDIT_RECORD Primary key Asc AuditID

Relationships

Close relationships within degrees of separation