Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
ESEC
.
ESECDBA
.
EXTERNAL_DATA_RPT_V
Generated by
SchemaSpy
Related columns
Constraint names
Comments
Legend
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
<
n
> number of related tables
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
EXTERNAL_DATA_ID
number
22
SOURCE_NAME
varchar2
150
√
null
SOURCE_DATA_ID
varchar2
765
√
null
EXTERNAL_DATA
clob
4000
√
null
EXTERNAL_DATA_TYPE
varchar2
30
√
null
DATE_CREATED
date
7
DATE_MODIFIED
date
7
CREATED_BY
number
22
√
null
MODIFIED_BY
number
22
√
null
Analyzed at Tue May 04 17:09 EDT 2010
View SQL:
SELECT
EXT_DATA_ID, SOURCE_NAME, SOURCE_DATA_ID,
EXT_DATA
, EXT_DATA_TYPE,DATE_CREATED,DATE_MODIFIED, CREATED_BY, MODIFIED_BY
FROM
EXT_DATA