CREATE TABLE [dbo].[treatment_service]
(
treatment_key int not null,
treatment_service_key int not null,
pt_key int not null,
treatment_service_proposed_weeks int null,
treatment_service_start_date datetime not null,
treatment_service_review_date datetime not null,
treatment_service_rpl_rate float not null default 100.0,
treatment_service_code nvarchar(10) not null,
treatment_service_code_units int not null default 1,
treatment_service_repeats int not null default 1,
modified_dt datetime not null,
modified_by_key UNIQUEIDENTIFIER not null,
CONSTRAINT [treatment_service_PK] PRIMARY KEY CLUSTERED ([treatment_service_key] ASC),
CONSTRAINT [patient_treatment_service_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
)
