93
edits
Module Digirisk: Difference between revisions
Jump to navigation
Jump to search
→llx_digiriskdolibarr_digiriskresources
Theo-eoxia (talk | contribs) |
Theo-eoxia (talk | contribs) Tag: 2017 source edit |
||
| Line 22: | Line 22: | ||
==llx_digiriskdolibarr_digiriskdocuments== | ==llx_digiriskdolibarr_digiriskdocuments== | ||
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left" | |||
| style="background-color: #e9e9ef" |<b>Field</b> | |||
| style="background-color: #e9e9ef" |<b>Type</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 | |||
|- | |||
|ref | |||
|varchar(128) | |||
|NO | |||
| | |||
|(PROV) | |||
| | |||
|document ref | |||
|- | |||
|ref_ext | |||
|varchar(128) | |||
|NO | |||
| | |||
|NULL | |||
| | |||
|document external ref | |||
|- | |||
|entity | |||
|int(11) | |||
|NO | |||
| | |||
|1 | |||
| | |||
|entity | |||
|- | |||
|date_creation | |||
|datetime | |||
|NO | |||
| | |||
| | |||
| | |||
|creation date | |||
|- | |||
|tms | |||
|timestamp | |||
|NO | |||
| | |||
|CURRENT_TIMESTAMP | |||
|ON UPDATE CURRENT_TIMESTAMP | |||
|timestamp | |||
|- | |||
|json | |||
|text | |||
| | |||
| | |||
| | |||
| | |||
|content | |||
|- | |||
|import_key | |||
|int(11) | |||
| | |||
| | |||
|NULL | |||
| | |||
|import key | |||
|- | |||
|status | |||
|smallint | |||
| | |||
| | |||
| | |||
| | |||
|status | |||
|- | |||
|fk_user_creat | |||
|int(11) | |||
| | |||
| | |||
|NULL | |||
| | |||
|creation user | |||
|- | |||
|last_main_doc | |||
|varchar(255) | |||
| | |||
| | |||
| | |||
| | |||
|last main doc | |||
|- | |||
|model_pdf | |||
|varchar(255) | |||
| | |||
| | |||
|NULL | |||
| | |||
|PDF model | |||
|- | |||
|model_odt | |||
|varchar(255) | |||
| | |||
| | |||
|NULL | |||
| | |||
|ODT model | |||
|- | |||
|type | |||
|varchar(50) | |||
| | |||
| | |||
|NULL | |||
| | |||
|document type | |||
|} | |||
=Tables SQL= | |||
==llx_digiriskdolibarr_digiriskresources== | |||
{| 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>Field</b> | | style="background-color: #e9e9ef" |<b>Field</b> | ||