NOGCAPlannedTreatmentMap


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PlannedTreatmentCode varchar 3 null
ltblTREATMENT_TYPE.TREATMENT_CODE FK_NOGCAPlannedTreatmentMap_ltblTREATMENT_TYPER
CarePlanIntentCode char 1 null
ltblINTENT.INTENT_CODE FK_NOGCAPlannedTreatmentMap_ltblINTENTR
NOGCATreatmentID int 4 null
ltblNOGCATreatments.ID FK_NOGCAPlannedTreatmentMap_ltblNOGCATreatmentsR

Indexes

Constraint Name Type Sort Column(s)
PK_NOGCAPlannedTreatmentMap Primary key Asc/Asc/Asc PlannedTreatmentCode + CarePlanIntentCode + NOGCATreatmentID

Relationships