Hi,
I have the following SQL schema :
create table persons (
id integer not null auto_increment,
lastname varchar(175) not null,
firstname varchar(125) not null,
primary key(id)
);
create table responsabilities (
id integer not null auto_increment,
responsability varchar(75) not null,
primary key(id)
);
create table books (
id integer not null auto_increment,
title varchar(175) not null,
primary key(id)
);
create table act_as (
person_id integer not null,
responsability_id integer not null,
book_id integer not null,
primary key(person, responsability, book),
foreign key(person_id) references persons(id),
foreign key(responsability_id) references responsabilities(id),
foreign key(book_id) references books(id)
);
Ideally, when I create a new book, I want to join a Person with a
Responsability (author, translator, ...) with the new book. Unfortunately, I
don't know how I can handle this kind of thing with CakePHP. Is there
anybody who already set up something like that? Have you any ideas how I can
do that?
Thanks in advance.
Regards,
Emmanuel
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
