SchemaSpy - View ESEC.ESECDBA.EVT_TXNMY_RPT

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
TAXONOMY_ID	number	22
TAXONONY_LEVEL_1	varchar2	300	√	null
TAXONONY_LEVEL_2	varchar2	300	√	null
TAXONONY_LEVEL_3	varchar2	300	√	null
TAXONONY_LEVEL_4	varchar2	300	√	null
DEVICE_CATEGORY	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 TXNMY_ID as Taxonomy_ID, TXNMY_LVL_1 as Taxonony_Level_1, TXNMY_LVL_2 as Taxonony_Level_2, TXNMY_LVL_3 as Taxonony_Level_3, TXNMY_LVL_4 as Taxonony_Level_4, DEVICE_CTGRY as Device_Category, DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY FROM EVT_TXNMY

SELECT
TXNMY_ID as Taxonomy_ID,
TXNMY_LVL_1 as Taxonony_Level_1,
TXNMY_LVL_2 as Taxonony_Level_2,
TXNMY_LVL_3 as Taxonony_Level_3,
TXNMY_LVL_4 as Taxonony_Level_4,
DEVICE_CTGRY as Device_Category,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY
FROM EVT_TXNMY