Index: openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.html,v diff -u -r1.48.2.5 -r1.48.2.6 --- openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.html 1 Dec 2015 14:38:41 -0000 1.48.2.5 +++ openacs-4/packages/acs-core-docs/www/eng-standards-constraint-naming.html 9 Jun 2016 08:44:49 -0000 1.48.2.6 @@ -1,5 +1,5 @@ -Constraint naming standard

Constraint naming standard

By Michael Bryzek

+Constraint naming standard

Constraint naming standard

By Michael Bryzek

OpenACS docs are written by the named authors, and may be edited by OpenACS documentation staff.

The Big Picture

@@ -18,7 +18,7 @@ http://oradoc.photo.net/ora81/DOC/server.815/a67779/ch4e.htm#8953. Note that we shortened all of the constraint abbrevations to two characters to save room. -

Constraint typeAbbreviation
references (foreign key)fk
uniqueun
primary keypk
checkck
not nullnn

Format of constraint name

+

Constraint typeAbbreviation
references (foreign key)fk
uniqueun
primary keypk
checkck
not nullnn

Format of constraint name

<table name>_<column_name>_<constraint abbreviation>

In reality, this won't be possible because of the character limitation on