Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
qohview
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
LOCATIONGROUPID
INT
10
null
LOCATIONID
INT
10
null
location
.id
Implied Constraint
R
PARTID
INT
10
√
null
part
.id
Implied Constraint
R
TAGNUM
BIGINT
19
null
SERIALNUM
VARCHAR
256
√
null
QTY
DECIMAL
51,9
0.000000000
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
select `fishbowl`.`location`.`locationGroupId` AS `LOCATIONGROUPID`,`fishbowl`.`tag`.`locationId` AS `LOCATIONID`,`fishbowl`.`tag`.`partId` AS `PARTID`,`fishbowl`.`tag`.`num` AS `TAGNUM`,`fishbowl`.`tagserialview`.`SERIALNUM` AS `SERIALNUM`,(((1 - `fishbowl`.`tag`.`qty`) * (count(`fishbowl`.`tagserialview`.`SERIALNUM`) - 1)) + 1) AS `QTY` from `fishbowl`.`location` join (`fishbowl`.`tag` left join `fishbowl`.`tagserialview` on((`fishbowl`.`tagserialview`.`TAGID` = `fishbowl`.`tag`.`id`))) where (`fishbowl`.`location`.`id` = `fishbowl`.`tag`.`locationId`) group by `fishbowl`.`location`.`locationGroupId`,`fishbowl`.`tag`.`locationId`,`fishbowl`.`tag`.`partId`,`fishbowl`.`tag`.`num`,`fishbowl`.`tagserialview`.`SERIALNUM`,`fishbowl`.`tag`.`qty`
Possibly Referenced Tables/Views
location
tag
tagserialview
serialnum