31,003
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→Table and fields structures
No edit summary |
|||
| Line 171: | Line 171: | ||
- date_creation datetime that is the creation date | - date_creation datetime that is the creation date | ||
- tms timestamp that will contain date of last modification (the database manages this field automatically, no need to manage it by the code, just create the field) | - tms timestamp that will contain date of last modification (the database manages this field automatically, no need to manage it by the code, just create the field) | ||
- date_valid datetime that is the validation date (if applicable) | |||
- import_key that will contains the import code YYYYMMDDHHMMSS if you make mass import. | - import_key that will contains the import code YYYYMMDDHHMMSS if you make mass import. | ||
Eventually | Eventually | ||
- fk_user_creat integer that is the id of user making creation | - fk_user_creat integer that is the id of user making creation | ||
- fk_user_modif integer that is the id of user making change | - fk_user_modif integer that is the id of user making change | ||
- fk_user_valid integer that is the id of user validating record | - fk_user_valid integer that is the id of user validating record (if applicable) | ||
- fk_soc integer that is the ID of the Third party (if applicable) | - fk_soc integer that is the ID of the Third party (if applicable) | ||