SchemaSpy - View ESEC.ESECDBA.EVT_PRTCL_RPT

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
PROTOCOL_ID	number	22
PROTOCOL_NAME	varchar2	765	√	null
DATE_CREATED	date	7	√	null
DATE_MODIFIED	date	7	√	null
CREATED_BY	number	22	√	null
MODIFIED_BY	number	22	√	null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:

SELECT PRTCL_ID as Protocol_ID, PRTCL_NAME as Protocol_Name, DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY FROM EVT_PRTCL

SELECT
PRTCL_ID as Protocol_ID,
PRTCL_NAME as Protocol_Name,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY
FROM EVT_PRTCL