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: 372
        
database-design
|reserved-words
“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