CREATE TABLE [dbo].[treatment_main] (
	[treatment_key] INT IDENTITY (1, 1) NOT NULL,
	[pt_key] INT NOT NULL,
	[treatment_status_key] INT NOT NULL,
	[treatment_from_dt] DATE NOT NULL,
	[treatment_till_dt] DATE NOT NULL,
	[prov_key] INT NOT NULL,
	[treatment_total_amt] MONEY NULL,
	[modified_dt] DATETIME NOT NULL,
	[modified_by_key] UNIQUEIDENTIFIER
    CONSTRAINT [pt_treatment_PK] PRIMARY KEY CLUSTERED ([treatment_key] ASC)
	CONSTRAINT [patient_treatment_main_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);