Table llx adherent: Difference between revisions

no edit summary
No edit summary
Line 7: Line 7:


= Contenu =
= Contenu =
{{flag en}} Contains the list of adhering members of the association module


{{flag fr}} Table contenant les adhérents du module association
{{flag fr}} Contient les adhérents du module association
 
{{flag en}} Contains the list of adhering members of the association module


{{flag sp}} Contiene la lista de miembros del módulo miembros
{{flag sp}} Contiene la lista de miembros del módulo miembros
Line 31: Line 30:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| nom
| varchar(50)
| YES
|
|
|
| name of member
|-
| prenom
| varchar(50)
| YES
|
|
|
| firtname of member
|-
| login
| varchar(50)
|
|
|
|
| login of member
|-
| password
| varchar(50)
| YES
|
|
|
| login password of member
|-
| morphy
| varchar(3)
|
|
|
|
| person physical / entity
|-
| societe
| varchar(50)
| YES
|
|
|
|
|-
| fk_soc
| int(11)
| YES
|
|
|
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| adresse
| text
| YES
|
|
|
| adress of member
|-
| cp
| varchar(30)
| YES
|
|
|
| postal code of member
|-
| ville
| varchar(50)
| YES
|
|
|
| city of member
|-
| pays
| varchar(50)
| YES
|
|
|
| country of member
|-
| email
| varchar(255)
| YES
|
|
|
| email of member
|-
| phone
| varchar(30)
| YES
|
|
|
| phone of member
|-
| phone_perso
| varchar(30)
| YES
|
|
|
| personal phone of member
|-
| phone_mobile
| varchar(30)
| YES
|
|
|
| mobil phone of member
|-
| naiss
| date
| YES
|
|
|
| date of birth
|-
| photo
| varchar(255)
| YES
|
|
|
| url to photo of member
|-
| statut
| smallint
|
|
| 0
|
| status of member
|-
| public
| smallint
|
|
| 0
|
| flag to set or not public member
|-
| datefin
| datetime
| YES
|
|
|
| date end of cotisation
|-
| note
| text
| YES
|
|
|
|
|-
| tms
| timestamp
|
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| fk_user_author 
| int(11)
| YES
|
|
|
| ID user author ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_mod 
| int(11)
| YES
|
|
|
| ID user made last modification ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_valid 
| int(11)
| YES
|
|
|
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
|}
|}