Table llx adherent options: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary Tag: 2017 source edit |
|||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Table SQL]] | [[Category:Table SQL]] | ||
[[Category: | [[Category:Module Membership management]] | ||
[[Category:Adhérent]] | [[Category:Adhérent]] | ||
[[Category:Miembros]] | [[Category:Miembros]] | ||
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
== Table == | |||
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | |||
{| align="left" width="100%" border="0 | |||
|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 25: | Line 24: | ||
|style="background-color: #e9e9ef"| <b>Description</b> | |style="background-color: #e9e9ef"| <b>Description</b> | ||
|- | |- | ||
| | | rowid | ||
| int(11) | | int(11) | ||
| NO | | NO | ||
| Line 32: | Line 31: | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
{{FieldTms}} | |||
|- | |- | ||
| | | fk_member | ||
| int(11) | | int(11) | ||
| NO | | NO | ||
| | | MUL | ||
| | | | ||
| | | | ||
| ID of member ([[Table llx_adherent|llx_adherent]]->rowid) | | ID of member ([[Table llx_adherent|llx_adherent]]->rowid) | ||
|} | |||
==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 | |||
|- | |||
| idx_adherent_options | |||
| MULTIPLE | |||
| fk_member | |||
|} | |} | ||
Latest revision as of 10:52, 24 October 2023
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
Content/Contenu/Contenido
Contains the optional attributes of members of the association module
Contient les attributs optionnel des adhérents du module association
Contiene los atributos opcionales de los miembros del módulo miembros
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| fk_member | int(11) | NO | MUL | ID of member (llx_adherent->rowid) |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_adherent_options | MULTIPLE | fk_member |