Table llx adherent: Difference between revisions

Jump to navigation Jump to search
Undo revision 53293 by Udo.tamm (talk)
(Undo revision 53293 by Udo.tamm (talk))
Tag: Undo
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


=Content/Contenu/Contenido=
= Content/Contenu/Contenido =
{{flag en}}
{{flag en}} Contains the list of members managed in the foundation module
Contains the list of members managed in the foundation module


{{flag fr}}
{{flag fr}} Contient les adhérents du module association
Contient les adhérents du module association


{{flag sp}}
{{flag sp}} Contiene la lista de miembros del módulo miembros
Contiene la lista de miembros del módulo miembros


=Structure=
= Structure =
==Table==
== Table ==
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  |
  |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>
  |style="background-color: #e9e9ef"| <b>Key</b>
  | style="background-color: #e9e9ef" |<b>Key</b>
  |style="background-color: #e9e9ef"| <b>Default</b>
  | style="background-color: #e9e9ef" |<b>Default</b>
  |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>
|-  
|-
| rowid  
|
| int(11)  
|rowid
| NO
|int(11)
| PRI
|NO
|  
|PRI
| auto_increment  
|
| technical index
|auto_increment
|technical index
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|-
| civilite
| varchar(3)
| YES
|
| NULL
|
| civility of member
|-
| nom
| varchar(50)
| YES
|
| NULL
|
| name of member
|-
| prenom
| varchar(50)
| YES
|
| NULL
|
| firstname of member
|-
| login
| varchar(50)
| NO
| UNI
|
|
| login of member
|-
| password
| varchar(50)
| YES
|
| NULL
|
| login password of member
|-
|-
|
| fk_adherent_type  
|civilite
| int(11)
|varchar(3)
| NO
|YES
| MUL
|
|  
|NULL
|  
|
| ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
|civility of member
|-  
|-
| morphy
|
| varchar(3)
|nom
| NO
|varchar(50)
|  
|YES
|  
|
|  
|NULL
| person physical / entity
|
|-  
|name of member
| societe
|-
| varchar(50)
|
| YES
|prenom
|  
|varchar(50)
| NULL
|YES
|  
|
| society
|NULL
|-  
|
| fk_soc
|firstname of member
| int(11)
|-
| YES
|
| UNI
|login
| NULL
|varchar(50)
|  
|NO
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|UNI
|-  
|
| adresse
|
| text
|login of member
| YES
|-
|  
|
| NULL
|password
|  
|varchar(50)
| adress of member
|YES
|-  
|
| cp
|NULL
| varchar(30)
|
| YES
|login password of member
|  
|-
| NULL
|
|  
|fk_adherent_type
| postal code of member
|int(11)
|-  
|NO
| ville
|MUL
| varchar(50)
|
| YES
|
|  
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
| NULL
|-
|  
|
| city of member
|morphy
|-  
|varchar(3)
| pays
|NO
| integer
|
| YES
|
|  
|
| NULL
|person physical / entity
|  
|-
| ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|
|-  
|societe
| email
|varchar(50)
| varchar(255)
|YES
| YES
|
|  
|NULL
| NULL
|
|  
|society
| email of member
|-
|-  
|
| phone
|fk_soc
| varchar(30)
|int(11)
| YES
|YES
|  
|UNI
| NULL
|NULL
|  
|
| phone of member
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-  
|-
| phone_perso
|
| varchar(30)
|adresse
| YES
|text
|  
|YES
| NULL
|
|  
|NULL
| personal phone of member
|
|-  
|adress of member
| phone_mobile
|-
| varchar(30)
|
| YES
|cp
|  
|varchar(30)
| NULL
|YES
|  
|
| mobil phone of member
|NULL
|-  
|
| naiss
|postal code of member
| date
|-
| YES
|
|  
|ville
| NULL
|varchar(50)
|  
|YES
| date of birth
|
|-  
|NULL
| photo
|
| varchar(255)
|city of member
| YES
|-
|  
|
| NULL
|pays
|  
|integer
| url to photo of member
|YES
|-  
|
| statut
|NULL
| smallint
|
| NO
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|  
|-
| 0
|
|  
|email
| status of member ( -1 : draft, 0 : terminated, 1 : validated)
|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
|public
| smallint
|smallint
| NO
|NO
|  
|
| 0
|0
|  
|
| flag to set or not public member
|flag to set or not public member
|-
|-
|
| datefin
|datefin
| datetime
|datetime
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| date end of cotisation
|date end of cotisation
|-
|-
|
| note
|note
| text
|text
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| comentary
|comentary
{{FieldTms}}
{{FieldTms}}
|-
|-
|
| fk_user_author  
|fk_user_author
| int(11)
|int(11)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID user author ([[Table llx_user|llx_user]]->rowid)
|ID user author ([[Table llx_user|llx_user]]->rowid)
|-
|-
|
| fk_user_mod  
|fk_user_mod
| int(11)
|int(11)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID user made last modification ([[Table llx_user|llx_user]]->rowid)
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
|-
|-
|
| fk_user_valid
|fk_user_valid
| int(11)
|int(11)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID user made validation ([[Table llx_user|llx_user]]->rowid)
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
{{FieldImportKey}}
{{FieldImportKey}}
|}&nbsp;
|}&nbsp;


==Keys==
==Keys==
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  | 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;
1,988

edits

Navigation menu