addressmultilinesoview

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

SOID

INT

10

0

so.id

Implied Constraint

R

SHIPTOADDRESS1

VARCHAR

90

√

null

SHIPTOADDRESS2

VARCHAR

90

√

null

SHIPTOADDRESS3

VARCHAR

90

√

null

Relationships

Close relationships within degrees of separation

View Definition

select `fishbowl`.`so`.`id` AS `SOID`,(case when (locate('\n',`fishbowl`.`so`.`shipToAddress`) > 0) then substr(`fishbowl`.`so`.`shipToAddress`,1,(locate('\n',`fishbowl`.`so`.`shipToAddress`) - 1)) else `fishbowl`.`so`.`shipToAddress` end) AS `SHIPTOADDRESS1`,(case when ((locate('\n',`fishbowl`.`so`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) = 0)) then substr(`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) when ((locate('\n',`fishbowl`.`so`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) > 0)) then substr(`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1),(locate('\n',`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) - (locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1))) else '' end) AS `SHIPTOADDRESS2`,(case when (locate('\n',`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) > 0) then substr(`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`,(locate('\n',`fishbowl`.`so`.`shipToAddress`) + 1)) + 1)) else '' end) AS `SHIPTOADDRESS3` from `fishbowl`.`so`

Possibly Referenced Tables/Views

so