{"table_name":"jetreader_notes","full_table_name":"wp_jetreader_notes","description":"Stores jetreader notes data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_jetreader_notes ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, item_id BIGINT(20) UNSIGNED NOT NULL, chapter_id BIGINT(20) UNSIGNED DEFAULT NULL, type VARCHAR(20) NOT NULL DEFAULT 'note', content LONGTEXT DEFAULT NULL, quote TEXT DEFAULT NULL, position LONGTEXT DEFAULT NULL, color VARCHAR(20) DEFAULT '#FFFF00', is_public TINYINT(1) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY item_id (item_id), KEY type (type), KEY user_item (user_id, item_id) ) ENGINE","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"item_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"chapter_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"quote","type":"TEXT","nullable":true,"primary_key":false},{"name":"position","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"color","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"is_public","type":"TINYINT(1)","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":"jetreader","name":"JetReader – Book Library, EPUB & PDF Reader (Lite)","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/jetreader/"}}