Line 29:
Line 29:
|technical index
|technical index
|-
|-
−
|name
+
|tms
−
|varchar(255)
+
|timestamp
|NO
|NO
−
|UNI
|
|
|
|
−
|key/name of constant
+
|
+
|Last update date
+
|-
+
|datec
+
|datetime
+
|NO
+
|
+
|
+
|
+
|Date creation
|-
|-
−
|entity
+
|jobtype
−
|int(11)
+
|varchar(10)
|NO
|NO
−
|UNI
−
|1
|
|
−
|multi company id
+
|
+
|
+
|Type of job
|-
|-
−
|value
+
|label
|text
|text
−
|NO
|
|
|
|
|
|
−
|value of constant.
+
|
+
|
|-
|-
−
|type
+
|command
−
|varchar(6)
+
|varchar(10)
|YES
|YES
|
|
−
|NULL
|
|
−
|type of constant (deprecated)
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|
+
|
+
|
|-
|-
−
|visible
−
|tinyint(4)
−
|NO
|
|
−
|1
|
|
−
|is the constant visible in the page home->setup->other ?
+
|
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|
+
|
+
|
+
|-
+
|
+
|
+
|
+
|
+
|
+
|
+
|
|-
|-
−
|note
−
|text
−
|YES
|
|
−
|NULL
|
|
−
|notes about the constant {{FieldTms}}
+
|
+
|
+
|
+
|
+
|
+
|-
+
|entity
+
|int(11)
+
|NO
+
|UNI
+
|1
+
|
+
|multi company id
|}
|}
==Keys==
==Keys==