Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
ESEC
.
ESECDBA
.
ROLE_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
ROLE_CODE
varchar2
15
ROLE_NAME
varchar2
765
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
ROLE_LKUP
.ROLE_CD,
ROLE_LKUP
.ROLE_NAME,
ROLE_LKUP
.DATE_CREATED,
ROLE_LKUP
.DATE_MODIFIED,
ROLE_LKUP
.CREATED_BY,
ROLE_LKUP
.MODIFIED_BY
FROM
ROLE_LKUP