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

Part Records

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

BOMITEM.PARTID	INTEG_593 R
COSTLAYER.PARTID	INTEG_1163 R
DEFAULTLOCATION.PARTID	INTEG_1047 R
INVENTORYLOG.PARTID	INTEG_317 R
PARTCOST.PARTID	INTEG_328 R
PARTREORDER.PARTID	INTEG_311 R
PARTTOTRACKING.PARTID	INTEG_189 R
PICKITEM.PARTID	INTEG_982 R
PRODUCT.PARTID	INTEG_356 R
RECEIPTITEM.PARTID	INTEG_807 R
TAG.PARTID	INTEG_338 R
VENDORCOSTRULE.PARTID	INTEG_792 R
WATCH.ITEMID	INTEG_808 R
WOITEM.PARTID	INTEG_752 R
XOITEM.PARTID	INTEG_1135 R

PARTCLASSID

integer

10

√

null

TYPEID

integer

10

0

PARTTYPE.ID

INTEG_300 R

UOMID

integer

10

UOM.ID

INTEG_302 R

NUM

varchar

70

DESCRIPTION

varchar

252

√

null

DETAILS

blob sub_type 1

0

√

null

ABCCODE

varchar

1

√

'N'

LEADTIME

integer

10

√

0

LEADTIMETOFULFILL

integer

10

√

0

REV

varchar

15

√

null

ACTIVEFLAG

smallint

5

√

0

CONTROLLEDFLAG

smallint

5

√

0

SERIALIZEDFLAG

smallint

5

√

0

TAXABLEFLAG

smallint

5

√

0

CONFIGUREABLE

smallint

5

√

0

DATECREATED

timestamp

19

√

null

DATELASTISSUED

timestamp

19

√

null

DATELASTMODIFIED

timestamp

19

√

null

LASTCHANGEDUSER

varchar

15

√

null

COGSACCOUNTID

integer

10

√

0

INTEG_305 R

INVENTORYACCOUNTID

integer

10

√

0

INTEG_306 R

WEIGHTUOMID

integer

10

√

1

UOM.ID

INTEG_307 R

ACCOUNTINGID

varchar

36

√

null

ACCOUNTINGHASH

varchar

30

√

null

ALWAYSMANUFACTURE

smallint

5

√

0

SIZEUOMID

integer

10

√

2

UOM.ID

INTEG_832 R

UPC

varchar

31

√

null

URL

varchar

256

√

null

PICKINUOMOFPART

smallint

5

√

0

DEFAULTPRODUCTID

integer

10

√

null

PRODUCT.ID

INTEG_1338 R

ADJUSTMENTACCOUNTID

integer

10

√

0

INTEG_33 R

VARIANCEACCOUNTID

integer

10

√

0

INTEG_34 R

SCRAPACCOUNTID

integer

10

√

0

INTEG_35 R

TRACKINGFLAG

smallint

5

√

0

RECEIVINGTOL

double precision

15

√

0

CYCLECOUNTTOL

double precision

15

√

0

WEIGHT

double precision

15

√

0

WIDTH

double precision

15

√

0

HEIGHT

double precision

15

√

0

LEN

double precision

15

√

0

STDCOST

double precision

15

√

0

DEFAULTBOMID

integer

10

√

10

BOM.ID

INTEG_775 R

TAXID

integer

10

√

null

TAXRATE.ID

INTEG_264 R

ALERTNOTE

varchar

90

√

null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
	Must be unique		RDB$82	These unique columns are also nullable
ID	Must be unique	Asc	RDB$PRIMARY81