4,395
edits
Changes
→Structure
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)
+|}
+==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
|}
|}