{"slug":"wp-appointments","name":"Wp Appointments","description":"With totally AJAX based front & back ends, WP Appointments is a fully managed and flexible tool for building powerful appointments systems.","author":"Webinane","active_installs":10,"version":"1.0","wp_org_url":"https://wordpress.org/plugins/wp-appointments/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"appointments","full_table_name":"wp_appointments","description":"Stores appointments data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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\" );"},{"table_name":"connections","full_table_name":"wp_connections","description":"Stores connections data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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\" );"},{"table_name":"locations","full_table_name":"wp_locations","description":"Stores locations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address","type":"text","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"cord","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"image","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_locations ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, address text NOT NULL, country varchar(255) DEFAULT NULL, location varchar(255) DEFAULT NULL, cord varchar(255) DEFAULT NULL, image int(11) NOT NULL, PRIMARY KEY (id) ) $charset_collate\" );"},{"table_name":"services","full_table_name":"wp_services","description":"Stores services data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"varchar(1000)","nullable":true,"primary_key":false},{"name":"duration","type":"int(11)","nullable":false,"primary_key":false},{"name":"price","type":"decimal(10,0)","nullable":true,"primary_key":false},{"name":"image","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_services ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, description varchar(1000) DEFAULT NULL, duration int(11) NOT NULL, price decimal(10,0) DEFAULT NULL, image int(11) NOT NULL, PRIMARY KEY (id) ) $charset_collate\" );"},{"table_name":"staff","full_table_name":"wp_staff","description":"Stores staff data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"start_time","type":"time","nullable":true,"primary_key":false},{"name":"end_time","type":"time","nullable":true,"primary_key":false},{"name":"interval_time","type":"int(11)","nullable":true,"primary_key":false},{"name":"interval_set","type":"varchar(1000)","nullable":true,"primary_key":false},{"name":"image","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_staff ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) DEFAULT NULL, description text, email varchar(100) DEFAULT NULL, phone varchar(45) DEFAULT NULL, country varchar(255) DEFAULT NULL, start_time time DEFAULT NULL, end_time time DEFAULT NULL, interval_time int(11) DEFAULT NULL, interval_set varchar(1000) DEFAULT NULL, image int(11) NOT NULL, PRIMARY KEY (id) ) $charset_collate\" );"},{"table_name":"wst_","full_table_name":"wp_wst_","description":"Stores wst  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":6}