{"table_name":"booking_form_structures","full_table_name":"wp_booking_form_structures","description":"Stores form definitions and related configuration.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_booking_form_structures ( booking_form_id bigint(20) unsigned NOT NULL auto_increment, form_slug VARCHAR(191) NOT NULL, status VARCHAR(32) NOT NULL, owner_user_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, scope varchar(64) NOT NULL default 'global', version int(11) NOT NULL default 1, booking_resource_id BIGINT UNSIGNED NULL, engine varchar(32) NOT NULL default 'bfb', engine_version varchar(16) NOT NULL default '1.0', structure_json LONGTEXT NOT NULL, settings_json LONGTEXT NULL, advanced_form LONGTEXT NULL, content_form LONGTEXT NULL, is_default TINYINT(1) NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL, description TEXT NULL, picture_url text NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by bigint(20) unsigned DEFAULT NULL, updated_by bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (booking_form_id), UNIQUE KEY form_slug_status (form_slug, status, owner_user_id) ) {$charset_collate}\"; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter $wpdb->query( $simple_sql );","columns":[{"name":"booking_form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"form_slug","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"owner_user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"scope","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"version","type":"int(11)","nullable":false,"primary_key":false},{"name":"booking_resource_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"engine","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"engine_version","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"structure_json","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"settings_json","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"advanced_form","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"content_form","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"is_default","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"picture_url","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"created_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"updated_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false}],"plugin":{"slug":"booking","name":"Booking Calendar","active_installs":50000,"version":"11.3","wp_org_url":"https://wordpress.org/plugins/booking/"}}