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 @@

Constraint naming -standard

-

By Michael Bryzek

-OpenACS docs are written by the named authors, and may be edited by -OpenACS documentation staff.
+standard
<authorblurb>

By Michael Bryzek

</authorblurb>

The Big Picture

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:

Why do we need a naming convention?

-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.

@@ -122,12 +119,13 @@ constraints is optional...

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.

About Naming the not null constraints

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.6.14.3 -2017/06/16 17:19:52 gustafn Exp $)
+naming of all constraints.

($‌Id: constraint-naming.xml,v 1.7 +2017/08/07 23:47:54 gustafn Exp $)