| EMPLOYEES_MV | EMPLOYEE_ID
| NUMBER
(6,0)
|
|
| EMPLOYEES_MV | FIRST_NAME
| VARCHAR2
(20)
|
|
| EMPLOYEES_MV | LAST_NAME
| VARCHAR2
(25)
|
|
| EMPLOYEES_MV | EMAIL
| VARCHAR2
(25)
|
|
| EMPLOYEES_MV | PHONE_NUMBER
| VARCHAR2
(20)
|
|
| EMPLOYEES_MV | HIRE_DATE
| DATE
|
|
| EMPLOYEES_MV | JOB_ID
| VARCHAR2
(10)
|
|
| EMPLOYEES_MV | SALARY
| NUMBER
(8,2)
|
|
| EMPLOYEES_MV | COMMISSION_PCT
| NUMBER
(2,2)
|
|
| EMPLOYEES_MV | MANAGER_ID
| NUMBER
(6,0)
|
|
| EMPLOYEES_MV | DEPARTMENT_ID
| NUMBER
(4,0)
|
|
| COUNTRIES | COUNTRY_ID
| CHAR
(2)
| Primary key of countries table.
|
| COUNTRIES | COUNTRY_NAME
| VARCHAR2
(40)
| Country name (in words) testing
|
| COUNTRIES | REGION_ID
| NUMBER
| Region ID for the country. Foreign key to region_id column in the departments table.
|
| DEPARTMENTS | DEPARTMENT_ID
| NUMBER
(4,0)
| Primary key column of departments table.
|
| DEPARTMENTS | DEPARTMENT_NAME
| VARCHAR2
(30)
| A not null column that shows name of a department. Administration,
Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public
Relations, Sales, Finance, and Accounting.
|
| DEPARTMENTS | MANAGER_ID
| NUMBER
(6,0)
| Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.
|
| DEPARTMENTS | LOCATION_ID
| NUMBER
(4,0)
| Location id where a department is located. Foreign key to location_id column of locations table.
|
| EMPLOYEES | EMPLOYEE_ID
| NUMBER
(6,0)
| Primary key of employees table.
|
| EMPLOYEES | FIRST_NAME
| VARCHAR2
(20)
| First name of the employee. A not null column.
|
| EMPLOYEES | LAST_NAME
| VARCHAR2
(25)
| Last name of the employee. A not null column.
|
| EMPLOYEES | EMAIL
| VARCHAR2
(25)
| Email id of the employee
|
| EMPLOYEES | PHONE_NUMBER
| VARCHAR2
(20)
| Phone number of the employee; includes country code and area code
|
| EMPLOYEES | HIRE_DATE
| DATE
| Date when the employee started on this job. A not null column.
|
| EMPLOYEES | JOB_ID
| VARCHAR2
(10)
| Current job of the employee; foreign key to job_id column of the
jobs table. A not null column.
|
| EMPLOYEES | SALARY
| NUMBER
(8,2)
| Monthly salary of the employee. Must be greater
than zero (enforced by constraint emp_salary_min)
|
| EMPLOYEES | COMMISSION_PCT
| NUMBER
(2,2)
| Commission percentage of the employee; Only employees in sales
department elgible for commission percentage
|
| EMPLOYEES | MANAGER_ID
| NUMBER
(6,0)
| Manager id of the employee; has same domain as manager_id in
departments table. Foreign key to employee_id column of employees table.
(useful for reflexive joins and CONNECT BY query)
|
| EMPLOYEES | DEPARTMENT_ID
| NUMBER
(4,0)
| Department id where employee works; foreign key to department_id
column of the departments table
|
| HTMLDB_PLAN_TABLE | STATEMENT_ID
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | PLAN_ID
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | TIMESTAMP
| DATE
|
|
| HTMLDB_PLAN_TABLE | REMARKS
| VARCHAR2
(4000)
|
|
| HTMLDB_PLAN_TABLE | OPERATION
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | OPTIONS
| VARCHAR2
(255)
|
|
| HTMLDB_PLAN_TABLE | OBJECT_NODE
| VARCHAR2
(128)
|
|
| HTMLDB_PLAN_TABLE | OBJECT_OWNER
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | OBJECT_NAME
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | OBJECT_ALIAS
| VARCHAR2
(65)
|
|
| HTMLDB_PLAN_TABLE | OBJECT_INSTANCE
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | OBJECT_TYPE
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | OPTIMIZER
| VARCHAR2
(255)
|
|
| HTMLDB_PLAN_TABLE | SEARCH_COLUMNS
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | ID
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | PARENT_ID
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | DEPTH
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | POSITION
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | COST
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | CARDINALITY
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | BYTES
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | OTHER_TAG
| VARCHAR2
(255)
|
|
| HTMLDB_PLAN_TABLE | PARTITION_START
| VARCHAR2
(255)
|
|
| HTMLDB_PLAN_TABLE | PARTITION_STOP
| VARCHAR2
(255)
|
|
| HTMLDB_PLAN_TABLE | PARTITION_ID
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | OTHER
| LONG
|
|
| HTMLDB_PLAN_TABLE | DISTRIBUTION
| VARCHAR2
(30)
|
|
| HTMLDB_PLAN_TABLE | CPU_COST
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | IO_COST
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | TEMP_SPACE
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | ACCESS_PREDICATES
| VARCHAR2
(4000)
|
|
| HTMLDB_PLAN_TABLE | FILTER_PREDICATES
| VARCHAR2
(4000)
|
|
| HTMLDB_PLAN_TABLE | PROJECTION
| VARCHAR2
(4000)
|
|
| HTMLDB_PLAN_TABLE | TIME
| NUMBER
|
|
| HTMLDB_PLAN_TABLE | QBLOCK_NAME
| VARCHAR2
(30)
|
|
| JOB_HISTORY | EMPLOYEE_ID
| NUMBER
(6,0)
| A not null column in the complex primary key employee_id+start_date.
Foreign key to employee_id column of the employee table
|
| JOB_HISTORY | START_DATE
| DATE
| A not null column in the complex primary key employee_id+start_date.
Must be less than the end_date of the job_history table. (enforced by
constraint jhist_date_interval)
|
| JOB_HISTORY | END_DATE
| DATE
| Last day of the employee in this job role. A not null column. Must be
greater than the start_date of the job_history table.
(enforced by constraint jhist_date_interval)
|
| JOB_HISTORY | JOB_ID
| VARCHAR2
(10)
| Job role in which the employee worked in the past; foreign key to
job_id column in the jobs table. A not null column.
|
| JOB_HISTORY | DEPARTMENT_ID
| NUMBER
(4,0)
| Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table
|
| JOBS | JOB_ID
| VARCHAR2
(10)
| Primary key of jobs table.
|
| JOBS | JOB_TITLE
| VARCHAR2
(35)
| A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
|
| JOBS | MIN_SALARY
| NUMBER
(6,0)
| Minimum salary for a job title.
|
| JOBS | MAX_SALARY
| NUMBER
(6,0)
| Maximum salary for a job title
|
| LOCATIONS | LOCATION_ID
| NUMBER
(4,0)
| Primary key of locations table
|
| LOCATIONS | STREET_ADDRESS
| VARCHAR2
(40)
| Street address of an office, warehouse, or production site of a company.
Contains building number and street name
|
| LOCATIONS | POSTAL_CODE
| VARCHAR2
(12)
| Postal code of the location of an office, warehouse, or production site
of a company.
|
| LOCATIONS | CITY
| VARCHAR2
(30)
| A not null column that shows city where an office, warehouse, or
production site of a company is located.
|
| LOCATIONS | STATE_PROVINCE
| VARCHAR2
(25)
| State or Province where an office, warehouse, or production site of a
company is located.
|
| LOCATIONS | COUNTRY_ID
| CHAR
(2)
| Country where an office, warehouse, or production site of a company is
located. Foreign key to country_id column of the countries table.
|
| REGIONS | REGION_ID
| NUMBER
|
|
| REGIONS | REGION_NAME
| VARCHAR2
(25)
|
|
| RSK_VERTRAGSAGGREGAT_T | VERTRAG_ID
| VARCHAR2
(30)
|
|
| RSK_VERTRAGSAGGREGAT_T | COMMODITY
| VARCHAR2
(16)
|
|
| RSK_VERTRAGSAGGREGAT_T | ZEITRASTER
| VARCHAR2
(20)
|
|
| RSK_VERTRAGSAGGREGAT_T | ZEITSTEMPEL_VON_LOCAL
| DATE
|
|
| RSK_VERTRAGSAGGREGAT_T | ZEITSTEMPEL_BIS_LOCAL
| DATE
|
|
| RSK_VERTRAGSAGGREGAT_T | ZEITSTEMPEL_VON_MET
| DATE
|
|
| RSK_VERTRAGSAGGREGAT_T | ZEITSTEMPEL_BIS_MET
| DATE
|
|
| RSK_VERTRAGSAGGREGAT_T | REALISIERT
| CHAR
(1)
|
|
| RSK_VERTRAGSAGGREGAT_T | PROFIL_COD
| VARCHAR2
(4)
|
|
| RSK_VERTRAGSAGGREGAT_T | VOLUMEN
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | EINHEIT
| VARCHAR2
(4)
|
|
| RSK_VERTRAGSAGGREGAT_T | ARBEITSWERT_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | ARBEITSPREIS_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | ANZAHL_STUNDEN_ENERGIE
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | LEISTUNG_MW
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | LEISTUNGSWERT_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | LEISTUNGSPREIS_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | ANZAHL_STUNDEN_LEISTUNG
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | VERTRAGSWERT_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | VERTRAGSPREIS_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | MARKTWERT_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | MARKTPREIS_EUR
| NUMBER
|
|
| RSK_VERTRAGSAGGREGAT_T | VALID_FROM
| DATE
|
|
| RSK_VERTRAGSAGGREGAT_T | VALID_TO
| DATE
|
|
| EMP_DETAILS_VIEW | EMPLOYEE_ID
| NUMBER
(6,0)
|
|
| EMP_DETAILS_VIEW | JOB_ID
| VARCHAR2
(10)
|
|
| EMP_DETAILS_VIEW | MANAGER_ID
| NUMBER
(6,0)
|
|
| EMP_DETAILS_VIEW | DEPARTMENT_ID
| NUMBER
(4,0)
|
|
| EMP_DETAILS_VIEW | LOCATION_ID
| NUMBER
(4,0)
|
|
| EMP_DETAILS_VIEW | COUNTRY_ID
| CHAR
(2)
|
|
| EMP_DETAILS_VIEW | FIRST_NAME
| VARCHAR2
(20)
|
|
| EMP_DETAILS_VIEW | LAST_NAME
| VARCHAR2
(25)
|
|
| EMP_DETAILS_VIEW | SALARY
| NUMBER
(8,2)
|
|
| EMP_DETAILS_VIEW | COMMISSION_PCT
| NUMBER
(2,2)
|
|
| EMP_DETAILS_VIEW | DEPARTMENT_NAME
| VARCHAR2
(30)
|
|
| EMP_DETAILS_VIEW | JOB_TITLE
| VARCHAR2
(35)
|
|
| EMP_DETAILS_VIEW | CITY
| VARCHAR2
(30)
|
|
| EMP_DETAILS_VIEW | STATE_PROVINCE
| VARCHAR2
(25)
|
|
| EMP_DETAILS_VIEW | COUNTRY_NAME
| VARCHAR2
(40)
|
|
| EMP_DETAILS_VIEW | REGION_NAME
| VARCHAR2
(25)
|
|
| PUBLIC_HR_JOBS | JOB_ID
| VARCHAR2
(10)
|
|
| PUBLIC_HR_JOBS | JOB_TITLE
| VARCHAR2
(35)
|
|
| PUBLIC_HR_JOBS | MIN_SALARY
| NUMBER
(6,0)
|
|
| PUBLIC_HR_JOBS | MAX_SALARY
| NUMBER
(6,0)
|
|
| SYS_ALL_OBJECTS | OWNER
| VARCHAR2
(30)
|
|
| SYS_ALL_OBJECTS | OBJECT_NAME
| VARCHAR2
(30)
|
|
| SYS_ALL_OBJECTS | SUBOBJECT_NAME
| VARCHAR2
(30)
|
|
| SYS_ALL_OBJECTS | OBJECT_ID
| NUMBER
|
|
| SYS_ALL_OBJECTS | DATA_OBJECT_ID
| NUMBER
|
|
| SYS_ALL_OBJECTS | OBJECT_TYPE
| VARCHAR2
(19)
|
|
| SYS_ALL_OBJECTS | CREATED
| DATE
|
|
| SYS_ALL_OBJECTS | LAST_DDL_TIME
| DATE
|
|
| SYS_ALL_OBJECTS | TIMESTAMP
| VARCHAR2
(19)
|
|
| SYS_ALL_OBJECTS | STATUS
| VARCHAR2
(7)
|
|
| SYS_ALL_OBJECTS | TEMPORARY
| VARCHAR2
(1)
|
|
| SYS_ALL_OBJECTS | GENERATED
| VARCHAR2
(1)
|
|
| SYS_ALL_OBJECTS | SECONDARY
| VARCHAR2
(1)
| testing
|