Dolibarr ERP CRM Wiki

Changes

Table llx projet task (view source)

Revision as of 11:56, 22 January 2025

1,560 bytes added ,  2 months ago
m
no edit summary
Line 6: Line 6:  
{{ListOfTables}}
 
{{ListOfTables}}
   −
= Content/Contenu/Contenido =
+
=Content/Contenu/Contenido/Conteúdo=
−
{{flag en}} Contains tasks related to a project.  
+
{{flag en}}
 +
Contains tasks related to a project.  
   −
{{flag fr}} Contient des tâches liées à un projet.
+
{{flag fr}}
 +
Contient des tâches liées à un projet.
   −
{{flag sp}} Contiene las tareas relacionadas a un proyecto.
+
{{flag sp}}
 +
Contiene las tareas relacionadas a un proyecto.
   −
= Structure =
+
{{flag pt}}
−
{| 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"
+
Contém as tarefas relacionadas a um projeto.
−
  |style="background-color: #e9e9ef"| <b>Field</b>
+
 
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
=Structure=
−
  |style="background-color: #e9e9ef"| <b>Null</b>
+
==Table==
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
−
  |style="background-color: #e9e9ef"| <b>Default</b>
+
  | style="background-color: #e9e9ef" |<b>Field</b>
−
  |style="background-color: #e9e9ef"| <b>Extra</b>
+
| style="background-color: #e9e9ef" |<b>Type</b>
−
  |style="background-color: #e9e9ef"| <b>Description</b>
+
| style="background-color: #e9e9ef" |<b>Null</b>
 +
  | style="background-color: #e9e9ef" |<b>Key</b>
 +
  | style="background-color: #e9e9ef" |<b>Default</b>
 +
  | style="background-color: #e9e9ef" |<b>Extra</b>
 +
  | style="background-color: #e9e9ef" |<b>Description</b>
 +
|-
 +
|rowid
 +
|int(11)
 +
|NO
 +
|PRI
 +
|
 +
|auto_increment
 +
|technical index
 +
|-
 +
|fk_projet
 +
|int(11)
 +
|NO
 +
|MUL
 +
|
 +
|
 +
|ID of project ([[Table llx_projet|llx_projet]]->rowid)
 +
|-
 +
|fk_task_parent
 +
|int(11)
 +
|NO
 +
|
 +
|0
 +
|
 +
|ID of task ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
 +
|-
 +
|datec
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|creation date
 +
{{FieldTms}}
 +
|-
 +
|dateo
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|date start task
 +
|-
 +
|datee
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|date end task
 +
|-
 +
|datev
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|date validation task
 +
|-
 +
|label
 +
|varchar(255)
 +
|NO
 +
|
 +
|
 +
|
 +
|task label
 +
|-
 +
|description
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|task description
 +
|-
 +
|duration_effective
 +
|real
 +
|NO
 +
|
 +
|0
 +
|
 +
|duration of task
 +
|-
 +
|progress
 +
|int(11)
 +
|YES
 +
|
 +
|0
 +
|
 +
|progress of task
 +
|-
 +
|priority
 +
|int(11)
 +
|YES
 +
|
 +
|0
 +
|
 +
|task priority
 +
|-
 +
|fk_user_creat
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
|fk_user_modif
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of modifier user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
|fk_user_valid
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of validator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
|fk_statut
 +
|smallint(6)
 +
|NO
 +
|
 +
|0
 +
|
 +
|status
 +
|-
 +
|note_private
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|private notes
 +
|-
 +
|note_public
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|public notes
 +
|-
 +
|rang
 +
|int(11)
 +
|YES
 +
|
 +
|0
 +
|
 +
|rang
 +
|}&nbsp;
 +
 
 +
==Keys==
 +
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
 +
  | style="background-color: #e9e9ef" |<b>Key</b>
 +
  | style="background-color: #e9e9ef" |<b>Type</b>
 +
  | style="background-color: #e9e9ef" |<b>Fields</b>
 +
|-
 +
|PRIMARY
 +
|PRIMARY
 +
|rowid
 +
|-
 +
|fk_projet_task_fk_projet
 +
|MULTIPLE
 +
|fk_projet
 +
|-
 +
|idx_projet_task_fk_user_creat
 +
|MULTIPLE
 +
|fk_user_creat
 
|-  
 
|-  
−
| rowid
+
|idx_projet_task_fk_user_valid
−
| int(11)
+
|MULTIPLE
−
| &nbsp;
+
|fk_user_valid
−
| PRI
+
|}&nbsp;
−
| NULL
  −
| auto_increment
  −
| technical index
  −
|}
 
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/15620...62236"