1,988
edits
Changes
m
→Table
Line 19:
Line 19:
==Table==
==Table==
{| 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>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 26:
Line 27:
| 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)
Line 35:
Line 37:
|technical index
|technical index
|-
|-
+|
|ref
|ref
|varchar(30)
|varchar(30)
Line 43:
Line 46:
|
|
|-
|-
+|
|entity
|entity
|int(11)
|int(11)
Line 51:
Line 55:
|See page Field Multi company id. (llx_entity->rowid)
|See page Field Multi company id. (llx_entity->rowid)
|-
|-
+|
|ref_ext
|ref_ext
|varchar(128)
|varchar(128)
Line 58:
Line 63:
|
|
|See page Field ref_ext.
|See page Field ref_ext.
−|-
+|-
+|
|civilite
|civilite
|varchar(3)
|varchar(3)
Line 66:
Line 72:
|
|
|civility of member
|civility of member
−|-
+|-
+|
|nom
|nom
|varchar(50)
|varchar(50)
Line 74:
Line 81:
|
|
|name of member
|name of member
−|-
+|-
+|
|prenom
|prenom
|varchar(50)
|varchar(50)
Line 82:
Line 90:
|
|
|firstname of member
|firstname of member
−|-
+|-
+|
|login
|login
|varchar(50)
|varchar(50)
Line 90:
Line 99:
|
|
|login of member
|login of member
−|-
+|-
+|
|password
|password
|varchar(50)
|varchar(50)
Line 99:
Line 109:
|login password of member
|login password of member
|-
|-
+|
|fk_adherent_type
|fk_adherent_type
|int(11)
|int(11)
Line 106:
Line 117:
|
|
|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)
Line 114:
Line 126:
|
|
|person physical / entity
|person physical / entity
−|-
+|-
+|
|societe
|societe
|varchar(50)
|varchar(50)
Line 122:
Line 135:
|
|
|society
|society
−|-
+|-
+|
|fk_soc
|fk_soc
|int(11)
|int(11)
Line 130:
Line 144:
|
|
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
−|-
+|-
+|
|adresse
|adresse
|text
|text
Line 138:
Line 153:
|
|
|adress of member
|adress of member
−|-
+|-
+|
|cp
|cp
|varchar(30)
|varchar(30)
Line 146:
Line 162:
|
|
|postal code of member
|postal code of member
−|-
+|-
+|
|ville
|ville
|varchar(50)
|varchar(50)
Line 154:
Line 171:
|
|
|city of member
|city of member
−|-
+|-
+|
|pays
|pays
|integer
|integer
Line 162:
Line 180:
|
|
|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)
Line 170:
Line 189:
|
|
|email of member
|email of member
−|-
+|-
+|
|phone
|phone
|varchar(30)
|varchar(30)
Line 178:
Line 198:
|
|
|phone of member
|phone of member
−|-
+|-
+|
|phone_perso
|phone_perso
|varchar(30)
|varchar(30)
Line 186:
Line 207:
|
|
|personal phone of member
|personal phone of member
−|-
+|-
+|
|phone_mobile
|phone_mobile
|varchar(30)
|varchar(30)
Line 194:
Line 216:
|
|
|mobil phone of member
|mobil phone of member
−|-
+|-
+|
|naiss
|naiss
|date
|date
Line 202:
Line 225:
|
|
|date of birth
|date of birth
−|-
+|-
+|
|photo
|photo
|varchar(255)
|varchar(255)
Line 210:
Line 234:
|
|
|url to photo of member
|url to photo of member
−|-
+|-
+|
|statut
|statut
|smallint
|smallint
Line 219:
Line 244:
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
|-
|-
+|
|public
|public
|smallint
|smallint
Line 227:
Line 253:
|flag to set or not public member
|flag to set or not public member
|-
|-
+|
|datefin
|datefin
|datetime
|datetime
Line 235:
Line 262:
|date end of cotisation
|date end of cotisation
|-
|-
+|
|note
|note
|text
|text
Line 244:
Line 272:
{{FieldTms}}
{{FieldTms}}
|-
|-
+|
|fk_user_author
|fk_user_author
|int(11)
|int(11)
Line 252:
Line 281:
|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)
Line 260:
Line 290:
|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)