Hi there, I've got the following schema: http://pastie.org/private/w3oyxp5yjqggtiorknz6q
Am I doing things right? To explain what I'm trying to do: right now, I'm trying to parse a dictionary file (edict2). It consists of dictionary 'entries', each of which have some basic information, then multiple 'readings', and multiple 'tags'. (And definitions, but those will come later.) Each reading item itself can also contain multiple 'tags'. There will not be too many connections per entry, but there will be many (170,000+) entries. So I've made two relationship tables. I think this should work. But I'm not sure if it is optimal. In pure SQL I'd probably do a (id, id) primary key. Right now it generates this SQL: http://pastie.org/private/an5kiotkqgatl4tre3x4q I'd just like to set this up as properly as possible from the start, so maybe you have suggestions on what I could improve? Thanks! Michiel -- 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.
