4,395
edits
Table llx socpeople: Difference between revisions
Jump to navigation
Jump to search
→Structure
No edit summary |
|||
| Line 37: | Line 37: | ||
| NULL | | NULL | ||
| | | | ||
| date | | creation date | ||
|- | |- | ||
| tms | | tms | ||
| Line 45: | Line 45: | ||
| CURRENT_TIMESTAMP | | CURRENT_TIMESTAMP | ||
| | | | ||
| timestamp (date | | timestamp (date last modified) | ||
|- | |- | ||
| fk_soc | | fk_soc | ||
| Line 53: | Line 53: | ||
| NULL | | NULL | ||
| | | | ||
| | | foreign key to llx_societe | ||
|- | |- | ||
| civilite | | civilite | ||
| Line 61: | Line 61: | ||
| NULL | | NULL | ||
| | | | ||
| | | civility (in text eg Mr, Mrs,...) | ||
|- | |- | ||
| name | | name | ||
| Line 69: | Line 69: | ||
| NULL | | NULL | ||
| | | | ||
| | | last name | ||
|- | |- | ||
| firstname | | firstname | ||
| Line 77: | Line 77: | ||
| NULL | | NULL | ||
| | | | ||
| | | first name | ||
|- | |- | ||
| address | | address | ||
| Line 85: | Line 85: | ||
| NULL | | NULL | ||
| | | | ||
| | | address | ||
|- | |- | ||
| cp | | cp | ||
| Line 93: | Line 93: | ||
| NULL | | NULL | ||
| | | | ||
| | | postcode | ||
|- | |- | ||
| ville | | ville | ||
| Line 101: | Line 101: | ||
| NULL | | NULL | ||
| | | | ||
| | | city | ||
|- | |- | ||
| fk_pays | | fk_pays | ||
| Line 109: | Line 109: | ||
| 0 | | 0 | ||
| | | | ||
| | | foreign key to llx_c_pays | ||
|- | |- | ||
| birthday | | birthday | ||
| Line 117: | Line 117: | ||
| NULL | | NULL | ||
| | | | ||
| | | anniversary/date of birth | ||
|- | |- | ||
| poste | | poste | ||
| Line 125: | Line 125: | ||
| NULL | | NULL | ||
| | | | ||
| | | function within the company | ||
|- | |- | ||
| phone | | phone | ||
| Line 133: | Line 133: | ||
| NULL | | NULL | ||
| | | | ||
| | | telephone | ||
|- | |- | ||
| phone_perso | | phone_perso | ||
| Line 141: | Line 141: | ||
| NULL | | NULL | ||
| | | | ||
| | | personal telephone | ||
|- | |- | ||
| phone_mobile | | phone_mobile | ||
| Line 149: | Line 149: | ||
| NULL | | NULL | ||
| | | | ||
| | | mobile phone (GSM) | ||
|- | |- | ||
| fax | | fax | ||
| Line 173: | Line 173: | ||
| NULL | | NULL | ||
| | | | ||
| | | identifier on the Jabber network (could be another network) | ||
|- | |- | ||
| fk_user_creat | | fk_user_creat | ||
| Line 181: | Line 181: | ||
| 0 | | 0 | ||
| | | | ||
| | | foreign key to llx_user (user who created this contact) | ||
|- | |- | ||
| fk_user_modif | | fk_user_modif | ||
| Line 189: | Line 189: | ||
| NULL | | NULL | ||
| | | | ||
| | | foreign key to llx_user (user who changed this contact) | ||
|- | |- | ||
| note | | note | ||