6th normal form #1875
Replies: 7 comments 2 replies
-
6th normal form requires decomposing tables, and currently pgModeler does not change the structure of tables already designed by the users (unless when using some specific relationships). Anyway, I can think on how to add such feature to the tool in the future. |
Beta Was this translation helpful? Give feedback.
-
No haha, despite I'm being a great fan of Asterix! :)
Yeah, it's awful!
That's the problem with pgModeler. The model itself must be in 6th normal form to create a code in 6th normal form. |
Beta Was this translation helpful? Give feedback.
-
Love those comix ;-) since my childhood.
Ok, I was rather thinking of another code generator and not the existing one. But model conversion would be fine by me. Out of interest. Is somewhere an xsd for the dbm files? |
Beta Was this translation helpful? Give feedback.
-
pgModeler database model files are ruled/validated by DTD files. You can check them here: The DTD of the entire database model file is defined here: |
Beta Was this translation helpful? Give feedback.
-
I am a bit puzzled. Are the types not defined. At least for constraints, it seems to me, that the value is just free text. |
Beta Was this translation helpful? Give feedback.
-
No, I meant constraint types, but I suppose, it works the same. And I reckon that having the types defined in the dtd too, might be overkill. Hm, just noticed that there must be two lists of constraint types. The one in https://github.com/pgmodeler/pgmodeler/blob/develop/libs/libcore/src/pgsqltypes/constrainttype.cpp looks like the GUI, but the values in the dbm file are different. |
Beta Was this translation helpful? Give feedback.
-
In installed QtCreator to fiddle around a bit, but already fail with the inclusion of xmlparser.h. |
Beta Was this translation helpful? Give feedback.
-
Hi
Are there any plans to support the generation of code in the 6th normal form, like the anchor modelling does?
Kind regards
Thiemo
Beta Was this translation helpful? Give feedback.
All reactions