Difference between revisions of "Table llx bookmark"

Latest revision as of 16:03, 10 September 2017

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the bookmarks displayed in the Dolibarr menus

Contient les bookmarks affichées dans les menus de Dolibarr

Contiene los marcadores a mostrar en los menús de Dolibarr

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_user	int(11)	NO	UNI			ID of user owner of the bookmark (llx_user->rowid)
dateb	datetime	YES		NULL		date of bookmark creation
url	varchar(128)	NO	UNI			url of bookmark pointing
target	varchar(16)	YES		NULL		indicates the behaviour on click on URL
title	varchar(64)	YES	UNI	NULL		title of bookmark
favicon	varchar(24)	YES		NULL		favicon of bookmark

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
uk_bookmark_url	UNIQUE	fk_user,url
uk_bookmark_title	UNIQUE	fk_user,title

@@ Line 1: / Line 1: @@
 [[Category:Table SQL]]
+[[Category:Bookmarks]]
+[[Category:Marque pages]]
+[[Category:Marcadores]]
 {{ListOfTables}}
@@ Line 12: / Line 15: @@
 = Structure =
+== Table ==
-{|  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" cellpadding="1" cellspacing="0" class="dolbox"
   |style="background-color: #e9e9ef"| <b>Field</b>
   |style="background-color: #e9e9ef"| <b>Type</b>
@@ Line 24: / Line 27: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|-
-| fk_soc
-| int(11)
-| YES
-|
-| NULL
-|
-| ID of society ([[Table llx_societe|llx_societe]]->rowid)
 |-
 | fk_user
 | int(11)
-|
+| NO
-|
+| UNI
 |
 |
@@ Line 56: / Line 51: @@
 | url
 | varchar(128)
-|
+| NO
-|
+| UNI
 |
 |
@@ Line 73: / Line 68: @@
 | varchar(64)
 | YES
-|
+| UNI
 | NULL
 |
@@ Line 85: / Line 80: @@
 |
 | favicon of bookmark
-|}
+|}&nbsp;
+==Keys==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| uk_bookmark_url
+| UNIQUE
+| fk_user,url
+|-
+| uk_bookmark_title
+| UNIQUE
+| fk_user,title
+|}&nbsp;