Table llx adherent

From Dolibarr ERP CRM Wiki
Revision as of 06:39, 15 May 2009 by Simnandez (talk | contribs)
Jump to navigation Jump to search


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


Contenu

En verysmall.png Contains the list of adhering members of the association module

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

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

Structure

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