In CADSTAR libraries we add attributes, one per different bit of information that we want to store.
These will be for all sorts of things including Manufacturers name, part number, suppliers name and stock code, rosh compliance, value, tolerance, who created the part, who approved it and so on.
The information allows bespoke reports to be made that can output any of these bits of information based on the BOM.
Before you actually start filling out your library sit down and discuss everything that is going into the library structure, discuss it with everyone that is involved ihn the manufacturing process from buying,board manufacture, assembly, test, sales (not forgetting IT dept) etc.
Then at least you are able to make informed decisions on what to put in it and how the information may be used and how to use it.
Decide on what standard you want to follow for footprints (I.E. IPC7351) what outlines and line widths you want, what fonts and font sizes to use etc and write them all down.
Use them, test them and then make them a standard - use them on ALL your symbols and footprints.
Make your footprints all using metric pad codes, mm drill sizes.
If you can name the pad codes, line widths, text codes etc then name them appropriate they are being used on.
I name my pad codes appropriate to how they are used.
I.E. not pad code 1, pad code 2 etc but more.
SM Rectangle 1.0mmx1.2mm
PTH Circle 1.5mmx0.8mm drill.
NPTH Circle 3.5mm