dokuwiki

This is an old revision of the document!

---

jn table

CREATE TABLE employees_jn
    (
    id                             NUMBER(6,0) ,
    jn_type                        VARCHAR2(1 BYTE),  
    employee_id                    NUMBER(6,0) ,
    first_name                     VARCHAR2(20 BYTE),
    last_name                      VARCHAR2(25 BYTE) ,
    email                          VARCHAR2(25 BYTE) ,
    phone_number                   VARCHAR2(20 BYTE),
    hire_date                      DATE ,
    job_id                         VARCHAR2(10 BYTE) ,
    job_title                      VARCHAR2(100 BYTE) ,
    old_salary                     NUMBER(8,2),
    new_salary                     NUMBER(8,2),
    commission_pct                 NUMBER(2,2),
    manager_id                     NUMBER(6,0),
    manager_name                   VARCHAR2(100 BYTE),
    department_id                  NUMBER(4,0),
    department_name                VARCHAR2(100 BYTE),
    valid_from                     date,
    valid_to                       date 
    )