31,003
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→Table and fields structures
PolyglotBot (talk | contribs) m (Import interlang links (links to translated versions of this page in other languages) from Multi Language Manager table.) |
Tag: 2017 source edit |
||
| Line 206: | Line 206: | ||
Well, to be compatible with any accuracy required by any country on amounts, to be compatible with any database syntax and with the Dolibarr upgrade framework, we will use the following types for database fields: | Well, to be compatible with any accuracy required by any country on amounts, to be compatible with any database syntax and with the Dolibarr upgrade framework, we will use the following types for database fields: | ||
- integer for an any of foreign key | - integer for a primary key, an integer or any of foreign key (bigint may also be accepted for very large tables) | ||
- 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 | ||