Is it possible to stop symfony/propel autogenerating id columns in my
tables?

I have the following schema and don't want id columns on the files and
folder tables, they have object_id that is Fk to the objects table. I
want to then create a getid that returns the objectId but at the
moment symfony/propel aut0o creates id columns for the files and
folders tables. I won't ever use these ids.

  cms_object:
    id:  ~
    peer_name:  {type: varchar(100), required: true}

  cms_folder:
    object_id:  { type: integer, foreignTable: cms_object,
foreignReference:id, required: true, onDelete: cascade, onUpdate:
cascade}
    name:  {type: varchar(255)}
    description:  {type: varchar(1000)}
    _propel_behaviors:
       timestampable:      ~
       nested_set:

  cms_file:
    object_id:  { type: integer, foreignTable: cms_object,
foreignReference:id, required: true, onDelete: cascade, onUpdate:
cascade}
    name:  {type: varchar(255)}
    description:  {type: varchar(1000)}
    mime_type:  {type: varchar(50)}
    file_size: {type:integer}
    hash:    { type: varchar(100),  required: true}
    folder_id: { type: integer, foreignTable: cms_folder,
foreignReference:id, required: true, onDelete: cascade, onUpdate:
cascade}

-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.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-users@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

Reply via email to