Table llx adherent: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
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)
|} 
|} 

Revision as of 15:27, 13 October 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the list of members managed in the foundation module

Fr verysmall.png Contient les adhérents du module association

Es verysmall.png Contiene la lista de miembros del módulo miembros

Structure

Version 1.1 2009/10/07

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
nom varchar(50) YES NULL name of member
prenom varchar(50) YES NULL firstname of member
login varchar(50) NO UNI login of member
password varchar(50) YES NULL login password of member
fk_adherent_type int(11) NO MUL ID type of member (llx_adherent_type->rowid)
morphy varchar(3) NO person physical / entity
societe varchar(50) YES NULL society
fk_soc int(11) YES UNI NULL ID of society (llx_societe->rowid)
adresse text YES NULL adress of member
cp varchar(30) YES NULL postal code of member
ville varchar(50) YES NULL city of member
pays varchar(50) YES NULL country of member
email varchar(255) YES NULL email of member
phone varchar(30) YES NULL phone of member
phone_perso varchar(30) YES NULL personal phone of member
phone_mobile varchar(30) YES NULL mobil phone of member
naiss date YES NULL date of birth
photo varchar(255) YES NULL url to photo of member
statut smallint NO 0 status of member ( -1 : draft, 0 : terminated, 1 : validated)
public smallint NO 0 flag to set or not public member
datefin datetime YES NULL date end of cotisation
note text YES NULL comentary
tms timestamp NO CURRENT_TIMESTAMP last update date
fk_user_author int(11) YES NULL ID user author (llx_user->rowid)
fk_user_mod int(11) YES NULL ID user made last modification (llx_user->rowid)
fk_user_valid int(11) YES NULL ID user made validation (llx_user->rowid)