28,936
edits
Changes
m
no edit summary
Line 1:
Line 1:
{{FieldTms}}+{{FieldImportKey}}
[[Category:Table SQL]]
[[Category:Table SQL]]
−[[Category:Foundations]]
+[[Category:Module Membership management]]
[[Category:Adhérent]]
[[Category:Adhérent]]
[[Category:Miembros]]
[[Category:Miembros]]
Line 18:
Line 18:
=Structure=
=Structure=
==Table==
==Table==
+
+Version Dolibarr 15
+
+
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
− |#
+ | style="background-color: #e9e9ef" |<b> # </b>
−| 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>
Line 27:
Line 31:
| 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>
−|History
+ | style="background-color: #e9e9ef" |<b>History</b>
|-
|-
|1
|1
Line 99:
Line 103:
|nom
|nom
|-
|-
−|
+|8
−|prenom
+|firstname
|varchar(50)
|varchar(50)
|YES
|YES
Line 119:
Line 123:
|
|
|-
|-
+|10
+|pass
+|varchar(50)
+|YES
|
|
+|NULL
+|
+|login password of member
|password
|password
−|varchar(50)
+|-
+|11
+|pass_crypted
+|varchar(128)
|YES
|YES
|
|
|NULL
|NULL
|
|
−|login password of member
+|
|
|
|-
|-
−|
+|12
|fk_adherent_type
|fk_adherent_type
|int(11)
|int(11)
Line 151:
Line 165:
|14
|14
|societe
|societe
−|varchar(50)
+|varchar(128)
|YES
|YES
|
|
Line 157:
Line 171:
|
|
|society
|society
−|
+|varchar(50)
|-
|-
−|
+|15
|fk_soc
|fk_soc
|int(11)
|int(11)
Line 169:
Line 183:
|
|
|-
|-
−|
+|16
−|adresse
+|adress
|text
|text
|YES
|YES
Line 177:
Line 191:
|
|
|adress of member
|adress of member
−|
+|adresse
|-
|-
−|
+|17
−|cp
+|zip
|varchar(30)
|varchar(30)
|YES
|YES
Line 187:
Line 201:
|
|
|postal code of member
|postal code of member
+|cp
+|-
+|18
+|town
+|varchar(50)
+|YES
|
|
−|-
+|NULL
|
|
+|city of member
|ville
|ville
−|varchar(50)
+|-
+|19
+|state_id
+|int(11)
|YES
|YES
|
|
|NULL
|NULL
|
|
−|city of member
+|
|
|
|-
|-
−|
+|20
−|pays
+|country
−|integer
+|int(11)
|YES
|YES
|
|
Line 207:
Line 231:
|
|
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
−|
+|payes
|-
|-
−|
+|21
|email
|email
|varchar(255)
|varchar(255)
Line 219:
Line 243:
|
|
|-
|-
+|22
+|url
+|varchar(255)
+|YES
|
|
+|NULL
+|
+|website of member
+|
+|-
+|23
+|socialnetworks
+|text
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|24
|phone
|phone
|varchar(30)
|varchar(30)
Line 229:
Line 273:
|
|
|-
|-
−|
+|25
|phone_perso
|phone_perso
|varchar(30)
|varchar(30)
Line 239:
Line 283:
|
|
|-
|-
−|
+|26
|phone_mobile
|phone_mobile
|varchar(30)
|varchar(30)
Line 249:
Line 293:
|
|
|-
|-
−|
+|27
−|naiss
+|birth
|date
|date
|YES
|YES
Line 257:
Line 301:
|
|
|date of birth
|date of birth
−|
+|naiss
|-
|-
−|
+|28
|photo
|photo
|varchar(255)
|varchar(255)
Line 269:
Line 313:
|
|
|-
|-
−|
+|29
|statut
|statut
−|smallint
+|smallint(6)
|NO
|NO
|
|
Line 279:
Line 323:
|
|
|-
|-
−|
+|30
|public
|public
−|smallint
+|smallint(6)
|NO
|NO
|
|
Line 289:
Line 333:
|
|
|-
|-
−|
+|31
|datefin
|datefin
|datetime
|datetime
Line 299:
Line 343:
|
|
|-
|-
+|32
+|note_private
+|text
+|YES
+|
+|NULL
|
|
+|comentary
|note
|note
+|-
+|33
+|note_public
|text
|text
|YES
|YES
Line 306:
Line 360:
|NULL
|NULL
|
|
−|comentary
+|
−|
+|-
+|34
+|model_pdf
+|varchar(255)
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|35
+|datevalid
+|datetime
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|36
+|datec
+|datetime
+|YES
+|
+|NULL
+|
+|creation time
|
|
|-
|-
+|37
+|tms
+|timestamp
+|YES
+|
+|CURRENT_TIMESTAMP
|
|
+|ON UPDATE CURRENT_TIMESTAMP
+|
+|-
+|38
|fk_user_author
|fk_user_author
|int(11)
|int(11)
Line 320:
Line 413:
|
|
|-
|-
−|
+|38
|fk_user_mod
|fk_user_mod
|int(11)
|int(11)
Line 330:
Line 423:
|
|
|-
|-
−|
+|40
|fk_user_valid
|fk_user_valid
|int(11)
|int(11)
Line 338:
Line 431:
|
|
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
−|
|
+|-
+|41
+|canvas
+|varchar(32)
+|YES
+|
+|NULL
+|
+|
+|
+|-
+|42
+|import_key
+|varchar(14)
+|YES
+|
+|NULL
+|
+|Code used to save the import id. See page Field Import key.
+|
+|-
|}
|}