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 209:
Line 213:
|ville
|ville
|-
|-
+|19
+|state_id
+|int(11)
+|YES
|
|
−|pays
+|NULL
−|integer
+|
+|
+|
+|-
+|20
+|country
+|int(11)
|YES
|YES
|
|
Line 217:
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 229:
Line 243:
|
|
|-
|-
+|22
+|url
+|varchar(255)
+|YES
+|
+|NULL
+|
+|website of member
+|
+|-
+|23
+|socialnetworks
+|text
+|YES
+|
+|NULL
+|
+|
|
|
+|-
+|24
|phone
|phone
|varchar(30)
|varchar(30)
Line 239:
Line 273:
|
|
|-
|-
−|
+|25
|phone_perso
|phone_perso
|varchar(30)
|varchar(30)
Line 249:
Line 283:
|
|
|-
|-
−|
+|26
|phone_mobile
|phone_mobile
|varchar(30)
|varchar(30)
Line 259:
Line 293:
|
|
|-
|-
−|
+|27
−|naiss
+|birth
|date
|date
|YES
|YES
Line 267:
Line 301:
|
|
|date of birth
|date of birth
−|
+|naiss
|-
|-
−|
+|28
|photo
|photo
|varchar(255)
|varchar(255)
Line 279:
Line 313:
|
|
|-
|-
−|
+|29
|statut
|statut
−|smallint
+|smallint(6)
|NO
|NO
|
|
Line 289:
Line 323:
|
|
|-
|-
−|
+|30
|public
|public
−|smallint
+|smallint(6)
|NO
|NO
|
|
Line 299:
Line 333:
|
|
|-
|-
−|
+|31
|datefin
|datefin
|datetime
|datetime
Line 309:
Line 343:
|
|
|-
|-
+|32
+|note_private
+|text
+|YES
|
|
+|NULL
+|
+|comentary
|note
|note
+|-
+|33
+|note_public
|text
|text
|YES
|YES
Line 316:
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 330:
Line 413:
|
|
|-
|-
−|
+|38
|fk_user_mod
|fk_user_mod
|int(11)
|int(11)
Line 340:
Line 423:
|
|
|-
|-
−|
+|40
|fk_user_valid
|fk_user_valid
|int(11)
|int(11)
Line 348:
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.
+|
+|-
|}
|}