Need alternative field names for these reserved words

Posted by MattSlay on Stack Overflow See other posts from Stack Overflow or by MattSlay
Published on 2010-11-10T22:10:51Z Indexed on 2011/12/01 9:51 UTC
Read the original article Hit count: 298

“type” and “class” are likely reserved or problematic words in C# and/or Ruby, two languages I may use to program against my new database schema in the future.

So, in order to avoid potential conflicts with those languages, I’m looking for alternative names for these field names in my tables.

In this case, it is from my Machines table, where I have:

“class” field (values would be something like “manual” or “computerized”)

and

“type” field (values would be “lathe” or “mill”)

I could call the fields “machineclass” and “machinetype”, but that is inconsistent with naming scheme in the rest of my schema (meaning, I do not re-use the table name in the field… For instance, I use Machine.name, not Machine.machinename)

Any thought on this madness?

© Stack Overflow or respective owner

Related posts about database-design

Related posts about reserved-words