Table: DEPARTMENT
 Index > Table Index > DEPARTMENT
 
Description:
 
No description available.
 
Columns
 
Field Name Data Type Allow Null Character Set Default
DEPT_NO CHAR(3) No NONE
DEPARTMENT VARCHAR(25) No NONE
HEAD_DEPT CHAR(3) Yes NONE
MNGR_NO SHORT Yes
BUDGET DECIMAL(12, 2) Yes
LOCATION VARCHAR(15) Yes NONE
PHONE_NO VARCHAR(20) Yes NONE DEFAULT '555-1234'
 
Indices
 
Index Name FieldName Unique Active Descending Description
BUDGETX BUDGET No Yes Yes 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 DELETE_EMPLOYEE MNGR_NO
Procedure DEPT_BUDGET DEPT_NO, HEAD_DEPT, BUDGET
Procedure ORG_CHART DEPT_NO, DEPARTMENT, HEAD_DEPT, MNGR_NO
View PHONE_LIST DEPT_NO
Procedure SUB_TOT_BUDGET HEAD_DEPT, BUDGET
 
Created using FBDoc