SchemaEditor and OneToOne relations : clearing up a bit of ambiguity
October 22, 2012
Using Dovetail SchemaEditor to add a new relation to your schema is super easy. For example, here’s my schema script for adding a new one-to-one relation between the modem table and the user table: What’s nice is that I only have to define the relation once in the schema file, as opposed to other tools (ddcomp, DD Editor, SchemaManager) where I would have to add the relation to the file in two places (as a relation under both the modem table and as a relation under the user table). But, there is a bit of ambiguity here – which side is the primary side (OTOP) and which side is the foreign side (OTOF)? Answer The foreign side will be on the table/name, and the primary side will be inverseTable/inverseRelationName. So in the example above, the modem2user is the OTOF, and…