SITE

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SITE

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
ID	number		NOT NULL		Column
MANAGER_ID	int		NULL		Column
NAME	NVARCHAR2		NULL		Column

Indexes

No Data

Check Constraints

No Data

Triggers

No Data

References
     The items listed in the matrix below are called / used by the Table “SITE”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
INT	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Impact Analysis
     The items listed in the matrix below are using / calling the Table “SITE”

Name	Types	Description
<DEFAULT SCHEMA>.DEPARTMENT	Table	Table
<DEFAULT SCHEMA>.ALL_SITES	View	View
<DEFAULT SCHEMA>.ALL_SITES.Select	Select Statement	SELECT S.ID, S.NAME, S.Manager_Id, E.emp_fname, E.emp_lname F