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

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

RECEIPTID

integer

10

RECEIPT.ID

INTEG_1322 R

LOCATIONID

integer

10

√

null

RESPONSIBILITYID

integer

10

√

null

TYPEID

integer

10

RECEIPTITEMTYPE.ID

INTEG_1324 R

PARTTYPEID

integer

10

PARTTYPE.ID

INTEG_1326 R

TAGID

integer

10

√

null

REASON

varchar

90

√

null

PARTID

integer

10

√

null

PART.ID

INTEG_807 R

SHIPITEMID

integer

10

√

null

ORDERITEMID

integer

10

√

null

STATUSID

integer

10

10

RECEIPTITEMSTATUS.ID

INTEG_1328 R

UOMID

integer

10

UOM.ID

INTEG_1330 R

DATERECEIVED

timestamp

19

√

null

DATERECONCILED

timestamp

19

√

null

TRACKINGNUM

varchar

30

√

null

CARRIERID

integer

10

√

null

CARRIER.ID

INTEG_806 R

PACKAGECOUNT

integer

10

√

1

DELIVERTO

varchar

30

√

null

BILLVENDORFLAG

smallint

5

√

1

DATELASTMODIFIED

timestamp

19

√

null

QTY

double precision

15

√

0

BILLEDTOTALCOST

double precision

15

√

0

LANDEDTOTALCOST

double precision

15

√

0

CUSTOMERID

integer

10

√

null

CUSTOMER.ID

INTEG_780 R

TAXID

integer

10

√

null

TAXRATE.ID

INTEG_267 R

TAXRATE

double precision

15

√

0

REFNO

varchar

20

√

null

DATEBILLED

timestamp

19

√

null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
TAXID	Performance	Asc	RDB$FOREIGN12
CUSTOMERID	Performance	Asc	RDB$FOREIGN174
CARRIERID	Performance	Asc	RDB$FOREIGN196
PARTID	Performance	Asc	RDB$FOREIGN197
RECEIPTID	Performance	Asc	RDB$FOREIGN643
TYPEID	Performance	Asc	RDB$FOREIGN644
PARTTYPEID	Performance	Asc	RDB$FOREIGN645
STATUSID	Performance	Asc	RDB$FOREIGN646
UOMID	Performance	Asc	RDB$FOREIGN647
ID	Must be unique	Asc	RDB$PRIMARY642
CARRIERID	Performance	Asc	RECEIPTITEMCARRIERID_IDX
CUSTOMERID	Performance	Asc	RECEIPTITEMCUSTOMERID
DATEBILLED	Performance	Asc	RECEIPTITEMDATEBILLED
DATERECEIVED	Performance	Asc	RECEIPTITEMDATERECEIVED
DATERECONCILED	Performance	Asc	RECEIPTITEMDATERECONCILED
ORDERITEMID	Performance	Asc	RECEIPTITEMORDERITEMID_IDX
PARTTYPEID	Performance	Asc	RECEIPTITEMPARTTYPEID_IDX
RECEIPTID	Performance	Asc	RECEIPTITEMRECEIPTID_IDX
STATUSID	Performance	Asc	RECEIPTITEMSTATUSID_IDX
TYPEID	Performance	Asc	RECEIPTITEMTYPEID_IDX
UOMID	Performance	Asc	RECEIPTITEMUOMID