Table shrdb.LAWSN.ENPTRANSACTSUB 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
SUBID number 22
SUBUSER nvarchar2 50
SUBUSERTYPE number 22
SUBTRANSOURCE number 22
SUBFORM nvarchar2 50
SUBHKEY nvarchar2 100
SUBKEYFIELD nvarchar2 20
SUBOPERATOR number 22
SUBKEYVAL nvarchar2 2000  √  null
SUBM1VAL number 38,7  √  null
SUBM2VAL number 38,7  √  null
SUBMPREV number 38,7  √  null
SUBCOMMENT nvarchar2 200  √  null
SUBDELIVERY nvarchar2 500  √  null
SUBFLAG1 number 22  √  null
SUBFLAG2 number 22  √  null
SUBEXTRDATA nvarchar2 100  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
SUBTRANSOURCE + SUBFORM + SUBHKEY + SUBID Primary key Asc/Asc/Asc/Asc PK_TRANSSUB
SUBID Performance Asc IDX_ENPTRANSUBID
SUBUSERTYPE + SUBUSER + SUBTRANSOURCE + SUBFORM Performance Asc/Asc/Asc/Asc IDX_ENPTRANSUBUFK