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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
