30,997
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→Table and fields structures
Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 189: | Line 189: | ||
- 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) | - date_valid datetime that is the validation date (if applicable) | ||
- import_key | - import_key varchar(32) that will contains the import code YYYYMMDDHHMMSS if you make mass import. | ||
- status smallint to store a status | |||
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 | ||
| Line 207: | Line 208: | ||
- integer for a primary key, an integer or any of foreign key (bigint may also be accepted for very large tables) | - integer for a primary key, an integer or any of foreign key (bigint may also be accepted for very large tables) | ||
- smallint for a small number (like for a status) or a boolean | |||
- double(24,8) for any amount | - double(24,8) for any amount | ||
- double(6,3) for any vat rate | - double(6,3) for any vat rate | ||