Subject | Field naming |
---|---|
Author | zifnabbe@users.sourceforge.net |
Post date | 2001-11-19T17:27:54Z |
Hi,
Is there a standard in field naming?
Assume you've a table APPOINTMENTS:
Is the standard:
APPOINTMENTID
CENTREID
EQUIPMENTID
APPOINTMENT
or:
APP_APPOINTMENTID
APP_CENTREID
APP_EQUIPMENTID
APP_APPOINTMENT
And then table CENTRES:
CENTREID
NAME
or
CENTRE_ID
CENTRE_NAME
Thus, using a prefix or not?
Thanks, Tom.
Is there a standard in field naming?
Assume you've a table APPOINTMENTS:
Is the standard:
APPOINTMENTID
CENTREID
EQUIPMENTID
APPOINTMENT
or:
APP_APPOINTMENTID
APP_CENTREID
APP_EQUIPMENTID
APP_APPOINTMENT
And then table CENTRES:
CENTREID
NAME
or
CENTRE_ID
CENTRE_NAME
Thus, using a prefix or not?
Thanks, Tom.