|
id
|
int
|
|
|
|
|
ref_ext
|
varchar(255)
|
|
|
|
|
entity
|
int
|
|
|
1
|
|
datep
|
datetime
|
|
|
|
|
datep2
|
datetime
|
|
|
|
|
fk_action
|
int
|
|
|
|
|
code
|
varchar(50)
|
|
|
|
|
datec
|
datetime
|
|
|
|
|
tms
|
timestamp
|
|
|
CURRENT_TIMESTAMP
|
|
fk_user_author
|
int
|
|
|
|
|
fk_user_mod
|
int
|
|
|
|
|
fk_project
|
int
|
|
|
|
|
fk_soc
|
int
|
|
|
|
|
fk_contact
|
int
|
|
|
|
|
fk_parent
|
int
|
|
|
0
|
|
fk_user_action
|
int
|
|
|
|
|
fk_user_done
|
int
|
|
|
|
|
transparency
|
int
|
|
|
|
|
priority
|
smallint
|
|
|
|
|
visibility
|
varchar(12)
|
|
|
default
|
|
fulldayevent
|
smallint
|
|
|
0
|
|
percent
|
smallint
|
|
|
0
|
|
location
|
varchar(128)
|
|
|
|
|
durationp
|
double
|
|
|
|
|
label
|
varchar(255)
|
|
|
|
|
note
|
text
|
|
|
|
|
calling_duration
|
int
|
|
|
|
|
email_subject
|
varchar(255)
|
|
|
|
|
email_msgid
|
varchar(255)
|
|
|
|
|
email_from
|
varchar(255)
|
|
|
|
|
email_sender
|
varchar(255)
|
|
|
|
|
email_to
|
varchar(255)
|
|
|
|
|
email_tocc
|
varchar(255)
|
|
|
|
|
email_tobcc
|
varchar(255)
|
|
|
|
|
errors_to
|
varchar(255)
|
|
|
|
|
recurid
|
varchar(128)
|
|
|
|
|
recurrule
|
varchar(128)
|
|
|
|
|
recurdateend
|
datetime
|
|
|
|
|
fk_element
|
int
|
|
|
|
|
elementtype
|
varchar(255)
|
|
|
|
|
import_key
|
varchar(14)
|
|
|
|
|
extraparams
|
varchar(255)
|
|
|
|