Table llx actioncomm: Difference between revisions

Jump to navigation Jump to search

Table llx actioncomm (view source)

Revision as of 18:00, 13 May 2009

1,714 bytes added ,  17 years ago
→‎Structure
VisualWikitext
Line 24: Line 24:
  |style="background-color: #e9e9ef"| <b>Description</b>
  |style="background-color: #e9e9ef"| <b>Description</b>
|-  
|-  
| rowid
| id
| int(11)  
| int(11)  
| &nbsp;
| &nbsp;
Line 31: Line 31:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| datec
| datetime
| YES
|
|
|
| creation date
|-
| datep
| datetime
| YES
|
|
|
| planned start date
|-
| datep2
| datetime
| YES
|
|
|
| deprecated
|-
| datea
| datetime
| YES
|
|
|
| real start date
|-
| datea2
| datetime
| YES
|
|
|
| deprecated
|-
| tms
| timestamp
|
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| fk_action
| int(11)
| YES
|
|
|
| ID of action (llx_c_actioncomm->id)
|-
| label
| varchar(50)
|
|
|
|
| label of action
|-
| fk_proyect
| int(11)
| YES
|
|
|
| ID of proyect (llx_projet->rowid)
|-
| fk_soc
| int(11)
| YES
|
|
|
| ID of society (llx_societe->rowid)
|-
| fk_contact
| int(11)
| YES
|
|
|
| ID of contact (llx_socpeople->rowid)
|-
| fk_parent
| int(11)
|
|
| 0
|
| ID of parent (llx_socpeople->rowid)
|-
| fk_user_action
| int(11)
| YES
|
|
|
| ID of user must perform the action (llx_user->rowid)
|-
| fk_user_done
| int(11)
| YES
|
|
|
| ID of user who perform the action (llx_user->rowid)
|-
| fk_user_author
| int(11)
| YES
|
|
|
| ID of user author of the action (llx_user->rowid)
|-
| fk_user_mod
| int(11)
| YES
|
|
|
| ID of last user which modify the action (llx_user->rowid)
|-
| priority
| smallint(6)
| YES
|
|
|
| priority of action
|-
| punctual
| smallint(6)
|
|
| 1
|
| priority of action
|-
| percent
| smallint(6)
|
|
| 0
|
| percentage realised of action
|-
| location
| varchar(128)
| YES
|
|
|
|
|-
| durationp
| double
| YES
|
|
|
| planned duration
|-
| durationa
| double
| YES
|
|
|
| deprecated
|-
| note
| text
| YES
|
|
|
|
|-
| propalrowid
| int(11)
| YES
|
|
|
|
|-
| fk_commande
| int(11)
| YES
|
|
|
|
|-
| fk_facture
| int(11)
| YES
|
|
|
|
|}
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11535"

Navigation menu