employeeA_t Struct Reference

#include <db001_employee.h>

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

---

Detailed Description

Examples:

testcase.pc.

---

Field Documentation

double employeeA_t::commission_pct[500]

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

int employeeA_t::department_id[500]

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

char employeeA_t::email[500][26]

Email id of the employee.

int employeeA_t::employee_id[500]

Primary key of employees table.

char employeeA_t::first_name[500][21]

First name of the employee. A not null column.

char employeeA_t::hire_date[500][30]

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

char employeeA_t::job_id[500][11]

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

A not null column.

char employeeA_t::last_name[500][26]

Last name of the employee. A not null column.

int employeeA_t::manager_id[500]

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 employeeA_t::phone_number[500][21]

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

double employeeA_t::salary[500]

Monthly salary of the employee.

Must be greater than zero (enforced by constraint emp_salary_min)

---

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

• db001_employee.h