Table llx socpeople: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre> | <pre> | ||
+---------------------+--------------+------+-----+-------------------+----------------+ | +---------------------+--------------+------+-----+-------------------+----------------+ | ||
| Line 26: | Line 25: | ||
| fk_user_modif | int(11) | YES | | NULL | | | | fk_user_modif | int(11) | YES | | NULL | | | ||
| note | text | YES | | NULL | | | | note | text | YES | | NULL | | | ||
+---------------------+--------------+------+-----+-------------------+----------------+ | +---------------------+--------------+------+-----+-------------------+----------------+ | ||
</pre> | </pre> | ||
Revision as of 04:51, 22 July 2007
+---------------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+-------------------+----------------+ | rowid | int(11) | NO | PRI | NULL | auto_increment | | datec | datetime | YES | | NULL | | | tms | timestamp | NO | | CURRENT_TIMESTAMP | | | fk_soc | int(11) | YES | MUL | NULL | | | civilite | varchar(6) | YES | | NULL | | | name | varchar(50) | YES | | NULL | | | firstname | varchar(50) | YES | | NULL | | | address | varchar(255) | YES | | NULL | | | cp | varchar(25) | YES | | NULL | | | ville | varchar(255) | YES | | NULL | | | fk_pays | int(11) | YES | | 0 | | | birthday | date | YES | | NULL | | | poste | varchar(80) | YES | | NULL | | | phone | varchar(30) | YES | | NULL | | | phone_perso | varchar(30) | YES | | NULL | | | phone_mobile | varchar(30) | YES | | NULL | | | fax | varchar(30) | YES | | NULL | | | email | varchar(255) | YES | | NULL | | | jabberid | varchar(255) | YES | | NULL | | | fk_user_creat | int(11) | YES | MUL | 0 | | | fk_user_modif | int(11) | YES | | NULL | | | note | text | YES | | NULL | | +---------------------+--------------+------+-----+-------------------+----------------+