CREATE TABLE EMPLOYEE_PAY_TBL
{
EMP_ID VARCHAR2(9) NOT NULL PRIMARYKEY,
POSITION VARCHAR2(15) NOT NULL,
DATE_HIRE DATE,
PAY_RATE NUMBER(4,2),
DATE_LAST_RAISE DATE,
SALARY NUMBER(8,2),
BONUS NUMBER(6,2),
CONSTRAINT EMP_FK FOREIGN KEY (EMP_ID) REFERENCES EMPLOYEE_TBL (EMP_ID)
}
/