Dolibarr ERP CRM Wiki

Changes

Table llx adherent (view source)

Revision as of 10:52, 24 October 2023

1,154 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 18: Line 18:  
=Structure=
 
=Structure=
 
==Table==
 
==Table==
 +
 +
Version Dolibarr 15
 +
 +
 
{| 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> # </b>
−
| 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 27: Line 31:  
  | 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>
 +
| style="background-color: #e9e9ef" |<b>History</b>
 
|-
 
|-
−
|
+
|1
 
|rowid
 
|rowid
 
|int(11)
 
|int(11)
Line 36: Line 41:  
|auto_increment
 
|auto_increment
 
|technical index
 
|technical index
−
{{FieldEntity}}
+
|
−
{{FieldRefExt}}
+
|-
 +
|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
 
|civilite
 
|varchar(3)
 
|varchar(3)
Line 47: Line 91:  
|
 
|
 
|civility of member
 
|civility of member
 +
|
 
|-
 
|-
−
|
+
|7
−
|nom
+
|lastname
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 56: Line 101:  
|
 
|
 
|name of member
 
|name of member
 +
|nom
 
|-
 
|-
−
|
+
|8
−
|prenom
+
|firstname
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 65: Line 111:  
|
 
|
 
|firstname of member
 
|firstname of member
 +
|prenom
 
|-
 
|-
−
|
+
|9
 
|login
 
|login
 
|varchar(50)
 
|varchar(50)
Line 74: Line 121:  
|
 
|
 
|login of member
 
|login of member
 +
|
 
|-
 
|-
−
|
+
|10
−
|password
+
|pass
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 83: Line 131:  
|
 
|
 
|login password of member
 
|login password of member
 +
|password
 
|-
 
|-
 +
|11
 +
|pass_crypted
 +
|varchar(128)
 +
|YES
 +
|
 +
|NULL
 +
|
 
|
 
|
 +
|
 +
|-
 +
|12
 
|fk_adherent_type
 
|fk_adherent_type
 
|int(11)
 
|int(11)
Line 92: Line 151:  
|
 
|
 
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
 
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
 +
|
 
|-
 
|-
−
|
+
|13
 
|morphy
 
|morphy
 
|varchar(3)
 
|varchar(3)
Line 101: Line 161:  
|
 
|
 
|person physical / entity
 
|person physical / entity
 +
|
 
|-
 
|-
−
|
+
|14
 
|societe
 
|societe
−
|varchar(50)
+
|varchar(128)
 
|YES
 
|YES
 
|
 
|
Line 110: Line 171:  
|
 
|
 
|society
 
|society
 +
|varchar(50)
 
|-
 
|-
−
|
+
|15
 
|fk_soc
 
|fk_soc
 
|int(11)
 
|int(11)
Line 119: Line 181:  
|
 
|
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
 +
|
 
|-
 
|-
−
|
+
|16
−
|adresse
+
|adress
 
|text
 
|text
 
|YES
 
|YES
Line 128: Line 191:  
|
 
|
 
|adress of member
 
|adress of member
 +
|adresse
 
|-
 
|-
−
|
+
|17
−
|cp
+
|zip
 
|varchar(30)
 
|varchar(30)
 
|YES
 
|YES
Line 137: Line 201:  
|
 
|
 
|postal code of member
 
|postal code of member
 +
|cp
 
|-
 
|-
−
|
+
|18
−
|ville
+
|town
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 146: Line 211:  
|
 
|
 
|city of member
 
|city of member
 +
|ville
 
|-
 
|-
 +
|19
 +
|state_id
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 
|
 
|
−
|pays
+
|-
−
|integer
+
|20
 +
|country
 +
|int(11)
 
|YES
 
|YES
 
|
 
|
Line 155: Line 231:  
|
 
|
 
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
 
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
 +
|payes
 
|-
 
|-
−
|
+
|21
 
|email
 
|email
 
|varchar(255)
 
|varchar(255)
Line 164: Line 241:  
|
 
|
 
|email of member
 
|email of member
 +
|
 +
|-
 +
|22
 +
|url
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|website of member
 +
|
 
|-
 
|-
 +
|23
 +
|socialnetworks
 +
|text
 +
|YES
 +
|
 +
|NULL
 
|
 
|
 +
|
 +
|
 +
|-
 +
|24
 
|phone
 
|phone
 
|varchar(30)
 
|varchar(30)
Line 173: Line 271:  
|
 
|
 
|phone of member
 
|phone of member
 +
|
 
|-
 
|-
−
|
+
|25
 
|phone_perso
 
|phone_perso
 
|varchar(30)
 
|varchar(30)
Line 182: Line 281:  
|
 
|
 
|personal phone of member
 
|personal phone of member
 +
|
 
|-
 
|-
−
|
+
|26
 
|phone_mobile
 
|phone_mobile
 
|varchar(30)
 
|varchar(30)
Line 191: Line 291:  
|
 
|
 
|mobil phone of member
 
|mobil phone of member
 +
|
 
|-
 
|-
−
|
+
|27
−
|naiss
+
|birth
 
|date
 
|date
 
|YES
 
|YES
Line 200: Line 301:  
|
 
|
 
|date of birth
 
|date of birth
 +
|naiss
 
|-
 
|-
−
|
+
|28
 
|photo
 
|photo
 
|varchar(255)
 
|varchar(255)
Line 209: Line 311:  
|
 
|
 
|url to photo of member
 
|url to photo of member
 +
|
 
|-
 
|-
−
|
+
|29
 
|statut
 
|statut
−
|smallint
+
|smallint(6)
 
|NO
 
|NO
 
|
 
|
Line 218: Line 321:  
|
 
|
 
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
 
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
 +
|
 
|-
 
|-
−
|
+
|30
 
|public
 
|public
−
|smallint
+
|smallint(6)
 
|NO
 
|NO
 
|
 
|
Line 227: Line 331:  
|
 
|
 
|flag to set or not public member
 
|flag to set or not public member
 +
|
 
|-
 
|-
−
|
+
|31
 
|datefin
 
|datefin
 
|datetime
 
|datetime
Line 236: Line 341:  
|
 
|
 
|date end of cotisation
 
|date end of cotisation
 +
|
 
|-
 
|-
 +
|32
 +
|note_private
 +
|text
 +
|YES
 
|
 
|
 +
|NULL
 +
|
 +
|comentary
 
|note
 
|note
 +
|-
 +
|33
 +
|note_public
 
|text
 
|text
 
|YES
 
|YES
Line 244: Line 360:  
|NULL
 
|NULL
 
|
 
|
−
|comentary
+
|
−
{{FieldTms}}
+
|
 +
|-
 +
|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
 
|fk_user_author
 
|int(11)
 
|int(11)
Line 255: Line 411:  
|
 
|
 
|ID user author ([[Table llx_user|llx_user]]->rowid)
 
|ID user author ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
|
+
|38
 
|fk_user_mod
 
|fk_user_mod
 
|int(11)
 
|int(11)
Line 264: Line 421:  
|
 
|
 
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
 +
|
 
|-
 
|-
−
|
+
|40
 
|fk_user_valid
 
|fk_user_valid
 
|int(11)
 
|int(11)
Line 273: Line 431:  
|
 
|
 
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
 
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
−
{{FieldImportKey}}
+
|
 +
|-
 +
|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.
 +
|
 +
|-
 
|}&nbsp;
 
|}&nbsp;
  
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/53293...58472"