Language and development rules: Difference between revisions

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

Eldy

Bureaucrats, Interface administrators, Administrators

31,003

edits

@@ Line 81: / Line 81: @@
 == 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 =