SchemaSpy - View ESEC.ESECDBA.EVT_XDAS_TXNMY_RPT

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
XDAS_TAXONOMY_NAME	varchar2	765	√	null
XDAS_OUTCOME_NAME	varchar2	765	√	null
XDAS_REGISTRY	number	22	√	null
XDAS_PROVIDER	number	22	√	null
XDAS_CLASS	number	22	√	null
XDAS_IDENTIFIER	number	22	√	null
XDAS_OUTCOME	number	22	√	null
XDAS_DETAIL	number	22	√	null
XDAS_TAXONOMY_ID	number	22
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 XDAS_TXNMY_NAME as Xdas_Taxonomy_Name, XDAS_OUTCOME_NAME as Xdas_Outcome_Name, XDAS_REGISTRY as Xdas_Registry, XDAS_PROVIDER as Xdas_Provider, XDAS_CLASS as Xdas_Class, XDAS_IDENTIFIER as Xdas_Identifier, XDAS_OUTCOME as Xdas_Outcome, XDAS_OUTCOME_DTL as Xdas_Detail, XDAS_TXNMY_ID as Xdas_Taxonomy_Id, DATE_CREATED, DATE_MODIFIED, CREATED_BY, MODIFIED_BY FROM EVT_XDAS_TXNMY

SELECT
XDAS_TXNMY_NAME as Xdas_Taxonomy_Name,
XDAS_OUTCOME_NAME as Xdas_Outcome_Name,
XDAS_REGISTRY as Xdas_Registry,
XDAS_PROVIDER as Xdas_Provider,
XDAS_CLASS as Xdas_Class,
XDAS_IDENTIFIER as Xdas_Identifier,
XDAS_OUTCOME as Xdas_Outcome,
XDAS_OUTCOME_DTL as Xdas_Detail,
XDAS_TXNMY_ID as Xdas_Taxonomy_Id,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY
FROM EVT_XDAS_TXNMY