{"table_name":"bcog_usage_reservations","full_table_name":"wp_bcog_usage_reservations","description":"Stores bcog usage reservations data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bcog_usage_reservations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, reservation_key CHAR(64) NOT NULL, scope VARCHAR(20) NOT NULL, subject_hash VARCHAR(64) NOT NULL, bucket_start DATETIME NOT NULL, status VARCHAR(20) NOT NULL, order_id BIGINT UNSIGNED NULL DEFAULT NULL, reserved_at DATETIME NOT NULL, expires_at DATETIME NOT NULL, confirmed_at DATETIME NULL DEFAULT NULL, released_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_reservation_key (reservation_key), KEY promo_scope_subject_bucket_status (promotion_id, scope, subject_hash, bucket_start, status), KEY status_expires (status, expires_at), 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":"reservation_key","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"scope","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"subject_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"bucket_start","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"reserved_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"expires_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"confirmed_at","type":"DATETIME","nullable":true,"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/"}}