Exemples de description de table de schémas HR
Les tableaux suivants décrivent les colonnes de chaque table du schéma échantillon hr.
Tableau HR.COUNTRIES
| Nom de la colonne |
NULL ? |
Type |
COUNTRY_ID |
NOT NULL |
CHAR(2) |
COUNTRY_NAME |
|
VARCHAR2(60) |
REGION_ID |
|
NUMBER |
Tableau HR.DEPARTMENTS
| Nom de la colonne |
NULL ? |
Type |
DEPARTMENT_ID |
NOT NULL |
NUMBER(4) |
DEPARTMENT_NAME |
NOT NULL |
VARCHAR2(30) |
MANAGER_ID |
|
NUMBER(6) |
LOCATION_ID |
|
NUMBER(4) |
Tableau HR.EMPLOYEES
| Nom de la colonne |
NULL ? |
Type |
EMPLOYEE_ID |
NOT NULL |
NUMBER(6) |
FIRST_NAME |
|
VARCHAR2(20) |
LAST_NAME |
NOT NULL |
VARCHAR2(25) |
EMAIL |
NOT NULL |
VARCHAR2(25) |
PHONE_NUMBER |
|
VARCHAR2(20) |
HIRE_DATE |
NOT NULL |
DATE |
JOB_ID |
NOT NULL |
VARCHAR2(10) |
SALARY |
|
NUMBER(8,2) |
COMMISSION_PCT |
|
NUMBER(2,2) |
MANAGER_ID |
|
NUMBER(6) |
DEPARTMENT_ID |
|
NUMBER(4) |
Tableau HR.JOBS
| Nom de la colonne |
NULL ? |
Type |
JOB_ID |
NOT NULL |
VARCHAR2(10) |
JOB_TITLE |
NOT NULL |
VARCHAR2(35) |
MIN_SALARY |
|
NUMBER(6) |
MAX_SALARY |
|
NUMBER(6) |
Tableau HR.JOB_HISTORY
Tableau 7 HR.JOB_HISTORY Description de la table
| Nom de la colonne |
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 |
|
NUMBER(4) |
Tableau HR.LOCATIONS
| Nom de la colonne |
NULL ? |
Type |
LOCATION_ID |
NOT NULL |
NUMBER(4) |
STREET_ADDRESS |
|
VARCHAR2(40) |
POSTAL_CODE |
|
VARCHAR2(12) |
CITY |
NOT NULL |
VARCHAR2(30) |
STATE_PROVINCE |
|
VARCHAR2(25) |
COUNTRY_ID |
|
CHAR(2) |
Tableau HR.REGIONS
| Nom de la colonne |
NULL ? |
Type |
REGION_ID |
NOT NULL |
NUMBER |
REGION_NAME |
|
VARCHAR2(25) |