CREATE TABLE bmr_bpr_fdf
(
	product_id,
	batch_plan_header_id,
	batch						VARCHAR2(15),
	process_type				CHAR(3)
		CONSTRAINT bmrbprasp_processtype_nn NOT NULL,
		CONSTRAINT bmrbprasp_processtype_chk
			CHECK (process_type IN ('BMR','BPR')),
	user_id,
		CONSTRAINT bmrbprasp_prodid_fk
			FOREIGN KEY (product_id)
			REFERENCES product_master (product_id),
		CONSTRAINT bmrbprasp_btchplnhdrid_fk
			FOREIGN KEY (batch_plan_header_id)
			REFERENCES batch_plan_header (batch_plan_header_id),
		CONSTRAINT bmrbprasp_userid_fk
			FOREIGN KEY (user_id)
			REFERENCES user_master (user_id)
);



CREATE TABLE process_bmr_bpr
(
	batch_plan_header_id,
	process_type				CHAR(3)
		CONSTRAINT prsbmrbpr_processtype_nn NOT NULL,
		CONSTRAINT prsbmrbpr_processtype_chk
			CHECK (process_type IN ('BMR','BPR')),
		CONSTRAINT prsbmrbpr_btchplnhdrid_fk
			FOREIGN KEY (batch_plan_header_id)
			REFERENCES batch_plan_header (batch_plan_header_id)
);