PK length
Posted: Sat Apr 21, 2018 11:10 pm
I found this article: "Recommended Table Structure": https://wiki.nubuilder.net/nubuilderv3/ ... _Structure
Assuming that this is also valid for nuBuilder Forte, I wonder why the PK length should be 25 although all (automatically generated) PK keys are only 15 characters in length.We suggest the PK should be a varchar(25), as it will automatically be populated by nuBuilderPro using a nuBuilder function called nuID() (when filled out as below), unless the PK is an auto-incrementing number.
If a varchar(25) is used for the PK instead of a number it allows for better use of certain hash variables such as #nu_browse_filter#.