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

Purchase Order Header Table

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

POSTPO.POID

INTEG_1259 R

CARRIERID

integer

10

CARRIER.ID

INTEG_426 R

FOBPOINTID

integer

10

FOBPOINT.ID

INTEG_428 R

PAYMENTTERMSID

integer

10

PAYMENTTERMS.ID

INTEG_430 R

REMITCOUNTRYID

integer

10

√

null

REMITSTATEID

integer

10

√

null

SHIPTERMSID

integer

10

INTEG_432 R

SHIPTOCOUNTRYID

integer

10

√

null

SHIPTOSTATEID

integer

10

√

null

TYPEID

integer

10

POTYPE.ID

INTEG_434 R

STATUSID

integer

10

POSTATUS.ID

INTEG_436 R

VENDORID

integer

10

VENDOR.ID

INTEG_438 R

USERNAME

varchar

15

√

null

NUM

varchar

25

VENDORSO

varchar

25

√

null

VENDORCONTACT

varchar

30

√

null

REMITTONAME

varchar

60

√

null

REMITADDRESS

varchar

90

√

null

REMITCITY

varchar

30

√

null

REMITZIP

varchar

10

√

null

BUYER

varchar

30

√

null

SHIPTONAME

varchar

60

√

null

SHIPTOADDRESS

varchar

90

√

null

SHIPTOCITY

varchar

30

√

null

SHIPTOZIP

varchar

10

√

null

DELIVERTO

varchar

30

√

null

REVISIONNUM

integer

10

√

0

DATELASTMODIFIED

timestamp

19

√

null

DATECREATED

timestamp

19

√

null

DATEISSUED

timestamp

19

√

null

DATECONFIRMED

timestamp

19

√

null

DATEREVISION

timestamp

19

√

null

DATEFIRSTSHIP

timestamp

19

√

null

DATECOMPLETED

timestamp

19

√

null

QBCLASSID

integer

10

√

1

QBCLASS.ID

INTEG_441 R

LOCATIONGROUPID

integer

10

LOCATIONGROUP.ID

INTEG_443 R

NOTE

blob sub_type 1

0

√

null

CUSTOMERSO

varchar

25

√

null

URL

varchar

256

√

null

TAXRATEID

integer

10

√

null

TAXRATE.ID

INTEG_266 R

TOTALTAX

double precision

15

√

null

TAXRATENAME

varchar

31

√

null

TOTALINCLUDESTAX

smallint

5

√

0

CURRENCYID

integer

10

√

null

CURRENCY.ID

INTEG_1155 R

CURRENCYRATE

double precision

15

√

1

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
NUM	Must be unique	Asc	INTEG_440
CARRIERID	Performance	Asc	POCARRIERID
CUSTOMERSO	Performance	Asc	POCUSTOMERSO
DATECOMPLETED	Performance	Asc	PODATECOMPLETED
DATECONFIRMED	Performance	Asc	PODATECONFIRMED
DATECREATED	Performance	Asc	PODATECREATED
DATEFIRSTSHIP	Performance	Asc	PODATEFIRSTSHIP
DATEISSUED	Performance	Asc	PODATEISSUED
DATEREVISION	Performance	Asc	PODATEREVISION
FOBPOINTID	Performance	Asc	POFOBPOINTID
LOCATIONGROUPID	Performance	Asc	POLOCATIONGROUPID
NUM	Performance	Asc	PONUM
PAYMENTTERMSID	Performance	Asc	POPAYMENTTERMSID
QBCLASSID	Performance	Asc	POQBCLASSID
SHIPTERMSID	Performance	Asc	POSHIPTERMSID
STATUSID	Performance	Asc	POSTATUSID
TYPEID	Performance	Asc	POTYPEID
VENDORID	Performance	Asc	POVENDORID
VENDORSO	Performance	Asc	POVENDORSO
TAXRATEID	Performance	Asc	RDB$FOREIGN11
CURRENCYID	Performance	Asc	RDB$FOREIGN142
CARRIERID	Performance	Asc	RDB$FOREIGN206
FOBPOINTID	Performance	Asc	RDB$FOREIGN207
PAYMENTTERMSID	Performance	Asc	RDB$FOREIGN208
SHIPTERMSID	Performance	Asc	RDB$FOREIGN209
TYPEID	Performance	Asc	RDB$FOREIGN210
STATUSID	Performance	Asc	RDB$FOREIGN211
VENDORID	Performance	Asc	RDB$FOREIGN212
QBCLASSID	Performance	Asc	RDB$FOREIGN214
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN215
ID	Must be unique	Asc	RDB$PRIMARY205