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

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

POSTSOITEM.SOITEMID	INTEG_1253 R
SOITEMTOMOITEM.SOITEMID	INTEG_693 R

PRODUCTID

integer

10

√

null

PRODUCT.ID

INTEG_492 R

SOID

integer

10

SO.ID

INTEG_494 R

TYPEID

integer

10

INTEG_496 R

STATUSID

integer

10

SOITEMSTATUS.ID

INTEG_498 R

UOMID

integer

10

√

null

UOM.ID

INTEG_499 R

SOLINEITEM

integer

10

DESCRIPTION

varchar

252

√

null

PRODUCTNUM

varchar

70

CUSTOMERPARTNUM

varchar

70

√

null

TAXABLEFLAG

smallint

5

√

0

DATELASTFULFILLMENT

timestamp

19

√

null

DATESCHEDULEDFULFILLMENT

timestamp

19

'NOW'

REVLEVEL

varchar

15

√

null

EXCHANGESOLINEITEM

integer

10

√

0

QBCLASSID

integer

10

√

1

QBCLASS.ID

INTEG_503 R

NOTE

blob sub_type 1

0

√

null

SHOWITEMFLAG

smallint

5

1

QTYTOFULFILL

double precision

15

√

0

QTYFULFILLED

double precision

15

√

0

QTYPICKED

double precision

15

√

0

ITEMADJUSTID

integer

10

√

null

ADJUSTPERCENTAGE

double precision

15

√

0

UNITPRICE

double precision

15

√

0

TOTALPRICE

double precision

15

√

0

ADJUSTAMOUNT

double precision

15

√

0

TOTALCOST

double precision

15

√

0

DATELASTMODIFIED

timestamp

19

√

NULL

TAXID

integer

10

√

null

TAXRATE.ID

INTEG_263 R

TAXRATE

double precision

15

√

null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
	Must be unique		INTEG_463	These unique columns are also nullable
	Performance		RDB$FOREIGN107
	Performance		RDB$FOREIGN193
	Performance		RDB$FOREIGN195
STATUSID	Performance	Asc	RDB$FOREIGN219
	Performance		RDB$FOREIGN220
	Performance		RDB$FOREIGN221
TYPEID	Performance	Asc	RDB$FOREIGN222
	Performance		RDB$FOREIGN223
	Performance		RDB$FOREIGN225
QBCLASSID	Performance	Asc	RDB$FOREIGN226
	Performance		RDB$FOREIGN227
	Performance		RDB$FOREIGN57
ID	Must be unique	Asc	RDB$PRIMARY218
	Performance		SOCARRIERID
	Performance		SOCUSTOMERID
	Performance		SOCUSTOMERPO
	Performance		SODATECOMPLETED
	Performance		SODATECREATED
	Performance		SODATEFIRSTSHIP
	Performance		SODATEISSUED
	Performance		SODATEREVISION
	Performance		SOFOBPOINTID
	Performance		SOLOCATIONGROUPID
	Performance		SONUM
	Performance		SOPAYMENTTERMSID
QBCLASSID	Performance	Asc	SOQBCLASSID
	Performance		SOSALESMAN
	Performance		SOSHIPTERMSID
STATUSID	Performance	Asc	SOSTATUSID
	Performance		SOTAXRATEID
	Performance		SOUSERNAME
	Performance		SOVENDORPO