{"table_name":"appointments","full_table_name":"wp_appointments","description":"Stores appointments data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_appointments ( id int(11) NOT NULL AUTO_INCREMENT, location int(11) NOT NULL, service int(11) NOT NULL, worker int(11) NOT NULL, name varchar(255) DEFAULT NULL, email varchar(255) DEFAULT NULL, phone varchar(45) DEFAULT NULL, date date DEFAULT NULL, slot varchar(45) DEFAULT NULL, status varchar(45) DEFAULT NULL, created timestamp NULL DEFAULT CURRENT_TIMESTAMP, price decimal(10, 0) DEFAULT NULL, ip varchar(45) DEFAULT NULL, PRIMARY KEY (id), KEY appointments_location (location), KEY appointments_service (service), KEY appointments_worker (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":"service","type":"int(11)","nullable":false,"primary_key":false},{"name":"worker","type":"int(11)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"slot","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"created","type":"timestamp","nullable":true,"primary_key":false},{"name":"price","type":"decimal(10, 0)","nullable":true,"primary_key":false},{"name":"ip","type":"varchar(45)","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/"}}