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

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

MO.SOID	INTEG_777 R
POSTRANSACTION.SOID	INTEG_471 R
POSTSO.SOID	INTEG_1244 R
SOITEM.SOID	INTEG_494 R

STATUSID

integer

10

SOSTATUS.ID

INTEG_453 R

CARRIERID

integer

10

√

null

CARRIER.ID

INTEG_805 R

FOBPOINTID

integer

10

FOBPOINT.ID

INTEG_455 R

PAYMENTTERMSID

integer

10

PAYMENTTERMS.ID

INTEG_457 R

BILLTOCOUNTRYID

integer

10

√

null

BILLTOSTATEID

integer

10

√

null

SHIPTERMSID

integer

10

√

null

INTEG_804 R

SHIPTOCOUNTRYID

integer

10

√

null

SHIPTOSTATEID

integer

10

√

null

TYPEID

integer

10

SOTYPE.ID

INTEG_459 R

CUSTOMERID

integer

10

CUSTOMER.ID

INTEG_461 R

USERNAME

varchar

15

√

null

NUM

varchar

25

CUSTOMERPO

varchar

25

√

null

CUSTOMERCONTACT

varchar

30

√

null

BILLTONAME

varchar

60

√

null

BILLTOADDRESS

varchar

90

√

null

BILLTOCITY

varchar

30

√

null

BILLTOZIP

varchar

10

√

null

SALESMAN

varchar

30

√

null

SALESMANINITIALS

varchar

5

√

null

SHIPTONAME

varchar

60

√

null

SHIPTOADDRESS

varchar

90

√

null

SHIPTOCITY

varchar

30

√

null

SHIPTOZIP

varchar

10

√

null

REVISIONNUM

integer

10

√

0

DATELASTMODIFIED

timestamp

19

√

null

DATECREATED

timestamp

19

√

null

DATEISSUED

timestamp

19

√

null

DATEREVISION

timestamp

19

√

null

DATEFIRSTSHIP

timestamp

19

√

null

DATECOMPLETED

timestamp

19

√

null

TAXRATEID

integer

10

√

null

TAXRATE.ID

INTEG_464 R

TAXRATENAME

varchar

31

√

'None'

QBCLASSID

integer

10

√

1

QBCLASS.ID

INTEG_465 R

LOCATIONGROUPID

integer

10

LOCATIONGROUP.ID

INTEG_467 R

NOTE

blob sub_type 1

0

√

null

REGISTERID

integer

10

√

0

RESIDENTIALFLAG

smallint

5

√

0

VENDORPO

varchar

25

√

null

TOTALTAX

double precision

15

√

0

COST

double precision

15

√

0

TAXRATE

double precision

15

√

0

URL

varchar

256

√

null

TOTALINCLUDESTAX

smallint

5

√

0

UPSSERVICEID

integer

10

√

null

INTEG_899 R

PRIORITYID

integer

10

√

null

PRIORITY.ID

INTEG_945 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
NUM	Must be unique	Asc	INTEG_463
PRIORITYID	Performance	Asc	RDB$FOREIGN107
SHIPTERMSID	Performance	Asc	RDB$FOREIGN193
CARRIERID	Performance	Asc	RDB$FOREIGN195
STATUSID	Performance	Asc	RDB$FOREIGN219
FOBPOINTID	Performance	Asc	RDB$FOREIGN220
PAYMENTTERMSID	Performance	Asc	RDB$FOREIGN221
TYPEID	Performance	Asc	RDB$FOREIGN222
CUSTOMERID	Performance	Asc	RDB$FOREIGN223
TAXRATEID	Performance	Asc	RDB$FOREIGN225
QBCLASSID	Performance	Asc	RDB$FOREIGN226
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN227
UPSSERVICEID	Performance	Asc	RDB$FOREIGN57
ID	Must be unique	Asc	RDB$PRIMARY218
CARRIERID	Performance	Asc	SOCARRIERID
CUSTOMERID	Performance	Asc	SOCUSTOMERID
CUSTOMERPO	Performance	Asc	SOCUSTOMERPO
DATECOMPLETED	Performance	Asc	SODATECOMPLETED
DATECREATED	Performance	Asc	SODATECREATED
DATEFIRSTSHIP	Performance	Asc	SODATEFIRSTSHIP
DATEISSUED	Performance	Asc	SODATEISSUED
DATEREVISION	Performance	Asc	SODATEREVISION
FOBPOINTID	Performance	Asc	SOFOBPOINTID
LOCATIONGROUPID	Performance	Asc	SOLOCATIONGROUPID
NUM	Performance	Asc	SONUM
PAYMENTTERMSID	Performance	Asc	SOPAYMENTTERMSID
QBCLASSID	Performance	Asc	SOQBCLASSID
SALESMAN	Performance	Asc	SOSALESMAN
SHIPTERMSID	Performance	Asc	SOSHIPTERMSID
STATUSID	Performance	Asc	SOSTATUSID
TAXRATEID	Performance	Asc	SOTAXRATEID
USERNAME	Performance	Asc	SOUSERNAME
VENDORPO	Performance	Asc	SOVENDORPO