tblTREATMENT_SUMMARY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TREATMENT_SUMMARY_ID int identity 4 √ null
tblTREATMENT_SUMMARY_PUBLISHED.TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_tblTREATMENT_SUMMARYC
tblTREATMENT_SUMMARY_REFERRAL_MAPPING.TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_REFERRAL_MAPPING_tblTREATMENT_SUMMARYR
tblTREATMENT_SUMMARY_TOXICITIES_MAPPING.TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_TOXICITIES_MAPPING_tblTREATMENT_SUMMARYR
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblTREATMENT_SUMMARY_tblMAIN_REFERRALSC
ALERT_SYMPTOMS varchar 8000 √ null
SECONDARY_CARE varchar 8000 √ null
PALLIATIVE_CARE_REGISTER int 4 √ null
DS1500_COMPLETED int 4 √ null
CONTACT_IN_HOURS int 4 √ null
CONTACT_OUT_HOURS int 4 √ null
PRESCRIPTION_CHARGE_EXEMPTION int 4 √ null
GP_ACTIONS varchar 8000 √ null
SUMMARY_INFORMATION varchar 8000 √ null
ADDITIONAL_INFORMATION varchar 8000 √ null
AIM_ID int 4 √ null
ltblTREATMENT_SUMMARY_AIM.AIM_ID FK_tblTREATMENT_SUMMARY_ltblTREATMENT_SUMMARY_AIMR
AIM_COMMENTS varchar 8000 √ null
CouldExperianceAdditionslComments varchar 8000 √ null
ACTION_ID int 4 √ null
FLU_JAB int 4 √ null
ltblFLU_JAB_DETAILS.FLU_JAB Implied ConstraintR
DATE_DISCHARGE smalldatetime 16 √ null
DISCHARGE_TEXT int 4 √ null
WHICH_TEAM varchar 255 √ null
COMPLETED_BY_CON int 4 √ null
COMPLETED_BY_CNS int 4 √ null
PATIENT_REC int 4 √ null
ltblPAT_RECEIVED_TREATMENT_SUMMARY.PATIENT_REC Implied ConstraintR
DATE_ADMINISTERED smalldatetime 16 √ null
REASONS_NO_JAB varchar 255 √ null
DATE_LAST_SAVED smalldatetime 16 √ null
LAST_EDITED_BY varchar 50 √ null
GP int 4 √ null
GPPractice int 4 √ null
GPBranch int 4 √ null
IntroText nvarchar 1073741823 √ null
AtRistOfAdditionalComments varchar 8000 √ null
ReasonNoHNA varchar 255 √ null
LeadConsultant int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblTREATMENT_SUMMARY Primary key Asc TREATMENT_SUMMARY_ID
IX_tblTREATMENT_SUMMARY_CARE_ID Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation