[web2py] Custom fields for each record????

[Ismael Serratos]

Hi!! How could I make custom fields for each record in a model, I mean:

I have:

db.define_table('building',
    Field('name','string'),
    Field('comment', 'string'))

db.define_table('room',
    Field('name','string'),
    Field('owner','string'),
    Field('building',db.building))


But every building need some extra info about each room, for example

Building1 needed info:

room.name room.owner room.building room.xinfo room.yinfo


Building 2 needed info:

room.name room.owner room.building room.ainfo room.binfo

etc, etc.


Basically following this structure:


project                                   room                custom_attribs
-----                                     -------------
--------------
attrib_assoc_id    -->         id                  <--  assoc_id
...