{"table_name":"bingocr_reservations","full_table_name":"wp_bingocr_reservations","description":"Stores bingocr reservations data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_bingocr_reservations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_number varchar(20) NOT NULL DEFAULT '', car_id bigint(20) unsigned NOT NULL, customer_name varchar(200) NOT NULL DEFAULT '', customer_email varchar(200) NOT NULL DEFAULT '', customer_phone varchar(50) DEFAULT NULL, pickup_date date NOT NULL, return_date date NOT NULL, pickup_time varchar(10) NOT NULL DEFAULT '10:00', return_time varchar(10) NOT NULL DEFAULT '10:00', pickup_location_id bigint(20) unsigned DEFAULT NULL, dropoff_location_id bigint(20) unsigned DEFAULT NULL, status enum('pending','confirmed','active','cancelled','completed') NOT NULL DEFAULT 'pending', total_price decimal(10,2) DEFAULT NULL, deposit_amount decimal(10,2) NOT NULL DEFAULT 0.00, discount_code varchar(50) DEFAULT NULL, discount_amount decimal(10,2) NOT NULL DEFAULT 0.00, extras longtext DEFAULT NULL, notes text DEFAULT NULL, payment_method varchar(50) NOT NULL DEFAULT 'cash', payment_status varchar(20) NOT NULL DEFAULT 'unpaid', paid_amount decimal(10,2) NOT NULL DEFAULT 0.00, language varchar(10) NOT NULL DEFAULT 'en', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY reservation_number (reservation_number), KEY car_id (car_id), KEY status (status), KEY pickup_date (pickup_date), KEY customer_email (customer_email) ) $c;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"reservation_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"car_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"customer_email","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"customer_phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"pickup_date","type":"date","nullable":false,"primary_key":false},{"name":"return_date","type":"date","nullable":false,"primary_key":false},{"name":"pickup_time","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"return_time","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"pickup_location_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"dropoff_location_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"enum('pending','confirmed','active','cancelled','completed')","nullable":false,"primary_key":false},{"name":"total_price","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"deposit_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"discount_code","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"extras","type":"longtext","nullable":true,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"payment_method","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"paid_amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"language","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_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/"}}