| COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
|---|---|---|---|---|---|---|---|---|
| EMPLOYEE_ID | NUMBER(6) | No | null | 1 | null | NO | NO | NO |
| JOB_ID | VARCHAR2(10) | No | null | 2 | null | NO | NO | NO |
| MANAGER_ID | NUMBER(6) | Yes | null | 3 | null | NO | NO | NO |
| DEPARTMENT_ID | NUMBER(4) | Yes | null | 4 | null | NO | NO | NO |
| LOCATION_ID | NUMBER(4) | Yes | null | 5 | null | NO | NO | NO |
| COUNTRY_ID | CHAR(2) | Yes | null | 6 | null | NO | NO | NO |
| FIRST_NAME | VARCHAR2(20) | Yes | null | 7 | null | NO | NO | NO |
| LAST_NAME | VARCHAR2(25) | No | null | 8 | null | NO | NO | NO |
| SALARY | NUMBER(8,2) | Yes | null | 9 | null | NO | NO | NO |
| COMMISSION_PCT | NUMBER(2,2) | Yes | null | 10 | null | NO | NO | NO |
| DEPARTMENT_NAME | VARCHAR2(30) | No | null | 11 | null | NO | NO | NO |
| JOB_TITLE | VARCHAR2(35) | No | null | 12 | null | NO | NO | NO |
| CITY | VARCHAR2(30) | No | null | 13 | null | NO | NO | NO |
| STATE_PROVINCE | VARCHAR2(25) | Yes | null | 14 | null | NO | NO | NO |
| COUNTRY_NAME | VARCHAR2(40) | Yes | null | 15 | null | NO | NO | NO |
| REGION_NAME | VARCHAR2(25) | Yes | null | 16 | null | NO | NO | NO |