Table llx adherent: Difference between revisions

Jump to navigation Jump to search
m
→‎Table: add column History
m (→‎Table: #7 nom --> lastname)
m (→‎Table: add column History)
Line 27: 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>
|History
|-
|-
|1
|1
Line 36: Line 37:
|auto_increment
|auto_increment
|technical index
|technical index
|
|-
|-
|2
|2
Line 42: Line 44:
|NO
|NO
|IDX
|IDX
|
|
|
|
|
Line 54: Line 57:
|
|
|See page Field Multi company id. (llx_entity->rowid)
|See page Field Multi company id. (llx_entity->rowid)
|
|-
|-
|4
|4
Line 63: Line 67:
|
|
|See page Field ref_ext.
|See page Field ref_ext.
|
|-
|-
|5
|5
Line 70: Line 75:
|
|
|NULL
|NULL
|
|
|
|
|
Line 81: Line 87:
|
|
|civility of member
|civility of member
|
|-
|-
|7
|7
Line 90: Line 97:
|
|
|name of member
|name of member
|
|-
|-
|
|
Line 99: Line 107:
|
|
|firstname of member
|firstname of member
|
|-
|-
|9
|9
Line 108: Line 117:
|
|
|login of member
|login of member
|
|-
|-
|
|
Line 117: Line 127:
|
|
|login password of member
|login password of member
|
|-
|-
|
|
Line 126: Line 137:
|
|
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
|ID type of member ([[Table llx_adherent_type|llx_adherent_type]]->rowid)
|
|-
|-
|13
|13
Line 135: Line 147:
|
|
|person physical / entity
|person physical / entity
|
|-
|-
|14
|14
Line 144: Line 157:
|
|
|society
|society
|
|-
|-
|
|
Line 153: Line 167:
|
|
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
|ID of society ([[Table llx_societe|llx_societe]]->rowid)
|
|-
|-
|
|
Line 162: Line 177:
|
|
|adress of member
|adress of member
|
|-
|-
|
|
Line 171: Line 187:
|
|
|postal code of member
|postal code of member
|
|-
|-
|
|
Line 180: Line 197:
|
|
|city of member
|city of member
|
|-
|-
|
|
Line 189: Line 207:
|
|
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|ID of member country ([[Table llx_c_pays|llx_c_pays]]->rowid)
|
|-
|-
|
|
Line 198: Line 217:
|
|
|email of member
|email of member
|
|-
|-
|
|
Line 207: Line 227:
|
|
|phone of member
|phone of member
|
|-
|-
|
|
Line 216: Line 237:
|
|
|personal phone of member
|personal phone of member
|
|-
|-
|
|
Line 225: Line 247:
|
|
|mobil phone of member
|mobil phone of member
|
|-
|-
|
|
Line 234: Line 257:
|
|
|date of birth
|date of birth
|
|-
|-
|
|
Line 243: Line 267:
|
|
|url to photo of member
|url to photo of member
|
|-
|-
|
|
Line 252: Line 277:
|
|
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
|status of member ( -1 : draft, 0 : terminated, 1 : validated)
|
|-
|-
|
|
Line 261: Line 287:
|
|
|flag to set or not public member
|flag to set or not public member
|
|-
|-
|
|
Line 270: Line 297:
|
|
|date end of cotisation
|date end of cotisation
|
|-
|-
|
|
Line 280: Line 308:
|comentary
|comentary
{{FieldTms}}
{{FieldTms}}
|
|-
|-
|
|
Line 289: Line 318:
|
|
|ID user author ([[Table llx_user|llx_user]]->rowid)
|ID user author ([[Table llx_user|llx_user]]->rowid)
|
|-
|-
|
|
Line 298: Line 328:
|
|
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
|ID user made last modification ([[Table llx_user|llx_user]]->rowid)
|
|-
|-
|
|
Line 308: Line 339:
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
|ID user made validation ([[Table llx_user|llx_user]]->rowid)
{{FieldImportKey}}
{{FieldImportKey}}
|
|}&nbsp;
|}&nbsp;


1,988

edits

Navigation menu