Line 27:
Line 27:
| auto_increment
| auto_increment
| technical index
| technical index
+
|-
+
| name
+
| varchar(255)
+
| YES
+
|
+
| NULL
+
|
+
| name of constant
+
|-
+
| entity
+
| int(11)
+
|
+
|
+
| 1
+
|
+
| multi company id
+
|-
+
| value
+
| text
+
| YES
+
|
+
| NULL
+
|
+
| value of constant. max 65535 caracteres
+
|-
+
| type
+
| varchar(6)
+
| YES
+
|
+
| NULL
+
|
+
| type of constant
+
|-
+
| visible
+
| tinyint(4)
+
|
+
|
+
| 1
+
|
+
| is the constant visible?
+
|-
+
| note
+
| text
+
| YES
+
|
+
| NULL
+
|
+
| notes about the constant
+
|-
+
| tms
+
| timestamp
+
|
+
|
+
| CURRENT_TIMESTAMP
+
|
+
| last update date
|}
|}