A how to question. 

I'd like to be able to create a table which has dynamic primary keys. 

Something along these lines. 

Lets say the main table is called Master. it has a generated id.

Then a table that is an id and a name, called AliasType. 

It's then a many to many association between Master and AliasType, where 
the association, Alias,  also contains a field called alias. 

If a master record is deleted, then the Alias(es) get deleted. The Alias 
Type can't be deleted unless there are no Aliases, its an orphan.

What's the best implementation?

Thanks

N

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
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 sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/60b85849-da4e-4776-bd36-95de166e2e96%40googlegroups.com.

Reply via email to