create table io_link (from_io_id varchar(32) not null, from_ln_code varchar(2) not null, from_vr_code varchar(2) not null, from_iov_number integer not null, from_yid varchar(35) not null, to_io_id varchar(32) not null, to_ln_code varchar(2) not null, to_vr_code varchar(2) not null, to_iov_number integer not null, to_yid varchar(35) not null, lt_id varchar(32) not null, iol_automatic boolean, iol_order double, iol_translate boolean, *source_io_id* varchar(32) not null, *source_ln_code* varchar(2) not null, *source_vr_code* varchar(2) not null, *source_iov_number* integer not null, *target_io_id* varchar(32) not null, ....

select iolinkmode0_.from_io_id as from_io_1_1_, iolinkmode0_.from_ln_code as from_ln_2_1_, iolinkmode0_.from_vr_code as from_vr_3_1_, iolinkmode0_.from_iov_number as from_iov4_1_, iolinkmode0_.from_yid as from_yid5_1_, iolinkmode0_.to_io_id as to_io_id6_1_, iolinkmode0_.to_ln_code as to_ln_co7_1_, iolinkmode0_.to_vr_code as to_vr_co8_1_, iolinkmode0_.to_iov_number as to_iov_n9_1_, iolinkmode0_.to_yid as to_yid10_1_, iolinkmode0_.lt_id as lt_id11_1_, iolinkmode0_.iol_automatic as iol_aut12_1_, iolinkmode0_.iol_order as iol_ord13_1_, *iolinkmode0_.source_io_id* as source_15_1_, *iolinkmode0_.source_ln_code* as source_16_1_, ....