Changes

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