CREATE TABLE ZAYAVKI 
(
  ZAYAVKA_ID	INTEGER NOT NULL,
  EMP_NO	EMPNO NOT NULL,
  ITEM_ID	ITEMID NOT NULL,
  QUANTITY	SMALLINT NOT NULL,
  ZAYAV_DATE	TIMESTAMP default 'now' NOT NULL,
  STATUS	VARCHAR( 12 ) CHARACTER SET WIN1251 default 'новая' NOT NULL,
  ORDER_ID	ORDERID,
 PRIMARY KEY (ZAYAVKA_ID, EMP_NO, ITEM_ID)
);
ALTER TABLE ZAYAVKI ADD FOREIGN KEY (EMP_NO) REFERENCES EMPLOYEE (EMP_NO);
ALTER TABLE ZAYAVKI ADD FOREIGN KEY (ITEM_ID) REFERENCES GOODS (ITEM_ID);
ALTER TABLE ZAYAVKI ADD FOREIGN KEY (ORDER_ID) REFERENCES ORDERS (ORDER_ID);