4,395
edits
Table llx actioncomm: Difference between revisions
→Structure
| Line 26: | Line 26: | ||
| id | | id | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| NULL | | NULL | ||
| Line 59: | Line 59: | ||
| datetime | | datetime | ||
| YES | | YES | ||
| | | MUL | ||
| | | | ||
| | | | ||
| Line 74: | Line 74: | ||
| tms | | tms | ||
| timestamp | | timestamp | ||
| | | NO | ||
| | | | ||
| CURRENT_TIMESTAMP | | CURRENT_TIMESTAMP | ||
| Line 90: | Line 90: | ||
| label | | label | ||
| varchar(50) | | varchar(50) | ||
| | | NO | ||
| | | | ||
| | | | ||
| Line 107: | Line 107: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| | | MUL | ||
| | | | ||
| | | | ||
| Line 115: | Line 115: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| | | MUL | ||
| | | | ||
| | | | ||
| Line 122: | Line 122: | ||
| fk_parent | | fk_parent | ||
| int(11) | | int(11) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| Line 170: | Line 170: | ||
| punctual | | punctual | ||
| smallint(6) | | smallint(6) | ||
| | | NO | ||
| | | | ||
| 1 | | 1 | ||
| Line 178: | Line 178: | ||
| percent | | percent | ||
| smallint(6) | | smallint(6) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| Line 214: | Line 214: | ||
| | | | ||
| | | | ||
| | | comentary | ||
|- | |- | ||
| propalrowid | | propalrowid | ||
| Line 235: | Line 235: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| | | MUL | ||
| | | | ||
| | | | ||
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid) | | ID of invoice ([[Table llx_facture|llx_facture]]->rowid) | ||
|} | |} | ||