ltblTEMP_NHS_NUMBERS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TEMP_ID varchar 255 null
aaPALQ1CURRYEAR.TEMP_ID Implied ConstraintR
bktblINITIAL_ASSESSMENT.TEMP_ID Implied ConstraintR
DEPRECATED_21_01_bk_tblMAIN_IMAGING.TEMP_ID Implied ConstraintR
tblBREAST_VISITS.TEMP_ID Implied ConstraintR
tblDEMOGRAPHICS.TEMP_ID Implied ConstraintR
tblDERMATOLOGY_RECURRENCES.TEMP_ID Implied ConstraintR
tblFAMILY_HISTORY.TEMP_ID Implied ConstraintR
tblFamilyHistoryBackup.TEMP_ID Implied ConstraintR
tblINPATIENT_ADMISSIONS.TEMP_ID Implied ConstraintR
tblMAIN_ASSESSMENT.TEMP_ID Implied ConstraintR
tblMAIN_BRACHYTHERAPY.TEMP_ID Implied ConstraintR
tblMAIN_CARE_PLAN.TEMP_ID Implied ConstraintR
tblMAIN_CHEMO_TREATMENT.TEMP_ID Implied ConstraintR
tblMAIN_CHEMOTHERAPY.TEMP_ID Implied ConstraintR
tblMAIN_IMAGING.TEMP_ID Implied ConstraintR
tblMAIN_PALLIATIVE.TEMP_ID Implied ConstraintR
tblMAIN_PATHOLOGY.TEMP_ID Implied ConstraintR
tblMAIN_REFERRALS.TEMP_ID Implied ConstraintR
tblMAIN_SURGERY.TEMP_ID Implied ConstraintR
tblMAIN_TELETHERAPY.TEMP_ID Implied ConstraintR
tblMAIN_TRIAL.TEMP_ID Implied ConstraintR
tblMONITORING.TEMP_ID Implied ConstraintR
tblPALLIATIVE_CARE.TEMP_ID Implied ConstraintR
tblPALLIATIVE_CONTACT.TEMP_ID Implied ConstraintR
tblPALLIATIVE_CONTACT_BACK_UP.TEMP_ID Implied ConstraintR
tblPALLIATIVE_INPATIENTS.TEMP_ID Implied ConstraintR
tblPALLIATIVE_MDT.TEMP_ID Implied ConstraintR
tblPOSSUM_SCORE.TEMP_ID Implied ConstraintR
tblSCORES.TEMP_ID Implied ConstraintR
tblSUPPORTIVE_TREATMENT.TEMP_ID Implied ConstraintR
vwAHP_CONTACTS_CONV.TEMP_ID Implied ConstraintR
vwAHP_CONTACTS_CONV2.TEMP_ID Implied ConstraintR
vwBAUS_CYSTECTOMY.TEMP_ID Implied ConstraintR
vwBAUS_CYSTECTOMY_PATHOLOGY.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY_PATHOLOGIES_LEFT.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY_PATHOLOGIES_RIGHT.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY_PATHOLOGY.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY_PATHOLOGY_LEFT.TEMP_ID Implied ConstraintR
vwBAUS_NEPHRECTOMY_PATHOLOGY_RIGHT.TEMP_ID Implied ConstraintR
vwBAUS_POST_TREAT_PATHOLOGY.TEMP_ID Implied ConstraintR
vwBAUS_PRE_TREAT_BIOPSY.TEMP_ID Implied ConstraintR
vwBAUS_PROSTATECTOMY.TEMP_ID Implied ConstraintR
vwBAUS_PROSTATECTOMY_PATHOLOGY.TEMP_ID Implied ConstraintR
vwBREAST_SURGERY.TEMP_ID Implied ConstraintR
vwCARE_PLAN_SUMMARY_TRANSFERS.TEMP_ID Implied ConstraintR
vwCOSD_UGI_RADIO_ENDO_PROC.TEMP_ID Implied ConstraintR
vwDEMOGRAPHICS.TEMP_ID Implied ConstraintR
vwFIRST_BRACHYTHERAPY.TEMP_ID Implied ConstraintR
vwFIRST_CHEMOTHERAPY.TEMP_ID Implied ConstraintR
vwFIRST_INVESTIGATIONS.TEMP_ID Implied ConstraintR
vwFIRST_MAIN_PALLIATIVE.TEMP_ID Implied ConstraintR
vwFIRST_PATHOLOGY.TEMP_ID Implied ConstraintR
vwFIRST_PATHOLOGY_BAUS.TEMP_ID Implied ConstraintR
vwFIRST_SURGERY.TEMP_ID Implied ConstraintR
vwFIRST_TELETHERAPY.TEMP_ID Implied ConstraintR
vwINVESTIGATIONS.TEMP_ID Implied ConstraintR
vwMAIN_BRACHYTHERAPY.TEMP_ID Implied ConstraintR
vwMAIN_CARE_PLAN.TEMP_ID Implied ConstraintR
vwMAIN_CHEMOTHERAPY.TEMP_ID Implied ConstraintR
vwMAIN_TELETHERAPY.TEMP_ID Implied ConstraintR
vwNBOCAP_CARE_PLANS.TEMP_ID Implied ConstraintR
vwNOGCA_CARE_PLAN.TEMP_ID Implied ConstraintR
vwNOGCA_FIRST_CARE_PLAN.TEMP_ID Implied ConstraintR
vwNOGCA_FIRST_NON_DEFINITIVE_SURGERY.TEMP_ID Implied ConstraintR
vwNOGCA_FIRST_PALLIATIVE.TEMP_ID Implied ConstraintR
vwNOGCA_FIRST_SURGERY.TEMP_ID Implied ConstraintR
vwNOGCA_LATEST_OGD.TEMP_ID Implied ConstraintR
vwNOGCA_PROCEDURES.TEMP_ID Implied ConstraintR
vwNPCA_CARE_PLAN.TEMP_ID Implied ConstraintR
vwNPCA_CARE_PLAN_AGREED.TEMP_ID Implied ConstraintR
vwNPCA_CARE_PLAN_CHECKBOX_SELECTED.TEMP_ID Implied ConstraintR
vwNPCA_CARE_PLAN_DISCUSSED_AGREED.TEMP_ID Implied ConstraintR
vwNPCA_CARE_PLAN_DS3_ALL.TEMP_ID Implied ConstraintR
vwNPCA_FIRST_CARE_PLAN_AGREED.TEMP_ID Implied ConstraintR
vwNPCA_FIRST_CARE_PLAN_DISCUSSED_AGREED.TEMP_ID Implied ConstraintR
vwPALLIATIVE_CONTACT_PID.TEMP_ID Implied ConstraintR
vwSECOND_INVESTIGATIONS.TEMP_ID Implied ConstraintR
TEMP_NHS_NUMBER numeric() identity 20 √ null
CREATED_DATE smalldatetime 16 null

Indexes

Constraint Name Type Sort Column(s)
PK_ltblTEMP_NHS_NUMBERS Primary key Asc TEMP_ID

Relationships

Close relationships within degrees of separation