0

I work on a database where column names are prefixed by a character representing the datatype of the column. I quite like this, because it's easy to see at a glance what type of data each column holds.

For example, in the model City associated with many People, you might have the following relations (this is an example of column names):

Person

id
sName (string)
sSurname (string)
iAge (int)
dtDateOfBirth (date)
bIsLiving (bit)
dSomeDecimalColumn (decimal)
hCity (means foreign key reference to the 'City' relation)

City

id
sName
dLat
dLong
etc

The database where I have seen this standard is Yardi. Someone told me this was a standard they had come across before and that it was associated with Bulgaria. But they couldn't be more precise

3
  • 1
    It sounds to me like a Hungarian notation (en.wikipedia.org/wiki/Hungarian_notation)
    – a1ex07
    Sep 12 '18 at 21:45
  • 3
    Specifically you're talking about Systems Hungarian, something most authorities tend to avoid these days. Use a good IDE that tells you the typeinstead
    – Caius Jard
    Sep 13 '18 at 4:13
  • ah thanks. yes it does indeed look like Systems Hungarian. I like it because when looking at columns in SSMS / pgAdmin / etc it's easy to see datatypes and especially foreign keys. I definitely don't see the benefit of it in a typed environment such as Java/C#
    – Zach Smith
    Sep 13 '18 at 7:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.