SchemaSpy - Table ESEC.ESECDBA.USERS

Generated by
SchemaSpy

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

USR_ID

number

22

EVT_USR.USR_ID	Implied Constraint
MD_CONFIG.USR_ID	Implied Constraint
USERS_RPT_V.USR_ID	Implied Constraint

NAME

varchar2

192

CNT_ID

number

22

√

null

CONTACTS.CNT_ID

USR_CNT_FK

STT_ID

number

22

STATES.STT_ID

USR_STT_FK

DESCRIPTION

varchar2

1536

√

null

DATE_CREATED

date

7

DATE_MODIFIED

date

7

CREATED_BY

number

22

√

null

MODIFIED_BY

number

22

√

null

PERMISSIONS

varchar2

4000

√

null

FILTER

varchar2

384

√

null

UPPER_NAME

varchar2

192

√

null

DOMAIN_AUTH_IND

number

1

√

null

Table contained 2 rows at Tue May 04 17:09 EDT 2010

Indexes:

Column(s)	Type	Sort	Constraint Name
USR_ID	Primary key	Asc	USR_PK
CNT_ID	Performance	Asc	USR_CNT_ID_IDX