Table llx usergroup user: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
No edit summary
 
(13 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Contient les liens entre [[Table llx_user]] et [[Table llx_usergroup]]
[[Category:Table SQL]]
[[Category:Utilisateurs]]
[[Category:Users]]
[[Category:Usuarios]]
{{ListOfTables}}


== Structure ==
<pre>
-- ============================================================================
-- Copyright (C) 2005 Rodolphe Quiedeville <rodolphe@quiedeville.org>
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
--
-- $Id: llx_usergroup_user.sql,v 1.1 2005/01/27 15:13:02 rodolphe Exp $
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_usergroup_user.sql,v $
--
-- ===========================================================================


create table llx_usergroup_user
= Content/Contenu/Contenido =
(
  rowid        integer AUTO_INCREMENT PRIMARY KEY,
  fk_user      integer NOT NULL,
  fk_usergroup  integer NOT NULL,


  UNIQUE(fk_user,fk_usergroup)
{{flag_en}} Contains the link between [[Table llx_user|llx_user]] and [[Table llx_usergroup|llx_usergroup]]
)type=innodb;
 
</pre>
{{flag_fr}} Contient les liens entre [[Table llx_user|llx_user]] et [[Table llx_usergroup|llx_usergroup]]
 
{{flag_sp}} Contiene los enlaces entre [[Table llx_user|llx_user]] y [[Table llx_usergroup|llx_usergroup]]
 
= Structure =
== Table ==
{|  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>
|style="background-color: #e9e9ef"| <b>Null</b>
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Default</b>
|style="background-color: #e9e9ef"| <b>Extra</b>
|style="background-color: #e9e9ef"| <b>Description</b>
|-
| rowid
| int(11)
| NO
| PRI
|
| auto_increment
| technical index
|-
| fk_user
| int(11)
| NO
| UNI
|
| 
| ID of user ([[Table llx_user|llx_user]]->rowid)
|-
| fk_usergroup
| int(11)  
| NO
| UNI
|
|
| ID of user group ([[Table llx_usergroup|llx_usergroup]]->rowid)
|}&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
|-
| fk_user
| UNIQUE
| fk_user,fk_usergroup
|}&nbsp;

Latest revision as of 16:03, 19 July 2011


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the link between llx_user and llx_usergroup

Fr verysmall.png Contient les liens entre llx_user et llx_usergroup

Es verysmall.png Contiene los enlaces entre llx_user y llx_usergroup

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 (llx_user->rowid)
fk_usergroup int(11) NO UNI ID of user group (llx_usergroup->rowid)

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
fk_user UNIQUE fk_user,fk_usergroup

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_usergroup_user&oldid=22561"