{"slug":"course-booking-system","name":"Course Booking System","description":"Individual course booking system for recurring events and specific needs.","author":"ComMotion","active_installs":100,"version":"7.0.4","wp_org_url":"https://wordpress.org/plugins/course-booking-system/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cbs_attendances","full_table_name":"wp_cbs_attendances","description":"Stores cbs attendances data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"attendance_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"attendance","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_attendances` ( `attendance_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `attendance` int(11) NOT NULL, PRIMARY KEY (`attendance_id`) ) ENGINE"},{"table_name":"cbs_bookings","full_table_name":"wp_cbs_bookings","description":"Stores cbs bookings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"booking_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_bookings` ( `booking_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`booking_id`) ) ENGINE"},{"table_name":"cbs_cancellations","full_table_name":"wp_cbs_cancellations","description":"Stores cbs cancellations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"cancellation_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"timestamp","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_cancellations` ( `cancellation_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `user_id` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`cancellation_id`) ) ENGINE"},{"table_name":"cbs_data","full_table_name":"wp_cbs_data","description":"Stores cbs data data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"day","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"start","type":"time","nullable":true,"primary_key":false},{"name":"end","type":"time","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `day` int(11) NOT NULL, `date` date NULL, `post_id` int(11) NOT NULL, `start` time NULL, `end` time NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"cbs_logs","full_table_name":"wp_cbs_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"log_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"card_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"card","type":"int(11)","nullable":true,"primary_key":false},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"action","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"timestamp","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_logs` ( `log_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `card_name` VARCHAR(255) NOT NULL, `card` int(11) NULL, `course_id` int(11) NOT NULL, `action` VARCHAR(255) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`log_id`) ) ENGINE"},{"table_name":"cbs_notes","full_table_name":"wp_cbs_notes","description":"Stores cbs notes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"note_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"note","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_notes` ( `note_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `note` text NOT NULL, PRIMARY KEY (`note_id`) ) ENGINE"},{"table_name":"cbs_substitutes","full_table_name":"wp_cbs_substitutes","description":"Stores cbs substitutes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"substitute_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_substitutes` ( `substitute_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`substitute_id`) ) ENGINE"},{"table_name":"cbs_waitlists","full_table_name":"wp_cbs_waitlists","description":"Stores cbs waitlists data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"waitlist_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"date","type":"date","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_cbs_waitlists` ( `waitlist_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `date` date NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`waitlist_id`) ) ENGINE"}],"table_count":8}