4,395
edits
Table llx actioncomm: Difference between revisions
→Structure
| Line 15: | Line 15: | ||
= Structure = | = Structure = | ||
'''Version 1. | '''Version 1.1 2009/10/07''' | ||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
| Line 38: | Line 38: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| creation date | | creation date | ||
| Line 46: | Line 46: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| planned start date | | planned start date | ||
| Line 54: | Line 54: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| deprecated | | deprecated | ||
| Line 62: | Line 62: | ||
| YES | | YES | ||
| MUL | | MUL | ||
| | | NULL | ||
| | | | ||
| real start date | | real start date | ||
| Line 70: | Line 70: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| deprecated | | deprecated | ||
| Line 86: | Line 86: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id) | | ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id) | ||
| Line 102: | Line 102: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid) | | ID of proyect ([[Table llx_projet|llx_projet]]->rowid) | ||
| Line 110: | Line 110: | ||
| YES | | YES | ||
| MUL | | MUL | ||
| | | NULL | ||
| | | | ||
| ID of society ([[Table llx_societe|llx_societe]]->rowid) | | ID of society ([[Table llx_societe|llx_societe]]->rowid) | ||
| Line 118: | Line 118: | ||
| YES | | YES | ||
| MUL | | MUL | ||
| | | NULL | ||
| | | | ||
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid) | | ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid) | ||
| Line 134: | Line 134: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of user must perform the action ([[Table llx_user|llx_user]]->rowid) | | ID of user must perform the action ([[Table llx_user|llx_user]]->rowid) | ||
| Line 142: | Line 142: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of user who perform the action ([[Table llx_user|llx_user]]->rowid) | | ID of user who perform the action ([[Table llx_user|llx_user]]->rowid) | ||
| Line 150: | Line 150: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of user author of the action ([[Table llx_user|llx_user]]->rowid) | | ID of user author of the action ([[Table llx_user|llx_user]]->rowid) | ||
| Line 158: | Line 158: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid) | | ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid) | ||
| Line 166: | Line 166: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| priority of action | | priority of action | ||
| Line 190: | Line 190: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| | | | ||
|- | |- | ||
| durationp | | durationp | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| planned duration | | planned duration | ||
|- | |- | ||
| durationa | | durationa | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| deprecated | | deprecated | ||
| Line 214: | Line 214: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| comentary | | comentary | ||
| Line 222: | Line 222: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of propal ([[Table llx_propal|llx_propal]]->rowid) | | ID of propal ([[Table llx_propal|llx_propal]]->rowid) | ||
| Line 230: | Line 230: | ||
| YES | | YES | ||
| | | | ||
| | | NULL | ||
| | | | ||
| ID of order ([[Table llx_commande|llx_commande]]->rowid) | | ID of order ([[Table llx_commande|llx_commande]]->rowid) | ||
| Line 238: | Line 238: | ||
| YES | | YES | ||
| MUL | | MUL | ||
| | | NULL | ||
| | | | ||
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid) | | ID of invoice ([[Table llx_facture|llx_facture]]->rowid) | ||
|} | |} | ||