Line 16:
Line 16:
= Structure =
= Structure =
−
{| 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"
+
== Table ==
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|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>
Line 27:
Line 28:
| rowid
| rowid
| int(11)
| int(11)
−
|
+
| NO
| PRI
| PRI
−
| NULL
+
|
| auto_increment
| auto_increment
| technical index
| technical index
−
|}
+
|-
+
| nom
+
| varchar(255)
+
| NO
+
|
+
|
+
|
+
| name
+
|-
+
| entity
+
| int(11)
+
| NO
+
|
+
| 1
+
|
+
| multi company id
+
|-
+
| datec
+
| datetime
+
| YES
+
|
+
| NULL
+
|
+
| creation date
+
{{FieldTms}}
+
|-
+
| note
+
| text
+
| YES
+
|
+
| NULL
+
|
+
| comentary
+
|}
+
+
== Keys ==
+
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+
|style="background-color: #e9e9ef"| <b>Key</b>
+
|style="background-color: #e9e9ef"| <b>Type</b>
+
|style="background-color: #e9e9ef"| <b>Fields</b>
+
|-
+
| PRIMARY
+
| PRIMARY
+
| rowid
+
|-
+
| uk_usergroup_name
+
| UNIQUE
+
| nom,entity
+
|}