{"table_name":"bcog_promotion_index","full_table_name":"wp_bcog_promotion_index","description":"Stores bcog promotion index data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bcog_promotion_index ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, index_type VARCHAR(20) NOT NULL, object_id BIGINT UNSIGNED NULL DEFAULT NULL, lookup_key VARCHAR(191) NOT NULL, role VARCHAR(20) NOT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_idx_unique (promotion_id, lookup_key, role), KEY index_type_object_role (index_type, object_id, role), KEY lookup_key_role (lookup_key, role), KEY promotion_id (promotion_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":"object_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"lookup_key","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"role","type":"VARCHAR(20)","nullable":false,"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/"}}