tblMDT_LIST


Columns

Column Type Size Nulls Auto Default Children Parents Comments
MDT_ID int identity 4 √ null
tblMDTMoves.MDT_ID FK_tblMDTMoves_tblMDT_LIST_MDT_IDR
tblMDTMoves.MeetingIDFrom FK_tblMDTMoves_tblMDT_LIST_FromR
tblMDTMoves.MeetingIDTo FK_tblMDTMoves_tblMDT_LIST_ToR
tblPalliativeMDTMoves.MeetingIDFrom FK_tblPalliativeMDTMoves_tblMDT_LIST_FromR
tblPalliativeMDTMoves.MeetingIDTo FK_tblPalliativeMDTMoves_tblMDT_LIST_ToR
MEETING_ID int 4 √ null
MDT_DATE smalldatetime 16 √ null
OTHER_SITE varchar 50 √ null
PT_ORDER int 4 √ null
PATIENT_ID int 4 √ null
CARE_ID int 4 √ null
PRE_POST varchar 4 √ null
DONE int 4 √ null
PREP int 4 √ null
COMMENTS varchar 255 √ null
RADIOLOGY_COMMENTS varchar 255 √ null
HISTOLOGY_COMMENTS varchar 255 √ null
MDT_COMMENTS text 2147483647 √ null
LAST_SAVED datetime 16,3 √ null
ROOT_CAUSE_COMMENTS text 2147483647 √ null
NEXT_OPA datetime 16,3 √ null
TO_BE_SEEN_BY varchar 50 √ null
MDTLeadID int 4 √ null
ltblCONSULTANTS.CON_ID FK_tblMDT_LIST_ltblCONSULTANTSR
CTX bit 1 √ ((0))
MDTDiscussionType int 4 √ null
ltblMDTDiscussionType.ID FK_tblMDT_LIST_ltblMDTDiscussionTypeR

Indexes

Constraint Name Type Sort Column(s)
PK_tblMDT_LIST Primary key Asc MDT_ID
IX_tblMDT_LIST Performance Asc/Asc MEETING_ID + MDT_DATE
IX_tblMDT_LIST_CARE_ID_DONE Performance Asc/Asc CARE_ID + DONE

Relationships

Close relationships within degrees of separation