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