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