ltblTreatmentIntent


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IntentID int 4 null
tblMAIN_BRACHYTHERAPY.N11_6_TREATMENT_INTENT FK_tblMAIN_BRACHYTHERAPY_ltblTreatmentIntentR
tblMAIN_CHEMOTHERAPY.N9_8_TREATMENT_INTENT FK_tblMAIN_CHEMOTHERAPY_ltblTreatmentIntentR
tblMAIN_SURGERY.N7_4_TREATMENT_INTENT FK_tblMAIN_SURGERY_ltblTreatmentIntentR
tblMAIN_TELETHERAPY.N10_6_TREATMENT_INTENT FK_tblMAIN_TELETHERAPY_ltblTreatmentIntentR
IntentCode char 1 √ null
NonSurgicalIntentDesc varchar 50 √ null
SurgicalIntentDesc varchar 50 √ null
HANACode int 4 √ null
IsDeleted bit 1 null
COSDValue varchar 2 √ null
SACTCode varchar 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_ltblTreatmentIntent Primary key Asc IntentID

Relationships

Close relationships within degrees of separation