COLUMN_NAME	DATA_TYPE	NULLABLE	DATA_DEFAULT	COLUMN_ID	COMMENTS
EMPLOYEE_ID	NUMBER(6,0)	No	null	1	A not null column in the complex primary key employee_id+start_date. Foreign key to employee_id column of the employee table test234
START_DATE	DATE	No	null	2	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)
END_DATE	DATE	No	null	3	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_ID	VARCHAR2(10 BYTE)	No	null	4	Job role in which the employee worked in the past; foreign key to job_id column in the jobs table. A not null column.
DEPARTMENT_ID	NUMBER(4,0)	Yes	null	5	Department id in which the employee worked in the past; foreign key to deparment_id column in the departments table

CONSTRAINT_NAME	CONSTRAINT_TYPE	SEARCH_CONDITION	R_OWNER	R_TABLE_NAME	R_CONSTRAINT_NAME	DELETE_RULE	STATUS	DEFERRABLE	VALIDATED	GENERATED	BAD	RELY	LAST_CHANGE	INDEX_OWNER	INDEX_NAME	INVALID	VIEW_RELATED
JHIST_DATE_INTERVAL	Check	end_date > start_date	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_DEPT_FK	Foreign_Key	null	HR	DEPARTMENTS	DEPT_ID_PK	NO ACTION	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_EMP_FK	Foreign_Key	null	HR	EMPLOYEES	EMP_EMP_ID_PK	NO ACTION	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_EMP_ID_ST_DATE_PK	Primary_Key	null	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	JHIST_EMP_ID_ST_DATE_PK	null	null
JHIST_EMPLOYEE_NN	Check	"EMPLOYEE_ID" IS NOT NULL	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_END_DATE_NN	Check	"END_DATE" IS NOT NULL	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_JOB_FK	Foreign_Key	null	HR	JOBS	JOB_ID_PK	NO ACTION	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_JOB_NN	Check	"JOB_ID" IS NOT NULL	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null
JHIST_START_DATE_NN	Check	"START_DATE" IS NOT NULL	null	null	null	null	ENABLED	NOT DEFERRABLE	VALIDATED	USER NAME	null	null	2011/08/28	null	null	null	null

Columns

COLUMN_NAME	COLUMN_POSITION
END_DATE	null
START_DATE	null

COLUMN_NAME	COLUMN_POSITION
DEPARTMENT_ID	1

COLUMN_NAME	COLUMN_POSITION
EMPLOYEE_ID	1

COLUMN_NAME	COLUMN_POSITION
EMPLOYEE_ID	1
START_DATE	2

COLUMN_NAME	COLUMN_POSITION
EMPLOYEE_ID	null

COLUMN_NAME	COLUMN_POSITION
END_DATE	null

COLUMN_NAME	COLUMN_POSITION
JOB_ID	1

COLUMN_NAME	COLUMN_POSITION
JOB_ID	null

COLUMN_NAME	COLUMN_POSITION
START_DATE	null

PRIVILEGE	GRANTEE	GRANTABLE	GRANTOR	OBJECT_NAME

Column Statistics

TRIGGER_NAME	TRIGGER_TYPE	TRIGGER_OWNER	TRIGGERING_EVENT	STATUS	TABLE_NAME

OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE
HR	ADD_JOB_HISTORY	PROCEDURE	HR	JOB_HISTORY	TABLE

References

OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE

NAME	VALUE
CREATED	2011/08/28
LAST_DDL_TIME	2011/08/28
OWNER	HR
TABLE_NAME	JOB_HISTORY
TABLESPACE_NAME	USERS
CLUSTER_NAME	null
IOT_NAME	null
STATUS	VALID
PCT_FREE	10
PCT_USED	null
INI_TRANS	1
MAX_TRANS	255
INITIAL_EXTENT	65536
NEXT_EXTENT	1048576
MIN_EXTENTS	1
MAX_EXTENTS	2147483645
PCT_INCREASE	null
FREELISTS	null
FREELIST_GROUPS	null
LOGGING	YES
BACKED_UP	N
NUM_ROWS	10
BLOCKS	5
EMPTY_BLOCKS	0
AVG_SPACE	0
CHAIN_CNT	0
AVG_ROW_LEN	31
AVG_SPACE_FREELIST_BLOCKS	0
NUM_FREELIST_BLOCKS	0
DEGREE	1
INSTANCES	1
CACHE	N
TABLE_LOCK	ENABLED
SAMPLE_SIZE	10
LAST_ANALYZED	2016/09/23
PARTITIONED	NO
IOT_TYPE	null
OBJECT_ID_TYPE	null
TABLE_TYPE_OWNER	null
TABLE_TYPE	null
TEMPORARY	N
SECONDARY	N
NESTED	NO
BUFFER_POOL	DEFAULT
ROW_MOVEMENT	DISABLED
GLOBAL_STATS	YES
USER_STATS	NO
DURATION	null
SKIP_CORRUPT	DISABLED
MONITORING	YES
CLUSTER_OWNER	null
DEPENDENCIES	DISABLED
COMPRESSION	DISABLED
COMPRESS_FOR	null
DROPPED	NO
COMMENTS	Table that stores job history of the employees. If an employee changes departments within the job or changes jobs within the department, new rows get inserted into this table with old job information of the employee. Contains a complex primary key: employee_id+start_date. Contains 25 rows. References with jobs, employees, and departments tables.

PARTITION_NAME	LAST_ANALYZED	NUM_ROWS	BLOCKS	SAMPLE_SIZE	HIGH_VALUE

INDEX_OWNER	INDEX_NAME	UNIQUENESS	STATUS	INDEX_TYPE	TEMPORARY	PARTITIONED	FUNCIDX_STATUS	JOIN_INDEX	COLUMNS	COLUMN_EXPRESSION
HR	JHIST_JOB_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	JOB_ID	null
HR	JHIST_EMPLOYEE_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	EMPLOYEE_ID	null
HR	JHIST_DEPARTMENT_IX	NONUNIQUE	VALID	NORMAL	N	NO	null	NO	DEPARTMENT_ID	null
HR	JHIST_EMP_ID_ST_DATE_PK	UNIQUE	VALID	NORMAL	N	NO	null	NO	EMPLOYEE_ID, START_DATE	null

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	JHIST_JOB_IX	HR	JOB_HISTORY	JOB_ID	1	10	10	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	JHIST_EMPLOYEE_IX	HR	JOB_HISTORY	EMPLOYEE_ID	1	22	0	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	JHIST_DEPARTMENT_IX	HR	JOB_HISTORY	DEPARTMENT_ID	1	22	0	ASC

INDEX_OWNER	INDEX_NAME	TABLE_OWNER	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND
HR	JHIST_EMP_ID_ST_DATE_PK	HR	JOB_HISTORY	EMPLOYEE_ID	1	22	0	ASC
HR	JHIST_EMP_ID_ST_DATE_PK	HR	JOB_HISTORY	START_DATE	2	7	0	ASC

JOB_HISTORY