EMPLOYEE_PAY_TBL

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)
}
/

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset