{"table_name":"bcog_gift_selections","full_table_name":"wp_bcog_gift_selections","description":"Stores bcog gift selections data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bcog_gift_selections ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_key VARCHAR(64) NOT NULL, promotion_id BIGINT UNSIGNED NOT NULL, reward_id VARCHAR(64) NOT NULL, product_id BIGINT UNSIGNED NULL DEFAULT NULL, variation_id BIGINT UNSIGNED NULL DEFAULT NULL, quantity INT NOT NULL DEFAULT 1, status VARCHAR(20) NOT NULL DEFAULT 'selected', updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_selection_unique (session_key, promotion_id, reward_id), KEY session_promotion (session_key, promotion_id), KEY updated_at (updated_at) ) ENGINE","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_key","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"promotion_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"reward_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"variation_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"quantity","type":"INT","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","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/"}}