Primary Key

nuBuilder requires the use of a Primary Key for each table

It is suggested that the Primary Key be the name of the table followed by an underscore (_) and the letters id.

e.g. customer_id

The Primary Key should be a varchar(15), as it will automatically be populated using PHP's uniqid() function.

As of version 11.03.21, nuBuilder supports auto-incrementing Primary Keys.

It is also suggested that Unique Indexes not be used from now on, allowing nuBuilder's validating rules to check for duplicates.
This is because of the way nuBuilder implements the checking for Primary Key types.

Created by: system. Last Modification: Wednesday 08 of June, 2011 08:03:38 CST by steven.