Column naming convention origin?
From: Anton Versteeg <anton_versteeg_at_nnll.iibbmm.com>
Date: Wed, 21 Jan 2004 13:08:53 +0100
Message-ID: <400E6BD5.8070905_at_nnll.iibbmm.com>
Back in the seventies, (I was doing IMS database design) I saw somewhere a naming convention for attributes.
It was in the form a_b_c_d
where 'a' was a 1 character code describing the attribute type.
etc.
Date: Wed, 21 Jan 2004 13:08:53 +0100
Message-ID: <400E6BD5.8070905_at_nnll.iibbmm.com>
Back in the seventies, (I was doing IMS database design) I saw somewhere a naming convention for attributes.
It was in the form a_b_c_d
where 'a' was a 1 character code describing the attribute type.
A - address, text, name B - binary C - code (often called number like part number) D - date K - key M - amountN - number, numeric
etc.
'b' was the (abbreviated) primary attribute description, 'c' optionally
the second attr descr, 'd' optionally the third attr descr. etc.
So an attribute with the description 'resource manager name' would
become A_MGR_RES,
'last update date' would become D_UPD_LAST etc.
The abbreviations used could easily be extracted and put in an acronym list.
I have been using this convention over the years and noticed that also
other people are using it.
Does anyone know what the origin of this convention is? If I remember well I read about it and started using it in 1976.
-- Anton Versteeg IBM Certified DB2 Specialist IBM NetherlandsReceived on Wed Jan 21 2004 - 13:08:53 CET