Relations are defined by (at less) 3 attributes : class, local, foreign. Read Doctrine Documentation ( on doctrine-project.org) about relations, your schema is missing some informations.
Alex' 2009/11/29 Trailfinder <beer...@gmail.com> > Hi All, > > Could somebody help me with a schema for a ticketing system. Problem > is that after reading the documentation on both Symfony and Doctrine I > still have problems figuring out how to use relations in YAML. > > Ticket: > actAs: [Timestampable] > columns: > id: > type: integer(4) > primary: true > autoincrement: true > tickettype_id: > type: integer > tickettext: > type: clob(65532) > actions: > type: clob(65532) > ticketnumber: > type: integer > user_id: > type: integer > created_at: > type: timestamp > notnull: true > update_at: > type: timestamp > relations: > Tickettype: > type: one > User: > type: one > > User: > columns: > id: > type: integer(4) > primary: true > autoincrement: true > firstname: > type: string(255) > lastname: > type: string(255) > email: > type: string(255) > username: > type: string(255) > password: > type: string(255) > active: > type: enum > values: [yes,no] > level: > type: integer(2) > > Tickettype: > columns: > id: > type: integer(4) > primary: true > autoincrement: true > name: > type : string(255) > > I tried something like the above without any luck. Clearly I don't > understand how relations work in YML and Doctrine. > > So can someone help me how to do this or suggest a better way to build > a ticket system in Symfony. > > Thanks! > > -- > > You received this message because you are subscribed to the Google Groups > "symfony users" group. > To post to this group, send email to symfony-us...@googlegroups.com. > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > > -- Alexandre Salomé -- alexandre.sal...@gmail.com -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
