Terrence Brannon <schemelab@...> writes:
>
> I would like to build this simple car listing app:
> http://docs.sencha.com/architect/2-0/#!/guide/first_desktop_app
Well, anyway I went ahead and did the data model with the (EXCELLENT!) wizard
tool. I opted for a many-to-many relation instead of using the list:type
shortcut. I think being a relational purist is the safest route. Here is my data
model:
########################################
db.define_table('t_model',
Field('f_name', type='string',
label=T('Name')),
Field('f_price', type='integer',
label=T('Price')),
Field('f_wiki', type='string',
label=T('Wiki')),
Field('f_img', type='upload',
label=T('Img')),
auth.signature,
format='%(f_name)s',
migrate=settings.migrate)
db.define_table('t_model_archive',db.t_model,Field('current_record',
'reference
t_model',readable=False,
writable=False))
########################################
db.define_table('t_quality',
Field('f_name', type='string',
label=T('Name')),
auth.signature,
format='%(f_name)s',
migrate=settings.migrate)
db.define_table('t_quality_archive',db.t_quality,Field('current_record',
'reference
t_quality',readable=False,writable=False))
########################################
db.define_table('t_model_quality',
Field('f_model_id', type='string',
label=T('Model Id')),
Field('f_quality_id', type='string',
label=T('Quality Id')),
Field('f_rating', type='integer',
label=T('Rating')),
auth.signature,
format='%(f_model_id)s',
migrate=settings.migrate)
db.define_table('t_model_quality_archive',db.t_model_quality,
Field('current_record','reference
t_model_quality',readable=False,writable=False))
########################################
db.define_table('t_manufacturer',
Field('f_name', type='string',
label=T('Name')),
auth.signature,
format='%(f_name)s',
migrate=settings.migrate)
db.define_table('t_manufacturer_archive',db.t_manufacturer,
Field('current_record','reference
t_manufacturer',readable=False,writable=False))
--
