Table shrdb.LAWSN.ENPPERSONALOBJECT Generated by
SchemaSpy
Legend: SourceForge.net
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
OBJECTID char 100
ENPPERSONALALERTHIST.OBJECTID FK_ALERTHIST_PERSONALOBJECT C
ENPPERSONALTRIPPED.OBJECTID FK_TRIPPED_PERSONALOBJECT C
ALERTNAME nvarchar2 500  √  null
USERNAME nvarchar2 250  √  null
DESCRIPTION nvarchar2 1000  √  null
ALERTTYPE varchar2 1  √  null
ENABLESTATUS varchar2 1  √  null
PROCESSINGSTATUS varchar2 1  √  null
DATASOURCE varchar2 2  √  null
FORMORIGIN varchar2 12  √  null
CREATEDATETIME date 7  √  null
STARTDATETIME date 7  √  null
ENDDATETIME date 7  √  null
FREQUENCY varchar2 1  √  null
LASTRUNDATETIME date 7  √  null
NEXTPROCDATETIME date 7  √  null
PROCESSEDCOUNTER number 22  √  null
STOPRULE varchar2 1  √  null
CLIENTXML nclob 4000  √  null
RESPONSEXML blob 4000  √  null
PROCESSINGDATA blob 4000  √  null

Table contained 0 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
OBJECTID Primary key Asc PK_ENPPERSONALOBJECT_OBJECTID

Close relationships: