locationgroup


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
address.locationGroupId FKeb9p2sl5g5eg3ss19hxfj68vx R
bomitemtolocation.locationGroupId FK85fq12qj8tqdffnlof52p0d2w R
bomtolocation.locationGroupId FK1epqyk52u859rcr9y12mfkhg4 R
defaultlocation.locationGroupId FKewsgk9wkk42a6is2k2ujf67xy R
inventorylog.locationGroupId FKqyvvoyphlhr86w6gkggmc5ik9 R
location.locationGroupId FKdbr8c3q0091lx99rftn63xd6o R
mo.locationGroupId FKlwbv9u1264ui0jv0kip6t7f2e R
notification.locationGroupId FKNotificationLocationGroupId R
partreorder.locationGroupId FKrqbatnyevd9buvfpur3pir4a9 R
pick.locationGroupId FK5aw6xpq8126ajp30yywjl9lf7 R
po.locationGroupId FKns1kxfo7dgixcekw34hu4bnt4 R
receipt.locationGroupId FK55lrc8meneoxaotygksohs5oe R
rma.locationGroupId FK8390alxisu5cqs3d580cmnhy3 R
ship.locationGroupId FKba5surnm1t6w0rimckhk6xivd R
so.locationGroupId FKrypf38gxheyggehl4ssm4l2mt R
usertolg.locationGroupId FKfw8oc670jlse8yh17ojon0emg R
watch.locationGroupId FK5ps0jyg9wlibhp2iu4bbhu7lp R
wo.locationGroupId FKp1jvxjqnx6dx1h8469k5xa02d R
xo.fromLGId FK32yiw9aqxue37clcqfl0o2khv R
xo.shipToLGId FKrtl3tvftrid2h9r0e15ox3h4u R
activeFlag BIT 1 null
dateLastModified DATETIME 26 √ null
name VARCHAR 30 null
qbClassId INT 10 √ null
qbclass.id FKarya0mcflqbxdbxa18jcrtqhl R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKarya0mcflqbxdbxa18jcrtqhl Performance Asc qbClassId
locationGroupNameIdx Performance Asc name
UKavmvxmck7nw8j2kihnbyw9ldx Must be unique Asc name

Relationships