{"table_name":"bcog_usage_log","full_table_name":"wp_bcog_usage_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bcog_usage_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NULL DEFAULT NULL, customer_id BIGINT UNSIGNED NULL DEFAULT NULL, customer_hash VARCHAR(64) NULL DEFAULT NULL, reward_snapshot LONGTEXT NULL, used_at DATETIME NOT NULL, released_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_usage_unique (promotion_id, order_id), KEY promotion_customer (promotion_id, customer_id), KEY promotion_customer_hash (promotion_id, customer_hash), KEY order_id (order_id) ) ENGINE","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"promotion_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"customer_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"customer_hash","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"reward_snapshot","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"used_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"released_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"byticslab-conditional-offers-for-woocommerce","name":"ByticsLab Conditional Offers for WooCommerce","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/byticslab-conditional-offers-for-woocommerce/"}}