Difference between revisions of "Table llx adherent"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
m
Tag: 2017 source edit
 
(48 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
[[Category:Table SQL]]
 
[[Category:Table SQL]]
−
[[Category:Foundations]]
+
[[Category:Module Membership management]]
 
[[Category:Adhérent]]
 
[[Category:Adhérent]]
 
[[Category:Miembros]]
 
[[Category:Miembros]]
Line 6: Line 6:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Content/Contenu/Contenido =
+
=Content/Contenu/Contenido=
−
{{flag en}} Contains the list of members managed in the foundation module
+
{{flag en}}
 +
Contains the list of members managed in the foundation module
  
−
{{flag fr}} Contient les adhérents du module association
+
{{flag fr}}
 +
Contient les adhérents du module association
  
−
{{flag sp}} Contiene la lista de miembros del módulo miembros
+
{{flag sp}}
 +
Contiene la lista de miembros del módulo miembros
  
−
= Structure =
+
=Structure=
−
== Table ==
+
==Table==
−
'''Version 1.4 2010/03/20'''
+
 
−
{| 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"
+
Version Dolibarr 15
−
  |style="background-color: #e9e9ef"| <b>Field</b>
+
 
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
 
−
  |style="background-color: #e9e9ef"| <b>Null</b>
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
  | style="background-color: #e9e9ef" |<b> # </b>
−
  |style="background-color: #e9e9ef"| <b>Default</b>
+
  | style="background-color: #e9e9ef" |<b>Field</b>
−
  |style="background-color: #e9e9ef"| <b>Extra</b>
+
  | style="background-color: #e9e9ef" |<b>Type</b>
−
  |style="background-color: #e9e9ef"| <b>Description</b>
+
  | style="background-color: #e9e9ef" |<b>Null</b>
−
|-  
+
  | style="background-color: #e9e9ef" |<b>Key</b>
−
| rowid  
+
  | style="background-color: #e9e9ef" |<b>Default</b>
−
| int(11)  
+
  | style="background-color: #e9e9ef" |<b>Extra</b>
−
| NO
+
  | style="background-color: #e9e9ef" |<b>Description</b>
−
| PRI
+
| style="background-color: #e9e9ef" |<b>History</b>
−
|  
+
|-
−
| auto_increment  
+
|1
−
| technical index
+
|rowid
−
|-  
+
|int(11)
−
| entity
+
|NO
−
| int(11)  
+
|PRI
−
| NO
+
|
−
| UNI
+
|auto_increment
−
| 1
+
|technical index
−
|  
+
|
−
| multi company id
+
|-
−
|-  
+
|2
−
| civilite
+
|ref
−
| varchar(3)
+
|varchar(30)
−
| YES
+
|NO
−
|  
+
|IDX
−
| NULL
+
|
−
|  
+
|
−
| civility of member
+
|
−
|-  
+
|
−
| nom
+
|-
−
| varchar(50)
+
|3
−
| YES
+
|entity
−
|  
+
|int(11)
−
| NULL
+
|NO
−
|  
+
|
−
| name of member
+
|1
−
|-  
+
|
−
| prenom
+
|See page Field Multi company id. (llx_entity->rowid)
−
| varchar(50)
+
|
−
| YES
+
|-
−
|  
+
|4
−
| NULL
+
|ref_ext
−
|  
+
|varchar(128)
−
| firstname of member
+
|YES
−
|-  
+
|
−
| login
+
|NULL
−
| varchar(50)
+
|
−
| NO
+
|See page Field ref_ext.
−
| UNI
+
|
−
|  
+
|-
−
|  
+
|5
−
| login of member
+
|gender
−
|-  
+
|varchar(10)
−
| password
+
|YES
−
| varchar(50)
+
|
−
| YES
+
|NULL
−
|  
+
|
−
| NULL
+
|
−
|  
+
|
−
| login password of member
+
|-
 +
|6
 +
|civilite
 +
|varchar(3)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|civility of member
 +
|
 +
|-
 +
|7
 +
|lastname
 +
|varchar(50)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|name of member
 +
|nom
 +
|-
 +
|8
 +
|firstname
 +
|varchar(50)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|firstname of member
 +
|prenom
 +
|-
 +
|9
 +
|login
 +
|varchar(50)
 +
|NO
 +
|UNI
 +
|
 +
|
 +
|login of member
 +
|
 +
|-
 +
|10
 +
|pass
 +
|varchar(50)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|login password of member
 +
|password
 +
|-
 +
|11
 +
|pass_crypted
 +
|varchar(128)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|12
 +
|fk_adherent_type
 +
|int(11)
 +
|NO
 +
|MUL
 +
|
 +
|
 +
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
 +
|
 +
|-
 +
|13
 +
|morphy
 +
|varchar(3)
 +
|NO
 +
|
 +
|
 +
|
 +
|person physical / entity
 +
|
 +
|-
 +
|14
 +
|societe
 +
|varchar(128)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|society
 +
|varchar(50)
 +
|-
 +
|15
 +
|fk_soc
 +
|int(11)
 +
|YES
 +
|UNI
 +
|NULL
 +
|
 +
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
 +
|
 +
|-
 +
|16
 +
|adress
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|adress of member
 +
|adresse
 +
|-
 +
|17
 +
|zip
 +
|varchar(30)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|postal code of member
 +
|cp
 +
|-
 +
|18
 +
|town
 +
|varchar(50)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|city of member
 +
|ville
 +
|-
 +
|19
 +
|state_id
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|20
 +
|country
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
 +
|payes
 +
|-
 +
|21
 +
|email
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|email of member
 +
|
 +
|-
 +
|22
 +
|url
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|website of member
 +
|
 +
|-
 +
|23
 +
|socialnetworks
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|24
 +
|phone
 +
|varchar(30)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|phone of member
 +
|
 +
|-
 +
|25
 +
|phone_perso
 +
|varchar(30)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|personal phone of member
 +
|
 +
|-
 +
|26
 +
|phone_mobile
 +
|varchar(30)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|mobil phone of member
 +
|
 +
|-
 +
|27
 +
|birth
 +
|date
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|date of birth
 +
|naiss
 +
|-
 +
|28
 +
|photo
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|url to photo of member
 +
|
 +
|-
 +
|29
 +
|statut
 +
|smallint(6)
 +
|NO
 +
|
 +
|0
 +
|
 +
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
 +
|
 +
|-
 +
|30
 +
|public
 +
|smallint(6)
 +
|NO
 +
|
 +
|0
 +
|
 +
|flag to set or not public member
 +
|
 +
|-
 +
|31
 +
|datefin
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|date end of cotisation
 +
|
 +
|-
 +
|32
 +
|note_private
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|comentary
 +
|note
 +
|-
 +
|33
 +
|note_public
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|34
 +
|model_pdf
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|35
 +
|datevalid
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 
|-
 
|-
−
| fk_adherent_type
+
|36
−
| int(11)
+
|datec
−
| NO
+
|datetime
−
| MUL
+
|YES
−
|
+
|
−
|
+
|NULL
−
| ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
+
|
−
|-
+
|creation time
−
| morphy
+
|
−
| varchar(3)
 
−
| NO
 
−
|
 
−
|
 
−
|
 
−
| person physical / entity
 
−
|-
 
−
| societe
 
−
| varchar(50)
 
−
| YES
 
−
|
 
−
| NULL
 
−
|
 
−
| society
 
−
|-
 
−
| fk_soc
 
−
| int(11)
 
−
| YES
 
−
| UNI
 
−
| NULL
 
−
|
 
−
| ID of society ([[Table llx_societe|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
+
|37
−
| smallint
+
|tms
−
| NO
+
|timestamp
−
|  
+
|YES
−
| 0
+
|
−
|  
+
|CURRENT_TIMESTAMP
−
| flag to set or not public member
+
|
 +
|ON UPDATE CURRENT_TIMESTAMP
 +
|
 
|-
 
|-
−
| datefin
+
|38
−
| datetime
+
|fk_user_author
−
| YES
+
|int(11)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| date end of cotisation
+
|
 +
|ID user author ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
| note
+
|38
−
| text
+
|fk_user_mod
−
| YES
+
|int(11)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| comentary
+
|
 +
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
| tms
+
|40
−
| timestamp
+
|fk_user_valid
−
| NO
+
|int(11)
−
|  
+
|YES
−
| CURRENT_TIMESTAMP
+
|
−
|  
+
|NULL
−
| last update date
+
|
 +
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
| fk_user_author 
+
|41
−
| int(11)
+
|canvas
−
| YES
+
|varchar(32)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| ID user author ([[Table llx_user|llx_user]]->rowid)
+
|
 +
|
 +
|
 
|-
 
|-
−
| fk_user_mod 
+
|42
−
| int(11)
+
|import_key
−
| YES
+
|varchar(14)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| ID user made last modification ([[Table llx_user|llx_user]]->rowid)
+
|
 +
|Code used to save the import id. See page Field Import key.
 +
|
 
|-
 
|-
−
| fk_user_valid 
 
−
| int(11)
 
−
| YES
 
−
|
 
−
| NULL
 
−
|
 
−
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
 
 
|}&nbsp;
 
|}&nbsp;
  
 
==Keys==
 
==Keys==
−
'''Version 1.3 2009/11/07'''
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
−
{| 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>Key</b>
+
  | style="background-color: #e9e9ef" |<b>Type</b>
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
  | style="background-color: #e9e9ef" |<b>Fields</b>
−
  |style="background-color: #e9e9ef"| <b>Fields</b>
 
 
|-  
 
|-  
−
| PRIMARY
+
|PRIMARY
−
| PRIMARY  
+
|PRIMARY
−
| rowid
+
|rowid
 
|-  
 
|-  
−
| uk_adherent_login  
+
|uk_adherent_login
−
| UNIQUE
+
|UNIQUE
−
| login,entity
+
|login,entity
 
|-  
 
|-  
−
| uk_adherent_fk_soc  
+
|uk_adherent_fk_soc
−
| UNIQUE
+
|UNIQUE
−
| fk_soc
+
|fk_soc
 
|-  
 
|-  
−
| idx_adherent_fk_adherent_type  
+
|idx_adherent_fk_adherent_type
−
| MULTIPLE
+
|MULTIPLE
−
| fk_adherent_type
+
|fk_adherent_type
 
|}&nbsp;
 
|}&nbsp;

Latest revision as of 10:52, 24 October 2023


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

Version Dolibarr 15


# Field Type Null Key Default Extra Description History
1 rowid int(11) NO PRI auto_increment technical index
2 ref varchar(30) NO IDX
3 entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
4 ref_ext varchar(128) YES NULL See page Field ref_ext.
5 gender varchar(10) YES NULL
6 civilite varchar(3) YES NULL civility of member
7 lastname varchar(50) YES NULL name of member nom
8 firstname varchar(50) YES NULL firstname of member prenom
9 login varchar(50) NO UNI login of member
10 pass varchar(50) YES NULL login password of member password
11 pass_crypted varchar(128) YES NULL
12 fk_adherent_type int(11) NO MUL ID type of member (llx_adherent_type->rowid)
13 morphy varchar(3) NO person physical / entity
14 societe varchar(128) YES NULL society varchar(50)
15 fk_soc int(11) YES UNI NULL ID of society (llx_societe->rowid)
16 adress text YES NULL adress of member adresse
17 zip varchar(30) YES NULL postal code of member cp
18 town varchar(50) YES NULL city of member ville
19 state_id int(11) YES NULL
20 country int(11) YES NULL ID of member country (llx_c_pays->rowid) payes
21 email varchar(255) YES NULL email of member
22 url varchar(255) YES NULL website of member
23 socialnetworks text YES NULL
24 phone varchar(30) YES NULL phone of member
25 phone_perso varchar(30) YES NULL personal phone of member
26 phone_mobile varchar(30) YES NULL mobil phone of member
27 birth date YES NULL date of birth naiss
28 photo varchar(255) YES NULL url to photo of member
29 statut smallint(6) NO 0 status of member ( -1 : draft, 0 : terminated, 1 : validated)
30 public smallint(6) NO 0 flag to set or not public member
31 datefin datetime YES NULL date end of cotisation
32 note_private text YES NULL comentary note
33 note_public text YES NULL
34 model_pdf varchar(255) YES NULL
35 datevalid datetime YES NULL
36 datec datetime YES NULL creation time
37 tms timestamp YES CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
38 fk_user_author int(11) YES NULL ID user author (llx_user->rowid)
38 fk_user_mod int(11) YES NULL ID user made last modification (llx_user->rowid)
40 fk_user_valid int(11) YES NULL ID user made validation (llx_user->rowid)
41 canvas varchar(32) YES NULL
42 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=58472"