Difference between revisions of "Table llx adherent"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 19: Line 19:
 
==Table==
 
==Table==
 
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
 
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
−
  | style="background-color: #e9e9ef" |<b>Field</b>
+
  |#
 +
| style="background-color: #e9e9ef" |<b>Field</b>
 
  | style="background-color: #e9e9ef" |<b>Type</b>
 
  | style="background-color: #e9e9ef" |<b>Type</b>
 
  | style="background-color: #e9e9ef" |<b>Null</b>
 
  | style="background-color: #e9e9ef" |<b>Null</b>
Line 26: Line 27:
 
  | style="background-color: #e9e9ef" |<b>Extra</b>
 
  | style="background-color: #e9e9ef" |<b>Extra</b>
 
  | style="background-color: #e9e9ef" |<b>Description</b>
 
  | style="background-color: #e9e9ef" |<b>Description</b>
−
|-  
+
|-
 +
|
 
|rowid
 
|rowid
 
|int(11)
 
|int(11)
Line 35: Line 37:
 
|technical index
 
|technical index
 
|-
 
|-
 +
|
 
|ref
 
|ref
 
|varchar(30)
 
|varchar(30)
Line 43: Line 46:
 
|
 
|
 
|-
 
|-
 +
|
 
|entity
 
|entity
 
|int(11)
 
|int(11)
Line 51: Line 55:
 
|See page Field Multi company id. (llx_entity->rowid)
 
|See page Field Multi company id. (llx_entity->rowid)
 
|-
 
|-
 +
|
 
|ref_ext
 
|ref_ext
 
|varchar(128)
 
|varchar(128)
Line 58: Line 63:
 
|
 
|
 
|See page Field ref_ext.
 
|See page Field ref_ext.
−
|-  
+
|-
 +
|
 
|civilite
 
|civilite
 
|varchar(3)
 
|varchar(3)
Line 66: Line 72:
 
|
 
|
 
|civility of member
 
|civility of member
−
|-  
+
|-
 +
|
 
|nom
 
|nom
 
|varchar(50)
 
|varchar(50)
Line 74: Line 81:
 
|
 
|
 
|name of member
 
|name of member
−
|-  
+
|-
 +
|
 
|prenom
 
|prenom
 
|varchar(50)
 
|varchar(50)
Line 82: Line 90:
 
|
 
|
 
|firstname of member
 
|firstname of member
−
|-  
+
|-
 +
|
 
|login
 
|login
 
|varchar(50)
 
|varchar(50)
Line 90: Line 99:
 
|
 
|
 
|login of member
 
|login of member
−
|-  
+
|-
 +
|
 
|password
 
|password
 
|varchar(50)
 
|varchar(50)
Line 99: Line 109:
 
|login password of member
 
|login password of member
 
|-
 
|-
 +
|
 
|fk_adherent_type
 
|fk_adherent_type
 
|int(11)
 
|int(11)
Line 106: Line 117:
 
|
 
|
 
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
 
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
−
|-  
+
|-
 +
|
 
|morphy
 
|morphy
 
|varchar(3)
 
|varchar(3)
Line 114: Line 126:
 
|
 
|
 
|person physical / entity
 
|person physical / entity
−
|-  
+
|-
 +
|
 
|societe
 
|societe
 
|varchar(50)
 
|varchar(50)
Line 122: Line 135:
 
|
 
|
 
|society
 
|society
−
|-  
+
|-
 +
|
 
|fk_soc
 
|fk_soc
 
|int(11)
 
|int(11)
Line 130: Line 144:
 
|
 
|
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
−
|-  
+
|-
 +
|
 
|adresse
 
|adresse
 
|text
 
|text
Line 138: Line 153:
 
|
 
|
 
|adress of member
 
|adress of member
−
|-  
+
|-
 +
|
 
|cp
 
|cp
 
|varchar(30)
 
|varchar(30)
Line 146: Line 162:
 
|
 
|
 
|postal code of member
 
|postal code of member
−
|-  
+
|-
 +
|
 
|ville
 
|ville
 
|varchar(50)
 
|varchar(50)
Line 154: Line 171:
 
|
 
|
 
|city of member
 
|city of member
−
|-  
+
|-
 +
|
 
|pays
 
|pays
 
|integer
 
|integer
Line 162: Line 180:
 
|
 
|
 
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
 
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
−
|-  
+
|-
 +
|
 
|email
 
|email
 
|varchar(255)
 
|varchar(255)
Line 170: Line 189:
 
|
 
|
 
|email of member
 
|email of member
−
|-  
+
|-
 +
|
 
|phone
 
|phone
 
|varchar(30)
 
|varchar(30)
Line 178: Line 198:
 
|
 
|
 
|phone of member
 
|phone of member
−
|-  
+
|-
 +
|
 
|phone_perso
 
|phone_perso
 
|varchar(30)
 
|varchar(30)
Line 186: Line 207:
 
|
 
|
 
|personal phone of member
 
|personal phone of member
−
|-  
+
|-
 +
|
 
|phone_mobile
 
|phone_mobile
 
|varchar(30)
 
|varchar(30)
Line 194: Line 216:
 
|
 
|
 
|mobil phone of member
 
|mobil phone of member
−
|-  
+
|-
 +
|
 
|naiss
 
|naiss
 
|date
 
|date
Line 202: Line 225:
 
|
 
|
 
|date of birth
 
|date of birth
−
|-  
+
|-
 +
|
 
|photo
 
|photo
 
|varchar(255)
 
|varchar(255)
Line 210: Line 234:
 
|
 
|
 
|url to photo of member
 
|url to photo of member
−
|-  
+
|-
 +
|
 
|statut
 
|statut
 
|smallint
 
|smallint
Line 219: Line 244:
 
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
 
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
 
|-
 
|-
 +
|
 
|public
 
|public
 
|smallint
 
|smallint
Line 227: Line 253:
 
|flag to set or not public member
 
|flag to set or not public member
 
|-
 
|-
 +
|
 
|datefin
 
|datefin
 
|datetime
 
|datetime
Line 235: Line 262:
 
|date end of cotisation
 
|date end of cotisation
 
|-
 
|-
 +
|
 
|note
 
|note
 
|text
 
|text
Line 244: Line 272:
 
{{FieldTms}}
 
{{FieldTms}}
 
|-
 
|-
 +
|
 
|fk_user_author
 
|fk_user_author
 
|int(11)
 
|int(11)
Line 252: Line 281:
 
|ID user author ([[Table llx_user|llx_user]]->rowid)
 
|ID user author ([[Table llx_user|llx_user]]->rowid)
 
|-
 
|-
 +
|
 
|fk_user_mod
 
|fk_user_mod
 
|int(11)
 
|int(11)
Line 260: Line 290:
 
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 
|-
 
|-
 +
|
 
|fk_user_valid
 
|fk_user_valid
 
|int(11)
 
|int(11)

Revision as of 21:46, 31 March 2022


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


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

Table

# Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
ref varchar(30) NO IDX
entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
ref_ext varchar(128) YES NULL See page Field ref_ext.
civilite varchar(3) YES NULL civility of member
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 integer YES NULL ID of member country (llx_c_pays->rowid)
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 date Date of last modification. See page Field Tms.
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)
import_key varchar(14) YES NULL Code used to save the import id. See page Field Import key.

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_adherent_login UNIQUE login,entity
uk_adherent_fk_soc UNIQUE fk_soc
idx_adherent_fk_adherent_type MULTIPLE fk_adherent_type

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_adherent&oldid=53302"