As for naming all "id" fields just plain "id", it makes it far more difficult to keep track of foreign keys. The nice thing about giving even sequenced ID fields a somewhat unique name is that you can use that same name on other entities/tables and have them match up automatically.
The Entity Engine does a lot with field name mapping for relationships between entities, and there are thousands of these in the OFBiz data model, so the few extra characters goes a long way toward making things easier to understand and maintain. -David On Apr 4, 2011, at 12:19 AM, Erwan de FERRIERES wrote: > Le 03/04/2011 06:15, Mansour Al Akeel a écrit : >> Hello all, >> >> I am wondering about the reasons behind using VARCHAR for entities Id, >> instead of a numeric value with autoincrement. Another thing is the >> naming of the primary key. For example, accommodation_class has it's >> primary key as "accommodation_class_id". Wouldn't it be easier just to >> name it "id"? >> >> >> >> >> > Hi Mansour, > > just go to this page : > http://ofbiz.135035.n4.nabble.com/Why-primary-keys-are-VAR-CHAR-type-in-OFBiz-td146555.html#a146562 > > Cheers, > > -- > Erwan de FERRIERES > www.nereide.biz
