{"table_name":"classpilot_bookings","full_table_name":"wp_classpilot_bookings","description":"Stores classpilot bookings data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_bookings ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, session_id bigint(20) unsigned NOT NULL, customer_id bigint(20) unsigned NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', payment_mode varchar(20) NOT NULL DEFAULT 'stripe', stripe_session_id varchar(200) NOT NULL DEFAULT '', checkout_expires_at datetime NULL DEFAULT NULL, pack_credit_id bigint(20) unsigned NOT NULL DEFAULT 0, attendance_status varchar(20) NOT NULL DEFAULT 'unknown', idempotency_key varchar(100) NOT NULL DEFAULT '', note text NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY idempotency (idempotency_key), KEY session_id (session_id), KEY customer_id (customer_id), KEY status (status), KEY pending_expiry (status, checkout_expires_at) ) {$charset};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"session_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"customer_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"payment_mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"stripe_session_id","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"pack_credit_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"attendance_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"idempotency_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"note","type":"text","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":"classpilot-booking","name":"ClassPilot Booking","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/classpilot-booking/"}}