I’m trying to design a database and ran into a stumbling block.
I have a row in the table for hair color, so should I name the column hair_color or something shorter like color to make it as efficient as possible?
What’s the table name? If it’s ‘hair’ then ‘color’ might be clear enough as column name.
Is there any possibility that ‘color’ might have another meaning than ‘hair color’? If not, then ‘color’ might be fine.
But really, the difference between haircolor and color is 4 characters. If you want to be absolutely clear about it’s meaning, why not name the column haircolor? In terms of efficiency, it doesn’t make that much difference IMO.
the table names review but your right, color wouldn’t refer to anything but the hair color so color is all i need