Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Uniqueness of index PRIMARY is violated
Message
 
To
08/10/1998 10:12:13
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00144393
Message ID:
00145084
Views:
39
I use a naming convention that I picked up from Drew Speedie, and I've been quite happy with it:

Members table:
All fields are prefixed with mbr
Primary key: mbr_pk
Candidate key: mbr_name_ck

Dues table:
All fields are prefixed with due
Foreign key: due_mbr_fk
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform