{"slug":"emarksheet","name":"Online Marksheet Creator : eMarksheet","description":"This is a simple and unique wordpress plugin to create a simple marksheet using wordpress. You can also give a link to your users to see the result an …","author":"Aarvansh Infotech","active_installs":10,"version":"5.5.1","wp_org_url":"https://wordpress.org/plugins/emarksheet/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"emarksheet_class","full_table_name":"wp_emarksheet_class","description":"Stores emarksheet class data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"class_name","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `emarksheet_class` ( `id` int(11) NOT NULL AUTO_INCREMENT, `class_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE"},{"table_name":"emarksheet_marks","full_table_name":"wp_emarksheet_marks","description":"Stores emarksheet marks data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"student_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"class_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"marks","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `emarksheet_marks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `student_id` int(11) NOT NULL, `class_id` int(11) NOT NULL, `marks` TEXT NOT NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=4 ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\");"},{"table_name":"emarksheet_setting","full_table_name":"wp_emarksheet_setting","description":"Stores emarksheet setting data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"school_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address","type":"text","nullable":false,"primary_key":false},{"name":"district","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name_of_principal","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `emarksheet_setting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `school_name` varchar(255) NOT NULL, `address` text NOT NULL, `district` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `name_of_principal` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=5 ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\");"},{"table_name":"emarksheet_student","full_table_name":"wp_emarksheet_student","description":"Stores emarksheet student data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS `emarksheet_student` ( `id` int(11) NOT NULL AUTO_INCREMENT, `class_id` int(11) NOT NULL, `roll_no` varchar(255) COLLATE"},{"table_name":"emarksheet_subject","full_table_name":"wp_emarksheet_subject","description":"Stores emarksheet subject data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"class","type":"int(11)","nullable":false,"primary_key":false},{"name":"sub_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"total_marks","type":"int(11)","nullable":false,"primary_key":false},{"name":"min_pass","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `emarksheet_subject` ( `id` int(11) NOT NULL AUTO_INCREMENT, `class` int(11) NOT NULL, `sub_name` varchar(255) NOT NULL, `total_marks` int(11) NOT NULL, `min_pass` int(11) DEFAULT 33, PRIMARY KEY (`id`) )AUTO_INCREMENT=6 ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\");"}],"table_count":5}