HR JOBS (table)

wikibot

TableHR.JOBS
Descriptionjobs table with job titles and salary ranges. Contains 19 rows.

Columns

ColumnData TypeNullableDefaultDescription
JOB_IDVARCHAR2(10)not null Primary key of jobs table.
JOB_TITLEVARCHAR2(35)not null A not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
MIN_SALARYNUMBER(6, 0)null Minimum salary for a job title.
MAX_SALARYNUMBER(6, 0)null Maximum salary for a job title

Primary Key

Primary KeyColumns
JOB_ID_PKJOB_ID

Check Constraints

Check ConstraintExpressionDescription
JOB_TITLE_NN"JOB_TITLE" IS NOT NULL 

Detail Tables

Detail TableColumnReferencing Column
HR.EMPLOYEESJOB_IDJOB_ID
HR.JOB_HISTORYJOB_IDJOB_ID