1,988
edits
Changes
m
→Table
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}}
|}
|}
==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
|}
|}