Table llx ecm files - Revision history

Bgenere: moved Table llx ecm documents to Table llx ecm files: Table llx_ecm_documents has been renamed

2018-07-10T09:20:21Z

moved Table llx ecm documents to Table llx ecm files: Table llx_ecm_documents has been renamed

← Older revision

Revision as of 09:20, 10 July 2018

Simnandez: /* Structure */

2011-07-19T15:14:39Z

Structure

← Older revision		Revision as of 15:14, 19 July 2011
Line 11:		Line 11:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.4 2009/12/15'''~~		{\| 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>
Line 183:		Line 182:

	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| 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 */

2009-12-17T09:11:37Z

Table

@@ Line 11: / Line 11: @@
 = Structure =
 == Table ==
-'''Version 1.1 2009/10/07'''
+'''Version 1.4 2009/12/15'''
 {|  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>
@@ Line 36: / Line 36: @@
+|
 | ref. of document
 |-
 | filename
@@ Line 148: / Line 156: @@
+|
 | is the document private to user (0=no,1=yes)?
 |}&nbsp;
 == Keys ==
 '''Version 1.1 2009/10/07'''

Simnandez: /* Structure */

2009-10-20T09:34:37Z

Structure

← Older revision		Revision as of 09:34, 20 October 2009
Line 10:		Line 10:

	= Structure =		= Structure =
			== Table ==
			'''Version 1.1 2009/10/07'''
	{\| 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"		{\| 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>
Line 21:		Line 23:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 135:		Line 137:
	\| YES		\| YES
	\|		\|
	\| ~~NULL~~		\| 0
	\|		\|
	\| ID of status		\| ID of status
Line 143:		Line 145:
	\| YES		\| YES
	\|		\|
	\| ~~NULL~~		\| 0
	\|		\|
	\| is the document private to user?		\| is the document private to user (0=no,1=yes)?
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| 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>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Fields</b>
			\|-
			\| PRIMARY
			\| PRIMARY
			\| rowid
			\|}

Simnandez: /* Structure */

2009-06-16T17:33:59Z

Structure

← Older revision		Revision as of 17:33, 16 June 2009
Line 26:		Line 26:
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
			\|-
			\| ref
			\| varchar(16)
			\| NO
			\|
			\|
			\|
			\| ref. of document
			\|-
			\| filename
			\| varchar(255)
			\| NO
			\|
			\|
			\|
			\| file name of document
			\|-
			\| filesize
			\| int(11)
			\| NO
			\|
			\|
			\|
			\| file size of document
			\|-
			\| filenime
			\| varchar(32)
			\| NO
			\|
			\|
			\|
			\| file nime of document
			\|-
			\| fullpath_dol
			\| varchar(255)
			\| NO
			\|
			\|
			\|
			\| dolibarr path of file
			\|-
			\| fullpath_orig
			\| varchar(255)
			\| NO
			\|
			\|
			\|
			\| orig. path of file
			\|-
			\| description
			\| text
			\| YES
			\|
			\| NULL
			\|
			\| description about document
			\|-
			\| manualkeyword
			\| text
			\| YES
			\|
			\| NULL
			\|
			\| keyword for document
			\|-
			\| fk_create
			\| int(11)
			\| NO
			\|
			\|
			\|
			\| ID of creator user ([[Table llx_user\|llx_user]]->rowid)
			\|-
			\| fk_update
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of last updater user ([[Table llx_user\|llx_user]]->rowid)
			\|-
			\| date_c
			\| datetime
			\| NO
			\|
			\|
			\|
			\| creation date
			\|-
			\| date_u
			\| timestamp
			\| NO
			\|
			\| CURRENT_TIMESTAMP
			\|
			\| last update date
			\|-
			\| fk_directory
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of related directory ([[Table llx ecm directories\|llx ecm directories]]->rowid)
			\|-
			\| fk_status
			\| smallint(6)
			\| YES
			\|
			\| NULL
			\|
			\| ID of status
			\|-
			\| private
			\| smallint(6)
			\| YES
			\|
			\| NULL
			\|
			\| is the document private to user?
			\|}

Simnandez: /* Content/Contenu/Contenido */

2009-06-16T17:20:59Z

Content/Contenu/Contenido

← Older revision		Revision as of 17:20, 16 June 2009
Line 5:		Line 5:
	{{flag en}} contains the list of the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]		{{flag en}} contains the list of the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]

	{{flag fr}} contient la liste des documents du Gestion Electronique de Documents. Les ~~directories~~ sont a le [[Table llx ecm directories]]		{{flag fr}} contient la liste des documents du Gestion Electronique de Documents. Les répertoires sont a la [[Table llx ecm directories]]

	{{flag sp}} Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]		{{flag sp}} Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]

Simnandez: /* Content/Contenu/Contenido */

2009-06-16T15:12:18Z

Content/Contenu/Contenido

← Older revision		Revision as of 15:12, 16 June 2009
Line 5:		Line 5:
	{{flag en}} contains the list of the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]		{{flag en}} contains the list of the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]

	{{flag fr}} contient la liste des documents du Gestion Electronique de Documents. Les directories sont a le [[Table llx ecm directories]		{{flag fr}} contient la liste des documents du Gestion Electronique de Documents. Les directories sont a le [[Table llx ecm directories]]

	{{flag sp}} Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]		{{flag sp}} Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]

Simnandez: /* Content/Contenu/Contenido */

2009-06-16T15:12:08Z

Content/Contenu/Contenido

← Older revision		Revision as of 15:12, 16 June 2009
Line 3:		Line 3:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{flag en}} ~~Contains~~ the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]		{{flag en}} contains the list of the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]

	{{flag fr}} ~~Contient~~ des documents du Gestion Electronique de Documents. Les directories sont a le [[Table llx ecm directories]		{{flag fr}} contient la liste des documents du Gestion Electronique de Documents. Les directories sont a le [[Table llx ecm directories]

	{{flag sp}} Contiene los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]		{{flag sp}} Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]

	= Structure =		= Structure =

Simnandez: Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the documents of Electronic Content Management. The directories are in the [[Table llx...'

2009-06-16T15:00:49Z

Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the documents of Electronic Content Management. The directories are in the [[Table llx...'

New page

[[Category:Table SQL]]
{{ListOfTables}}

= Content/Contenu/Contenido =
{{flag en}} Contains the documents of Electronic Content Management. The directories are in the [[Table llx ecm directories]]

{{flag fr}} Contient des documents du Gestion Electronique de Documents. Les directories sont a le [[Table llx ecm directories]

{{flag sp}} Contiene los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en [[Table llx ecm directories]]

= Structure =
{| 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)
|  
| PRI
| NULL
| auto_increment
| technical index