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

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

SHIPCARTON.SHIPID	INTEG_517 R
SHIPITEM.SHIPID	INTEG_526 R
SHIPUPSDETAILS.SHIPID	INTEG_913 R
UPSRETURNSHIPMENT.SHIPID	INTEG_928 R

ORDERTYPEID

integer

10

INTEG_507 R

ORDERID

integer

10

√

0

CARRIERID

integer

10

CARRIER.ID

INTEG_509 R

FOBPOINTID

integer

10

FOBPOINT.ID

INTEG_511 R

STATUSID

integer

10

INTEG_513 R

SHIPTOID

integer

10

√

0

INVOICEID

integer

10

√

null

CARTONCOUNT

integer

10

√

0

DATECREATED

timestamp

19

√

null

DATESHIPPED

timestamp

19

√

null

INVOICENO

varchar

15

√

null

INVOICEDFLAG

smallint

5

√

0

NOTE

blob sub_type 1

0

√

null

LOCATIONGROUPID

integer

10

LOCATIONGROUP.ID

INTEG_1065 R

BILLOFLADING

varchar

20

√

null

OWNERISFROM

smallint

5

√

1

INVOICEAMOUNT

double precision

15

√

0

INVOICEAMOUNTPAID

double precision

15

√

0

DATELASTMODIFIED

timestamp

19

√

NULL

NUM

varchar

35

SHIPPEDBY

integer

10

√

null

SYSUSER.ID

INTEG_873 R

UPSSERVICEID

integer

10

√

null

INTEG_884 R

SHIPMENTIDENTIFICATIONNUMBER

varchar

32

√

null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
BILLOFLADING	Must be unique	Asc	RDB$534	This unique column is also nullable
ORDERTYPEID	Performance	Asc	RDB$FOREIGN247
CARRIERID	Performance	Asc	RDB$FOREIGN248
FOBPOINTID	Performance	Asc	RDB$FOREIGN249
STATUSID	Performance	Asc	RDB$FOREIGN250
SHIPPEDBY	Performance	Asc	RDB$FOREIGN37
UPSSERVICEID	Performance	Asc	RDB$FOREIGN48
LOCATIONGROUPID	Performance	Asc	RDB$FOREIGN522
ID	Must be unique	Asc	RDB$PRIMARY246
CARRIERID	Performance	Asc	SHIPCARRIERID
DATECREATED	Performance	Asc	SHIPDATECREATED
DATESHIPPED	Performance	Asc	SHIPDATESHIPPED
FOBPOINTID	Performance	Asc	SHIPFOBPOINTID
LOCATIONGROUPID	Performance	Asc	SHIPLOCGRPINDX
ORDERTYPEID	Performance	Asc	SHIPORDERTYPEID
STATUSID	Performance	Asc	SHIPSTATUSID