{"table_name":"dmcb_bookings","full_table_name":"wp_dmcb_bookings","description":"Stores dmcb bookings data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_dmcb_bookings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ref VARCHAR(20) NOT NULL, status VARCHAR(24) NOT NULL DEFAULT 'confirmed', start_utc DATETIME NOT NULL, end_utc DATETIME NOT NULL, minutes SMALLINT UNSIGNED NOT NULL, amount DECIMAL(12,2) NOT NULL DEFAULT 0, currency VARCHAR(3) NOT NULL DEFAULT '', service VARCHAR(120) NOT NULL DEFAULT '', prefix VARCHAR(12) NOT NULL DEFAULT '', first_name VARCHAR(80) NOT NULL, middle_name VARCHAR(80) NOT NULL DEFAULT '', last_name VARCHAR(80) NOT NULL, email VARCHAR(190) NOT NULL, phone VARCHAR(40) NOT NULL, business VARCHAR(160) NOT NULL DEFAULT '', notes TEXT NULL, client_tz VARCHAR(64) NOT NULL DEFAULT '', hold_expires_utc DATETIME NULL, paid_at DATETIME NULL, meeting_provider VARCHAR(12) NOT NULL DEFAULT '', meeting_id VARCHAR(190) NOT NULL DEFAULT '', meeting_url VARCHAR(500) NOT NULL DEFAULT '', meeting_password VARCHAR(40) NOT NULL DEFAULT '', meeting_error TEXT NULL, policy TEXT NULL, policy_accepted_at DATETIME NULL, reschedule_count TINYINT UNSIGNED NOT NULL DEFAULT 0, original_start_utc DATETIME NULL, rescheduled_at DATETIME NULL, cancelled_at DATETIME NULL, cancelled_by VARCHAR(10) NOT NULL DEFAULT '', refund_amount DECIMAL(12,2) NOT NULL DEFAULT 0, refund_status VARCHAR(20) NOT NULL DEFAULT '', reminder_day_sent TINYINT(1) NOT NULL DEFAULT 0, reminder_hour_sent TINYINT(1) NOT NULL DEFAULT 0, view_token VARCHAR(40) NOT NULL, ip VARCHAR(45) NOT NULL DEFAULT '', created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY ref (ref), KEY status_start (status,start_utc), KEY email (email) ) {$c};\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"ref","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(24)","nullable":false,"primary_key":false},{"name":"start_utc","type":"DATETIME","nullable":false,"primary_key":false},{"name":"end_utc","type":"DATETIME","nullable":false,"primary_key":false},{"name":"minutes","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(3)","nullable":false,"primary_key":false},{"name":"service","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"prefix","type":"VARCHAR(12)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"middle_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"business","type":"VARCHAR(160)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"client_tz","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"hold_expires_utc","type":"DATETIME","nullable":true,"primary_key":false},{"name":"paid_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"meeting_provider","type":"VARCHAR(12)","nullable":false,"primary_key":false},{"name":"meeting_id","type":"VARCHAR(190)","nullable":false,"primary_key":false},{"name":"meeting_url","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"meeting_password","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"meeting_error","type":"TEXT","nullable":true,"primary_key":false},{"name":"policy","type":"TEXT","nullable":true,"primary_key":false},{"name":"policy_accepted_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"reschedule_count","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"original_start_utc","type":"DATETIME","nullable":true,"primary_key":false},{"name":"rescheduled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancelled_by","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"refund_amount","type":"DECIMAL(12,2)","nullable":false,"primary_key":false},{"name":"refund_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"reminder_day_sent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"reminder_hour_sent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"view_token","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"discounts-mania-consultations","name":"Discounts Mania Consultations","active_installs":0,"version":"1.4.0","wp_org_url":"https://wordpress.org/plugins/discounts-mania-consultations/"}}