If I'm understanding correctly, something like the following:
# Keep track of manufacturer names
manufacturers_table = Table(u'manufacturer', metadata,
Column(u'id', Integer, primary_key=True,
Column(u'name', String(20))
)
# Keep track of model names
models_table = Table(u'model', metadata,
Column(u'id', Integer, primary_key=True,
Column(u'name', String(20))
)
# Keep track of inputs available to models
sources_table = Table(u'source', metadata,
Column(u'id', Integer, primary_key=True,
Column(u'pjlink', String(2)),
Column(u'text', String(20))
)
# Foreign key table for mfgr/model/sources
projector_table = Table(u'projector', metadata,
Column(u'manufacturer_id', Integer, primary_key=True,
ForeignKey(u'manufacturer.id')),
Column(u'model_id', Integer, primary_key=True, ForeignKey(u'model.id')),
Column(u'source_id', Integer, primary_key=True,
ForeignKey(u'source.id')),
)
# Persistent storage for installed projectors
# model_id would be an index for model_table.id
installed_table = Table(u'installed', metadata,
Column(u'id', Integer, primary_key=True),
Column(u'name', String(20)),
Column(u'model_id', Integer)
)
Or am I still off in left field?
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
