Table: JOB
Index
>
Table Index
> JOB
Description:
No description available.
Columns
Field Name
Data Type
Allow Null
Character Set
Default
JOB_CODE
VARCHAR(5)
No
NONE
JOB_GRADE
SHORT
No
JOB_COUNTRY
VARCHAR(15)
No
NONE
JOB_TITLE
VARCHAR(25)
No
NONE
MIN_SALARY
DECIMAL(10, 1)
No
MAX_SALARY
DECIMAL(10, 1)
No
JOB_REQUIREMENT
BLOB
Yes
NONE
LANGUAGE_REQ
VARCHAR(15)
Yes
NONE
Indices
Index Name
FieldName
Unique
Active
Descending
Description
MAXSALX
MAX_SALARY
No
Yes
Yes
No description available.
JOB_COUNTRY
No
Yes
Yes
No description available.
MINSALX
MIN_SALARY
No
Yes
No
No description available.
JOB_COUNTRY
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
Procedure
ALL_LANGS
JOB_CODE, JOB_COUNTRY, JOB_GRADE
Trigger
CHECK_1
MAX_SALARY, MIN_SALARY
Trigger
CHECK_2
MAX_SALARY, MIN_SALARY
Trigger
CHECK_3
MAX_SALARY, MIN_SALARY, JOB_CODE, JOB_COUNTRY, JOB_GRADE
Trigger
CHECK_4
MAX_SALARY, MIN_SALARY, JOB_CODE, JOB_COUNTRY, JOB_GRADE
Procedure
SHOW_LANGS
LANGUAGE_REQ, JOB_CODE, JOB_COUNTRY, JOB_GRADE
Created using FBDoc