employee_t Struct Reference

#include <db001_employee.h>

Data Fields
int	employee_id
	Primary key of employees table.
char	first_name [21]
	First name of the employee. A not null column.
char	last_name [26]
	Last name of the employee. A not null column.
char	email [26]
	Email id of the employee.
char	phone_number [21]
	Phone number of the employee; includes country code and area code.
char	hire_date [30]
	Date when the employee started on this job. A not null column.
char	job_id [11]
	Current job of the employee; foreign key to job_id column of the jobs table.
double	salary
	Monthly salary of the employee.
double	commission_pct
	Commission percentage of the employee; Only employees in sales department elgible for commission percentage.
int	manager_id
	Manager id of the employee; has same domain as manager_id in departments table.
int	department_id
	Department id where employee works; foreign key to department_id column of the departments table.

---

Detailed Description

Examples:

testcase.pc.

---

Field Documentation

double employee_t::commission_pct

Commission percentage of the employee; Only employees in sales department elgible for commission percentage.

Examples:

testcase.pc.

int employee_t::department_id

Department id where employee works; foreign key to department_id column of the departments table.

char employee_t::email[26]

Email id of the employee.

Examples:

testcase.pc.

int employee_t::employee_id

Primary key of employees table.

Examples:

testcase.pc.

char employee_t::first_name[21]

First name of the employee. A not null column.

Examples:

testcase.pc.

char employee_t::hire_date[30]

Date when the employee started on this job. A not null column.

Examples:

testcase.pc.

char employee_t::job_id[11]

Current job of the employee; foreign key to job_id column of the jobs table.

A not null column.

char employee_t::last_name[26]

Last name of the employee. A not null column.

Examples:

testcase.pc.

int employee_t::manager_id

Manager id of the employee; has same domain as manager_id in departments table.

Foreign key to employee_id column of employees table. (useful for reflexive joins and CONNECT BY query)

char employee_t::phone_number[21]

Phone number of the employee; includes country code and area code.

Examples:

testcase.pc.

double employee_t::salary

Monthly salary of the employee.

Must be greater than zero (enforced by constraint emp_salary_min)

Examples:

testcase.pc.

---

The documentation for this struct was generated from the following file:

• db001_employee.h