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

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

ASSOCPRICE.PRODUCTID	INTEG_847 R
KITITEM.KITPRODUCTID	INTEG_1358 R
KITITEM.PRODUCTID	INTEG_1359 R
KITOPTION.PRODUCTID	INTEG_1374 R
PART.DEFAULTPRODUCTID	INTEG_1338 R
QUICKLISTITEM.PRODUCTID	INTEG_720 R
RMAITEM.PRODUCTID	INTEG_1230 R
RMAITEM.PRODUCTSUBID	INTEG_1235 R
SOITEM.PRODUCTID	INTEG_492 R

PARTID

integer

10

√

null

PART.ID

INTEG_356 R

NUM

varchar

70

DESCRIPTION

varchar

252

√

null

DETAILS

blob sub_type 1

0

√

null

SKU

varchar

31

√

null

UPC

varchar

31

√

null

ACTIVEFLAG

smallint

5

√

1

TAXABLEFLAG

smallint

5

√

1

INCOMEACCOUNTID

integer

10

√

0

INTEG_359 R

DATECREATED

timestamp

19

√

null

DATELASTMODIFIED

timestamp

19

√

null

ACCOUNTINGID

varchar

36

√

null

ACCOUNTINGHASH

varchar

30

√

null

SIZEUOMID

integer

10

√

2

UOM.ID

INTEG_833 R

WEIGHTUOMID

integer

10

√

3

UOM.ID

INTEG_834 R

URL

varchar

256

√

null

UOMID

integer

10

UOM.ID

INTEG_836 R

SELLABLEINOTHERUOMS

smallint

5

√

1

DEFAULTSOITEMTYPE

integer

10

√

10

INTEG_1332 R

DISPLAYTYPEID

integer

10

√

10

KITDISPLAYTYPE.ID

INTEG_1387 R

KITFLAG

smallint

5

0

KITGROUPEDFLAG

smallint

5

√

0

SHOWSOCOMBOFLAG

smallint

5

1

USEPRICEFLAG

smallint

5

1

QBCLASSID

integer

10

√

null

QBCLASS.ID

INTEG_46 R

WEIGHT

double precision

15

√

0

WIDTH

double precision

15

√

0

HEIGHT

double precision

15

√

0

LEN

double precision

15

√

0

PRICE

double precision

15

√

0

TAXID

integer

10

√

null

TAXRATE.ID

INTEG_135 R

ALERTNOTE

varchar

90

√

null

QTYPERCARTON

double precision

15

√

NULL

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
PARTID	Performance	Asc	FB_PRODUCT_PARTID
NUM	Performance	Asc	IDX_14
DESCRIPTION	Performance	Asc	IDX_15
DISPLAYTYPEID	Performance	Asc	PRODUCTDISPLAYTYPEID
INCOMEACCOUNTID	Performance	Asc	PRODUCTINCOMEACCOUNTID
PARTID	Performance	Asc	PRODUCTPARTID
QBCLASSID	Performance	Asc	PRODUCTQBCLASSID
SHOWSOCOMBOFLAG	Performance	Asc	PRODUCTSHOWSOCOMBOFLAG_IDX
SIZEUOMID	Performance	Asc	PRODUCTSIZEUOMID
SKU	Performance	Asc	PRODUCTSKU
UOMID	Performance	Asc	PRODUCTUOMID
UPC	Performance	Asc	PRODUCTUPC
WEIGHTUOMID	Performance	Asc	PRODUCTWEIGHTUOMID
NUM	Must be unique	Asc	RDB$172
TAXID	Performance	Asc	RDB$FOREIGN1
PARTID	Performance	Asc	RDB$FOREIGN171
INCOMEACCOUNTID	Performance	Asc	RDB$FOREIGN173
SIZEUOMID	Performance	Asc	RDB$FOREIGN410
WEIGHTUOMID	Performance	Asc	RDB$FOREIGN411
UOMID	Performance	Asc	RDB$FOREIGN412
DEFAULTSOITEMTYPE	Performance	Asc	RDB$FOREIGN649
DISPLAYTYPEID	Performance	Asc	RDB$FOREIGN680
QBCLASSID	Performance	Asc	RDB$FOREIGN7
ID	Must be unique	Asc	RDB$PRIMARY170