Table llx adherent: Difference between revisions

Line 14: Line 14:


= Structure =
= Structure =
'''Version 1.26 2009/04/02'''
'''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"
Line 29: Line 29:
| NO
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
Line 37: Line 37:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| name of member
| name of member
Line 45: Line 45:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| firstname of member
| firstname of member
Line 61: Line 61:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| login password of member
| login password of member
Line 85: Line 85:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| society
| society
Line 93: Line 93:
| YES
| YES
| UNI
| UNI
|  
| NULL
|  
|  
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
Line 101: Line 101:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| adress of member
| adress of member
Line 109: Line 109:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| postal code of member
| postal code of member
Line 117: Line 117:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| city of member
| city of member
Line 125: Line 125:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| country of member
| country of member
Line 133: Line 133:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| email of member
| email of member
Line 141: Line 141:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| phone of member
| phone of member
Line 149: Line 149:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| personal phone of member
| personal phone of member
Line 157: Line 157:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| mobil phone of member
| mobil phone of member
Line 165: Line 165:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| date of birth
| date of birth
Line 173: Line 173:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| url to photo of member
| url to photo of member
Line 197: Line 197:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| date end of cotisation
| date end of cotisation
Line 205: Line 205:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| comentary
| comentary
Line 221: Line 221:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID user author ([[Table llx_user|llx_user]]->rowid)
| ID user author ([[Table llx_user|llx_user]]->rowid)
Line 229: Line 229:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID user made last modification ([[Table llx_user|llx_user]]->rowid)
| ID user made last modification ([[Table llx_user|llx_user]]->rowid)
Line 237: Line 237:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
|} 
|}