Hi , does anyone have a real example of CDT with the association one-to-man

marcop519 over 12 years ago

Hi ,
does anyone have a real example of CDT with the association one-to-many?
I don't know how to set correctly the generic string schema (eg. xmlns="urn:appian:example:assocations:one-to-many" ).

Thanks...

Discussion posts and replies are publicly visible

Parents

0 Sanjay over 12 years ago

Generated DDL:
create table `company` (
`id` integer not null auto_increment,
`name` varchar(255) not null,
primary key (`id`)
) type=InnoDB;

create table `officelocation` (
`id` integer not null auto_increment,
`address1` varchar(255) not null,
`address2` varchar(255),
`city` varchar(255) not null,
`state` varchar(255) not null,
`zip` integer,
`company_locations_id` integer,
`company_locations_idx` integer,
primary key (`id`)
) type=InnoDB;

alter table `officelocation`
add index company_locations (`company_locations_id`),
add constraint company_locations
foreign key (`company_locations_id`)
references `company` (`id`);
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sanjay over 12 years ago

Generated DDL:
create table `company` (
`id` integer not null auto_increment,
`name` varchar(255) not null,
primary key (`id`)
) type=InnoDB;

create table `officelocation` (
`id` integer not null auto_increment,
`address1` varchar(255) not null,
`address2` varchar(255),
`city` varchar(255) not null,
`state` varchar(255) not null,
`zip` integer,
`company_locations_id` integer,
`company_locations_idx` integer,
primary key (`id`)
) type=InnoDB;

alter table `officelocation`
add index company_locations (`company_locations_id`),
add constraint company_locations
foreign key (`company_locations_id`)
references `company` (`id`);
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data