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

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

SHIPITEM.SHIPCARTONID	INTEG_948 R
SHIPUPSCARTONDETAILS.SHIPCARTONID	INTEG_920 R

SHIPID

integer

10

SHIP.ID

INTEG_517 R

ORDERID

integer

10

√

0

CARRIERID

integer

10

CARRIER.ID

INTEG_519 R

CARTONTYPEID

integer

10

√

0

TRACKINGNUM

varchar

30

√

null

CARTONNUM

integer

10

DATECREATED

timestamp

19

√

null

ORDERTYPEID

integer

10

INTEG_522 R

SSCC

varchar

20

√

null

FREIGHTWEIGHT

double precision

15

√

0

FREIGHTAMOUNT

double precision

15

√

0

WEIGHTUOM

varchar

254

√

null

LEN

double precision

15

√

0

HEIGHT

double precision

15

√

0

WIDTH

double precision

15

√

0

SIZEUOM

varchar

30

√

null

INSUREDVALUE

double precision

15

√

0

ADDITIONALHANDLING

smallint

5

√

null

SHIPPERRELEASE

smallint

5

√

null

DELIVERYCONFIRMATIONID

integer

10

4

INTEG_933 R

PACKAGETYPEID

integer

10

2

PACKAGETYPES.ID

INTEG_935 R

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
	Must be unique		RDB$534	These unique columns are also nullable
ORDERTYPEID	Performance	Asc	RDB$FOREIGN247
CARRIERID	Performance	Asc	RDB$FOREIGN248
	Performance		RDB$FOREIGN249
	Performance		RDB$FOREIGN250
	Performance		RDB$FOREIGN37
	Performance		RDB$FOREIGN48
	Performance		RDB$FOREIGN522
ID	Must be unique	Asc	RDB$PRIMARY246
CARRIERID	Performance	Asc	SHIPCARRIERID
DATECREATED	Performance	Asc	SHIPDATECREATED
	Performance		SHIPDATESHIPPED
	Performance		SHIPFOBPOINTID
	Performance		SHIPLOCGRPINDX
ORDERTYPEID	Performance	Asc	SHIPORDERTYPEID
	Performance		SHIPSTATUSID