HR

Basic Index   Expanded Index

Table Name:JOBS
Description:jobs table with job titles and salary ranges. Contains 19 rows. References with employees and job_history table.
Primary Keys:JOB_ID
FieldTypeDefaultsNulls?Comments
JOB_IDVARCHAR2 (10)NoneNoPrimary key of jobs table.
JOB_TITLEVARCHAR2 (35)NoneNoA not null column that shows job title, e.g. AD_VP, FI_ACCOUNTANT
MIN_SALARYNUMBER (6)NoneYesMinimum salary for a job title.
MAX_SALARYNUMBER (6)NoneYesMaximum salary for a job title

IndexTypeUnique?Fields
JOB_ID_PKNORMALYesJOB_ID

No check constraints
No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected SchemaAffected TableAffected Field
EMP_JOB_FKHREMPLOYEESJOB_ID
JHIST_JOB_FKHRJOB_HISTORYJOB_ID

No triggers