location


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
bomitemtolocation.locationId FK4purmtcl1memd1db8a2uh90ai R
bomitemtolocation_aud.locationId Implied Constraint R
bomtolocation.locationId FKlb3wn1pfrbdsvbprmkat5aiqh R
bomtolocation_aud.locationId Implied Constraint R
defaultlocation.locationId FKlvjcurkrvj33lxmqqehd9c93r R
defaultlocation_aud.locationId Implied Constraint R
inventorylog.begLocationId FK8i3qih5k0vlst9hf2a30pfyp4 R
inventorylog.endLocationId FK4365ss8d1y218q1d10x78859i R
qohview.LOCATIONID Implied Constraint R
receiptitem.locationId Implied Constraint R
receiptitem_aud.locationId Implied Constraint R
tag.locationId FK29ws6jbab1w79ww7uf9ck7pjj R
wo.locationId FKehkprc6rewqtagth6wrob57jb R
wo_aud.locationId Implied Constraint R
activeFlag BIT 1 null
countedAsAvailable BIT 1 null
dateLastModified DATETIME 26 √ null
defaultCustomerId INT 10 √ null
customer.id FKrm7ei310f0tvnlciel8wlrjaa R
defaultFlag BIT 1 null
defaultVendorId INT 10 √ null
vendor.id FKo7qub3x04qf08t0p66p4kjo62 R
description VARCHAR 252 √ null
locationGroupId INT 10 null
locationgroup.id FKdbr8c3q0091lx99rftn63xd6o R
name VARCHAR 30 null
parentId INT 10 √ null
pickable BIT 1 null
receivable BIT 1 null
sortOrder INT 10 √ null
typeId INT 10 null
locationtype.id FK5b4bqcapyw1o0negakd8x1r4h R
customFields JSON 1073741824 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK5b4bqcapyw1o0negakd8x1r4h Performance Asc typeId
FKdbr8c3q0091lx99rftn63xd6o Performance Asc locationGroupId
FKo7qub3x04qf08t0p66p4kjo62 Performance Asc defaultVendorId
FKrm7ei310f0tvnlciel8wlrjaa Performance Asc defaultCustomerId
locationNameIdx Performance Asc name
UKlc2j6104g2nrydu089volt013 Must be unique Asc/Asc name + locationGroupId

Relationships

Close relationships within degrees of separation