SchemaSpy - Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.PICKITEM

Pick Item Detail

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

ID

integer

10

STATUSID

integer

10

PICKITEMSTATUS.ID

INTEG_978 R

PICKID

integer

10

PICK.ID

INTEG_980 R

PARTID

integer

10

PART.ID

INTEG_982 R

TAGID

integer

10

√

0

UOMID

integer

10

UOM.ID

INTEG_985 R

DESTTAGID

integer

10

√

0

ORDERTYPEID

integer

10

INTEG_987 R

ORDERID

integer

10

ORDERITEMID

integer

10

SLOTNUM

integer

10

√

1

SRCTAGID

integer

10

√

null

QTY

double precision

15

√

0

TYPEID

integer

10

√

10

PICKITEMTYPE.ID

INTEG_545 R

SRCLOCATIONID

integer

10

√

null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
	Must be unique		INTEG_440	These unique columns are also nullable
	Performance		POCARRIERID
	Performance		POCUSTOMERSO
	Performance		PODATECOMPLETED
	Performance		PODATECONFIRMED
	Performance		PODATECREATED
	Performance		PODATEFIRSTSHIP
	Performance		PODATEISSUED
	Performance		PODATEREVISION
	Performance		POFOBPOINTID
	Performance		POLOCATIONGROUPID
	Performance		PONUM
	Performance		POPAYMENTTERMSID
	Performance		POQBCLASSID
	Performance		POSHIPTERMSID
STATUSID	Performance	Asc	POSTATUSID
TYPEID	Performance	Asc	POTYPEID
	Performance		POVENDORID
	Performance		POVENDORSO
	Performance		RDB$FOREIGN11
	Performance		RDB$FOREIGN142
	Performance		RDB$FOREIGN206
	Performance		RDB$FOREIGN207
	Performance		RDB$FOREIGN208
	Performance		RDB$FOREIGN209
TYPEID	Performance	Asc	RDB$FOREIGN210
STATUSID	Performance	Asc	RDB$FOREIGN211
	Performance		RDB$FOREIGN212
	Performance		RDB$FOREIGN214
	Performance		RDB$FOREIGN215
ID	Must be unique	Asc	RDB$PRIMARY205