Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
womoview
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
MOID
INT
10
√
null
mo
.id
Implied Constraint
R
WOID
INT
10
0
wo
.id
Implied Constraint
R
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
select `fishbowl`.`moitem`.`moId` AS `MOID`,`fishbowl`.`wo`.`id` AS `WOID` from (`fishbowl`.`wo` join `fishbowl`.`moitem` on((`fishbowl`.`wo`.`moItemId` = `fishbowl`.`moitem`.`id`)))
Possibly Referenced Tables/Views
moitem
wo