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