{"table_name":"classpilot_sessions","full_table_name":"wp_classpilot_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_classpilot_sessions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, class_id bigint(20) unsigned NOT NULL, starts_at datetime NOT NULL, ends_at datetime NOT NULL, capacity smallint unsigned NOT NULL DEFAULT 10, seats_booked smallint unsigned NOT NULL DEFAULT 0, instructor_id bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'scheduled', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY class_starts (class_id, starts_at), KEY status (status) ) {$charset_collate};\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"class_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"starts_at","type":"datetime","nullable":false,"primary_key":false},{"name":"ends_at","type":"datetime","nullable":false,"primary_key":false},{"name":"capacity","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"seats_booked","type":"smallint unsigned","nullable":false,"primary_key":false},{"name":"instructor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","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":"classpilot-booking","name":"ClassPilot Booking","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/classpilot-booking/"}}