SchemaSpy - Table shrdb.LAWFS.EFSDEVICES

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

EFSDEVICEPREFS.DEVICEID

FK_EFSDEVICEPREFS1 C

EFSDOCUMENTS.DOCID

FK_EFSDEVICES1 C

DEVICETYPE

number

22

EFSDEVICETYPES.DOCID

FK_EFSDEVICES2 C

ADDRESS

nvarchar2

2000

STATUS

number

22

ISLOGICAL

number

22

0

NEXTDEVICE

number

22

√

null

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

Indexes:

Column(s)	Type	Sort	Constraint Name
DOCID	Primary key	Asc	PK_EFSDEVICES