I'm a bit confused about the right approach to defining and using primary keys in nuBuilderPro.
Can I use auto-incrementing integers for all primary keys? If so, is there a catch?
Is varchar() a recommendation or the better option?
If I have a hidden internal client_id PK can I enforce a unique numeric or alphanumeric business-side client_ref with a unique index?
Any other pearls of wisdom gratefully received.
Regards
John
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Rules on using primary keys?
Re: Rules on using primary keys?
John,
We strongly suggest using varchar(25) for all Primary Keys.
Here are some reasons.. http://nubuilder.blogspot.com.au/2010_0 ... chive.html
nuBuilder will automatically populate PKs.
Steven
We strongly suggest using varchar(25) for all Primary Keys.
Here are some reasons.. http://nubuilder.blogspot.com.au/2010_0 ... chive.html
nuBuilder will automatically populate PKs.
Steven