Subject Field naming
Author zifnabbe@users.sourceforge.net
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.