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

Inventory Location Group - Warehouse

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

integer

ADDRESS.LOCATIONGROUPID	INTEG_802 R
BOMITEMTOLOCATION.LOCATIONGROUPID	INTEG_607 R
BOMTOLOCATION.LOCATIONGROUPID	INTEG_579 R
DEFAULTLOCATION.LOCATIONGROUPID	INTEG_1051 R
INVENTORYLOG.LOCATIONGROUPID	INTEG_322 R
LOCATION.LOCATIONGROUPID	INTEG_248 R
MO.LOCATIONGROUPID	INTEG_666 R
PARTREORDER.LOCATIONGROUPID	INTEG_312 R
PICK.LOCATIONGROUPID	INTEG_1062 R
PO.LOCATIONGROUPID	INTEG_443 R
RECEIPT.LOCATIONGROUPID	INTEG_1318 R
RMA.LOCATIONGROUPID	INTEG_1223 R
SHIP.LOCATIONGROUPID	INTEG_1065 R
SO.LOCATIONGROUPID	INTEG_467 R
USERTOLG.LOCATIONGROUPID	INTEG_621 R
WATCH.LOCATIONGROUPID	INTEG_664 R
WO.LOCATIONGROUPID	INTEG_736 R
XO.FROMLGID	INTEG_1119 R
XO.SHIPTOLGID	INTEG_1121 R

NAME

varchar

ACTIVEFLAG

smallint

√

QBCLASSID

integer

√

QBCLASS.ID

INTEG_130 R

DATELASTMODIFIED

timestamp

√

NULL

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
	Performance		KITOPTIONKITITEMID
	Performance		KITOPTIONPRODUCTID
	Performance		RDB$FOREIGN673
	Performance		RDB$FOREIGN674
ID	Must be unique	Asc	RDB$PRIMARY672