Table llx adherent: Difference between revisions

Jump to navigation Jump to search
m
(Undo revision 53293 by Udo.tamm (talk))
Tag: Undo
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"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
  |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  
|rowid
| int(11)  
|int(11)
| NO
|NO
| PRI
|PRI
|  
|
| auto_increment  
|auto_increment
| technical index
|technical index
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|-
|
|
|
|
|
|
|
|-  
|-  
| civilite
|civilite
| varchar(3)
|varchar(3)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| civility of member
|civility of member
|-  
|-  
| nom
|nom
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| name of member
|name of member
|-  
|-  
| prenom
|prenom
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| firstname of member
|firstname of member
|-  
|-  
| login
|login
| varchar(50)
|varchar(50)
| NO
|NO
| UNI
|UNI
|  
|
|  
|
| login of member
|login of member
|-  
|-  
| password
|password
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| login password of member
|login password of member
|-
|-
| fk_adherent_type  
|fk_adherent_type
| int(11)
|int(11)
| NO
|NO
| MUL
|MUL
|  
|
|  
|
| ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
|-  
|-  
| morphy
|morphy
| varchar(3)
|varchar(3)
| NO
|NO
|  
|
|  
|
|  
|
| person physical / entity
|person physical / entity
|-  
|-  
| societe
|societe
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| society
|society
|-  
|-  
| fk_soc
|fk_soc
| int(11)
|int(11)
| YES
|YES
| UNI
|UNI
| NULL
|NULL
|  
|
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-  
|-  
| adresse
|adresse
| text
|text
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| adress of member
|adress of member
|-  
|-  
| cp
|cp
| varchar(30)
|varchar(30)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| postal code of member
|postal code of member
|-  
|-  
| ville
|ville
| varchar(50)
|varchar(50)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| city of member
|city of member
|-  
|-  
| pays
|pays
| integer
|integer
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|-  
|-  
| email
|email
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| email of member
|email of member
|-  
|-  
| phone
|phone
| varchar(30)
|varchar(30)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| phone of member
|phone of member
|-  
|-  
| phone_perso
|phone_perso
| varchar(30)
|varchar(30)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| personal phone of member
|personal phone of member
|-  
|-  
| phone_mobile
|phone_mobile
| varchar(30)
|varchar(30)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| mobil phone of member
|mobil phone of member
|-  
|-  
| naiss
|naiss
| date
|date
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| date of birth
|date of birth
|-  
|-  
| photo
|photo
| varchar(255)
|varchar(255)
| YES
|YES
|  
|
| NULL
|NULL
|  
|
| url to photo of member
|url to photo of member
|-  
|-  
| statut
|statut
| smallint
|smallint
| NO
|NO
|  
|
| 0
|0
|  
|
| status of member ( -1 : draft, 0 : terminated, 1 : validated)
|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==
{| 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;
1,988

edits

Navigation menu