{"table_name":"better_payment_subscription_order","full_table_name":"wp_better_payment_subscription_order","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_better_payment_subscription_order( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, subscription_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL, order_item_id bigint(20) unsigned NOT NULL DEFAULT 0, type varchar(20) NOT NULL DEFAULT 'new', source varchar(50) NOT NULL, PRIMARY KEY (id), KEY subscription_id (subscription_id), KEY order_id (order_id), KEY source (source) ) ENGINE","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"subscription_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_item_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(50)","nullable":false,"primary_key":false}],"plugin":{"slug":"better-payment","name":"Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More","active_installs":5000,"version":"2.4.2","wp_org_url":"https://wordpress.org/plugins/better-payment/"}}