SchemaSpy - Table shrdb.LAWFS.ENPDELIVERYLOG

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

TIMESTMP

date

7

now

USERID

number

22

ENPUSERMAP.USERID

FK_DELIVERYLOG C

TRACKING

nvarchar2

25

EVENT_ID

number

22

DEVICE_ID

number

22

√

null

DOCUMENT_ID

number

22

√

null

DOCUMENT_TYPE

number

22

√

null

MESSAGE

nvarchar2

200

√

null

DETAILS

nvarchar2

2000

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
USERID + TRACKING + EVENT_ID + TIMESTMP	Primary key	Asc/Asc/Asc/Asc	PK_DELIVERYLOG