| id |
int(11)
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| ref_ext |
varchar(255)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| datep |
datetime
|
|
|
|
| datep2 |
datetime
|
|
|
|
| fk_action |
int(11)
|
|
|
|
| code |
varchar(50)
|
utf8_unicode_ci
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_mod |
int(11)
|
|
|
|
| fk_project |
int(11)
|
|
|
|
| fk_task |
int(11)
|
|
|
|
| fk_soc |
int(11)
|
|
|
|
| fk_contact |
int(11)
|
|
|
|
| fk_parent |
int(11)
|
|
|
|
| fk_user_action |
int(11)
|
|
|
|
| transparency |
int(11)
|
|
|
|
| priority |
smallint(6)
|
|
|
|
| visibility |
varchar(12)
|
utf8_unicode_ci
|
|
|
| fulldayevent |
smallint(6)
|
|
|
|
| percent |
smallint(6)
|
|
|
|
| location |
varchar(128)
|
utf8_unicode_ci
|
|
|
| durationp |
double
|
|
|
|
| label |
varchar(255)
|
utf8_unicode_ci
|
|
|
| note |
mediumtext
|
utf8_unicode_ci
|
|
|
| calling_duration |
int(11)
|
|
|
|
| email_subject |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_msgid |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_from |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_sender |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_to |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_tocc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| email_tobcc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| errors_to |
varchar(255)
|
utf8_unicode_ci
|
|
|
| reply_to |
varchar(255)
|
utf8_unicode_ci
|
|
|
| recurid |
varchar(128)
|
utf8_unicode_ci
|
|
|
| recurrule |
varchar(128)
|
utf8_unicode_ci
|
|
|
| recurdateend |
datetime
|
|
|
|
| num_vote |
int(11)
|
|
|
|
| event_paid |
smallint(6)
|
|
|
|
| status |
smallint(6)
|
|
|
|
| fk_element |
int(11)
|
|
|
|
| elementtype |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ip |
varchar(250)
|
utf8_unicode_ci
|
|
|
| fk_bookcal_calendar |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
