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!
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.
Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, 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