[Modeling-users] Foreign key required for 1:1 relations Schema update thru differences
Status: Abandoned
Brought to you by:
sbigaret
From: Ernesto R. <er...@si...> - 2003-06-12 21:58:31
|
I started modeling with the ZModelingTool and the following issues arose: * When I modeled 1 0..* addresses person Person <---------------------------->>address although I told in the relation in entity address that it had to map '1:1' to Person, it didn't set the FK_Person to required. During model validation I got the warning : - relationship is mandatory but source attribute direccion.FK_PERSONA is not required. All in all, I see the tool a bit redundant, because: * the former issue should be done automatically * I would like to map all python string to varchar (w/o limit) or text (in fact, they should all be mapped to the same (perhaps system dependent) DB type * typeName is required but not used * name, className, moduleName and externalName have all to be specified, perhaps the latter three should be defaulted to the first if not specified. Sorry, this should not sound too destructive. I really appreciate a lot all the work done. I just think that the XML-file is too explicit (with all the required fields). Perhaps the semantics could be loosened a bit, making al lot of the attributes optional (like moduleName, packageName, externalType, etc.) If I can help, please tell me how. (I think I really need this project for our own (ERP).) Thanx, Erny |