| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| salutation |
varchar |
255 |
√ |
|
null |
|
|
| first_name |
varchar |
100 |
√ |
|
null |
|
|
| last_name |
varchar |
100 |
√ |
|
null |
|
|
| name |
varchar |
255 |
√ |
|
null |
|
|
| title |
varchar |
255 |
√ |
|
null |
|
|
| facebook |
varchar |
100 |
√ |
|
null |
|
|
| twitter |
varchar |
100 |
√ |
|
null |
|
|
| googleplus |
varchar |
100 |
√ |
|
null |
|
|
| department |
varchar |
255 |
√ |
|
null |
|
|
| do_not_call |
bit |
1 |
√ |
|
0 |
|
|
| phone_home |
varchar |
100 |
√ |
|
null |
|
|
| phone_mobile |
varchar |
100 |
√ |
|
null |
|
|
| phone_work |
varchar |
100 |
√ |
|
null |
|
|
| phone_other |
varchar |
100 |
√ |
|
null |
|
|
| phone_fax |
varchar |
100 |
√ |
|
null |
|
|
| primary_address_street |
varchar |
150 |
√ |
|
null |
|
|
| primary_address_city |
varchar |
100 |
√ |
|
null |
|
|
| primary_address_state |
varchar |
100 |
√ |
|
null |
|
|
| primary_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
| primary_address_country |
varchar |
255 |
√ |
|
null |
|
|
| alt_address_street |
varchar |
150 |
√ |
|
null |
|
|
| alt_address_city |
varchar |
100 |
√ |
|
null |
|
|
| alt_address_state |
varchar |
100 |
√ |
|
null |
|
|
| alt_address_postalcode |
varchar |
20 |
√ |
|
null |
|
|
| alt_address_country |
varchar |
255 |
√ |
|
null |
|
|
| assistant |
varchar |
75 |
√ |
|
null |
|
|
| assistant_phone |
varchar |
100 |
√ |
|
null |
|
|
| picture |
varchar |
255 |
√ |
|
null |
|
|
| id |
char |
36 |
|
|
|
|
|
| date_entered |
datetime |
19 |
√ |
|
null |
|
|
| date_modified |
datetime |
19 |
√ |
|
null |
|
|
| modified_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| created_by |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| description |
text |
65535 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| parent_type |
varchar |
255 |
√ |
|
null |
|
|
| parent_id |
char |
36 |
√ |
|
null |
|
|
| file_mime_type |
varchar |
100 |
√ |
|
null |
|
|
| filename |
varchar |
255 |
√ |
|
null |
|
|
| currency_id |
char |
36 |
√ |
|
-99 |
|
|
| list_price |
decimal |
26,6 |
√ |
|
null |
|
|
| website |
varchar |
255 |
√ |
|
null |
|
|
| birthdate |
date |
10 |
√ |
|
null |
|
|
| secret_password |
varchar |
255 |
√ |
|
null |
|
|
| user_email |
varchar |
100 |
√ |
|
null |
|
|
| date_start |
datetime |
19 |
√ |
|
null |
|
|
| radio_button_group |
varchar |
255 |
√ |
|
null |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
Analyzed at Thu Jul 14 08:24 UTC 2016
|
