Table llx adherent: Difference between revisions

Jump to navigation Jump to search
m
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)
1,988

edits

Navigation menu