Table llx adherent: Difference between revisions

m
no edit summary
mNo edit summary
Tag: 2017 source edit
 
(43 intermediate revisions by one other user 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==
{| 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;