{"table_name":"connections","full_table_name":"wp_connections","description":"Stores connections data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_connections ( id int(11) NOT NULL AUTO_INCREMENT, location int(11) NOT NULL, worker varchar(255) NOT NULL, service varchar(255) NOT NULL, date_start date DEFAULT NULL, date_end date DEFAULT NULL, week_of_days varchar(60) DEFAULT NULL, PRIMARY KEY (id), KEY location_to_connection (location), KEY worker_to_connection (worker) ) $charset_collate\" );","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"location","type":"int(11)","nullable":false,"primary_key":false},{"name":"worker","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"service","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"date_start","type":"date","nullable":true,"primary_key":false},{"name":"date_end","type":"date","nullable":true,"primary_key":false},{"name":"week_of_days","type":"varchar(60)","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-appointments","name":"Wp Appointments","active_installs":10,"version":"1.0","wp_org_url":"https://wordpress.org/plugins/wp-appointments/"}}