{"table_name":"bingocr_period_pricing","full_table_name":"wp_bingocr_period_pricing","description":"Stores bingocr period pricing data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bingocr_period_pricing ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', pricing_type enum('fixed_total','rate_per_day') NOT NULL DEFAULT 'rate_per_day', min_days tinyint(3) unsigned NOT NULL DEFAULT 1, max_days tinyint(3) unsigned NOT NULL DEFAULT 30, fixed_price decimal(10,2) NOT NULL DEFAULT 0.00, price_per_day decimal(10,2) NOT NULL DEFAULT 0.00, applies_to enum('all','category','car') NOT NULL DEFAULT 'all', category varchar(50) NOT NULL DEFAULT '', car_id bigint(20) unsigned DEFAULT NULL, priority tinyint(3) NOT NULL DEFAULT 0, status enum('active','inactive') NOT NULL DEFAULT 'active', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY min_days (min_days), KEY max_days (max_days) ) $c;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"pricing_type","type":"enum('fixed_total','rate_per_day')","nullable":false,"primary_key":false},{"name":"min_days","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"max_days","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"fixed_price","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"price_per_day","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"applies_to","type":"enum('all','category','car')","nullable":false,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"car_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"priority","type":"tinyint(3)","nullable":false,"primary_key":false},{"name":"status","type":"enum('active','inactive')","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"bingocar","name":"Bingo Car Rental","active_installs":0,"version":"1.0.59","wp_org_url":"https://wordpress.org/plugins/bingocar/"}}