SchemaSpy - Table shrdb.LAWFS.EFSDOCUMENTS

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

DOCID

number

22

EFSDEVICES.DOCID	FK_EFSDEVICES1 C
EFSDEVICETYPES.DOCID	FK_EFSDEVICETYPES C
EFSDOCPROPS.DOCID	FK_EFSDOCPROPS C

OWNERID

number

22

EFSDELIVERYUSERS.OWNERID

FK_EFSDOCUMENTS C

DOCNAME

nvarchar2

256

DOCTYPE

number

22

DOCDESCRIPT

nvarchar2

2000

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
DOCID	Primary key	Asc	PK_EFSDOCUMENTS
OWNERID + DOCNAME + DOCTYPE	Must be unique	Asc/Asc/Asc	UK_EFSDOCUMENTS