Table: SALARY_HISTORY
 Index > Table Index > SALARY_HISTORY
 
Description:
 
No description available.
 
Columns
 
Field Name Data Type Allow Null Character Set Default
EMP_NO SHORT No
CHANGE_DATE TIMESTAMP No DEFAULT 'NOW'
UPDATER_ID VARCHAR(20) No NONE
OLD_SALARY DECIMAL(10, 1) No
PERCENT_CHANGE DOUBLE No DEFAULT 0
NEW_SALARY DOUBLE Yes
 
Indices
 
Index Name FieldName Unique Active Descending Description
CHANGEX CHANGE_DATE No Yes Yes No description available.
UPDATERX UPDATER_ID 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_7 PERCENT_CHANGE
Trigger CHECK_8 PERCENT_CHANGE
Procedure DELETE_EMPLOYEE EMP_NO
COMPUTED RDB$17 PERCENT_CHANGE, OLD_SALARY
Trigger SAVE_SALARY_CHANGE PERCENT_CHANGE, CHANGE_DATE, OLD_SALARY, EMP_NO, UPDATER_ID
 
Created using FBDoc