ltblCONSULTANTS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CON_ID int identity 4 √ null
lnkAO_ASSESSED_BY_CONSULTANT.ConsultantID FK_lnkAO_ASSESSED_BY_CONSULTANT_ltblCONSULTANTSR
lnkAO_ASSESSED_BY_CONSULTANT_MSCC.ConsultantID FK_lnkAO_ASSESSED_BY_CONSULTANT_MSCC_ltblCONSULTANTSR
lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS.ConsultantID FK_lnkAO_ASSESSED_BY_CONSULTANT_NEUTROPENIC_SEPSIS_ltblCONSULTANTSR
tblMDT_LIST.MDTLeadID FK_tblMDT_LIST_ltblCONSULTANTSR
tblMDT_MEETINGS.MDTLeadID FK_tblMDT_MEETINGS_ltblCONSULTANTSR
tblUNPLANNED_RETURN_TO_THEATRE.CON_ID FK_tblUNPLANNED_RETURN_TO_THEATRE_ltblCONSULTANTSR
NATIONAL_CODE varchar 8 null
CON_CODE varchar 6 √ null
CON_DESC varchar 50 null
SPEC_CODE int 4 null
TITLE varchar 5 √ null
DEPT char 1 √ null
COLORECTAL int 4 √ null
GRADE varchar 10 √ null
BAUS int 4 √ null
IS_DELETED bit 1 ((0))
UNKNOWN bit 1 √ null
ProfessionalRegistrationBody int 4 √ null
ProfessionalRegistrationBody.ID FK_ltblCONSULTANTS_ProfessionalRegistrationBodyR

Indexes

Constraint Name Type Sort Column(s)
PK_ltblCONSULTANTS Primary key Asc CON_ID
IX_ltblCONSULTANTS Performance Asc CON_DESC
IX_ltblCONSULTANTS_1 Performance Asc SPEC_CODE

Relationships

Close relationships within degrees of separation