Index: openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.adp,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.adp 7 Aug 2017 23:47:49 -0000 1.2 +++ openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.adp 8 Nov 2017 09:42:10 -0000 1.3 @@ -10,10 +10,7 @@
<authorblurb>By Michael Bryzek
</authorblurb>Constraint naming standard is important for one reason: The @@ -22,8 +19,8 @@ associate a particular constraint with our data model. This gives us two real advantages:
We can quickly identify and fix any errors.
We can reliabily modify or drop constraints
-Oracle limits names, in general, to 30 +
+Why do we need a naming convention?Oracle limits names, in general, to 30 characters, which is hardly enough for a human readable constraint name.
People disagree on whether or not we should be naming not null constraints. So, if you want to name them, please do so and follow the above naming standard. But, naming not null constraints is not -a requirement.
Though naming "not null" constraints doesn't help +a requirement.
About Naming the not null +constraints
Though naming "not null" constraints doesn't help immeditately in error debugging (e.g. the error will say something like "Cannot insert null value into column"), we recommend naming not null constraints to be consistent in our -naming of all constraints.
($Id: constraint-naming.xml,v 1.7 +2017/08/07 23:47:54 gustafn Exp $)