28,936
edits
Changes
m
no edit summary
Line 1:
Line 1:
{{FieldImportKey}}
{{FieldTms}}+
[[Category:Table SQL]]
[[Category:Table SQL]]
−[[Category:Foundations]]
+[[Category:Module Membership management]]
[[Category:Adhérent]]
[[Category:Adhérent]]
[[Category:Miembros]]
[[Category:Miembros]]
Line 18:
Line 18:
=Structure=
=Structure=
==Table==
==Table==
+
+Version Dolibarr 15
+
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
− |#
+ | style="background-color: #e9e9ef" |<b> # </b>
−| 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>
Line 27:
Line 31:
| 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>
−|History
+ | style="background-color: #e9e9ef" |<b>History</b>
|-
|-
|1
|1
Line 359:
Line 363:
|
|
|-
|-
+|34
+|model_pdf
+|varchar(255)
+|YES
+|
+|NULL
+|
+|
|
|
+|-
+|35
+|datevalid
+|datetime
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|36
+|datec
+|datetime
+|YES
+|
+|NULL
+|
+|creation time
+|
+|-
+|37
+|tms
+|timestamp
+|YES
+|
+|CURRENT_TIMESTAMP
+|
+|ON UPDATE CURRENT_TIMESTAMP
+|
+|-
+|38
|fk_user_author
|fk_user_author
|int(11)
|int(11)
Line 369:
Line 413:
|
|
|-
|-
−|
+|38
|fk_user_mod
|fk_user_mod
|int(11)
|int(11)
Line 379:
Line 423:
|
|
|-
|-
−|
+|40
|fk_user_valid
|fk_user_valid
|int(11)
|int(11)
Line 387:
Line 431:
|
|
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
−|
|
|-
|-
−|41
+|canvas
+|varchar(32)
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|42
+|import_key
+|varchar(14)
+|YES
+|
+|NULL
+|
+|Code used to save the import id. See page Field Import key.
+|
+|-
|}
|}