[Dolibarr-dev] Question about dictionnary => id versus code

[Florian HENRY]

Hello all,
    I wondering something about best practice with dictionnary dolibarr 
implementation.

    I take two exemple about thirdparty.
    llx_societe.fk_prospectlevel : a foreign key  on 
llx_c_prospectlevel.code
        The dictionnay llx_c_prospectlevel don't have rowid column

    llx_societe.fk_typent => a foreign key on llx_c_typent.id
        The dictionnary  llx_c_typent have a id column (should be 
renamed into rowid by the way) but also get a code column

    What is the best strategy, to your mind, with dictionnary :

        1 :
            llx_dictionnary_1 (rowid,code,label,active)
            llx_table.fk_dict1 => llx_dictionnary_1.rowid

        2 :
            llx_dictionnary_1 (rowid,code,label,active)
            llx_table.fk_dict1 => llx_dictionnary_1.code

For me the best option is 1 but in this case what is the purpose of a 
"code" column ?

Regards.

--
Florian Henry
+33 6 03 76 48 07
address@hidden
http://www.open-concept.pro
Twitter : @_Open_Concept_
Google+ : https://www.google.com/+Open-conceptPro