tblTREATMENT_SUMMARY_PUBLISHED


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PUBLISHED_TREATMENT_SUMMARY_ID int identity 4 √ null
tblTREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN.PUBLISHED_TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_CNS_CARE_PLAN_tblTREATMENT_SUMMARY_PUBLISHEDR
tblTREATMENT_SUMMARY_PUBLISHED_CNS_REFERRALS.PUBLISHED_TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_CNS_REFERRALS_tblTREATMENT_SUMMARY_PUBLISHEDR
tblTREATMENT_SUMMARY_PUBLISHED_REFERRALS.PUBLISHED_TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_REFERRALS_tblTREATMENT_SUMMARY_PUBLISHEDR
tblTREATMENT_SUMMARY_PUBLISHED_TOXICITIES.PUBLISHED_TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_TOXICITIES_tblTREATMENT_SUMMARY_PUBLISHEDR
tblTREATMENT_SUMMARY_PUBLISHED_TREATMENTS.PUBLISHED_TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_TREATMENTS_tblTREATMENT_SUMMARY_PUBLISHEDC
TREATMENT_SUMMARY_ID int 4 null
tblTREATMENT_SUMMARY.TREATMENT_SUMMARY_ID FK_tblTREATMENT_SUMMARY_PUBLISHED_tblTREATMENT_SUMMARYC
KEY_WORKER varchar 50 √ null
CNS_NAME varchar 8000 √ null
HNA_CARRIED_OUT varchar 20 √ null
DIAGNOSIS varchar 250 √ null
DIAGNOSIS_DATE smalldatetime 16 √ null
TUMOUR_STATUS varchar 25 √ null
ORGAN_STAGING varchar 250 √ null
TREATMENT_AIM varchar 25 √ null
TREATMENT_AIM_COMMENTS varchar 8000 √ null
DATE_OF_DEATH smalldatetime 16 √ null
METS_BONE varchar 100 √ null
METS_BONE_EX_MARROW varchar 100 √ null
METS_BONE_MARROW varchar 100 √ null
METS_BRAIN varchar 100 √ null
METS_LYMPH_NODE varchar 100 √ null
METS_LIVER varchar 100 √ null
METS_LOCAL varchar 100 √ null
METS_REGIONAL varchar 100 √ null
METS_LUNG varchar 100 √ null
METS_SKIN varchar 100 √ null
METS_ADRENAL varchar 100 √ null
METS_UNKNOWN varchar 100 √ null
METS_OTHER varchar 350 √ null
CouldExperianceAdditionslComments varchar 8000 √ null
SECONDARY_CARE_COMMENTS varchar 8000 √ null
ADVISE_ENTRY_PAL_CARE varchar 20 √ null
DS1500_COMPLETED varchar 20 √ null
PRESCRIPTION_CHARGE_EXEMPTION varchar 20 √ null
CONTACT_IN_HOURS varchar 200 √ null
CONTACT_OUT_OF_HOURS varchar 200 √ null
CNS_PRIMARY_REFERRAL varchar 200 √ null
CNS_SECONDARY_REFERRAL varchar 200 √ null
GP_ACTIONS varchar 8000 √ null
SUMMARY_INFORMATION varchar 8000 √ null
ADDITIONAL_INFORMATION varchar 8000 √ null
FLU_JAB varchar 50 √ null
FLU_JAB_DATE smalldatetime 16 √ null
REASONS_NO_JAB varchar 255 √ null
DATE_DISCHARGE smalldatetime 16 √ null
DISCHARGE_TEXT varchar 100 √ null
WHICH_TEAM varchar 255 √ null
COMPLETED_BY_CON varchar 75 √ null
COMPLETED_BY_CNS varchar 75 √ null
PATIENT_REC varchar 25 √ null
GP_NAME varchar 100 √ null
GP_ADDR_1 varchar 250 √ null
GP_ADDR_2 varchar 250 √ null
GP_ADDR_3 varchar 250 √ null
GP_ADDR_4 varchar 250 √ null
GP_POSTCODE varchar 10 √ null
PAT_TITLE varchar 50 √ null
PAT_FORENAME varchar 50 √ null
PAT_SURNAME varchar 60 √ null
PAT_ADDR_1 varchar 150 √ null
PAT_ADDR_2 varchar 150 √ null
PAT_ADDR_3 varchar 150 √ null
PAT_ADDR_4 varchar 150 √ null
PAT_ADDR_5 varchar 150 √ null
PAT_POSTCODE varchar 10 √ null
ALERT_SYMPTOMS varchar 2147483647 √ null
DATE_PUBLISHED datetime 16,3 null
PDFGuid uniqueidentifier 16 null
PDFData varbinary 2147483647 null
ACTION_ID int 4 √ null
IntroText nvarchar 1073741823 √ null
NextSteps varchar 250 √ null
AtRistOfAdditionalComments varchar 8000 √ null
PointofPathway varchar 550 √ null
ReasonNoHNA varchar 255 √ null
LeadConsultant varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblTREATMENT_SUMMARY_PUBLISHED Primary key Asc PUBLISHED_TREATMENT_SUMMARY_ID
IX_tblTREATMENT_SUMMARY_PUBLISHED_TREATMENT_SUMMARY_ID Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc TREATMENT_SUMMARY_ID + DATE_PUBLISHED + PUBLISHED_TREATMENT_SUMMARY_ID + COMPLETED_BY_CON + COMPLETED_BY_CNS + PATIENT_REC + GP_NAME + ACTION_ID

Relationships

Close relationships within degrees of separation