{"table_name":"payment","full_table_name":"wp_payment","description":"Stores payment data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `payment` ( `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `customer_id` smallint(5) unsigned NOT NULL, `staff_id` tinyint(3) unsigned NOT NULL, `rental_id` int(11) DEFAULT NULL, `amount` decimal(5,2) NOT NULL, `payment_date` datetime NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`payment_id`), KEY `idx_fk_staff_id` (`staff_id`), KEY `idx_fk_customer_id` (`customer_id`), KEY `fk_payment_rental` (`rental_id`), CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE, CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE ) ENGINE","columns":[{"name":"payment_id","type":"smallint(5) unsigned","nullable":false,"primary_key":true},{"name":"customer_id","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"staff_id","type":"tinyint(3) unsigned","nullable":false,"primary_key":false},{"name":"rental_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(5,2)","nullable":false,"primary_key":false},{"name":"payment_date","type":"datetime","nullable":false,"primary_key":false},{"name":"last_update","type":"timestamp","nullable":false,"primary_key":false}],"plugin":{"slug":"rest-routes","name":"Rest Routes – Custom Endpoints for WordPress REST API","active_installs":80,"version":"5.5.5","wp_org_url":"https://wordpress.org/plugins/rest-routes/"}}