Dolibarr ERP CRM Wiki

Changes

Table llx adherent (view source)

Revision as of 10:52, 24 October 2023

1,173 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>
Line 26: 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 34: 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 52: Line 91:  
|
 
|
 
|civility of member
 
|civility of member
−
|-  
+
|
−
|nom
+
|-
 +
|7
 +
|lastname
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 60: Line 101:  
|
 
|
 
|name of member
 
|name of member
−
|-  
+
|nom
−
|prenom
+
|-
 +
|8
 +
|firstname
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 68: Line 111:  
|
 
|
 
|firstname of member
 
|firstname of member
−
|-  
+
|prenom
 +
|-
 +
|9
 
|login
 
|login
 
|varchar(50)
 
|varchar(50)
Line 76: Line 121:  
|
 
|
 
|login of member
 
|login of member
−
|-  
+
|
−
|password
+
|-
 +
|10
 +
|pass
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 84: 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 100: Line 161:  
|
 
|
 
|person physical / entity
 
|person physical / entity
−
|-  
+
|
 +
|-
 +
|14
 
|societe
 
|societe
−
|varchar(50)
+
|varchar(128)
 
|YES
 
|YES
 
|
 
|
Line 108: Line 171:  
|
 
|
 
|society
 
|society
−
|-  
+
|varchar(50)
 +
|-
 +
|15
 
|fk_soc
 
|fk_soc
 
|int(11)
 
|int(11)
Line 116: Line 181:  
|
 
|
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
 
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
−
|-  
+
|
−
|adresse
+
|-
 +
|16
 +
|adress
 
|text
 
|text
 
|YES
 
|YES
Line 124: Line 191:  
|
 
|
 
|adress of member
 
|adress of member
−
|-  
+
|adresse
−
|cp
+
|-
 +
|17
 +
|zip
 
|varchar(30)
 
|varchar(30)
 
|YES
 
|YES
Line 132: Line 201:  
|
 
|
 
|postal code of member
 
|postal code of member
−
|-  
+
|cp
−
|ville
+
|-
 +
|18
 +
|town
 
|varchar(50)
 
|varchar(50)
 
|YES
 
|YES
Line 140: Line 211:  
|
 
|
 
|city of member
 
|city of member
−
|-  
+
|ville
−
|pays
+
|-
−
|integer
+
|19
 +
|state_id
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|
 +
|-
 +
|20
 +
|country
 +
|int(11)
 
|YES
 
|YES
 
|
 
|
Line 148: 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 156: 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 164: Line 271:  
|
 
|
 
|phone of member
 
|phone of member
−
|-  
+
|
 +
|-
 +
|25
 
|phone_perso
 
|phone_perso
 
|varchar(30)
 
|varchar(30)
Line 172: Line 281:  
|
 
|
 
|personal phone of member
 
|personal phone of member
−
|-  
+
|
 +
|-
 +
|26
 
|phone_mobile
 
|phone_mobile
 
|varchar(30)
 
|varchar(30)
Line 180: Line 291:  
|
 
|
 
|mobil phone of member
 
|mobil phone of member
−
|-  
+
|
−
|naiss
+
|-
 +
|27
 +
|birth
 
|date
 
|date
 
|YES
 
|YES
Line 188: Line 301:  
|
 
|
 
|date of birth
 
|date of birth
−
|-  
+
|naiss
 +
|-
 +
|28
 
|photo
 
|photo
 
|varchar(255)
 
|varchar(255)
Line 196: Line 311:  
|
 
|
 
|url to photo of member
 
|url to photo of member
−
|-  
+
|
 +
|-
 +
|29
 
|statut
 
|statut
−
|smallint
+
|smallint(6)
 
|NO
 
|NO
 
|
 
|
Line 204: 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 212: Line 331:  
|
 
|
 
|flag to set or not public member
 
|flag to set or not public member
 +
|
 
|-
 
|-
 +
|31
 
|datefin
 
|datefin
 
|datetime
 
|datetime
Line 220: 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 227: 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 237: 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 245: 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 253: 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/53295...58472"