Changes

m
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==