4,395
edits
Changes
→Keys
Line 1:
Line 1:
−
+
+
+
+
+
+
+
Table qui contient l'association entre un utilisateur et ces droits ([[Table llx_user]] et [[Table llx_rights_def]])
+[[Category:Table SQL]]
+[[Category:Utilisateurs]]
+[[Category:Users]]
+[[Category:Usuarios]]
+{{ListOfTables}}
+= Content/Contenu/Contenido =
+{{flag_en}} Contains the link between a user and his permissions ([[Table llx_user]] and [[Table llx_rights_def]])
+{{flag_fr}} Contient l'association entre un utilisateur et ses droits ([[Table llx_user]] et [[Table llx_rights_def]])
+{{flag_sp}} Contiene los enlaces entre un usuario y sus permisos ([[Table llx_user]] y [[Table llx_rights_def]])
+= 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
+| NULL
+| auto_increment
+| technical index
+|-
+| fk_user
+| int(11)
+| NO
+| UNI
+|
+|
+| ID of user ([[Table llx_user|llx_user]]->rowid)
+|-
+| fk_id
+| int(11)
+| NO
+| UNI
+|
+|
+| ID of right ([[Table llx_rights_def|llx_rights_def]]->id)
+|}
+== 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_id
+|}