ecbc42a03f
* fix(connectors): Changed sql from varchar to varchar 8000 * fix(connectors): changed cropping to size 8000 for str in worker task
91 lines
3.1 KiB
SQL
91 lines
3.1 KiB
SQL
CREATE TABLE IF NOT EXISTS connector_events_detailed
|
|
(
|
|
sessionid BIGINT,
|
|
clickevent_hesitationtime BIGINT,
|
|
clickevent_label VARCHAR(8000),
|
|
clickevent_messageid BIGINT,
|
|
clickevent_timestamp BIGINT,
|
|
connectioninformation_downlink BIGINT,
|
|
connectioninformation_type VARCHAR(8000),
|
|
consolelog_level VARCHAR(8000),
|
|
consolelog_value VARCHAR(8000),
|
|
customevent_name VARCHAR(8000),
|
|
customevent_payload VARCHAR(8000),
|
|
fetch_duration BIGINT,
|
|
fetch_method VARCHAR(8000),
|
|
fetch_request VARCHAR(8000),
|
|
fetch_response VARCHAR(8000),
|
|
fetch_status BIGINT,
|
|
fetch_timestamp BIGINT,
|
|
fetch_url VARCHAR(8000),
|
|
graphql_operationkind VARCHAR(8000),
|
|
graphql_operationname VARCHAR(8000),
|
|
graphql_response VARCHAR(8000),
|
|
graphql_variables VARCHAR(8000),
|
|
inputevent_label VARCHAR(8000),
|
|
inputevent_messageid BIGINT,
|
|
inputevent_timestamp BIGINT,
|
|
inputevent_value VARCHAR(8000),
|
|
inputevent_valuemasked BOOLEAN,
|
|
jsexception_message VARCHAR(8000),
|
|
jsexception_name VARCHAR(8000),
|
|
jsexception_payload VARCHAR(8000),
|
|
jsexception_metadata VARCHAR(8000),
|
|
mouseclick_id BIGINT,
|
|
mouseclick_hesitationtime BIGINT,
|
|
mouseclick_label VARCHAR(8000),
|
|
networkrequest_type VARCHAR(8000),
|
|
networkrequest_method VARCHAR(8000),
|
|
networkrequest_url VARCHAR(8000),
|
|
networkrequest_request VARCHAR(8000),
|
|
networkrequest_response VARCHAR(8000),
|
|
networkrequest_status BIGINT,
|
|
networkrequest_timestamp BIGINT,
|
|
networkrequest_duration BIGINT,
|
|
pageevent_domcontentloadedeventend BIGINT,
|
|
pageevent_domcontentloadedeventstart BIGINT,
|
|
pageevent_firstcontentfulpaint BIGINT,
|
|
pageevent_firstpaint BIGINT,
|
|
pageevent_loaded BOOLEAN,
|
|
pageevent_loadeventend BIGINT,
|
|
pageevent_loadeventstart BIGINT,
|
|
pageevent_messageid BIGINT,
|
|
pageevent_referrer VARCHAR(8000),
|
|
pageevent_requeststart BIGINT,
|
|
pageevent_responseend BIGINT,
|
|
pageevent_responsestart BIGINT,
|
|
pageevent_speedindex BIGINT,
|
|
pageevent_timestamp BIGINT,
|
|
pageevent_url VARCHAR(8000),
|
|
sessionend_timestamp BIGINT,
|
|
sessionend_encryption_key VARCHAR(8000),
|
|
sessionstart_projectid BIGINT,
|
|
sessionstart_revid VARCHAR(8000),
|
|
sessionstart_timestamp BIGINT,
|
|
sessionstart_trackerversion VARCHAR(8000),
|
|
sessionstart_useragent VARCHAR(8000),
|
|
sessionstart_userbrowser VARCHAR(8000),
|
|
sessionstart_userbrowserversion VARCHAR(8000),
|
|
sessionstart_usercountry VARCHAR(8000),
|
|
sessionstart_userdevice VARCHAR(8000),
|
|
sessionstart_userdeviceheapsize BIGINT,
|
|
sessionstart_userdevicememorysize BIGINT,
|
|
sessionstart_userdevicetype VARCHAR(8000),
|
|
sessionstart_useros VARCHAR(8000),
|
|
sessionstart_userosversion VARCHAR(8000),
|
|
sessionstart_useruuid VARCHAR(8000),
|
|
setpagelocation_navigationstart BIGINT,
|
|
setpagelocation_referrer VARCHAR(8000),
|
|
setpagelocation_url VARCHAR(8000),
|
|
issueevent_message_id BIGINT,
|
|
issueevent_timestamp BIGINT,
|
|
issueevent_type VARCHAR(8000),
|
|
issueevent_context_string VARCHAR(8000),
|
|
issueevent_context VARCHAR(8000),
|
|
issueevent_payload VARCHAR(8000),
|
|
issueevent_url VARCHAR(8000),
|
|
customissue_name VARCHAR(8000),
|
|
customissue_payload VARCHAR(8000),
|
|
received_at BIGINT,
|
|
batch_order_number BIGINT
|
|
);
|