4,395
edits
Changes
→Structure
Line 15:
Line 15:
= Structure =
= Structure =
== Table ==
== Table ==
−'''Version 1.1 2009/10/07'''
+'''Version 1.6 2010/02/10'''
{| 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"
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Field</b>
Line 45:
Line 45:
| NO
| NO
|
|
+| 0
|
|
+| ID of task ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
+|-
+| datec
+| datetime
+| YES
+|
+| NULL
+|
+| creation date
+|-
+| tms
+| timestamp
+| NO
+|
+| CURRENT_TIMESTAMP
+|
+| last update date
+|-
+| dateo
+| datetime
+| YES
+|
+| NULL
+|
+| date start task
+|-
+| datee
+| datetime
+| YES
+|
+| NULL
+|
+| date end task
+|-
+| datee
+| datetime
+| YES
+|
+| NULL
+|
+| date end task
+|-
+| datev
+| datetime
+| YES
+|
+| NULL
|
|
−| ID of task ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
+| date validation task
|-
|-
−| title
+| label
| varchar(255)
| varchar(255)
+| NO
+|
+|
+|
+| task label
+|-
+| description
+| text
| YES
| YES
|
|
| NULL
| NULL
|
|
−| task title
+| task description
|-
|-
| duration_effective
| duration_effective
Line 61:
Line 117:
| NO
| NO
|
|
+| 0
+|
+| duration of task
+|-
+| progress
+| int(11)
+| YES
+|
+| 0
+|
+| progress of task
+|-
+| priority
+| int(11)
+| YES
+|
+| 0
|
|
+| task priority
+|-
+| fk_milestone
+| int(11)
+| YES
|
|
−| duration of task
+| 0
+|
+| ID of milestone ([[Table llx_projet_milestone|llx_projet_milestone]]->rowid)
|-
|-
| fk_user_creat
| fk_user_creat
Line 72:
Line 152:
|
|
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
| 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
| fk_statut
−| varchar(6)
+| smallint(6)
−| YES
+| NO
|
|
−| open
+| 0
|
|
| status
| status
|-
|-
−| note
+| note_private
| text
| text
| YES
| YES
Line 88:
Line 184:
|
|
| comentary notes
| comentary notes
+|-
+| note_public
+| text
+| YES
+|
+| NULL
+|
+| public comentary notes
+|-
+| rang
+| int(11)
+| YES
+|
+| 0
+|
+| rang
|}
|}
== Keys ==
== Keys ==
−'''Version 1.1 2009/10/07'''
+'''Version 1.3 2010/02/10'''
{| 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"
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Key</b>
Line 103:
Line 215:
| MULTIPLE
| MULTIPLE
| fk_projet
| fk_projet
+|-
+| idx_projet_task_fk_user_creat
+| MULTIPLE
+| fk_user_creat
+|-
+| idx_projet_task_fk_user_valid
+| MULTIPLE
+| fk_user_valid
|}
|}