Welcome Guest, Not a member yet? Register   Sign In
"Problem" with CodeIgniter and DataMapper (Databasedesign)
#1

[eluser]felix_[/eluser]
Hey,
i must use Datamapper instead of Doctrine in my actually project and im having some small problems with this.

Im using some simple relationships in my project.

For Example i build a small ticket system so that a user can create a ticket ... the admin can answer and the messages belong to the ticket.

I noticed that there is no way to auto create the tables.... so i did it in my personal way but this seems to be wrong with datamapper.

For Example: i would store the authors id of a message in the table Messages so i can resolve who wrote this text. And i would store the users is of the user who created the ticket in the Tickets table etc.

But this seems not to work.

Is it right that i hav to create a seperate table for each of this simple relationships?

It seems i hav to create tickets_users, tickets_messages, users_messages and so on

So is it correct to creat such a big amount if tables? normally i would create these tables only in n:n relationships and not 1:n

I also looked for a guid who tables hav to look like for datamapper but i didnt found anything

Hope someone can answer my question

greetz


Messages In This Thread
"Problem" with CodeIgniter and DataMapper (Databasedesign) - by El Forum - 05-11-2011, 08:18 AM



Theme © iAndrew 2016 - Forum software by © MyBB