Table llx extrafields - Revision history

Eldy at 09:13, 5 September 2015

2015-09-05T09:13:33Z

← Older revision		Revision as of 09:13, 5 September 2015
Line 36:		Line 36:
	\|		\|
	\| Name of field		\| Name of field
	\|-		{{FieldEntity}}
	~~\| entity~~
	~~\| int(11)~~
	~~\| NO~~
	~~\| UNI~~
	~~\| 1~~
	\|
	~~\| multi company id~~
	\|-		\|-
	\| elementtype		\| elementtype

Eldy: /* Keys */

2015-09-05T09:12:44Z

Keys

← Older revision		Revision as of 09:12, 5 September 2015
Line 145:		Line 145:
	\| rowid		\| rowid
	\|-		\|-
	\| ~~idx_extra_fields_name~~		\| uk_extrafields_name
	\| UNIQUE		\| UNIQUE
	\| name,entity		\| name,entity,elementtype
	\|}		\|}

Eldy at 09:12, 5 September 2015

2015-09-05T09:12:04Z

← Older revision		Revision as of 09:12, 5 September 2015
Line 27:		Line 27:
	\|		\|
	\| auto_increment		\| auto_increment
	\| ~~technical index~~		\| Technical id
	~~{{FieldTms}}~~		\|-
			\| name
			\| varchar(64)
			\| NO
			\| UNI
			\|
			\|
			\| Name of field
	\|-		\|-
	\| entity		\| entity
Line 38:		Line 45:
	\| multi company id		\| multi company id
	\|-		\|-
	\| ~~object~~		\| elementtype
	\| varchar(64)		\| varchar(64)
	\| NO		\| NO
Line 44:		Line 51:
	\|		\|
	\|		\|
	\| ~~object~~		\| For which element this extra fields is for
			{{FieldTms}}
	\|-		\|-
	\| ~~assign~~		\| label
	~~\| int(11)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	\|
	\|-
	~~\| name~~
	\| varchar(64)		\| varchar(64)
	\| NO		\| NO
	\| ~~UNI~~		\|
	\|		\|
	\|		\|
	\| ~~name~~ of field		\| Label of field
	\|-		\|-
	\| ~~label~~		\| type
	\| varchar(64)		\| varchar(8)
	\| NO		\| NO
	\|		\|
	\|		\|
	\|		\|
	\| ~~label~~ of field		\| Type/format of field
	\|-		\|-
	\| ~~format~~		\| size
	\| ~~varchar~~(8)		\| int(11)
	\| NO		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| ~~format~~ of field		\| Max size of field
	\|-		\|-
	\| ~~fieldsize~~		\| fieldunique
	\| int(11)		\| int(11)
	\| YES		\| YES
Line 84:		Line 84:
	\| NULL		\| NULL
	\|		\|
	\| ~~size of~~ field		\| 1 if field value must be unique
	\|-		\|-
	\| ~~maxlength~~		\| fieldrequired
	\| int(11)		\| int(11)
	\| YES		\| YES
Line 92:		Line 92:
	\| NULL		\| NULL
	\|		\|
	\| ~~maxlength of~~ field		\| 1 if field value is mandatory
			\|-
			\| perms
			\| varchar(255)
			\| YES
			\|
			\| NULL
			\|
			\| 1 if field value is mandatory
	\|-		\|-
	\| ~~options~~		\| pos
	\| ~~varchar~~(45)		\| int(11)
	\| YES		\| YES
	\|		\|
	\| NULL		\| NULL
	\|		\|
	\| ~~options~~ of field		\| Position of extra field among other extra field
	\|-		\|-
	\| ~~rank~~		\| alwayseditable
	\| int(11)		\| int(11)
	\| YES		\| YES
Line 108:		Line 116:
	\| NULL		\| NULL
	\|		\|
			\| 1=The field can be edited whatever is status of object
			\|-
			\| param
			\| text
			\| YES
	\|		\|
			\| NULL
			\|
			\| Parameters to define possible values of field
	\|-		\|-
	\| ishidden		\| ishidden
Line 116:		Line 132:
	\| 0		\| 0
	\|		\|
	\|		\| The extra field is not visible by user
	\|}		\|}

Eldy: moved Table llx extra fields to Table llx extrafields

2015-09-05T09:05:37Z

moved Table llx extra fields to Table llx extrafields

← Older revision

Revision as of 09:05, 5 September 2015

Phfavre: /* Table */

2015-08-31T06:58:13Z

Table

← Older revision		Revision as of 06:58, 31 August 2015
Line 107:		Line 107:
	\|		\|
	\| NULL		\| NULL
			\|
			\|
			\|-
			\| ishidden
			\| int(11)
			\| YES
			\|
			\| 0
	\|		\|
	\|		\|

Eldy: /* Table */

2012-08-10T12:41:10Z

Table

← Older revision		Revision as of 12:41, 10 August 2012
Line 28:		Line 28:
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| entity		\| entity

Simnandez: /* Keys */

2011-07-19T15:20:09Z

Keys

← Older revision		Revision as of 15:20, 19 July 2011
Line 119:		Line 119:

	== Keys ==		== Keys ==
	~~'''Version 1.1 2010/01/13'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

Simnandez: /* Table */

2011-07-19T15:19:57Z

Table

← Older revision		Revision as of 15:19, 19 July 2011
Line 12:		Line 12:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.1 2010/01/13'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

Simnandez: Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the extra fields. {{flag fr}} Contient des extra champs. {{flag sp}} Contiene los ...'

2010-03-22T11:30:12Z

Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the extra fields. {{flag fr}} Contient des extra champs. {{flag sp}} Contiene los ...'

New page

[[Category:Table SQL]]

{{ListOfTables}}

= Content/Contenu/Contenido =
{{flag en}} Contains the extra fields.

{{flag fr}} Contient des extra champs.

{{flag sp}} Contiene los campos adicionales.

= Structure =
== Table ==
'''Version 1.1 2010/01/13'''
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
|style="background-color: #e9e9ef"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| rowid
| int(11)
| NO
| PRI
|
| auto_increment
| technical index
|-
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| entity
| int(11)
| NO
| UNI
| 1
|
| multi company id
|-
| object
| varchar(64)
| NO
|
|
|
| object
|-
| assign
| int(11)
| YES
|
| NULL
|
|
|-
| name
| varchar(64)
| NO
| UNI
|
|
| name of field
|-
| label
| varchar(64)
| NO
|
|
|
| label of field
|-
| format
| varchar(8)
| NO
|
|
|
| format of field
|-
| fieldsize
| int(11)
| YES
|
| NULL
|
| size of field
|-
| maxlength
| int(11)
| YES
|
| NULL
|
| maxlength of field
|-
| options
| varchar(45)
| YES
|
| NULL
|
| options of field
|-
| rank
| int(11)
| YES
|
| NULL
|
|
|} 

== Keys ==
'''Version 1.1 2010/01/13'''
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Fields
|-
| PRIMARY
| PRIMARY
| rowid
|-
| idx_extra_fields_name
| UNIQUE
| name,entity
|}