Dolibarr ERP CRM Wiki

Changes

Table llx adherent (view source)

Revision as of 10:52, 24 October 2023

978 bytes added ,  1 year ago
m
no edit summary
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==
−
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+
 
−
  |style="background-color: #e9e9ef"| <b>Field</b>
+
Version Dolibarr 15
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
 
−
  |style="background-color: #e9e9ef"| <b>Null</b>
+
 
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
−
  |style="background-color: #e9e9ef"| <b>Default</b>
+
| style="background-color: #e9e9ef" |<b> # </b>
−
  |style="background-color: #e9e9ef"| <b>Extra</b>
+
  | style="background-color: #e9e9ef" |<b>Field</b>
−
  |style="background-color: #e9e9ef"| <b>Description</b>
+
  | style="background-color: #e9e9ef" |<b>Type</b>
−
|-  
+
  | style="background-color: #e9e9ef" |<b>Null</b>
−
| rowid  
+
  | style="background-color: #e9e9ef" |<b>Key</b>
−
| int(11)  
+
  | style="background-color: #e9e9ef" |<b>Default</b>
−
| NO
+
  | style="background-color: #e9e9ef" |<b>Extra</b>
−
| PRI
+
  | style="background-color: #e9e9ef" |<b>Description</b>
−
|  
+
| style="background-color: #e9e9ef" |<b>History</b>
−
| auto_increment  
+
|-
−
| technical index
+
|1
−
{{FieldEntity}}
+
|rowid
−
{{FieldRefExt}}
+
|int(11)
−
|-  
+
|NO
−
| civilite
+
|PRI
−
| varchar(3)
+
|
−
| YES
+
|auto_increment
−
|  
+
|technical index
−
| NULL
+
|
−
|  
+
|-
−
| civility of member
+
|2
−
|-  
+
|ref
−
| nom
+
|varchar(30)
−
| varchar(50)
+
|NO
−
| YES
+
|IDX
−
|  
+
|
−
| NULL
+
|
−
|  
+
|
−
| name of member
+
|
−
|-  
+
|-
−
| prenom
+
|3
−
| varchar(50)
+
|entity
−
| YES
+
|int(11)
−
|  
+
|NO
−
| NULL
+
|
−
|  
+
|1
−
| firstname of member
+
|
−
|-  
+
|See page Field Multi company id. (llx_entity->rowid)
−
| login
+
|
−
| varchar(50)
+
|-
−
| NO
+
|4
−
| UNI
+
|ref_ext
−
|  
+
|varchar(128)
−
|  
+
|YES
−
| login of member
+
|
−
|-  
+
|NULL
−
| password
+
|
−
| varchar(50)
+
|See page Field ref_ext.
−
| YES
+
|
−
|  
+
|-
−
| NULL
+
|5
−
|  
+
|gender
−
| login password of member
+
|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 ([[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
 +
|
 +
|
 +
|
 +
|-
 +
|36
 +
|datec
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|creation time
 +
|
 
|-
 
|-
−
| fk_adherent_type
+
|37
−
| int(11)
+
|tms
−
| NO
+
|timestamp
−
| MUL
+
|YES
−
|
+
|
−
|
+
|CURRENT_TIMESTAMP
−
| ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
+
|
−
|-
+
|ON UPDATE CURRENT_TIMESTAMP
−
| 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
  −
| integer
  −
| YES
  −
|
  −
| NULL
  −
|
  −
| ID of member country ([[Table llx_c_pays|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
+
|38
−
| smallint
+
|fk_user_author
−
| NO
+
|int(11)
−
|  
+
|YES
−
| 0
+
|
−
|  
+
|NULL
−
| flag to set or not public member
+
|
 +
|ID user author ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
| datefin
+
|38
−
| datetime
+
|fk_user_mod
−
| YES
+
|int(11)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| date end of cotisation
+
|
 +
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
| note
+
|40
−
| text
+
|fk_user_valid
−
| YES
+
|int(11)
−
|  
+
|YES
−
| NULL
+
|
−
|  
+
|NULL
−
| comentary
+
|
−
{{FieldTms}}
+
|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)
  −
{{FieldImportKey}}
   
|}&nbsp;
 
|}&nbsp;
    
==Keys==
 
==Keys==
−
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
−
  |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;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/53294...58472"