31,003
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
→Classes and properties structures
| Line 82: | Line 82: | ||
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 names: | ||
- rowid INTEGER AUTO_INCREMENT PRIMARY KEY qui est l'id technique | |||
- entity INTEGER default 1 that is id for the multicompany feature | |||
- date_creation datetime that is the creation date | |||
- 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) | |||
- import_key qui contiendra le code d'import YYYYMMDDHHMMSS si vous faites des imports en masse dans la table. | |||
* | Eventualy | ||
- fk_user_author integer qui est l'id du user de création | |||
- fk_user_mod integer qui est l'id du user de modification | |||
- 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 = | ||