Language and development rules: Difference between revisions

Jump to navigation Jump to search

Language and development rules (view source)

Revision as of 17:04, 31 July 2017

589 bytes removed ,  9 years ago
m
→‎Classes and properties structures
VisualWikitext
Line 81: Line 81:
== Classes and properties structures ==
== Classes and properties structures ==


Some properties of classes are found in different classes. To avoid having different names, we will use the following names:
Some properties of classes are found in different classes. To avoid having different names, we will use the following PHP properties names:


- rowid INTEGER AUTO_INCREMENT PRIMARY KEY    qui est l'id technique
- entity                         that is id for the multicompany feature
- entity INTEGER default 1                    that is id for the multicompany feature
- date_creation:                date of creation
- date_creation   datetime                    that is the creation date
- date_modification:            date of last modification
- tms             timestamp                  qui sera un champ contenant la date de chaque mise à jour (la base de donnée le gère tout seul, pas besoin de le gérer par le code)
- date_validation:              date validation
- import_key                                 qui contiendra le code d'import YYYYMMDDHHMMSS si vous faites des imports en masse dans la table.
- tms
 
- fk_user_creation:              id of user creating object
Eventualy
- fk_user_modification:          id of user doing modification
- fk_user_author integer qui est l'id du user de création
- import_key                     qui contiendra le code d'import YYYYMMDDHHMMSS si vous faites des imports en masse dans la table.
- fk_user_mod integer qui est l'id du user de modification
- fk_user_validation:            object User
- fk_user_valid integer qui est l'id du user de validation
- fk_soc integer qui est l'id du tiers (si applicable)
 
* Type of fields
- smallint for a very small integer
- integer for any number, id or foreign key
- double(24,8) for any amount
- double(6,3) for a vat rate
- real for a quantity
- varchar for a string (even if length is 1)
- timestamp for a date+time that is updated automaticaly
- datetime for a date+time
- date for a date


= SQL rules =
= SQL rules =
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/37562"

Navigation menu