| NAME | CONNECTION |
|---|---|
| Username | idd |
| Password | bazededate |
| Hostname | 193.226.51.37 |
| Port | 1521 |
| SID | o11g |
| Field | Null ? | Type |
|---|---|---|
| EMPLOYEE_ID | NOT NULL | NUMBER(6) |
| FIRST_NAME | Yes. | VARCHAR2(20) |
| LAST_NAME | NOT NULL | VARCHAR2(25) |
| NOT NULL | VARCHAR2(25) | |
| PHONE_NUMBER | Yes. | VARCHAR2(20) |
| HARE_DATE | NOT NULL | DATE |
| JOB_ID | NOT NULL | VARCHAR2(10) |
| SALARY | Yes. | NUMBER(8,2) |
| COMMISSION_PCT | Yes. | NUMBER(2,2) |
| MANAGER_ID | Yes. | NUMBER(6) |
| DEPARTMENT_ID | Yes. | NUMBER(4) |
| Field | Null ? | Type |
|---|---|---|
| DEPARTMENT_ID | NOT NULL | NUMBER(4) |
| DEPARTMENT_NAME | NOT NULL | VARCHAR2(30) |
| MANAGER_ID | Yes. | NUMBER(6) |
| LOCATION_ID | Yes. | NUMBER(4) |
| Field | Null ? | Type |
|---|---|---|
| JOB_ID | NOT NULL | VARCHAR2(10) |
| JOB_TITLE | NOT NULL | VARCHAR2(35) |
| MIN_SALARY | Yes. | NUMBER(6) |
| MAX_SALARY | Yes. | NUMBER(6) |
| Field | Null ? | Type |
|---|---|---|
| EMPLOYEE_ID | NOT NULL | NUMBER(6) |
| START_DATE | NOT NULL | DATE |
| END_DATE | NOT NULL | DATE |
| JOB_ID | NOT NULL | VARCHAR2(10) |
| DEPARTMENT_ID | NOT NULL | NUMBER(4) |