--order 502564

ALTER TABLE WORKORDER MODIFY ( REMARK VARCHAR2(1000) );

ALTER TABLE WORKORDER ADD ( SALESEMPLOYEE1_ID NUMBER NULL );

ALTER TABLE WORKORDER ADD ( SALESEMPLOYEE2_ID NUMBER NULL );

CREATE INDEX XIF20WORKORDER ON WORKORDER
(
	SALESEMPLOYEE1_ID
);

CREATE INDEX XIF21WORKORDER ON WORKORDER
(
	SALESEMPLOYEE2_ID
);

ALTER TABLE WORKORDER 
	ADD ( CONSTRAINT WORKORDER_SALESEMPLOYEE1_ID
		FOREIGN KEY (SALESEMPLOYEE1_ID)
	                     REFERENCES EMPLOYEE);

ALTER TABLE WORKORDER 
	ADD ( CONSTRAINT WORKORDER_SALESEMPLOYEE2_ID
		FOREIGN KEY (SALESEMPLOYEE2_ID)
	                     REFERENCES EMPLOYEE);