10
edits
Changes
m
no edit summary
Line 6:
Line 6:
{{ListOfTables}}
{{ListOfTables}}
−= Content/Contenu/Contenido/Conteúdo =
+=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.
−{{flag pt}} Contem as tarefas relacionadas a um projeto.
+{{flag pt}}
+ Contém as tarefas relacionadas a um projeto.
−= Structure =
+=Structure=
−== Table ==
+==Table==
−{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
− |style="background-color: #e9e9ef"| <b>Field</b>
+ | style="background-color: #e9e9ef" |<b>Field</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
+ | style="background-color: #e9e9ef" |<b>Type</b>
− |style="background-color: #e9e9ef"| <b>Null</b>
+ | style="background-color: #e9e9ef" |<b>Null</b>
− |style="background-color: #e9e9ef"| <b>Key</b>
+ | style="background-color: #e9e9ef" |<b>Key</b>
− |style="background-color: #e9e9ef"| <b>Default</b>
+ | style="background-color: #e9e9ef" |<b>Default</b>
− |style="background-color: #e9e9ef"| <b>Extra</b>
+ | style="background-color: #e9e9ef" |<b>Extra</b>
− |style="background-color: #e9e9ef"| <b>Description</b>
+ | style="background-color: #e9e9ef" |<b>Description</b>
|-
|-
−| rowid
+|rowid
−| int(11)
+|int(11)
−| NO
+|NO
−| PRI
+|PRI
−|
+|
−| auto_increment
+|auto_increment
−| technical index
+|technical index
|-
|-
−| fk_projet
+|fk_projet
−| int(11)
+|int(11)
−| NO
+|NO
−| MUL
+|MUL
−|
+|
−|
+|
−| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
+|ID of project ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
−| fk_task_parent
+|fk_task_parent
−| int(11)
+|int(11)
−| NO
+|NO
−|
+|
−| 0
+|0
−|
+|
−| ID of task ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
+|ID of task ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
|-
|-
−| datec
+|datec
−| datetime
+|datetime
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| creation date
+|creation date
{{FieldTms}}
{{FieldTms}}
|-
|-
−| dateo
+|dateo
−| datetime
+|datetime
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| date start task
+|date start task
|-
|-
−| datee
+|datee
−| datetime
+|datetime
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| date end task
+|date end task
|-
|-
−| datev
+|datev
−| datetime
+|datetime
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| date validation task
+|date validation task
|-
|-
−| label
+|label
−| varchar(255)
+|varchar(255)
−| NO
+|NO
−|
+|
−|
+|
−|
+|
−| task label
+|task label
|-
|-
−| description
+|description
−| text
+|text
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| task description
+|task description
|-
|-
−| duration_effective
+|duration_effective
−| real
+|real
−| NO
+|NO
−|
+|
−| 0
+|0
−|
+|
−| duration of task
+|duration of task
|-
|-
−| progress
+|progress
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| progress of task
+|progress of task
|-
|-
−| priority
+|priority
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| task priority
+|task priority
|-
|-
−| fk_user_creat
+|fk_user_creat
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of creator user ([[Table llx_user|llx_user]]->rowid)
+|ID of creator user ([[Table llx_user|llx_user]]->rowid)
|-
|-
−| fk_user_modif
+|fk_user_modif
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of modifier user ([[Table llx_user|llx_user]]->rowid)
+|ID of modifier user ([[Table llx_user|llx_user]]->rowid)
|-
|-
−| fk_user_valid
+|fk_user_valid
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of validator user ([[Table llx_user|llx_user]]->rowid)
+|ID of validator user ([[Table llx_user|llx_user]]->rowid)
|-
|-
−| fk_statut
+|fk_statut
−| smallint(6)
+|smallint(6)
−| NO
+|NO
−|
+|
−| 0
+|0
−|
+|
−| status
+|status
|-
|-
−| note_private
+|note_private
−| text
+|text
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| comentary notes
+|private notes
|-
|-
−| note_public
+|note_public
−| text
+|text
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| public comentary notes
+|public notes
|-
|-
−| rang
+|rang
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| rang
+|rang
|}
|}
−== Keys ==
+==Keys==
−{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
− |style="background-color: #e9e9ef"| <b>Key</b>
+ | style="background-color: #e9e9ef" |<b>Key</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
+ | style="background-color: #e9e9ef" |<b>Type</b>
− |style="background-color: #e9e9ef"| <b>Fields</b>
+ | style="background-color: #e9e9ef" |<b>Fields</b>
|-
|-
−| PRIMARY
+|PRIMARY
−| PRIMARY
+|PRIMARY
−| rowid
+|rowid
|-
|-
−| fk_projet_task_fk_projet
+|fk_projet_task_fk_projet
−| MULTIPLE
+|MULTIPLE
−| fk_projet
+|fk_projet
|-
|-
−| idx_projet_task_fk_user_creat
+|idx_projet_task_fk_user_creat
−| MULTIPLE
+|MULTIPLE
−| fk_user_creat
+|fk_user_creat
|-
|-
−| idx_projet_task_fk_user_valid
+|idx_projet_task_fk_user_valid
−| MULTIPLE
+|MULTIPLE
−| fk_user_valid
+|fk_user_valid
|}
|}