amf
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sms_delete_daily_data(IN _day_id integer, IN _tenant_id uuid)
Parameters
Name
Type
Mode
_day_id
integer
IN
_tenant_id
uuid
IN
Definition
DELETE FROM sms_teltonika_scraper_gps_data WHERE tenant_id = _tenant_id; DELETE FROM sms_tgd_computed_info WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_truck_move WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_truck_cycle WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_truck_daily_zone WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_loader_move WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_loader_daily_zone WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_scraper_move WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_scraper_cycle WHERE tenant_id = _tenant_id AND day_id = _day_id; DELETE FROM sms_scraper_daily_zone WHERE tenant_id = _tenant_id AND day_id = _day_id;