Fishbowl
Tables
(current)
Columns
Constraints
Orphan Tables
Routines
shippingemailview
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
SOID
INT
10
0
so
.id
Implied Constraint
R
CUSTOMERID
INT
10
0
customer
.id
Implied Constraint
R
EMAILADDRESS
VARCHAR
256
√
null
Relationships
Close relationships within degrees of separation
One
One implied
Two implied
View Definition
select `fishbowl`.`so`.`id` AS `SOID`,`fishbowl`.`customer`.`id` AS `CUSTOMERID`,`fishbowl`.`so`.`email` AS `EMAILADDRESS` from ((`fishbowl`.`so` join `fishbowl`.`customer` on((`fishbowl`.`so`.`customerId` = `fishbowl`.`customer`.`id`))) join `fishbowl`.`account` on((`fishbowl`.`customer`.`accountId` = `fishbowl`.`account`.`id`)))
Possibly Referenced Tables/Views
so
customer
account