HR Sample Schema Scripts and Objects

The following tables list the names of the scripts that create the human resources (hr) schema and describe the objects in the schema. Table 4-1 lists the hr scripts in alphabetical order, while Table 4-2 lists the hr objects.

Table 4-1 HR Sample Schema Scripts

Script Name	Description
hr_code.sql	Creates procedural objects in the schema
hr_create.sql	Creates the hr objects
hr_install.sql	Main script for schema hr; calls other scripts
hr_populate.sql	Populates the objects
hr_uninstall.sql	Uninstalls the schema

Table 4-2 HR Sample Schema Objects

Object Type	Objects
Index	country_c_id_pk, dept_id_pk, dept_location_ix, emp_department_ix, emp_email_uk, emp_emp_id_pk, emp_job_ix, emp_manager_ix, emp_name_ix, jhist_department_ix, jhist_employee_ix, jhist_emp_id_st_date_pk, jhist_job_ix, job_id_pk, loc_city_ix, loc_country_ix, loc_id_pk, loc_state_province_ix, reg_id_pk
Procedure	add_job_history, secure_dml
Sequence	departments_seq, employees_seq, locations_seq
Table	countries, departments, employees, jobs, job_history, locations, regions
Trigger	secure_employees, update_job_history
View	emp_details_view