{"table_name":"address","full_table_name":"wp_address","description":"Stores address data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `address` ( `address_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `address` varchar(50) NOT NULL, `address2` varchar(50) DEFAULT NULL, `district` varchar(20) NOT NULL, `city_id` smallint(5) unsigned NOT NULL, `postal_code` varchar(10) DEFAULT NULL, `phone` varchar(20) NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`address_id`), KEY `idx_fk_city_id` (`city_id`), CONSTRAINT `fk_address_city` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`) ON UPDATE CASCADE ) ENGINE","columns":[{"name":"address_id","type":"smallint(5) unsigned","nullable":false,"primary_key":true},{"name":"address","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"address2","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"district","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"city_id","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"postal_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(20)","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/"}}