Module Digirisk: Difference between revisions

Jump to navigation Jump to search
TABLE SQL
(TABLE SQL)
Tag: 2017 source edit
Line 41: Line 41:


=Tables SQL=
=Tables SQL=
=Digirisk Documents=


==llx_digiriskdolibarr_digiriskdocuments==
==llx_digiriskdolibarr_digiriskdocuments==
Line 165: Line 167:
|document type
|document type
|} 
|} 
=Élement Digirisk=
==llx_digiriskdolibarr_digiriskelement==
==llx_digiriskdolibarr_digiriskelement_extrafields==
=Analyse des risques=
==llx_digiriskdolibarr_risk==
==llx_digiriskdolibarr_risk_extrafields==
==llx_digiriskdolibarr_riskassessment==
==llx_digiriskdolibarr_riskassessment_extrafields==
==llx_digiriskdolibarr_risksign==
==llx_digiriskdolibarr_risksign_extrafields==
==llx_c_conventions_collectives==


==llx_digiriskdolibarr_digiriskresources==
==llx_digiriskdolibarr_digiriskresources==
Line 258: Line 282:
|} 
|} 


==llx_digiriskdolibarr_digiriskstandard==


==llx_digiriskdolibarr_digiriskconst==
==llx_digiriskdolibarr_digiriskstandard_extrafields==


{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
==llx_digiriskdolibarr_evaluator==
| 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
|
|
|
|document ref
|-
|ref_ext
|varchar(128)
|NO
|
|NULL
|
|document external ref
|-
|entity
|int(11)
|NO
|
|1
|
|entity
|-
|date_creation
|datetime
|NO
|
|
|
|creation date
|-
|import_key
|int(11)
|
|
|NULL
|
|import key
|-
|tms
|timestamp
|NO
|
|CURRENT_TIMESTAMP
|ON UPDATE CURRENT_TIMESTAMP
|timestamp
|-
|status
|smallint
|
|
|
|
|status
|-
|fk_user_creat
|int(11)
|
|
|NULL
|
|creation user
|-
|type
|varchar(50)
|
|
|NULL
|
|type
|-
|value
|varchar(128)
|
|
|NULL
|
|const value
|}&nbsp;


==llx_digiriskdolibarr_evaluator_extrafields==


==llx_element_openinghours==
==llx_element_openinghours==

Navigation menu