Table llx adherent: Difference between revisions

Line 14: Line 14:


= Structure =
= Structure =
== Table ==
'''Version 1.1 2009/10/07'''
'''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 240: Line 240:
|  
|  
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
|}&nbsp;
==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
|-
| uk_adherent_login
| UNIQUE
| login
|-
| uk_adherent_fk_soc
| UNIQUE
| fk_soc
|-
| idx_adherent_fk_soc
| MULTIPLE
| fk_soc
|-
| idx_adherent_fk_adherent_type
| MULTIPLE
| fk_adherent_type
|}&nbsp;
|}&nbsp;