>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

Yuk!