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

X

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

POSTWO.WOID	INTEG_765 R
WOASSIGNEDUSERS.WOID	INTEG_742 R
WOITEM.WOID	INTEG_748 R

NUM

varchar

30

MOITEMID

integer

10

MOITEM.ID

INTEG_731 R

TYPEID

integer

10

√

null

STATUSID

integer

10

WOSTATUS.ID

INTEG_733 R

QTYTARGET

integer

10

√

0

QTYORDERED

integer

10

√

0

QTYSCRAPPED

integer

10

√

0

USERID

integer

10

1

SYSUSER.ID

INTEG_735 R

DATESCHEDULED

timestamp

19

√

null

DATELASTMODIFIED

timestamp

19

√

null

DATECREATED

timestamp

19

√

null

DATESTARTED

timestamp

19

√

null

DATEFINISHED

timestamp

19

√

null

LOCATIONGROUPID

integer

10

√

null

LOCATIONGROUP.ID

INTEG_736 R

LOCATIONID

integer

10

√

null

LOCATION.ID

INTEG_737 R

NOTE

blob sub_type 1

0

√

null

COST

double precision

15

√

0

QBCLASSID

integer

10

√

1

QBCLASS.ID

INTEG_738 R

CUSTOMERID

integer

10

√

null

CUSTOMER.ID

INTEG_782 R

DATESCHEDULEDTOSTART

timestamp

19

√

null

PRIORITYID

integer

10

√

null

PRIORITY.ID

INTEG_983 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
	Performance		RDB$FOREIGN198
	Performance		RDB$FOREIGN327
TYPEID	Performance	Asc	RDB$FOREIGN328
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN329
	Performance		RDB$FOREIGN330
ID	Must be unique	Asc	RDB$PRIMARY326
	Performance		WATCHITEMID
	Performance		WATCHLGSUMTYPEID
LOCATIONGROUPID	Performance	Asc	WATCHLOCATIONGROUPID
	Performance		WATCHSYSUSERID
TYPEID	Performance	Asc	WATCHTYPEID