addressmultilinexoview

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

XOID

INT

10

0

xo.id

Implied Constraint

R

SHIPTOADDRESS1

VARCHAR

90

√

null

SHIPTOADDRESS2

VARCHAR

90

√

null

SHIPTOADDRESS3

VARCHAR

90

√

null

FROMADDRESS1

VARCHAR

90

√

null

FROMADDRESS2

VARCHAR

90

√

null

FROMADDRESS3

VARCHAR

90

√

null

Relationships

Close relationships within degrees of separation

View Definition

select `fishbowl`.`xo`.`id` AS `XOID`,(case when (locate('\n',`fishbowl`.`xo`.`shipToAddress`) > 0) then substr(`fishbowl`.`xo`.`shipToAddress`,1,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) - 1)) else `fishbowl`.`xo`.`shipToAddress` end) AS `SHIPTOADDRESS1`,(case when ((locate('\n',`fishbowl`.`xo`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) = 0)) then substr(`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) when ((locate('\n',`fishbowl`.`xo`.`shipToAddress`) > 0) and (locate('\n',`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) > 0)) then substr(`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1),(locate('\n',`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) - (locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1))) else '' end) AS `SHIPTOADDRESS2`,(case when (locate('\n',`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) > 0) then substr(`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`,(locate('\n',`fishbowl`.`xo`.`shipToAddress`) + 1)) + 1)) else '' end) AS `SHIPTOADDRESS3`,(case when (locate('\n',`fishbowl`.`xo`.`fromAddress`) > 0) then substr(`fishbowl`.`xo`.`fromAddress`,1,(locate('\n',`fishbowl`.`xo`.`fromAddress`) - 1)) else `fishbowl`.`xo`.`fromAddress` end) AS `FROMADDRESS1`,(case when ((locate('\n',`fishbowl`.`xo`.`fromAddress`) > 0) and (locate('\n',`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) = 0)) then substr(`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) when ((locate('\n',`fishbowl`.`xo`.`fromAddress`) > 0) and (locate('\n',`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) > 0)) then substr(`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1),(locate('\n',`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) - (locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1))) else '' end) AS `FROMADDRESS2`,(case when (locate('\n',`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) > 0) then substr(`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`,(locate('\n',`fishbowl`.`xo`.`fromAddress`) + 1)) + 1)) else '' end) AS `FROMADDRESS3` from `fishbowl`.`xo`

Possibly Referenced Tables/Views

xo