CREATE TABLE [dbo].[treatment_product]
(
treatment_key int not null,
treatment_product_key int not null,
pt_key int not null,
treatment_product_code nvarchar(9) not null,
treatment_product_dose float not null DEFAULT 1,
treatment_product_daily int not null DEFAULT 1,
treatment_product_cycle_length int not null DEFAULT 1 ,
treatment_product_no_of_cycles int not null DEFAULT 1 ,
treatment_product_start_dt datetime not null,
treatment_product_repeats int not null DEFAULT 1,
treatment_product_is_script BIT not null DEFAULT 1,
treatment_product_is_drug bit not null DEFAULT 1,
treatment_product_motivation nvarchar(max) null,
modified_dt datetime not null,
modified_by_key UNIQUEIDENTIFIER not null,
CONSTRAINT [treatment_product_PK] PRIMARY KEY CLUSTERED (treatment_product_key ASC),
CONSTRAINT [patient_treatment_product_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
)

