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