Table: EMPLOYEE
Index
>
Table Index
> EMPLOYEE
Description:
No description available.
Columns
Field Name
Data Type
Allow Null
Character Set
Default
EMP_NO
SHORT
No
FIRST_NAME
VARCHAR(15)
No
NONE
LAST_NAME
VARCHAR(20)
No
NONE
PHONE_EXT
VARCHAR(4)
Yes
NONE
HIRE_DATE
TIMESTAMP
No
DEFAULT 'NOW'
DEPT_NO
CHAR(3)
No
NONE
JOB_CODE
VARCHAR(5)
No
NONE
JOB_GRADE
SHORT
No
JOB_COUNTRY
VARCHAR(15)
No
NONE
SALARY
DECIMAL(10, 1)
No
FULL_NAME
Computed - (last_name || ', ' || first_name)
Yes
NONE
Indices
Index Name
FieldName
Unique
Active
Descending
Description
NAMEX
LAST_NAME
No
Yes
No
No description available.
FIRST_NAME
No
Yes
No
No description available.
Permissions:
User
Select
Insert
Delete
Update
Reference
User:
PUBLIC
Yes
Yes
Yes
Yes
Yes
User:
SYSDBA
Yes
Yes
Yes
Yes
Yes
Dependent Objects
Object Type
Name
Field
Trigger
CHECK_3
SALARY, JOB_CODE, JOB_COUNTRY, JOB_GRADE
Trigger
CHECK_4
SALARY, JOB_CODE, JOB_COUNTRY, JOB_GRADE
Procedure
DELETE_EMPLOYEE
EMP_NO
Procedure
ORG_CHART
DEPT_NO, EMP_NO, JOB_CODE, FULL_NAME
View
PHONE_LIST
DEPT_NO
COMPUTED
RDB$9
LAST_NAME, FIRST_NAME
Trigger
SAVE_SALARY_CHANGE
SALARY, EMP_NO
Trigger
SET_EMP_NO
EMP_NO
Created using FBDoc