From dbscript Online Help
wikibot
| Table
|
HR.JOBS
|
| Description
|
jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table.
|
Columns
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
| JOB_ID
|
VARCHAR2(10)
|
not null
|
|
Primary key of jobs table.
|
| JOB_TITLE
|
VARCHAR2(35)
|
not null
|
|
A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
|
| MIN_SALARY
|
NUMBER(6, 0)
|
null
|
|
Minimum salary for a job title.
|
| MAX_SALARY
|
NUMBER(6, 0)
|
null
|
|
Maximum salary for a job title
|
Primary Key
| Primary Key
|
Columns
|
| JOB_ID_PK
|
JOB_ID
|
Check Constraints
| Check Constraint
|
Expression
|
Description
|
| JOB_TITLE_NN
|
"JOB_TITLE" IS NOT NULL
|
|
Detail Tables
