29,131
edits
Changes
m
→Table and fields structures
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 that will contains the import code YYYYMMDDHHMMSS if you make mass import.
+ - 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