Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.LOCATION
Inventory Location - aka Shelf/Bin/Aisle

 Generated by
SchemaSpy
Legend: SourceForge.net
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
BOMITEMTOLOCATION.LOCATIONID INTEG_605 R
BOMTOLOCATION.LOCATIONID INTEG_577 R
DEFAULTLOCATION.LOCATIONID INTEG_1049 R
INVENTORYLOG.BEGLOCATIONID INTEG_319 R
INVENTORYLOG.ENDLOCATIONID INTEG_321 R
TAG.LOCATIONID INTEG_340 R
WO.LOCATIONID INTEG_737 R
TYPEID integer 10
LOCATIONTYPE.ID INTEG_245 R
PARENTID integer 10  √  0
NAME varchar 30
DESCRIPTION varchar 252  √  null
COUNTEDASAVAILABLE smallint 5  √  1
DEFAULTFLAG smallint 5  √  0
ACTIVEFLAG smallint 5  √  1
PICKABLE smallint 5  √  1
RECEIVABLE smallint 5  √  1
LOCATIONGROUPID integer 10
LOCATIONGROUP.ID INTEG_248 R
SORTORDER integer 10  √  0
DEFAULTCUSTOMERID integer 10  √  null
CUSTOMER.ID INTEG_1336 R
DEFAULTVENDORID integer 10  √  null
VENDOR.ID INTEG_1337 R
DATELASTMODIFIED timestamp 19  √  null

Analyzed at Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
LOCATIONGROUPID Performance Asc LOCATIONLOCATIONGROUPID
NAME Performance Asc LOCATIONNAME
TYPEID Performance Asc LOCATIONTYPEID
NAME + LOCATIONGROUPID Must be unique Asc/Asc RDB$118
TYPEID Performance Asc RDB$FOREIGN116
LOCATIONGROUPID Performance Asc RDB$FOREIGN117
DEFAULTCUSTOMERID Performance Asc RDB$FOREIGN653
DEFAULTVENDORID Performance Asc RDB$FOREIGN654
ID Must be unique Asc RDB$PRIMARY115

Close relationships  within of separation: