{"table_name":"user_payments","full_table_name":"wp_user_payments","description":"Stores user payments data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_user_payments ( `order_id` bigint(20) AUTO_INCREMENT, `transaction_id` varchar(250) NULL, `amount` varchar(250) NULL, `transaction_type` varchar(250) NULL, `subscribed_date` datetime NULL, `user_id` bigint(20) NULL, `payment_status` varchar(25) NULL, `payer_id` varchar(25) NULL, `course_id` varchar(45) NULL, `admin_commission` varchar(20) NULL,PRIMARY KEY (`order_id`) ) {$collate}\");","columns":[{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"transaction_id","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"amount","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"transaction_type","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"subscribed_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"payment_status","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"payer_id","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"course_id","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"admin_commission","type":"varchar(20)","nullable":true,"primary_key":false}],"plugin":{"slug":"quick-learn","name":"Quick Learn","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/quick-learn/"}}