Field Names: "LongName", "ShortName", "Code", "Description","Comments"

P

PeteCresswell

Is anybody plugged into some sort of standard that defines what
various common field names indicate.

e.g. "ShortName" = Text field 10 chars or less, unique, required
"LongName"" = Text field 100 chars or less, unique, required
"Description" = Free-form text. Not unique, not required
"Code"= ????

I'm trying to put together some consistent - and, hopefully, widely-
shared - rules for distinguishing between/choosing among "ShortName",
"Code", and so-forth.
 
P

Paul Shapiro

I often use something similar.

SurrogatePK_Identity: Long Integer, Autonumber in Access
SurrogatePK_NotIdentity: Long Integer

For Category-Type tables, I use:
TypeCode: PK, Text(10), not null
TypeName: Text(50), not null, usually unique
TypeDescription: Text(250), either null or not null depending on
circumstances

Other possibilities:
Comment: Text(255) or Memo, null
Note: Text(255) or Memo, null
SortOrder: Long Integer, not null (used in tables where alpha sorting would
not be suitable)
UpdatedDateTime: DateTime, not null, default=Now()
UpdatedBy: text(100), not null, automatically filled in with current user
login name
 
Top