Home » Archived » BIRT » problem in birt 2.1.1 to execute MySQL Aggregate Functions
| problem in birt 2.1.1 to execute MySQL Aggregate Functions [message #245336] |
Thu, 28 June 2007 09:33  |
Eclipse User |
|
|
|
Originally posted by: jil_gd.gmail.com
Hi,
(sorry for my poor english)
I use
eclipse-SDK-3.2.1-win32.zip,
emf-sdo-xsd-SDK-2.2.1.zip,
GEF-ALL-3.2.1.zip,
birt-report-designer-all-in-one-2_1_1.zip
This is my query, this run well from command prompt.
But when i run this query from birt then a BIRT exception occurred,
which i paste later.also i paste my database structure where i see that
the table 'engg_exam_total' is present.
//////////////////////////////////////////////////////////// ////
select
sum(.engg_exam_total.grand_total)*100/sum(.subject_curriculu m.full_marks)
from examination_type,
examination_instance,
examination_instance_item,
academic_session,
examination_roll_no,
student_personal_details,
person_details,
faculty_academicunit_composition,
academic_unit,
student_enrollment,
course_structure,
course_offering,
subject_curriculum,
subject,
subject_grade,
engg_exam_total
where
.examination_type.examination_type_id=.examination_instance. examination_type_id
and .engg_exam_total.exam_instance_id=.examination_instance.exam ination_instance_id
and
.academic_session.academic_session_id=.examination_instance. curriculum_session
and
.examination_roll_no.exam_instance_id=.examination_instance. examination_instance_id
and .student_personal_details.student_id=.examination_roll_no.st udent_id
and .student_personal_details.person_id=.person_details.person_i d
and
.faculty_academicunit_composition.faculty_id=.examination_ty pe.faculty_id
and
.faculty_academicunit_composition.academic_unit_id=.academic _unit.academic_unit_id
and .student_enrollment.student_id=.student_personal_details.stu dent_id
and
.course_structure.academic_unit_id=.faculty_academicunit_com position.academic_unit_id
and
.course_offering.course_structure_item_id=.course_structure. course_structure_item_id
and
.subject_curriculum.subject_curriculum_id=.course_offering.s ubject_curriculum_id
and .subject.subject_id=.subject_curriculum.subject_id
and
.examination_instance_item.examination_instance_id=.examinat ion_instance.examination_instance_id
and
.examination_instance_item.course_offering_item_id=.course_o ffering.course_offering_item_id
and
.subject_grade.exam_instance_id=.examination_instance.examin ation_instance_id
and
.subject_grade.course_offering_item_id=.examination_instance _item.course_offering_item_id
and .examination_instance.curriculum_session='3'
and .examination_instance.examination_type_id='15'
and .faculty_academicunit_composition.faculty_id='1'
and .academic_unit.academic_unit_id='17'
and .course_structure.course_id='42'
and .subject_grade.student_id='275'
group by .examination_instance.curriculum_session,
examination_instance.examination_type_id,
faculty_academicunit_composition.faculty_id,
academic_unit.academic_unit_id,
course_structure.course_id,
subject_grade.student_id
//////////////////////////////////////////////////////////// ////
and this is my DB structure where the table "engg_exam_total" is present.
///////////////////////////////////////////////////////////
DROP TABLE IF EXISTS `academic_program_course_offering`;
CREATE TABLE `academic_program_course_offering` (
`course_id` int(10) NOT NULL auto_increment,
`academic_unit_id` int(10) default NULL,
`program_id` int(10) default NULL,
`name` varchar(100) default NULL,
`code` varchar(100) default NULL,
`created_by` varchar(100) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`course_id`)
) TYPE=InnoDB;
/*Table structure for table `academic_session` */
DROP TABLE IF EXISTS `academic_session`;
CREATE TABLE `academic_session` (
`academic_session_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`start_date` datetime default NULL,
`end_date` datetime default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`previous_session_id` int(11) default '0',
PRIMARY KEY (`academic_session_id`)
) TYPE=InnoDB;
/*Table structure for table `academic_unit` */
DROP TABLE IF EXISTS `academic_unit`;
CREATE TABLE `academic_unit` (
`academic_unit_id` int(11) NOT NULL auto_increment,
`academic_unit_name` varchar(60) NOT NULL default '',
`location` varchar(60) default NULL,
`current_head` varchar(60) NOT NULL default '',
`type` varchar(60) default NULL,
`number_of_course` varchar(20) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`code` varchar(50) default NULL,
PRIMARY KEY (`academic_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `admin_user` */
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`user_id` varchar(25) NOT NULL default '',
`password` varchar(25) default NULL,
`access_allowed_till` datetime default NULL,
`password_aging` varchar(5) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `admin_user_person_association` */
DROP TABLE IF EXISTS `admin_user_person_association`;
CREATE TABLE `admin_user_person_association` (
`user_id` varchar(25) NOT NULL default '',
`user_type` varchar(15) NOT NULL default '',
`person_id` int(11) NOT NULL default '0',
`associated_by` varchar(60) default NULL,
`association_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `administrator_logged_in_at` */
DROP TABLE IF EXISTS `administrator_logged_in_at`;
CREATE TABLE `administrator_logged_in_at` (
`user_id` varchar(25) NOT NULL default '',
`logged_in_at` datetime default NULL
) TYPE=InnoDB;
/*Table structure for table `administrator_login_time` */
DROP TABLE IF EXISTS `administrator_login_time`;
CREATE TABLE `administrator_login_time` (
`user_id` varchar(25) NOT NULL default '',
`login_time` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_item_catagory` */
DROP TABLE IF EXISTS `assessment_item_catagory`;
CREATE TABLE `assessment_item_catagory` (
`assessment_item_catagory_id` int(10) NOT NULL auto_increment,
`assessment_item_catagory_title` varchar(100) default NULL,
`full_marks` int(11) default NULL,
`description` varchar(100) default NULL,
`grading_scheme_id` int(11) default NULL,
`assessmentcontrol` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_catagory_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_template` */
DROP TABLE IF EXISTS `assessment_template`;
CREATE TABLE `assessment_template` (
`assessment_template_id` int(10) NOT NULL auto_increment,
`assessment_template_title` varchar(70) default NULL,
`grading_scheme_id` int(11) default NULL,
PRIMARY KEY (`assessment_template_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_template_definition` */
DROP TABLE IF EXISTS `assessment_template_definition`;
CREATE TABLE `assessment_template_definition` (
`assessment_template_item` int(10) NOT NULL auto_increment,
`assessment_template_id` int(10) default NULL,
`assessment_item_catagory_id` int(10) default NULL,
`no_of_assessment_item` int(11) default NULL,
`best_of` int(11) default NULL,
`weightage` int(11) default NULL,
PRIMARY KEY (`assessment_template_item`)
) TYPE=InnoDB;
/*Table structure for table `bank_issuing_details` */
DROP TABLE IF EXISTS `bank_issuing_details`;
CREATE TABLE `bank_issuing_details` (
`person_id` int(10) NOT NULL default '0',
`bank_issuing_id` int(10) NOT NULL auto_increment,
`bank_draft_number` varchar(60) default NULL,
`bank_name` varchar(60) default NULL,
PRIMARY KEY (`bank_issuing_id`)
) TYPE=InnoDB;
/*Table structure for table `central_evaluation_results` */
DROP TABLE IF EXISTS `central_evaluation_results`;
CREATE TABLE `central_evaluation_results` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`exam_roll_no` varchar(100) NOT NULL default '',
`marks_obtain` varchar(100) default NULL,
`marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`exam_instance_item_id`,`exam_roll_no`)
) TYPE=InnoDB;
/*Table structure for table `central_evaluation_results_controller` */
DROP TABLE IF EXISTS `central_evaluation_results_controller`;
CREATE TABLE `central_evaluation_results_controller` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`exam_roll_no` varchar(100) NOT NULL default '',
`old_marks` varchar(100) default NULL,
`new_marks` varchar(100) default NULL,
`old_marks_entered_by` varchar(100) default NULL,
`new_marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`exam_instance_item_id`,`exam_roll_no`)
) TYPE=InnoDB;
/*Table structure for table `course_enrollment` */
DROP TABLE IF EXISTS `course_enrollment`;
CREATE TABLE `course_enrollment` (
`course_offering_item_id` int(10) NOT NULL default '0',
`student_id` int(10) NOT NULL default '0',
`student_group` varchar(100) default NULL,
PRIMARY KEY (`course_offering_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `course_evaluation_item` */
DROP TABLE IF EXISTS `course_evaluation_item`;
CREATE TABLE `course_evaluation_item` (
`course_offering_item_id` int(10) NOT NULL default '0',
`assessment_item_id` int(10) NOT NULL auto_increment,
`assessment_item_catagory_id` int(10) default NULL,
`assessment_item_title` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`)
) TYPE=InnoDB;
/*Table structure for table `course_fee_template_association` */
DROP TABLE IF EXISTS `course_fee_template_association`;
CREATE TABLE `course_fee_template_association` (
`academic_unit_id` int(10) NOT NULL default '0',
`course_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`fee_structure_template_id` int(10) NOT NULL default '0',
`associated_on` datetime default NULL,
PRIMARY KEY
(`academic_unit_id`,`course_id`,`session_id`,`fee_structure_ template_id`)
) TYPE=InnoDB;
/*Table structure for table `course_offering` */
DROP TABLE IF EXISTS `course_offering`;
CREATE TABLE `course_offering` (
`course_offering_item_id` int(11) NOT NULL auto_increment,
`course_structure_item_id` int(11) NOT NULL default '0',
`subject_curriculum_id` int(11) NOT NULL default '0',
`academic_session_id` int(11) NOT NULL default '0',
PRIMARY KEY (`course_offering_item_id`)
) TYPE=InnoDB;
/*Table structure for table `course_structure` */
DROP TABLE IF EXISTS `course_structure`;
CREATE TABLE `course_structure` (
`course_structure_item_id` int(11) NOT NULL auto_increment,
`academic_unit_id` int(11) NOT NULL default '0',
`program_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
PRIMARY KEY (`course_structure_item_id`)
) TYPE=InnoDB;
/*Table structure for table `curriculum` */
DROP TABLE IF EXISTS `curriculum`;
CREATE TABLE `curriculum` (
`curriculum_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`curriculum_id`)
) TYPE=InnoDB;
/*Table structure for table `curriculum_details` */
DROP TABLE IF EXISTS `curriculum_details`;
CREATE TABLE `curriculum_details` (
`curriculum_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`no_of_theory` int(11) NOT NULL default '0',
`no_of_labs` int(11) NOT NULL default '0',
`full_marks` int(11) NOT NULL default '0',
`grade_point` varchar(20) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`curriculum_id`,`subject_id`)
) TYPE=InnoDB;
/*Table structure for table `dashboardmgmt` */
DROP TABLE IF EXISTS `dashboardmgmt`;
CREATE TABLE `dashboardmgmt` (
`id` varchar(25) NOT NULL default '',
`title` varchar(50) default NULL,
`description` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=InnoDB;
/*Table structure for table `demand_note` */
DROP TABLE IF EXISTS `demand_note`;
CREATE TABLE `demand_note` (
`demand_note_no` int(10) NOT NULL default '0',
`student_id` int(10) default NULL,
`session_id` int(10) NOT NULL default '0',
`total_amount` varchar(100) default NULL,
`demand_note_type` varchar(100) default NULL,
`generation_date` datetime default NULL,
`generated_by` varchar(100) default NULL,
`payment_mode` varchar(100) default NULL,
`fees` varchar(100) default NULL,
PRIMARY KEY (`demand_note_no`,`session_id`)
) TYPE=InnoDB;
/*Table structure for table `engg_exam_total` */
DROP TABLE IF EXISTS `engg_exam_total`;
CREATE TABLE `engg_exam_total` (
`exam_instance_id` int(11) default NULL,
`student_id` int(11) default NULL,
`theory_total` int(11) default NULL,
`sessional_total` int(11) default NULL,
`grand_total` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`sgpa` varchar(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `evaluation_result` */
DROP TABLE IF EXISTS `evaluation_result`;
CREATE TABLE `evaluation_result` (
`assessment_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`marks_obtained` varchar(100) default NULL,
`user_id` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `evaluation_result_controller` */
DROP TABLE IF EXISTS `evaluation_result_controller`;
CREATE TABLE `evaluation_result_controller` (
`assessment_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`old_marks` varchar(100) default NULL,
`new_marks` varchar(100) default NULL,
`old_marks_entered_by` varchar(100) default NULL,
`new_marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_instance` */
DROP TABLE IF EXISTS `examination_instance`;
CREATE TABLE `examination_instance` (
`examination_instance_id` int(11) NOT NULL auto_increment,
`examination_type_id` int(11) NOT NULL default '0',
`examination_year` varchar(30) NOT NULL default '',
`start_date` datetime default NULL,
`end_date` datetime default NULL,
`comment` varchar(200) NOT NULL default '',
`curriculum_session` int(11) default NULL,
`marks_submit_last_date` datetime default NULL,
PRIMARY KEY (`examination_instance_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_instance_item` */
DROP TABLE IF EXISTS `examination_instance_item`;
CREATE TABLE `examination_instance_item` (
`examination_instance_item_id` int(11) NOT NULL auto_increment,
`examination_instance_id` int(11) NOT NULL default '0',
`course_offering_item_id` int(11) NOT NULL default '0',
`date` datetime default NULL,
`reference_no` varchar(60) NOT NULL default '',
`start_time` varchar(60) NOT NULL default '',
`end_time` varchar(60) NOT NULL default '',
`no_student_enrolled` int(11) NOT NULL default '0',
`result_publish` datetime default NULL,
PRIMARY KEY (`examination_instance_item_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_enrollment` */
DROP TABLE IF EXISTS `examination_item_enrollment`;
CREATE TABLE `examination_item_enrollment` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`enrolled_by` varchar(100) default NULL,
`enrolled_on` datetime default NULL,
PRIMARY KEY (`exam_instance_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_examiner` */
DROP TABLE IF EXISTS `examination_item_examiner`;
CREATE TABLE `examination_item_examiner` (
`examination_item_examiner_id` int(11) NOT NULL auto_increment,
`examination_instance_item_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',
`date_script_sent` datetime default NULL,
`script_sent_by` int(11) NOT NULL default '0',
`date_script_received` datetime default NULL,
`script_received_by` int(11) NOT NULL default '0',
`date_proposed` datetime default NULL,
`proposed_by` int(11) NOT NULL default '0',
`date_confirmed` datetime default NULL,
`confirmed_by` int(11) NOT NULL default '0',
`marks_posted_status` varchar(20) default NULL,
`no_of_answer_script` int(10) default '0',
PRIMARY KEY (`examination_item_examiner_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_paper_setter` */
DROP TABLE IF EXISTS `examination_item_paper_setter`;
CREATE TABLE `examination_item_paper_setter` (
`examination_item_paper_setter_id` int(11) NOT NULL auto_increment,
`examination_instance_item_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',
`date_letter_sent` datetime default NULL,
`letter_sent_by` int(11) NOT NULL default '0',
`date_question_received` datetime default NULL,
`question_received_by` int(11) NOT NULL default '0',
`date_proposed` datetime default NULL,
`proposed_by` int(11) NOT NULL default '0',
`date_confirmed` datetime default NULL,
`confirmed_by` int(11) NOT NULL default '0',
PRIMARY KEY (`examination_item_paper_setter_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_roll_no` */
DROP TABLE IF EXISTS `examination_roll_no`;
CREATE TABLE `examination_roll_no` (
`exam_instance_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`given_by` varchar(100) default NULL,
`exam_roll_no` varchar(100) default NULL,
`given_on` datetime default NULL,
PRIMARY KEY (`exam_instance_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_type` */
DROP TABLE IF EXISTS `examination_type`;
CREATE TABLE `examination_type` (
`examination_type_id` int(11) NOT NULL auto_increment,
`faculty_id` int(11) NOT NULL default '0',
`examination_title` varchar(60) NOT NULL default '',
`examination_code` varchar(60) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`program_composition_item_id` int(11) NOT NULL default '0',
`base_exam_id` int(11) default NULL,
`cgpa_enabled` char(3) default 'No',
`elective_enabled` char(3) default 'No',
PRIMARY KEY (`examination_type_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_academicunit_association` */
DROP TABLE IF EXISTS `faculty_academicunit_association`;
CREATE TABLE `faculty_academicunit_association` (
`academic_unit_id` int(11) NOT NULL default '0',
`faculty_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`academic_unit_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_academicunit_composition` */
DROP TABLE IF EXISTS `faculty_academicunit_composition`;
CREATE TABLE `faculty_academicunit_composition` (
`academic_unit_id` int(11) NOT NULL default '0',
`faculty_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`academic_unit_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_assignment` */
DROP TABLE IF EXISTS `faculty_assignment`;
CREATE TABLE `faculty_assignment` (
`faculty_member_id` int(11) NOT NULL default '0',
`session_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`academic_unit_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`program_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
PRIMARY KEY
(`faculty_member_id`,`session_id`,`subject_id`,`academic_uni t_id`,`program_unit_id`,`program_id`,`course_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_definition` */
DROP TABLE IF EXISTS `faculty_definition`;
CREATE TABLE `faculty_definition` (
`faculty_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
`description` varchar(100) default NULL,
`code` varchar(50) default NULL,
PRIMARY KEY (`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_evaluation_assignment` */
DROP TABLE IF EXISTS `faculty_evaluation_assignment`;
CREATE TABLE `faculty_evaluation_assignment` (
`assessment_item_id` int(10) NOT NULL default '0',
`faculty_id` int(10) NOT NULL default '0',
`student_group_name` varchar(50) NOT NULL default '',
`status` varchar(50) default NULL,
`marks_posted_status` varchar(50) default NULL,
`last_date_of_marks_submit` datetime default NULL,
`result_publish` datetime default NULL,
PRIMARY KEY (`assessment_item_id`,`faculty_id`,`student_group_name`)
) TYPE=InnoDB;
/*Table structure for table `faculty_member` */
DROP TABLE IF EXISTS `faculty_member`;
CREATE TABLE `faculty_member` (
`person_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL auto_increment,
`date_of_joining` datetime default NULL,
`academic_unit_id` int(11) NOT NULL default '0',
`description` varchar(100) default NULL,
PRIMARY KEY (`faculty_member_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_teaching_assignment` */
DROP TABLE IF EXISTS `faculty_teaching_assignment`;
CREATE TABLE `faculty_teaching_assignment` (
`course_offering_item_id` int(10) NOT NULL default '0',
`faculty_id` int(10) NOT NULL default '0',
`student_group_name` varchar(50) default NULL,
PRIMARY KEY (`course_offering_item_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_head` */
DROP TABLE IF EXISTS `fee_head`;
CREATE TABLE `fee_head` (
`fee_head_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`fee_head_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_structure_template` */
DROP TABLE IF EXISTS `fee_structure_template`;
CREATE TABLE `fee_structure_template` (
`fee_structure_template_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`fee_structure_template_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_structure_template_definition` */
DROP TABLE IF EXISTS `fee_structure_template_definition`;
CREATE TABLE `fee_structure_template_definition` (
`fee_structure_template_id` int(10) NOT NULL default '0',
`fee_head_id` int(10) NOT NULL default '0',
`amount` varchar(100) default NULL,
`comment` varchar(100) default NULL,
PRIMARY KEY (`fee_structure_template_id`,`fee_head_id`)
) TYPE=InnoDB;
/*Table structure for table `fees_history` */
DROP TABLE IF EXISTS `fees_history`;
CREATE TABLE `fees_history` (
`demand_note_no` int(10) NOT NULL default '0',
`student_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`total_amount` varchar(100) default NULL,
`demand_note_type` varchar(100) default NULL,
`generation_date` datetime default NULL,
`generated_by` varchar(100) NOT NULL default '',
`payment_mode` varchar(100) default NULL,
`fees` varchar(100) NOT NULL default '',
PRIMARY KEY
(`demand_note_no`,`session_id`,`student_id`,`fees`,`generate d_by`)
) TYPE=InnoDB;
/*Table structure for table `final_grade` */
DROP TABLE IF EXISTS `final_grade`;
CREATE TABLE `final_grade` (
`exam_roll_no` int(11) default NULL,
`promotion_unit_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` varchar(4) default NULL,
`program_unit_id` int(11) default NULL,
`student_id` int(11) default NULL,
`session_id` int(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `final_total_marks` */
DROP TABLE IF EXISTS `final_total_marks`;
CREATE TABLE `final_total_marks` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`promotion_unit_id` int(11) default NULL,
`program_unit_id` int(11) default NULL,
`total_marks` varchar(4) default NULL,
`session_id` int(11) default NULL,
`sgpa` varchar(10) default NULL
) TYPE=InnoDB;
/*Table structure for table `function` */
DROP TABLE IF EXISTS `function`;
CREATE TABLE `function` (
`function_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
`program` varchar(100) default NULL,
PRIMARY KEY (`function_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_column` */
DROP TABLE IF EXISTS `grading_column`;
CREATE TABLE `grading_column` (
`grading_column_id` mediumint(9) NOT NULL auto_increment,
`grading_structure_id` mediumint(9) default NULL,
`column_no` int(11) default NULL,
`column_title` blob,
`course_offering_item_id` int(11) default NULL,
`assessment_item_catagory_id` int(3) default NULL,
`assessment_item_id` int(11) default NULL,
`column_type` varchar(30) default NULL,
PRIMARY KEY (`grading_column_id`),
UNIQUE KEY `grading_column_id` (`grading_column_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_data` */
DROP TABLE IF EXISTS `grading_data`;
CREATE TABLE `grading_data` (
`grading_column_id` mediumint(9) default NULL,
`exam_roll_no` varchar(25) default NULL,
`exam_data` int(3) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_footer` */
DROP TABLE IF EXISTS `grading_footer`;
CREATE TABLE `grading_footer` (
`grading_col_id` int(11) default NULL,
`full_form` varchar(60) default NULL,
`abbreviation` char(2) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_scheme` */
DROP TABLE IF EXISTS `grading_scheme`;
CREATE TABLE `grading_scheme` (
`grading_scheme_id` int(10) NOT NULL auto_increment,
`grading_scheme_title` varchar(70) default NULL,
PRIMARY KEY (`grading_scheme_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_scheme_definition` */
DROP TABLE IF EXISTS `grading_scheme_definition`;
CREATE TABLE `grading_scheme_definition` (
`grading_item` int(10) NOT NULL auto_increment,
`grading_scheme_id` int(10) default NULL,
`grade` varchar(30) default NULL,
`lower_value` int(11) default NULL,
`upper_value` int(11) default NULL,
`grade_point` int(11) default NULL,
PRIMARY KEY (`grading_item`)
) TYPE=InnoDB;
/*Table structure for table `grading_sheet` */
DROP TABLE IF EXISTS `grading_sheet`;
CREATE TABLE `grading_sheet` (
`grading_structure_id` mediumint(9) default NULL,
`col1` varchar(50) default NULL,
`col2` varchar(50) default NULL,
`col3` varchar(50) default NULL,
`col4` varchar(50) default NULL,
`col5` varchar(5) default NULL,
`col6` varchar(5) default NULL,
`col7` varchar(5) default NULL,
`col8` varchar(5) default NULL,
`col9` varchar(5) default NULL,
`col10` varchar(5) default NULL,
`col11` varchar(5) default NULL,
`col12` varchar(5) default NULL,
`col13` varchar(5) default NULL,
`col14` varchar(5) default NULL,
`col15` varchar(5) default NULL,
`col16` varchar(5) default NULL,
`col17` varchar(5) default NULL,
`col18` varchar(5) default NULL,
`col19` varchar(5) default NULL,
`col20` varchar(5) default NULL,
`col21` varchar(5) default NULL,
`col22` varchar(5) default NULL,
`col23` varchar(5) default NULL,
`col24` varchar(5) default NULL,
`col25` varchar(5) default NULL,
`col26` varchar(5) default NULL,
`col27` varchar(5) default NULL,
`col28` varchar(5) default NULL,
`col29` varchar(5) default NULL,
`col30` varchar(5) default NULL,
`col31` varchar(5) default NULL,
`col32` varchar(5) default NULL,
`col33` varchar(5) default NULL,
`col34` varchar(5) default NULL,
`col35` varchar(5) default NULL,
`col36` varchar(5) default NULL,
`col37` varchar(5) default NULL,
`col38` varchar(5) default NULL,
`col39` varchar(5) default NULL,
`col40` varchar(5) default NULL,
`col41` varchar(5) default NULL,
`col42` varchar(5) default NULL,
`col43` varchar(5) default NULL,
`col44` varchar(5) default NULL,
`col45` varchar(5) default NULL,
`col46` varchar(5) default NULL,
`col47` varchar(5) default NULL,
`col48` varchar(5) default NULL,
`col49` varchar(5) default NULL,
`col50` varchar(5) default NULL,
`col51` varchar(5) default NULL,
`col52` varchar(5) default NULL,
`col53` varchar(5) default NULL,
`col54` varchar(5) default NULL,
`col55` varchar(5) default NULL,
`col56` varchar(5) default NULL,
`col57` varchar(5) default NULL,
`col58` varchar(5) default NULL,
`col59` varchar(5) default NULL,
`col60` varchar(5) default NULL,
`col61` varchar(5) default NULL,
`col62` varchar(5) default NULL,
`col63` varchar(5) default NULL,
`col64` varchar(5) default NULL,
`col65` varchar(5) default NULL,
`col66` varchar(5) default NULL,
`col67` varchar(5) default NULL,
`col68` varchar(5) default NULL,
`col69` varchar(5) default NULL,
`col70` varchar(5) default NULL,
`col71` varchar(5) default NULL,
`col72` varchar(5) default NULL,
`col73` varchar(5) default NULL,
`col74` varchar(5) default NULL,
`col75` varchar(5) default NULL,
`col76` varchar(5) default NULL,
`col77` varchar(5) default NULL,
`col78` varchar(5) default NULL,
`col79` varchar(5) default NULL,
`col80` varchar(5) default NULL,
`col81` varchar(5) default NULL,
`col82` varchar(5) default NULL,
`col83` varchar(5) default NULL,
`col84` varchar(5) default NULL,
`col85` varchar(5) default NULL,
`col86` varchar(5) default NULL,
`col87` varchar(5) default NULL,
`col88` varchar(5) default NULL,
`col89` varchar(5) default NULL,
`col90` varchar(5) default NULL,
`col91` varchar(5) default NULL,
`col92` varchar(5) default NULL,
`col93` varchar(5) default NULL,
`col94` varchar(5) default NULL,
`col95` varchar(5) default NULL,
`col96` varchar(5) default NULL,
`col97` varchar(5) default NULL,
`col98` varchar(5) default NULL,
`col99` varchar(5) default NULL,
`col100` varchar(5) default NULL,
`col101` varchar(5) default NULL,
`col102` varchar(5) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_structure` */
DROP TABLE IF EXISTS `grading_structure`;
CREATE TABLE `grading_structure` (
`grading_structure_id` mediumint(9) NOT NULL auto_increment,
`exam_instance_id` int(11) NOT NULL default '0',
`yearofexam` int(5) NOT NULL default '0',
`academic_unit_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
`no_of_column` int(11) default '0',
PRIMARY KEY
(`exam_instance_id`,`academic_unit_id`,`course_id`,`yearofex am`),
UNIQUE KEY `grading_structure_id` (`grading_structure_id`)
) TYPE=InnoDB;
/*Table structure for table `image` */
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
`person_id` int(11) NOT NULL default '0',
`image_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
PRIMARY KEY (`image_id`)
) TYPE=InnoDB;
/*Table structure for table `late_faculty_role_change_history` */
DROP TABLE IF EXISTS `late_faculty_role_change_history`;
CREATE TABLE `late_faculty_role_change_history` (
`user_id` varchar(60) NOT NULL default '',
`role_name` varchar(60) NOT NULL default '',
`new_role_change_date` datetime default NULL,
`created_by` varchar(60) default NULL,
PRIMARY KEY (`user_id`,`role_name`)
) TYPE=InnoDB;
/*Table structure for table `manual_demand_note` */
DROP TABLE IF EXISTS `manual_demand_note`;
CREATE TABLE `manual_demand_note` (
`student_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`generation_date` datetime default NULL,
`generated_by` varchar(100) default NULL,
`head` varchar(100) NOT NULL default '',
`amount` varchar(100) default NULL,
PRIMARY KEY (`session_id`,`student_id`,`head`)
) TYPE=InnoDB;
/*Table structure for table `marks_adjustment` */
DROP TABLE IF EXISTS `marks_adjustment`;
CREATE TABLE `marks_adjustment` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`examination_type_id` int(11) default NULL,
`session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`course_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`original_marks` varchar(5) default NULL,
`adjusted_marks` varchar(5) default NULL,
`date_adjusted` datetime default NULL,
`adjusted_by` varchar(50) default NULL
) TYPE=InnoDB;
/*Table structure for table `marks_adjustment_cache` */
DROP TABLE IF EXISTS `marks_adjustment_cache`;
CREATE TABLE `marks_adjustment_cache` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`examination_type_id` int(11) default NULL,
`session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`course_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`original_marks` varchar(5) default NULL,
`adjusted_marks` varchar(5) default NULL,
`date_adjusted` datetime default NULL,
`adjusted_by` varchar(50) default NULL
) TYPE=InnoDB;
/*Table structure for table `matricdashboard` */
DROP TABLE IF EXISTS `matricdashboard`;
CREATE TABLE `matricdashboard` (
`dashboard_id` varchar(25) NOT NULL default '',
`matrics_id` varchar(25) NOT NULL default '',
PRIMARY KEY (`dashboard_id`,`matrics_id`)
) TYPE=InnoDB;
/*Table structure for table `matricsmgmt` */
DROP TABLE IF EXISTS `matricsmgmt`;
CREATE TABLE `matricsmgmt` (
`systemid` mediumint(9) NOT NULL auto_increment,
`id` varchar(25) NOT NULL default '',
`title` varchar(50) default NULL,
`description` varchar(200) default NULL,
`textdata` blob,
`numberdata` blob,
`numberdata2` blob,
`numberdata3` blob,
`legenddata1` varchar(50) default NULL,
`legenddata2` varchar(50) default NULL,
`legenddata3` varchar(50) default NULL,
`type` varchar(50) default NULL,
`subtype` varchar(50) default NULL,
`width` int(6) default NULL,
`height` int(6) default NULL,
`yaxis` varchar(100) default NULL,
`xaxis` varchar(100) default NULL,
`color` int(10) default NULL,
`transpose` varchar(25) default NULL,
`stacked` varchar(5) default NULL,
PRIMARY KEY (`systemid`,`id`),
UNIQUE KEY `systemid` (`systemid`)
) TYPE=InnoDB;
/*Table structure for table `menu` */
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`menu_id` int(10) NOT NULL auto_increment,
`menu_title` varchar(100) default NULL,
`comment` varchar(100) default NULL,
PRIMARY KEY (`menu_id`)
) TYPE=InnoDB;
/*Table structure for table `menu_item_function` */
DROP TABLE IF EXISTS `menu_item_function`;
CREATE TABLE `menu_item_function` (
`menu_item_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`function_id` int(10) default NULL,
PRIMARY KEY (`menu_item_id`)
) TYPE=InnoDB;
/*Table structure for table `menu_structure` */
DROP TABLE IF EXISTS `menu_structure`;
CREATE TABLE `menu_structure` (
`menu_id` int(10) NOT NULL default '0',
`menu_item_id` int(10) NOT NULL default '0',
PRIMARY KEY (`menu_id`,`menu_item_id`)
) TYPE=InnoDB;
/*Table structure for table `money_receipt` */
DROP TABLE IF EXISTS `money_receipt`;
CREATE TABLE `money_receipt` (
`money_receipt_id` int(10) NOT NULL auto_increment,
`demand_note_no` int(10) default NULL,
`demand_note_type` varchar(100) default NULL,
`total_amount` varchar(100) default NULL,
`receipt_date` datetime default NULL,
`receipt_by` varchar(100) default NULL,
PRIMARY KEY (`money_receipt_id`)
) TYPE=InnoDB;
/*Table structure for table `person_academic_details` */
DROP TABLE IF EXISTS `person_academic_details`;
CREATE TABLE `person_academic_details` (
`academic_id` int(10) NOT NULL auto_increment,
`person_id` int(10) NOT NULL default '0',
`name_examination_passed` varchar(100) default NULL,
`name_address_institution` varchar(100) default NULL,
`name_board_or_university` varchar(100) default NULL,
`subjects_taken` varchar(200) default NULL,
`marks_with_division` varchar(100) default NULL,
`year_of_passing` varchar(100) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`academic_id`,`person_id`)
) TYPE=InnoDB;
/*Table structure for table `person_details` */
DROP TABLE IF EXISTS `person_details`;
CREATE TABLE `person_details` (
`person_id` int(10) NOT NULL auto_increment,
`first_name` varchar(50) NOT NULL default '',
`middle_name` varchar(50) default NULL,
`last_name` varchar(50) NOT NULL default '',
`permanent_address` varchar(200) default NULL,
`present_address` varchar(200) default NULL,
`father_name` varchar(100) default NULL,
`mother_name` varchar(100) default NULL,
`telephone_number` varchar(50) default NULL,
`dob` datetime default NULL,
`gender` varchar(8) default NULL,
`mother_tongue` varchar(25) default NULL,
`nationality` varchar(25) default NULL,
`sc_st_physically_disabbled_sports` varchar(25) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`person_id`)
) TYPE=InnoDB;
/*Table structure for table `personnel_member` */
DROP TABLE IF EXISTS `personnel_member`;
CREATE TABLE `personnel_member` (
`personnel_id` int(10) NOT NULL auto_increment,
`person_id` int(10) default NULL,
`academic_unit_id` int(10) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`personnel_id`)
) TYPE=InnoDB;
/*Table structure for table `physician_details` */
DROP TABLE IF EXISTS `physician_details`;
CREATE TABLE `physician_details` (
`physician_id` int(11) NOT NULL auto_increment,
`physician_name` varchar(60) NOT NULL default '',
`physician_registration_no` varchar(60) default NULL,
`physician_address` varchar(100) default NULL,
`state` varchar(30) default NULL,
`type` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `portal_user_password` */
DROP TABLE IF EXISTS `portal_user_password`;
CREATE TABLE `portal_user_password` (
`user_id` varchar(25) NOT NULL default '',
`password` varchar(20) default NULL,
`access_allowed_till` datetime default NULL,
`password_aging` varchar(5) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `portal_user_person_association` */
DROP TABLE IF EXISTS `portal_user_person_association`;
CREATE TABLE `portal_user_person_association` (
`user_id` varchar(25) NOT NULL default '',
`user_type` varchar(15) NOT NULL default '',
`person_id` int(11) NOT NULL default '0',
`associated_by` varchar(60) default NULL,
`association_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `program` */
DROP TABLE IF EXISTS `program`;
CREATE TABLE `program` (
`program_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`description` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`program_id`)
) TYPE=InnoDB;
/*Table structure for table `program_composition` */
DROP TABLE IF EXISTS `program_composition`;
CREATE TABLE `program_composition` (
`program_composition_item_id` int(11) NOT NULL auto_increment,
`program_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`program_composition_item_id`)
) TYPE=InnoDB;
/*Table structure for table `program_course_association` */
DROP TABLE IF EXISTS `program_course_association`;
CREATE TABLE `program_course_association` (
`academic_unit_id` int(10) NOT NULL default '0',
`program_id` int(10) NOT NULL default '0',
`course_id` int(10) NOT NULL default '0',
`course_name` varchar(60) default NULL,
`course_description` varchar(60) default NULL,
PRIMARY KEY (`academic_unit_id`,`program_id`,`course_id`)
) TYPE=InnoDB;
/*Table structure for table `program_unit` */
DROP TABLE IF EXISTS `program_unit`;
CREATE TABLE `program_unit` (
`program_unit_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`duration` varchar(10) default NULL,
`description` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`weightage` varchar(5) default '0',
PRIMARY KEY (`program_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_event` */
DROP TABLE IF EXISTS `promotion_event`;
CREATE TABLE `promotion_event` (
`promotion_event_id` mediumint(9) NOT NULL auto_increment,
`promotion_event_title` varchar(60) default NULL,
`faculty_id` int(11) default NULL,
`program_unit_id` int(11) default NULL,
`promotion_target_id` int(11) default NULL,
`promotion_processing_template_id` mediumint(9) default NULL,
PRIMARY KEY (`promotion_event_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_processing_template` */
DROP TABLE IF EXISTS `promotion_processing_template`;
CREATE TABLE `promotion_processing_template` (
`template_id` mediumint(9) NOT NULL auto_increment,
`title` varchar(60) default NULL,
`aggregate_percentage` int(6) default NULL,
`sesional_pass_mark` int(6) default NULL,
`max_no_of_supple` int(6) default NULL,
`supple_mark` int(6) default NULL,
`supple_clearing_marks` int(6) default NULL,
`allowed_pre_supple` int(1) default NULL,
PRIMARY KEY (`template_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_program_association` */
DROP TABLE IF EXISTS `promotion_program_association`;
CREATE TABLE `promotion_program_association` (
`promotion_program_item_id` int(11) NOT NULL auto_increment,
`promotion_unit_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`comment` varchar(100) NOT NULL default '',
PRIMARY KEY (`promotion_program_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_result` */
DROP TABLE IF EXISTS `promotion_result`;
CREATE TABLE `promotion_result` (
`promotion_result_item_id` mediumint(9) NOT NULL auto_increment,
`promotion_event_id` mediumint(9) default NULL,
`exam_roll_no` int(11) default NULL,
`session_id` int(11) default NULL,
`status` varchar(20) default NULL,
`explanation` blob,
`student_id` int(11) default NULL,
PRIMARY KEY (`promotion_result_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_rule_application` */
DROP TABLE IF EXISTS `promotion_rule_application`;
CREATE TABLE `promotion_rule_application` (
`promotion_event_id` mediumint(9) default NULL,
`promotion_rule_item_id` mediumint(9) NOT NULL auto_increment,
`examination_type_id` int(11) default NULL,
`sequence` int(6) default NULL,
`sessional` varchar(6) default NULL,
`aggregate` varchar(6) default NULL,
`supplementary` varchar(6) default NULL,
`previous_process` varchar(6) default NULL,
PRIMARY KEY (`promotion_rule_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_unit` */
DROP TABLE IF EXISTS `promotion_unit`;
CREATE TABLE `promotion_unit` (
`promotion_unit_id` int(11) NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`description` varchar(100) default NULL,
`sequence` int(6) default '0',
`ranking_enabled` char(3) default 'No',
PRIMARY KEY (`promotion_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `ranking_template` */
DROP TABLE IF EXISTS `ranking_template`;
CREATE TABLE `ranking_template` (
`ranking_template_id` mediumint(11) NOT NULL auto_increment,
`ranking_title` varchar(100) default NULL,
`percentage` int(3) default NULL,
PRIMARY KEY (`ranking_template_id`)
) TYPE=InnoDB;
/*Table structure for table `role` */
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`role_id`)
) TYPE=InnoDB;
/*Table structure for table `role_function` */
DROP TABLE IF EXISTS `role_function`;
CREATE TABLE `role_function` (
`role_id` int(10) NOT NULL default '0',
`function_id` int(10) NOT NULL default '0',
`changepermission` varchar(25) default NULL,
`comment` varchar(100) default NULL,
`date` datetime default NULL,
`entered_by` varchar(100) default NULL,
PRIMARY KEY (`role_id`,`function_id`)
) TYPE=InnoDB;
/*Table structure for table `role_hierarchy` */
DROP TABLE IF EXISTS `role_hierarchy`;
CREATE TABLE `role_hierarchy` (
`role_id` int(10) NOT NULL default '0',
`parent_role_id` int(10) NOT NULL default '0',
PRIMARY KEY (`parent_role_id`,`role_id`)
) TYPE=InnoDB;
/*Table structure for table `role_parameter` */
DROP TABLE IF EXISTS `role_parameter`;
CREATE TABLE `role_parameter` (
`parameter_id` int(10) NOT NULL auto_increment,
`role_id` int(10) default NULL,
`parameter_title` varchar(100) default NULL,
`parameter_type` varchar(100) default NULL,
PRIMARY KEY (`parameter_id`)
) TYPE=InnoDB;
/*Table structure for table `science_academic_information` */
DROP TABLE IF EXISTS `science_academic_information`;
CREATE TABLE `science_academic_information` (
`student_id` int(10) NOT NULL default '0',
`part` varchar(60) NOT NULL default '',
`year` varchar(60) default NULL,
`theoretical` int(11) default '0',
`practical` int(11) default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`part`)
) TYPE=InnoDB;
/*Table structure for table `science_academic_information_summary` */
DROP TABLE IF EXISTS `science_academic_information_summary`;
CREATE TABLE `science_academic_information_summary` (
`student_id` int(10) NOT NULL default '0',
`subject` varchar(60) default NULL,
`full_marks` int(11) NOT NULL default '0',
`marks_obtained` int(11) NOT NULL default '0',
`subject1` varchar(60) default NULL,
`subject2` varchar(60) default NULL,
`subject3` varchar(60) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`)
) TYPE=InnoDB;
/*Table structure for table `section` */
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
`section_id` int(11) NOT NULL auto_increment,
`section_name` varchar(60) NOT NULL default '',
`section_description` varchar(60) default NULL,
`created_by` varchar(60) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`section_id`)
) TYPE=InnoDB;
/*Table structure for table `semester_weightage_sgpa` */
DROP TABLE IF EXISTS `semester_weightage_sgpa`;
CREATE TABLE `semester_weightage_sgpa` (
`student_id` double default NULL,
`examination_type_id` double default NULL,
`curriculum_session` double default NULL,
`academic_unit_id` double default NULL,
`course_id` double default NULL,
`SemWgtSGPA` varchar(100) default NULL,
`col1` varchar(50) default NULL,
`col2` varchar(50) default NULL,
`col3` varchar(50) default NULL,
`col4` varchar(50) default NULL,
`col5` varchar(5) default NULL,
`col6` varchar(5) default NULL,
`col7` varchar(5) default NULL,
`col8` varchar(5) default NULL,
`col9` varchar(5) default NULL,
`col10` varchar(5) default NULL,
`col11` varchar(5) default NULL,
`col12` varchar(5) default NULL
) TYPE=MyISAM;
/*Table structure for table `student_employment_details` */
DROP TABLE IF EXISTS `student_employment_details`;
CREATE TABLE `student_employment_details` (
`student_id` int(10) NOT NULL default '0',
`name_firm_or_instituation` varchar(100) NOT NULL default '',
`nature_of_job` varchar(60) default NULL,
`start_date` datetime default NULL,
`to_date` datetime default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`name_firm_or_instituation`)
) TYPE=InnoDB;
/*Table structure for table `student_enrollment` */
DROP TABLE IF EXISTS `student_enrollment`;
CREATE TABLE `student_enrollment` (
`student_id` int(10) NOT NULL default '0',
`date_of_enrollment` datetime default NULL,
`muster_roll_number` varchar(50) NOT NULL default '',
`registration_no` varchar(60) default NULL,
`academic_session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`program_id` int(11) default NULL,
`course_id` int(11) default NULL,
`form_no` varchar(60) default NULL,
`joint_rank_no` varchar(60) default NULL,
`joint_board_enrolment` varchar(60) default NULL,
`account_status` varchar(25) default NULL,
`sponsored_status` varchar(25) default NULL,
`day_or_night` varchar(25) default NULL,
`whether_wb_university` varchar(25) default NULL,
`faculty_id` int(11) default NULL,
`catagory` int(11) default NULL,
`batch` int(11) default NULL,
`user` varchar(50) default NULL,
`studentstatus` varchar(50) default NULL,
`marks_sheets_submit_by_student` varchar(60) default NULL,
`photo_submit_by_student` varchar(60) default NULL,
`income_submit_by_student` varchar(60) default NULL,
`cast_submit_by_student` varchar(60) default NULL,
`marrage_submit_by_student` varchar(60) default NULL,
`sponsership_submit_by_student` varchar(60) default NULL,
`resignation_submit_by_student` varchar(60) default NULL,
`qualification_submit_by_student` varchar(60) default NULL,
`ageprof_submit_by_student` varchar(60) default NULL,
`serial_no` int(10) default NULL,
PRIMARY KEY (`student_id`,`muster_roll_number`)
) TYPE=InnoDB;
/*Table structure for table `student_eyesight_details` */
DROP TABLE IF EXISTS `student_eyesight_details`;
CREATE TABLE `student_eyesight_details` (
`student_id` int(10) NOT NULL default '0',
`power_correcting_lens_left_eye` varchar(50) NOT NULL default '',
`power_correcting_lens_right_eye` varchar(50) default NULL,
`status_colour_blindness` varchar(60) NOT NULL default '',
`physician_id` int(10) NOT NULL default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `student_general_health_details` */
DROP TABLE IF EXISTS `student_general_health_details`;
CREATE TABLE `student_general_health_details` (
`student_id` int(10) NOT NULL default '0',
`weight` varchar(50) NOT NULL default '',
`height` varchar(50) default NULL,
`chest_measurements` varchar(60) NOT NULL default '',
`physician_id` int(10) NOT NULL default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `student_login_time` */
DROP TABLE IF EXISTS `student_login_time`;
CREATE TABLE `student_login_time` (
`session_id` varchar(50) default NULL,
`student_id` varchar(25) default NULL,
`logged_in_at` datetime default NULL,
`logged_out_at` datetime default NULL
) TYPE=InnoDB;
/*Table structure for table `student_migration` */
DROP TABLE IF EXISTS `student_migration`;
CREATE TABLE `student_migration` (
`student_id` int(11) default NULL,
`migration_mc_no` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`user` varchar(100) default NULL,
PRIMARY KEY (`migration_mc_no`)
) TYPE=InnoDB;
/*Table structure for table `student_personal_details` */
DROP TABLE IF EXISTS `student_personal_details`;
CREATE TABLE `student_personal_details` (
`student_id` int(10) NOT NULL auto_increment,
`person_id` varchar(50) default NULL,
`gnameaddress` varchar(200) default NULL,
`relationshipguardian` varchar(50) default NULL,
`occupation` varchar(50) default NULL,
`annualincome` varchar(50) default NULL,
`pob` varchar(25) default NULL,
`district` varchar(25) default NULL,
`state` varchar(50) default NULL,
`minority` varchar(25) default NULL,
`applicantuniversity` varchar(25) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`)
) TYPE=InnoDB;
/*Table structure for table `stuednt_grade` */
DROP TABLE IF EXISTS `stuednt_grade`;
CREATE TABLE `stuednt_grade` (
`grading_structure_id` mediumint(9) default NULL,
`exam_roll_no` varchar(25) default NULL,
`name` varchar(50) default NULL,
`class_roll` varchar(50) default NULL,
`reg_no` varchar(50) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` int(3) default NULL
) TYPE=InnoDB;
/*Table structure for table `subject` */
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
`subject_id` int(11) NOT NULL auto_increment,
`subject_name` varchar(200) default NULL,
`subject_code` varchar(30) default NULL,
PRIMARY KEY (`subject_id`)
) TYPE=InnoDB;
/*Table structure for table `subject_curriculum` */
DROP TABLE IF EXISTS `subject_curriculum`;
CREATE TABLE `subject_curriculum` (
`subject_curriculum_id` int(11) NOT NULL auto_increment,
`subject_id` int(11) NOT NULL default '0',
`lec_per_week` int(11) NOT NULL default '0',
`tut_per_week` int(11) NOT NULL default '0',
`sessional_per_week` int(11) NOT NULL default '0',
`full_marks` int(11) NOT NULL default '0',
`syllabus` blob,
`assessment_template_id` int(11) NOT NULL default '0',
`credit_hours` int(11) NOT NULL default '0',
`elective` char(3) default 'No',
`base_subject` int(11) default '0',
PRIMARY KEY (`subject_curriculum_id`)
) TYPE=InnoDB;
/*Table structure for table `subject_grade` */
DROP TABLE IF EXISTS `subject_grade`;
CREATE TABLE `subject_grade` (
`exam_roll_no` varchar(25) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` varchar(4) default NULL,
`status` varchar(20) default NULL,
`exam_instance_id` int(11) default NULL,
`student_id` int(11) default NULL,
`session_id` int(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `subject_syllabus_association` */
DROP TABLE IF EXISTS `subject_syllabus_association`;
CREATE TABLE `subject_syllabus_association` (
`academic_session_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`syllabus_id` int(11) NOT NULL default '0',
`association_date` datetime default NULL,
PRIMARY KEY (`academic_session_id`,`subject_id`,`syllabus_id`)
) TYPE=InnoDB;
/*Table structure for table `supplementary_subject_processing` */
DROP TABLE IF EXISTS `supplementary_subject_processing`;
CREATE TABLE `supplementary_subject_processing` (
`promotion_even
|
|
|
| Re: problem in birt 2.1.1 to execute MySQL Aggregate Functions [message #245345 is a reply to message #245336] |
Thu, 28 June 2007 09:57  |
| Eclipse User |
|
|
|
Originally posted by: jil_gd.gmail.com
Hi,
(sorry for my poor english)
I use eclipse-SDK-3.2.1-win32.zip,
emf-sdo-xsd-SDK-2.2.1.zip,
GEF-ALL-3.2.1.zip,
birt-report-designer-all-in-one-2_1_1.zip
This is my query, this run well from command prompt.
But when i run this query from birt then a BIRT exception occurred,
which i paste later.also i paste my database structure where i see that
the table 'engg_exam_total' is present.
Can u tell me where is the problem??
plz reply me.
//////////////////////////////////////////////////////////// ////
select
sum(.engg_exam_total.grand_total)*100/sum(.subject_curriculu m.full_marks)
from examination_type,
examination_instance,
examination_instance_item,
academic_session,
examination_roll_no,
student_personal_details,
person_details,
faculty_academicunit_composition,
academic_unit,
student_enrollment,
course_structure,
course_offering,
subject_curriculum,
subject,
subject_grade,
engg_exam_total
where
examination_type.examination_type_id=.examination_instance.e xamination_type_id
and
engg_exam_total.exam_instance_id=.examination_instance.exami nation_instance_id
and
academic_session.academic_session_id=.examination_instance.c urriculum_session
and
examination_roll_no.exam_instance_id=.examination_instance.e xamination_instance_id
and .student_personal_details.student_id=.examination_roll_no.st udent_id
and .student_personal_details.person_id=.person_details.person_i d
and
faculty_academicunit_composition.faculty_id=.examination_typ e.faculty_id
and
faculty_academicunit_composition.academic_unit_id=.academic_ unit.academic_unit_id
and .student_enrollment.student_id=.student_personal_details.stu dent_id
and
course_structure.academic_unit_id=.faculty_academicunit_comp osition.academic_unit_id
and
course_offering.course_structure_item_id=.course_structure.c ourse_structure_item_id
and
subject_curriculum.subject_curriculum_id=.course_offering.su bject_curriculum_id
and .subject.subject_id=.subject_curriculum.subject_id
and
examination_instance_item.examination_instance_id=.examinati on_instance.examination_instance_id
and
examination_instance_item.course_offering_item_id=.course_of fering.course_offering_item_id
and
subject_grade.exam_instance_id=.examination_instance.examina tion_instance_id
and
subject_grade.course_offering_item_id=.examination_instance_ item.course_offering_item_id
and .examination_instance.curriculum_session='3'
and .examination_instance.examination_type_id='15'
and .faculty_academicunit_composition.faculty_id='1'
and .academic_unit.academic_unit_id='17'
and .course_structure.course_id='42'
and .subject_grade.student_id='275'
group by .examination_instance.curriculum_session,
examination_instance.examination_type_id,
faculty_academicunit_composition.faculty_id,
academic_unit.academic_unit_id,
course_structure.course_id,
subject_grade.student_id
//////////////////////////////////////////////////////////// ////
and this is my DB structure where the table "engg_exam_total" is present.
///////////////////////////////////////////////////////////
DROP TABLE IF EXISTS `academic_program_course_offering`;
CREATE TABLE `academic_program_course_offering` (
`course_id` int(10) NOT NULL auto_increment,
`academic_unit_id` int(10) default NULL,
`program_id` int(10) default NULL,
`name` varchar(100) default NULL,
`code` varchar(100) default NULL,
`created_by` varchar(100) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`course_id`)
) TYPE=InnoDB;
/*Table structure for table `academic_session` */
DROP TABLE IF EXISTS `academic_session`;
CREATE TABLE `academic_session` (
`academic_session_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`start_date` datetime default NULL,
`end_date` datetime default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`previous_session_id` int(11) default '0',
PRIMARY KEY (`academic_session_id`)
) TYPE=InnoDB;
/*Table structure for table `academic_unit` */
DROP TABLE IF EXISTS `academic_unit`;
CREATE TABLE `academic_unit` (
`academic_unit_id` int(11) NOT NULL auto_increment,
`academic_unit_name` varchar(60) NOT NULL default '',
`location` varchar(60) default NULL,
`current_head` varchar(60) NOT NULL default '',
`type` varchar(60) default NULL,
`number_of_course` varchar(20) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`code` varchar(50) default NULL,
PRIMARY KEY (`academic_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `admin_user` */
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`user_id` varchar(25) NOT NULL default '',
`password` varchar(25) default NULL,
`access_allowed_till` datetime default NULL,
`password_aging` varchar(5) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `admin_user_person_association` */
DROP TABLE IF EXISTS `admin_user_person_association`;
CREATE TABLE `admin_user_person_association` (
`user_id` varchar(25) NOT NULL default '',
`user_type` varchar(15) NOT NULL default '',
`person_id` int(11) NOT NULL default '0',
`associated_by` varchar(60) default NULL,
`association_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `administrator_logged_in_at` */
DROP TABLE IF EXISTS `administrator_logged_in_at`;
CREATE TABLE `administrator_logged_in_at` (
`user_id` varchar(25) NOT NULL default '',
`logged_in_at` datetime default NULL
) TYPE=InnoDB;
/*Table structure for table `administrator_login_time` */
DROP TABLE IF EXISTS `administrator_login_time`;
CREATE TABLE `administrator_login_time` (
`user_id` varchar(25) NOT NULL default '',
`login_time` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_item_catagory` */
DROP TABLE IF EXISTS `assessment_item_catagory`;
CREATE TABLE `assessment_item_catagory` (
`assessment_item_catagory_id` int(10) NOT NULL auto_increment,
`assessment_item_catagory_title` varchar(100) default NULL,
`full_marks` int(11) default NULL,
`description` varchar(100) default NULL,
`grading_scheme_id` int(11) default NULL,
`assessmentcontrol` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_catagory_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_template` */
DROP TABLE IF EXISTS `assessment_template`;
CREATE TABLE `assessment_template` (
`assessment_template_id` int(10) NOT NULL auto_increment,
`assessment_template_title` varchar(70) default NULL,
`grading_scheme_id` int(11) default NULL,
PRIMARY KEY (`assessment_template_id`)
) TYPE=InnoDB;
/*Table structure for table `assessment_template_definition` */
DROP TABLE IF EXISTS `assessment_template_definition`;
CREATE TABLE `assessment_template_definition` (
`assessment_template_item` int(10) NOT NULL auto_increment,
`assessment_template_id` int(10) default NULL,
`assessment_item_catagory_id` int(10) default NULL,
`no_of_assessment_item` int(11) default NULL,
`best_of` int(11) default NULL,
`weightage` int(11) default NULL,
PRIMARY KEY (`assessment_template_item`)
) TYPE=InnoDB;
/*Table structure for table `bank_issuing_details` */
DROP TABLE IF EXISTS `bank_issuing_details`;
CREATE TABLE `bank_issuing_details` (
`person_id` int(10) NOT NULL default '0',
`bank_issuing_id` int(10) NOT NULL auto_increment,
`bank_draft_number` varchar(60) default NULL,
`bank_name` varchar(60) default NULL,
PRIMARY KEY (`bank_issuing_id`)
) TYPE=InnoDB;
/*Table structure for table `central_evaluation_results` */
DROP TABLE IF EXISTS `central_evaluation_results`;
CREATE TABLE `central_evaluation_results` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`exam_roll_no` varchar(100) NOT NULL default '',
`marks_obtain` varchar(100) default NULL,
`marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`exam_instance_item_id`,`exam_roll_no`)
) TYPE=InnoDB;
/*Table structure for table `central_evaluation_results_controller` */
DROP TABLE IF EXISTS `central_evaluation_results_controller`;
CREATE TABLE `central_evaluation_results_controller` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`exam_roll_no` varchar(100) NOT NULL default '',
`old_marks` varchar(100) default NULL,
`new_marks` varchar(100) default NULL,
`old_marks_entered_by` varchar(100) default NULL,
`new_marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`exam_instance_item_id`,`exam_roll_no`)
) TYPE=InnoDB;
/*Table structure for table `course_enrollment` */
DROP TABLE IF EXISTS `course_enrollment`;
CREATE TABLE `course_enrollment` (
`course_offering_item_id` int(10) NOT NULL default '0',
`student_id` int(10) NOT NULL default '0',
`student_group` varchar(100) default NULL,
PRIMARY KEY (`course_offering_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `course_evaluation_item` */
DROP TABLE IF EXISTS `course_evaluation_item`;
CREATE TABLE `course_evaluation_item` (
`course_offering_item_id` int(10) NOT NULL default '0',
`assessment_item_id` int(10) NOT NULL auto_increment,
`assessment_item_catagory_id` int(10) default NULL,
`assessment_item_title` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`)
) TYPE=InnoDB;
/*Table structure for table `course_fee_template_association` */
DROP TABLE IF EXISTS `course_fee_template_association`;
CREATE TABLE `course_fee_template_association` (
`academic_unit_id` int(10) NOT NULL default '0',
`course_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`fee_structure_template_id` int(10) NOT NULL default '0',
`associated_on` datetime default NULL,
PRIMARY KEY
(`academic_unit_id`,`course_id`,`session_id`,`fee_structure_ template_id`)
) TYPE=InnoDB;
/*Table structure for table `course_offering` */
DROP TABLE IF EXISTS `course_offering`;
CREATE TABLE `course_offering` (
`course_offering_item_id` int(11) NOT NULL auto_increment,
`course_structure_item_id` int(11) NOT NULL default '0',
`subject_curriculum_id` int(11) NOT NULL default '0',
`academic_session_id` int(11) NOT NULL default '0',
PRIMARY KEY (`course_offering_item_id`)
) TYPE=InnoDB;
/*Table structure for table `course_structure` */
DROP TABLE IF EXISTS `course_structure`;
CREATE TABLE `course_structure` (
`course_structure_item_id` int(11) NOT NULL auto_increment,
`academic_unit_id` int(11) NOT NULL default '0',
`program_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
PRIMARY KEY (`course_structure_item_id`)
) TYPE=InnoDB;
/*Table structure for table `curriculum` */
DROP TABLE IF EXISTS `curriculum`;
CREATE TABLE `curriculum` (
`curriculum_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`curriculum_id`)
) TYPE=InnoDB;
/*Table structure for table `curriculum_details` */
DROP TABLE IF EXISTS `curriculum_details`;
CREATE TABLE `curriculum_details` (
`curriculum_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`no_of_theory` int(11) NOT NULL default '0',
`no_of_labs` int(11) NOT NULL default '0',
`full_marks` int(11) NOT NULL default '0',
`grade_point` varchar(20) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`curriculum_id`,`subject_id`)
) TYPE=InnoDB;
/*Table structure for table `dashboardmgmt` */
DROP TABLE IF EXISTS `dashboardmgmt`;
CREATE TABLE `dashboardmgmt` (
`id` varchar(25) NOT NULL default '',
`title` varchar(50) default NULL,
`description` varchar(50) default NULL,
PRIMARY KEY (`id`)
) TYPE=InnoDB;
/*Table structure for table `demand_note` */
DROP TABLE IF EXISTS `demand_note`;
CREATE TABLE `demand_note` (
`demand_note_no` int(10) NOT NULL default '0',
`student_id` int(10) default NULL,
`session_id` int(10) NOT NULL default '0',
`total_amount` varchar(100) default NULL,
`demand_note_type` varchar(100) default NULL,
`generation_date` datetime default NULL,
`generated_by` varchar(100) default NULL,
`payment_mode` varchar(100) default NULL,
`fees` varchar(100) default NULL,
PRIMARY KEY (`demand_note_no`,`session_id`)
) TYPE=InnoDB;
/*Table structure for table `engg_exam_total` */
DROP TABLE IF EXISTS `engg_exam_total`;
CREATE TABLE `engg_exam_total` (
`exam_instance_id` int(11) default NULL,
`student_id` int(11) default NULL,
`theory_total` int(11) default NULL,
`sessional_total` int(11) default NULL,
`grand_total` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`sgpa` varchar(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `evaluation_result` */
DROP TABLE IF EXISTS `evaluation_result`;
CREATE TABLE `evaluation_result` (
`assessment_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`marks_obtained` varchar(100) default NULL,
`user_id` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `evaluation_result_controller` */
DROP TABLE IF EXISTS `evaluation_result_controller`;
CREATE TABLE `evaluation_result_controller` (
`assessment_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`old_marks` varchar(100) default NULL,
`new_marks` varchar(100) default NULL,
`old_marks_entered_by` varchar(100) default NULL,
`new_marks_entered_by` varchar(100) default NULL,
PRIMARY KEY (`assessment_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_instance` */
DROP TABLE IF EXISTS `examination_instance`;
CREATE TABLE `examination_instance` (
`examination_instance_id` int(11) NOT NULL auto_increment,
`examination_type_id` int(11) NOT NULL default '0',
`examination_year` varchar(30) NOT NULL default '',
`start_date` datetime default NULL,
`end_date` datetime default NULL,
`comment` varchar(200) NOT NULL default '',
`curriculum_session` int(11) default NULL,
`marks_submit_last_date` datetime default NULL,
PRIMARY KEY (`examination_instance_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_instance_item` */
DROP TABLE IF EXISTS `examination_instance_item`;
CREATE TABLE `examination_instance_item` (
`examination_instance_item_id` int(11) NOT NULL auto_increment,
`examination_instance_id` int(11) NOT NULL default '0',
`course_offering_item_id` int(11) NOT NULL default '0',
`date` datetime default NULL,
`reference_no` varchar(60) NOT NULL default '',
`start_time` varchar(60) NOT NULL default '',
`end_time` varchar(60) NOT NULL default '',
`no_student_enrolled` int(11) NOT NULL default '0',
`result_publish` datetime default NULL,
PRIMARY KEY (`examination_instance_item_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_enrollment` */
DROP TABLE IF EXISTS `examination_item_enrollment`;
CREATE TABLE `examination_item_enrollment` (
`exam_instance_item_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`enrolled_by` varchar(100) default NULL,
`enrolled_on` datetime default NULL,
PRIMARY KEY (`exam_instance_item_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_examiner` */
DROP TABLE IF EXISTS `examination_item_examiner`;
CREATE TABLE `examination_item_examiner` (
`examination_item_examiner_id` int(11) NOT NULL auto_increment,
`examination_instance_item_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',
`date_script_sent` datetime default NULL,
`script_sent_by` int(11) NOT NULL default '0',
`date_script_received` datetime default NULL,
`script_received_by` int(11) NOT NULL default '0',
`date_proposed` datetime default NULL,
`proposed_by` int(11) NOT NULL default '0',
`date_confirmed` datetime default NULL,
`confirmed_by` int(11) NOT NULL default '0',
`marks_posted_status` varchar(20) default NULL,
`no_of_answer_script` int(10) default '0',
PRIMARY KEY (`examination_item_examiner_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_item_paper_setter` */
DROP TABLE IF EXISTS `examination_item_paper_setter`;
CREATE TABLE `examination_item_paper_setter` (
`examination_item_paper_setter_id` int(11) NOT NULL auto_increment,
`examination_instance_item_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL default '0',
`status` varchar(20) NOT NULL default '',
`date_letter_sent` datetime default NULL,
`letter_sent_by` int(11) NOT NULL default '0',
`date_question_received` datetime default NULL,
`question_received_by` int(11) NOT NULL default '0',
`date_proposed` datetime default NULL,
`proposed_by` int(11) NOT NULL default '0',
`date_confirmed` datetime default NULL,
`confirmed_by` int(11) NOT NULL default '0',
PRIMARY KEY (`examination_item_paper_setter_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_roll_no` */
DROP TABLE IF EXISTS `examination_roll_no`;
CREATE TABLE `examination_roll_no` (
`exam_instance_id` int(11) NOT NULL default '0',
`student_id` int(11) NOT NULL default '0',
`given_by` varchar(100) default NULL,
`exam_roll_no` varchar(100) default NULL,
`given_on` datetime default NULL,
PRIMARY KEY (`exam_instance_id`,`student_id`)
) TYPE=InnoDB;
/*Table structure for table `examination_type` */
DROP TABLE IF EXISTS `examination_type`;
CREATE TABLE `examination_type` (
`examination_type_id` int(11) NOT NULL auto_increment,
`faculty_id` int(11) NOT NULL default '0',
`examination_title` varchar(60) NOT NULL default '',
`examination_code` varchar(60) NOT NULL default '',
`description` varchar(200) NOT NULL default '',
`program_composition_item_id` int(11) NOT NULL default '0',
`base_exam_id` int(11) default NULL,
`cgpa_enabled` char(3) default 'No',
`elective_enabled` char(3) default 'No',
PRIMARY KEY (`examination_type_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_academicunit_association` */
DROP TABLE IF EXISTS `faculty_academicunit_association`;
CREATE TABLE `faculty_academicunit_association` (
`academic_unit_id` int(11) NOT NULL default '0',
`faculty_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`academic_unit_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_academicunit_composition` */
DROP TABLE IF EXISTS `faculty_academicunit_composition`;
CREATE TABLE `faculty_academicunit_composition` (
`academic_unit_id` int(11) NOT NULL default '0',
`faculty_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`academic_unit_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_assignment` */
DROP TABLE IF EXISTS `faculty_assignment`;
CREATE TABLE `faculty_assignment` (
`faculty_member_id` int(11) NOT NULL default '0',
`session_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`academic_unit_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`program_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
PRIMARY KEY
(`faculty_member_id`,`session_id`,`subject_id`,`academic_uni t_id`,`program_unit_id`,`program_id`,`course_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_definition` */
DROP TABLE IF EXISTS `faculty_definition`;
CREATE TABLE `faculty_definition` (
`faculty_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
`description` varchar(100) default NULL,
`code` varchar(50) default NULL,
PRIMARY KEY (`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_evaluation_assignment` */
DROP TABLE IF EXISTS `faculty_evaluation_assignment`;
CREATE TABLE `faculty_evaluation_assignment` (
`assessment_item_id` int(10) NOT NULL default '0',
`faculty_id` int(10) NOT NULL default '0',
`student_group_name` varchar(50) NOT NULL default '',
`status` varchar(50) default NULL,
`marks_posted_status` varchar(50) default NULL,
`last_date_of_marks_submit` datetime default NULL,
`result_publish` datetime default NULL,
PRIMARY KEY (`assessment_item_id`,`faculty_id`,`student_group_name`)
) TYPE=InnoDB;
/*Table structure for table `faculty_member` */
DROP TABLE IF EXISTS `faculty_member`;
CREATE TABLE `faculty_member` (
`person_id` int(11) NOT NULL default '0',
`faculty_member_id` int(11) NOT NULL auto_increment,
`date_of_joining` datetime default NULL,
`academic_unit_id` int(11) NOT NULL default '0',
`description` varchar(100) default NULL,
PRIMARY KEY (`faculty_member_id`)
) TYPE=InnoDB;
/*Table structure for table `faculty_teaching_assignment` */
DROP TABLE IF EXISTS `faculty_teaching_assignment`;
CREATE TABLE `faculty_teaching_assignment` (
`course_offering_item_id` int(10) NOT NULL default '0',
`faculty_id` int(10) NOT NULL default '0',
`student_group_name` varchar(50) default NULL,
PRIMARY KEY (`course_offering_item_id`,`faculty_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_head` */
DROP TABLE IF EXISTS `fee_head`;
CREATE TABLE `fee_head` (
`fee_head_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`fee_head_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_structure_template` */
DROP TABLE IF EXISTS `fee_structure_template`;
CREATE TABLE `fee_structure_template` (
`fee_structure_template_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`fee_structure_template_id`)
) TYPE=InnoDB;
/*Table structure for table `fee_structure_template_definition` */
DROP TABLE IF EXISTS `fee_structure_template_definition`;
CREATE TABLE `fee_structure_template_definition` (
`fee_structure_template_id` int(10) NOT NULL default '0',
`fee_head_id` int(10) NOT NULL default '0',
`amount` varchar(100) default NULL,
`comment` varchar(100) default NULL,
PRIMARY KEY (`fee_structure_template_id`,`fee_head_id`)
) TYPE=InnoDB;
/*Table structure for table `fees_history` */
DROP TABLE IF EXISTS `fees_history`;
CREATE TABLE `fees_history` (
`demand_note_no` int(10) NOT NULL default '0',
`student_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`total_amount` varchar(100) default NULL,
`demand_note_type` varchar(100) default NULL,
`generation_date` datetime default NULL,
`generated_by` varchar(100) NOT NULL default '',
`payment_mode` varchar(100) default NULL,
`fees` varchar(100) NOT NULL default '',
PRIMARY KEY
(`demand_note_no`,`session_id`,`student_id`,`fees`,`generate d_by`)
) TYPE=InnoDB;
/*Table structure for table `final_grade` */
DROP TABLE IF EXISTS `final_grade`;
CREATE TABLE `final_grade` (
`exam_roll_no` int(11) default NULL,
`promotion_unit_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` varchar(4) default NULL,
`program_unit_id` int(11) default NULL,
`student_id` int(11) default NULL,
`session_id` int(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `final_total_marks` */
DROP TABLE IF EXISTS `final_total_marks`;
CREATE TABLE `final_total_marks` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`promotion_unit_id` int(11) default NULL,
`program_unit_id` int(11) default NULL,
`total_marks` varchar(4) default NULL,
`session_id` int(11) default NULL,
`sgpa` varchar(10) default NULL
) TYPE=InnoDB;
/*Table structure for table `function` */
DROP TABLE IF EXISTS `function`;
CREATE TABLE `function` (
`function_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
`program` varchar(100) default NULL,
PRIMARY KEY (`function_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_column` */
DROP TABLE IF EXISTS `grading_column`;
CREATE TABLE `grading_column` (
`grading_column_id` mediumint(9) NOT NULL auto_increment,
`grading_structure_id` mediumint(9) default NULL,
`column_no` int(11) default NULL,
`column_title` blob,
`course_offering_item_id` int(11) default NULL,
`assessment_item_catagory_id` int(3) default NULL,
`assessment_item_id` int(11) default NULL,
`column_type` varchar(30) default NULL,
PRIMARY KEY (`grading_column_id`),
UNIQUE KEY `grading_column_id` (`grading_column_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_data` */
DROP TABLE IF EXISTS `grading_data`;
CREATE TABLE `grading_data` (
`grading_column_id` mediumint(9) default NULL,
`exam_roll_no` varchar(25) default NULL,
`exam_data` int(3) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_footer` */
DROP TABLE IF EXISTS `grading_footer`;
CREATE TABLE `grading_footer` (
`grading_col_id` int(11) default NULL,
`full_form` varchar(60) default NULL,
`abbreviation` char(2) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_scheme` */
DROP TABLE IF EXISTS `grading_scheme`;
CREATE TABLE `grading_scheme` (
`grading_scheme_id` int(10) NOT NULL auto_increment,
`grading_scheme_title` varchar(70) default NULL,
PRIMARY KEY (`grading_scheme_id`)
) TYPE=InnoDB;
/*Table structure for table `grading_scheme_definition` */
DROP TABLE IF EXISTS `grading_scheme_definition`;
CREATE TABLE `grading_scheme_definition` (
`grading_item` int(10) NOT NULL auto_increment,
`grading_scheme_id` int(10) default NULL,
`grade` varchar(30) default NULL,
`lower_value` int(11) default NULL,
`upper_value` int(11) default NULL,
`grade_point` int(11) default NULL,
PRIMARY KEY (`grading_item`)
) TYPE=InnoDB;
/*Table structure for table `grading_sheet` */
DROP TABLE IF EXISTS `grading_sheet`;
CREATE TABLE `grading_sheet` (
`grading_structure_id` mediumint(9) default NULL,
`col1` varchar(50) default NULL,
`col2` varchar(50) default NULL,
`col3` varchar(50) default NULL,
`col4` varchar(50) default NULL,
`col5` varchar(5) default NULL,
`col6` varchar(5) default NULL,
`col7` varchar(5) default NULL,
`col8` varchar(5) default NULL,
`col9` varchar(5) default NULL,
`col10` varchar(5) default NULL,
`col11` varchar(5) default NULL,
`col12` varchar(5) default NULL,
`col13` varchar(5) default NULL,
`col14` varchar(5) default NULL,
`col15` varchar(5) default NULL,
`col16` varchar(5) default NULL,
`col17` varchar(5) default NULL,
`col18` varchar(5) default NULL,
`col19` varchar(5) default NULL,
`col20` varchar(5) default NULL,
`col21` varchar(5) default NULL,
`col22` varchar(5) default NULL,
`col23` varchar(5) default NULL,
`col24` varchar(5) default NULL,
`col25` varchar(5) default NULL,
`col26` varchar(5) default NULL,
`col27` varchar(5) default NULL,
`col28` varchar(5) default NULL,
`col29` varchar(5) default NULL,
`col30` varchar(5) default NULL,
`col31` varchar(5) default NULL,
`col32` varchar(5) default NULL,
`col33` varchar(5) default NULL,
`col34` varchar(5) default NULL,
`col35` varchar(5) default NULL,
`col36` varchar(5) default NULL,
`col37` varchar(5) default NULL,
`col38` varchar(5) default NULL,
`col39` varchar(5) default NULL,
`col40` varchar(5) default NULL,
`col41` varchar(5) default NULL,
`col42` varchar(5) default NULL,
`col43` varchar(5) default NULL,
`col44` varchar(5) default NULL,
`col45` varchar(5) default NULL,
`col46` varchar(5) default NULL,
`col47` varchar(5) default NULL,
`col48` varchar(5) default NULL,
`col49` varchar(5) default NULL,
`col50` varchar(5) default NULL,
`col51` varchar(5) default NULL,
`col52` varchar(5) default NULL,
`col53` varchar(5) default NULL,
`col54` varchar(5) default NULL,
`col55` varchar(5) default NULL,
`col56` varchar(5) default NULL,
`col57` varchar(5) default NULL,
`col58` varchar(5) default NULL,
`col59` varchar(5) default NULL,
`col60` varchar(5) default NULL,
`col61` varchar(5) default NULL,
`col62` varchar(5) default NULL,
`col63` varchar(5) default NULL,
`col64` varchar(5) default NULL,
`col65` varchar(5) default NULL,
`col66` varchar(5) default NULL,
`col67` varchar(5) default NULL,
`col68` varchar(5) default NULL,
`col69` varchar(5) default NULL,
`col70` varchar(5) default NULL,
`col71` varchar(5) default NULL,
`col72` varchar(5) default NULL,
`col73` varchar(5) default NULL,
`col74` varchar(5) default NULL,
`col75` varchar(5) default NULL,
`col76` varchar(5) default NULL,
`col77` varchar(5) default NULL,
`col78` varchar(5) default NULL,
`col79` varchar(5) default NULL,
`col80` varchar(5) default NULL,
`col81` varchar(5) default NULL,
`col82` varchar(5) default NULL,
`col83` varchar(5) default NULL,
`col84` varchar(5) default NULL,
`col85` varchar(5) default NULL,
`col86` varchar(5) default NULL,
`col87` varchar(5) default NULL,
`col88` varchar(5) default NULL,
`col89` varchar(5) default NULL,
`col90` varchar(5) default NULL,
`col91` varchar(5) default NULL,
`col92` varchar(5) default NULL,
`col93` varchar(5) default NULL,
`col94` varchar(5) default NULL,
`col95` varchar(5) default NULL,
`col96` varchar(5) default NULL,
`col97` varchar(5) default NULL,
`col98` varchar(5) default NULL,
`col99` varchar(5) default NULL,
`col100` varchar(5) default NULL,
`col101` varchar(5) default NULL,
`col102` varchar(5) default NULL
) TYPE=InnoDB;
/*Table structure for table `grading_structure` */
DROP TABLE IF EXISTS `grading_structure`;
CREATE TABLE `grading_structure` (
`grading_structure_id` mediumint(9) NOT NULL auto_increment,
`exam_instance_id` int(11) NOT NULL default '0',
`yearofexam` int(5) NOT NULL default '0',
`academic_unit_id` int(11) NOT NULL default '0',
`course_id` int(11) NOT NULL default '0',
`no_of_column` int(11) default '0',
PRIMARY KEY
(`exam_instance_id`,`academic_unit_id`,`course_id`,`yearofex am`),
UNIQUE KEY `grading_structure_id` (`grading_structure_id`)
) TYPE=InnoDB;
/*Table structure for table `image` */
DROP TABLE IF EXISTS `image`;
CREATE TABLE `image` (
`person_id` int(11) NOT NULL default '0',
`image_id` int(11) NOT NULL auto_increment,
`name` varchar(60) default NULL,
PRIMARY KEY (`image_id`)
) TYPE=InnoDB;
/*Table structure for table `late_faculty_role_change_history` */
DROP TABLE IF EXISTS `late_faculty_role_change_history`;
CREATE TABLE `late_faculty_role_change_history` (
`user_id` varchar(60) NOT NULL default '',
`role_name` varchar(60) NOT NULL default '',
`new_role_change_date` datetime default NULL,
`created_by` varchar(60) default NULL,
PRIMARY KEY (`user_id`,`role_name`)
) TYPE=InnoDB;
/*Table structure for table `manual_demand_note` */
DROP TABLE IF EXISTS `manual_demand_note`;
CREATE TABLE `manual_demand_note` (
`student_id` int(10) NOT NULL default '0',
`session_id` int(10) NOT NULL default '0',
`generation_date` datetime default NULL,
`generated_by` varchar(100) default NULL,
`head` varchar(100) NOT NULL default '',
`amount` varchar(100) default NULL,
PRIMARY KEY (`session_id`,`student_id`,`head`)
) TYPE=InnoDB;
/*Table structure for table `marks_adjustment` */
DROP TABLE IF EXISTS `marks_adjustment`;
CREATE TABLE `marks_adjustment` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`examination_type_id` int(11) default NULL,
`session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`course_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`original_marks` varchar(5) default NULL,
`adjusted_marks` varchar(5) default NULL,
`date_adjusted` datetime default NULL,
`adjusted_by` varchar(50) default NULL
) TYPE=InnoDB;
/*Table structure for table `marks_adjustment_cache` */
DROP TABLE IF EXISTS `marks_adjustment_cache`;
CREATE TABLE `marks_adjustment_cache` (
`student_id` int(11) default NULL,
`exam_roll_no` int(11) default NULL,
`examination_type_id` int(11) default NULL,
`session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`course_id` int(11) default NULL,
`course_offering_item_id` int(11) default NULL,
`original_marks` varchar(5) default NULL,
`adjusted_marks` varchar(5) default NULL,
`date_adjusted` datetime default NULL,
`adjusted_by` varchar(50) default NULL
) TYPE=InnoDB;
/*Table structure for table `matricdashboard` */
DROP TABLE IF EXISTS `matricdashboard`;
CREATE TABLE `matricdashboard` (
`dashboard_id` varchar(25) NOT NULL default '',
`matrics_id` varchar(25) NOT NULL default '',
PRIMARY KEY (`dashboard_id`,`matrics_id`)
) TYPE=InnoDB;
/*Table structure for table `matricsmgmt` */
DROP TABLE IF EXISTS `matricsmgmt`;
CREATE TABLE `matricsmgmt` (
`systemid` mediumint(9) NOT NULL auto_increment,
`id` varchar(25) NOT NULL default '',
`title` varchar(50) default NULL,
`description` varchar(200) default NULL,
`textdata` blob,
`numberdata` blob,
`numberdata2` blob,
`numberdata3` blob,
`legenddata1` varchar(50) default NULL,
`legenddata2` varchar(50) default NULL,
`legenddata3` varchar(50) default NULL,
`type` varchar(50) default NULL,
`subtype` varchar(50) default NULL,
`width` int(6) default NULL,
`height` int(6) default NULL,
`yaxis` varchar(100) default NULL,
`xaxis` varchar(100) default NULL,
`color` int(10) default NULL,
`transpose` varchar(25) default NULL,
`stacked` varchar(5) default NULL,
PRIMARY KEY (`systemid`,`id`),
UNIQUE KEY `systemid` (`systemid`)
) TYPE=InnoDB;
/*Table structure for table `menu` */
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`menu_id` int(10) NOT NULL auto_increment,
`menu_title` varchar(100) default NULL,
`comment` varchar(100) default NULL,
PRIMARY KEY (`menu_id`)
) TYPE=InnoDB;
/*Table structure for table `menu_item_function` */
DROP TABLE IF EXISTS `menu_item_function`;
CREATE TABLE `menu_item_function` (
`menu_item_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`function_id` int(10) default NULL,
PRIMARY KEY (`menu_item_id`)
) TYPE=InnoDB;
/*Table structure for table `menu_structure` */
DROP TABLE IF EXISTS `menu_structure`;
CREATE TABLE `menu_structure` (
`menu_id` int(10) NOT NULL default '0',
`menu_item_id` int(10) NOT NULL default '0',
PRIMARY KEY (`menu_id`,`menu_item_id`)
) TYPE=InnoDB;
/*Table structure for table `money_receipt` */
DROP TABLE IF EXISTS `money_receipt`;
CREATE TABLE `money_receipt` (
`money_receipt_id` int(10) NOT NULL auto_increment,
`demand_note_no` int(10) default NULL,
`demand_note_type` varchar(100) default NULL,
`total_amount` varchar(100) default NULL,
`receipt_date` datetime default NULL,
`receipt_by` varchar(100) default NULL,
PRIMARY KEY (`money_receipt_id`)
) TYPE=InnoDB;
/*Table structure for table `person_academic_details` */
DROP TABLE IF EXISTS `person_academic_details`;
CREATE TABLE `person_academic_details` (
`academic_id` int(10) NOT NULL auto_increment,
`person_id` int(10) NOT NULL default '0',
`name_examination_passed` varchar(100) default NULL,
`name_address_institution` varchar(100) default NULL,
`name_board_or_university` varchar(100) default NULL,
`subjects_taken` varchar(200) default NULL,
`marks_with_division` varchar(100) default NULL,
`year_of_passing` varchar(100) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`academic_id`,`person_id`)
) TYPE=InnoDB;
/*Table structure for table `person_details` */
DROP TABLE IF EXISTS `person_details`;
CREATE TABLE `person_details` (
`person_id` int(10) NOT NULL auto_increment,
`first_name` varchar(50) NOT NULL default '',
`middle_name` varchar(50) default NULL,
`last_name` varchar(50) NOT NULL default '',
`permanent_address` varchar(200) default NULL,
`present_address` varchar(200) default NULL,
`father_name` varchar(100) default NULL,
`mother_name` varchar(100) default NULL,
`telephone_number` varchar(50) default NULL,
`dob` datetime default NULL,
`gender` varchar(8) default NULL,
`mother_tongue` varchar(25) default NULL,
`nationality` varchar(25) default NULL,
`sc_st_physically_disabbled_sports` varchar(25) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`person_id`)
) TYPE=InnoDB;
/*Table structure for table `personnel_member` */
DROP TABLE IF EXISTS `personnel_member`;
CREATE TABLE `personnel_member` (
`personnel_id` int(10) NOT NULL auto_increment,
`person_id` int(10) default NULL,
`academic_unit_id` int(10) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`personnel_id`)
) TYPE=InnoDB;
/*Table structure for table `physician_details` */
DROP TABLE IF EXISTS `physician_details`;
CREATE TABLE `physician_details` (
`physician_id` int(11) NOT NULL auto_increment,
`physician_name` varchar(60) NOT NULL default '',
`physician_registration_no` varchar(60) default NULL,
`physician_address` varchar(100) default NULL,
`state` varchar(30) default NULL,
`type` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `portal_user_password` */
DROP TABLE IF EXISTS `portal_user_password`;
CREATE TABLE `portal_user_password` (
`user_id` varchar(25) NOT NULL default '',
`password` varchar(20) default NULL,
`access_allowed_till` datetime default NULL,
`password_aging` varchar(5) default NULL,
`created_by` varchar(50) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `portal_user_person_association` */
DROP TABLE IF EXISTS `portal_user_person_association`;
CREATE TABLE `portal_user_person_association` (
`user_id` varchar(25) NOT NULL default '',
`user_type` varchar(15) NOT NULL default '',
`person_id` int(11) NOT NULL default '0',
`associated_by` varchar(60) default NULL,
`association_date` datetime default NULL,
PRIMARY KEY (`user_id`)
) TYPE=InnoDB;
/*Table structure for table `program` */
DROP TABLE IF EXISTS `program`;
CREATE TABLE `program` (
`program_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`description` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`program_id`)
) TYPE=InnoDB;
/*Table structure for table `program_composition` */
DROP TABLE IF EXISTS `program_composition`;
CREATE TABLE `program_composition` (
`program_composition_item_id` int(11) NOT NULL auto_increment,
`program_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
PRIMARY KEY (`program_composition_item_id`)
) TYPE=InnoDB;
/*Table structure for table `program_course_association` */
DROP TABLE IF EXISTS `program_course_association`;
CREATE TABLE `program_course_association` (
`academic_unit_id` int(10) NOT NULL default '0',
`program_id` int(10) NOT NULL default '0',
`course_id` int(10) NOT NULL default '0',
`course_name` varchar(60) default NULL,
`course_description` varchar(60) default NULL,
PRIMARY KEY (`academic_unit_id`,`program_id`,`course_id`)
) TYPE=InnoDB;
/*Table structure for table `program_unit` */
DROP TABLE IF EXISTS `program_unit`;
CREATE TABLE `program_unit` (
`program_unit_id` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`duration` varchar(10) default NULL,
`description` varchar(100) default NULL,
`created_by` varchar(60) NOT NULL default '',
`creation_date` datetime default NULL,
`weightage` varchar(5) default '0',
PRIMARY KEY (`program_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_event` */
DROP TABLE IF EXISTS `promotion_event`;
CREATE TABLE `promotion_event` (
`promotion_event_id` mediumint(9) NOT NULL auto_increment,
`promotion_event_title` varchar(60) default NULL,
`faculty_id` int(11) default NULL,
`program_unit_id` int(11) default NULL,
`promotion_target_id` int(11) default NULL,
`promotion_processing_template_id` mediumint(9) default NULL,
PRIMARY KEY (`promotion_event_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_processing_template` */
DROP TABLE IF EXISTS `promotion_processing_template`;
CREATE TABLE `promotion_processing_template` (
`template_id` mediumint(9) NOT NULL auto_increment,
`title` varchar(60) default NULL,
`aggregate_percentage` int(6) default NULL,
`sesional_pass_mark` int(6) default NULL,
`max_no_of_supple` int(6) default NULL,
`supple_mark` int(6) default NULL,
`supple_clearing_marks` int(6) default NULL,
`allowed_pre_supple` int(1) default NULL,
PRIMARY KEY (`template_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_program_association` */
DROP TABLE IF EXISTS `promotion_program_association`;
CREATE TABLE `promotion_program_association` (
`promotion_program_item_id` int(11) NOT NULL auto_increment,
`promotion_unit_id` int(11) NOT NULL default '0',
`program_unit_id` int(11) NOT NULL default '0',
`comment` varchar(100) NOT NULL default '',
PRIMARY KEY (`promotion_program_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_result` */
DROP TABLE IF EXISTS `promotion_result`;
CREATE TABLE `promotion_result` (
`promotion_result_item_id` mediumint(9) NOT NULL auto_increment,
`promotion_event_id` mediumint(9) default NULL,
`exam_roll_no` int(11) default NULL,
`session_id` int(11) default NULL,
`status` varchar(20) default NULL,
`explanation` blob,
`student_id` int(11) default NULL,
PRIMARY KEY (`promotion_result_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_rule_application` */
DROP TABLE IF EXISTS `promotion_rule_application`;
CREATE TABLE `promotion_rule_application` (
`promotion_event_id` mediumint(9) default NULL,
`promotion_rule_item_id` mediumint(9) NOT NULL auto_increment,
`examination_type_id` int(11) default NULL,
`sequence` int(6) default NULL,
`sessional` varchar(6) default NULL,
`aggregate` varchar(6) default NULL,
`supplementary` varchar(6) default NULL,
`previous_process` varchar(6) default NULL,
PRIMARY KEY (`promotion_rule_item_id`)
) TYPE=InnoDB;
/*Table structure for table `promotion_unit` */
DROP TABLE IF EXISTS `promotion_unit`;
CREATE TABLE `promotion_unit` (
`promotion_unit_id` int(11) NOT NULL auto_increment,
`title` varchar(60) NOT NULL default '',
`description` varchar(100) default NULL,
`sequence` int(6) default '0',
`ranking_enabled` char(3) default 'No',
PRIMARY KEY (`promotion_unit_id`)
) TYPE=InnoDB;
/*Table structure for table `ranking_template` */
DROP TABLE IF EXISTS `ranking_template`;
CREATE TABLE `ranking_template` (
`ranking_template_id` mediumint(11) NOT NULL auto_increment,
`ranking_title` varchar(100) default NULL,
`percentage` int(3) default NULL,
PRIMARY KEY (`ranking_template_id`)
) TYPE=InnoDB;
/*Table structure for table `role` */
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` int(10) NOT NULL auto_increment,
`title` varchar(100) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`role_id`)
) TYPE=InnoDB;
/*Table structure for table `role_function` */
DROP TABLE IF EXISTS `role_function`;
CREATE TABLE `role_function` (
`role_id` int(10) NOT NULL default '0',
`function_id` int(10) NOT NULL default '0',
`changepermission` varchar(25) default NULL,
`comment` varchar(100) default NULL,
`date` datetime default NULL,
`entered_by` varchar(100) default NULL,
PRIMARY KEY (`role_id`,`function_id`)
) TYPE=InnoDB;
/*Table structure for table `role_hierarchy` */
DROP TABLE IF EXISTS `role_hierarchy`;
CREATE TABLE `role_hierarchy` (
`role_id` int(10) NOT NULL default '0',
`parent_role_id` int(10) NOT NULL default '0',
PRIMARY KEY (`parent_role_id`,`role_id`)
) TYPE=InnoDB;
/*Table structure for table `role_parameter` */
DROP TABLE IF EXISTS `role_parameter`;
CREATE TABLE `role_parameter` (
`parameter_id` int(10) NOT NULL auto_increment,
`role_id` int(10) default NULL,
`parameter_title` varchar(100) default NULL,
`parameter_type` varchar(100) default NULL,
PRIMARY KEY (`parameter_id`)
) TYPE=InnoDB;
/*Table structure for table `science_academic_information` */
DROP TABLE IF EXISTS `science_academic_information`;
CREATE TABLE `science_academic_information` (
`student_id` int(10) NOT NULL default '0',
`part` varchar(60) NOT NULL default '',
`year` varchar(60) default NULL,
`theoretical` int(11) default '0',
`practical` int(11) default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`part`)
) TYPE=InnoDB;
/*Table structure for table `science_academic_information_summary` */
DROP TABLE IF EXISTS `science_academic_information_summary`;
CREATE TABLE `science_academic_information_summary` (
`student_id` int(10) NOT NULL default '0',
`subject` varchar(60) default NULL,
`full_marks` int(11) NOT NULL default '0',
`marks_obtained` int(11) NOT NULL default '0',
`subject1` varchar(60) default NULL,
`subject2` varchar(60) default NULL,
`subject3` varchar(60) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`)
) TYPE=InnoDB;
/*Table structure for table `section` */
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
`section_id` int(11) NOT NULL auto_increment,
`section_name` varchar(60) NOT NULL default '',
`section_description` varchar(60) default NULL,
`created_by` varchar(60) default NULL,
`creation_date` datetime default NULL,
PRIMARY KEY (`section_id`)
) TYPE=InnoDB;
/*Table structure for table `semester_weightage_sgpa` */
DROP TABLE IF EXISTS `semester_weightage_sgpa`;
CREATE TABLE `semester_weightage_sgpa` (
`student_id` double default NULL,
`examination_type_id` double default NULL,
`curriculum_session` double default NULL,
`academic_unit_id` double default NULL,
`course_id` double default NULL,
`SemWgtSGPA` varchar(100) default NULL,
`col1` varchar(50) default NULL,
`col2` varchar(50) default NULL,
`col3` varchar(50) default NULL,
`col4` varchar(50) default NULL,
`col5` varchar(5) default NULL,
`col6` varchar(5) default NULL,
`col7` varchar(5) default NULL,
`col8` varchar(5) default NULL,
`col9` varchar(5) default NULL,
`col10` varchar(5) default NULL,
`col11` varchar(5) default NULL,
`col12` varchar(5) default NULL
) TYPE=MyISAM;
/*Table structure for table `student_employment_details` */
DROP TABLE IF EXISTS `student_employment_details`;
CREATE TABLE `student_employment_details` (
`student_id` int(10) NOT NULL default '0',
`name_firm_or_instituation` varchar(100) NOT NULL default '',
`nature_of_job` varchar(60) default NULL,
`start_date` datetime default NULL,
`to_date` datetime default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`name_firm_or_instituation`)
) TYPE=InnoDB;
/*Table structure for table `student_enrollment` */
DROP TABLE IF EXISTS `student_enrollment`;
CREATE TABLE `student_enrollment` (
`student_id` int(10) NOT NULL default '0',
`date_of_enrollment` datetime default NULL,
`muster_roll_number` varchar(50) NOT NULL default '',
`registration_no` varchar(60) default NULL,
`academic_session_id` int(11) default NULL,
`academic_unit_id` int(11) default NULL,
`program_id` int(11) default NULL,
`course_id` int(11) default NULL,
`form_no` varchar(60) default NULL,
`joint_rank_no` varchar(60) default NULL,
`joint_board_enrolment` varchar(60) default NULL,
`account_status` varchar(25) default NULL,
`sponsored_status` varchar(25) default NULL,
`day_or_night` varchar(25) default NULL,
`whether_wb_university` varchar(25) default NULL,
`faculty_id` int(11) default NULL,
`catagory` int(11) default NULL,
`batch` int(11) default NULL,
`user` varchar(50) default NULL,
`studentstatus` varchar(50) default NULL,
`marks_sheets_submit_by_student` varchar(60) default NULL,
`photo_submit_by_student` varchar(60) default NULL,
`income_submit_by_student` varchar(60) default NULL,
`cast_submit_by_student` varchar(60) default NULL,
`marrage_submit_by_student` varchar(60) default NULL,
`sponsership_submit_by_student` varchar(60) default NULL,
`resignation_submit_by_student` varchar(60) default NULL,
`qualification_submit_by_student` varchar(60) default NULL,
`ageprof_submit_by_student` varchar(60) default NULL,
`serial_no` int(10) default NULL,
PRIMARY KEY (`student_id`,`muster_roll_number`)
) TYPE=InnoDB;
/*Table structure for table `student_eyesight_details` */
DROP TABLE IF EXISTS `student_eyesight_details`;
CREATE TABLE `student_eyesight_details` (
`student_id` int(10) NOT NULL default '0',
`power_correcting_lens_left_eye` varchar(50) NOT NULL default '',
`power_correcting_lens_right_eye` varchar(50) default NULL,
`status_colour_blindness` varchar(60) NOT NULL default '',
`physician_id` int(10) NOT NULL default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `student_general_health_details` */
DROP TABLE IF EXISTS `student_general_health_details`;
CREATE TABLE `student_general_health_details` (
`student_id` int(10) NOT NULL default '0',
`weight` varchar(50) NOT NULL default '',
`height` varchar(50) default NULL,
`chest_measurements` varchar(60) NOT NULL default '',
`physician_id` int(10) NOT NULL default '0',
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`,`physician_id`)
) TYPE=InnoDB;
/*Table structure for table `student_login_time` */
DROP TABLE IF EXISTS `student_login_time`;
CREATE TABLE `student_login_time` (
`session_id` varchar(50) default NULL,
`student_id` varchar(25) default NULL,
`logged_in_at` datetime default NULL,
`logged_out_at` datetime default NULL
) TYPE=InnoDB;
/*Table structure for table `student_migration` */
DROP TABLE IF EXISTS `student_migration`;
CREATE TABLE `student_migration` (
`student_id` int(11) default NULL,
`migration_mc_no` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`user` varchar(100) default NULL,
PRIMARY KEY (`migration_mc_no`)
) TYPE=InnoDB;
/*Table structure for table `student_personal_details` */
DROP TABLE IF EXISTS `student_personal_details`;
CREATE TABLE `student_personal_details` (
`student_id` int(10) NOT NULL auto_increment,
`person_id` varchar(50) default NULL,
`gnameaddress` varchar(200) default NULL,
`relationshipguardian` varchar(50) default NULL,
`occupation` varchar(50) default NULL,
`annualincome` varchar(50) default NULL,
`pob` varchar(25) default NULL,
`district` varchar(25) default NULL,
`state` varchar(50) default NULL,
`minority` varchar(25) default NULL,
`applicantuniversity` varchar(25) default NULL,
`user` varchar(50) default NULL,
PRIMARY KEY (`student_id`)
) TYPE=InnoDB;
/*Table structure for table `stuednt_grade` */
DROP TABLE IF EXISTS `stuednt_grade`;
CREATE TABLE `stuednt_grade` (
`grading_structure_id` mediumint(9) default NULL,
`exam_roll_no` varchar(25) default NULL,
`name` varchar(50) default NULL,
`class_roll` varchar(50) default NULL,
`reg_no` varchar(50) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` int(3) default NULL
) TYPE=InnoDB;
/*Table structure for table `subject` */
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject` (
`subject_id` int(11) NOT NULL auto_increment,
`subject_name` varchar(200) default NULL,
`subject_code` varchar(30) default NULL,
PRIMARY KEY (`subject_id`)
) TYPE=InnoDB;
/*Table structure for table `subject_curriculum` */
DROP TABLE IF EXISTS `subject_curriculum`;
CREATE TABLE `subject_curriculum` (
`subject_curriculum_id` int(11) NOT NULL auto_increment,
`subject_id` int(11) NOT NULL default '0',
`lec_per_week` int(11) NOT NULL default '0',
`tut_per_week` int(11) NOT NULL default '0',
`sessional_per_week` int(11) NOT NULL default '0',
`full_marks` int(11) NOT NULL default '0',
`syllabus` blob,
`assessment_template_id` int(11) NOT NULL default '0',
`credit_hours` int(11) NOT NULL default '0',
`elective` char(3) default 'No',
`base_subject` int(11) default '0',
PRIMARY KEY (`subject_curriculum_id`)
) TYPE=InnoDB;
/*Table structure for table `subject_grade` */
DROP TABLE IF EXISTS `subject_grade`;
CREATE TABLE `subject_grade` (
`exam_roll_no` varchar(25) default NULL,
`course_offering_item_id` int(11) default NULL,
`grade` char(2) default NULL,
`marks` varchar(4) default NULL,
`status` varchar(20) default NULL,
`exam_instance_id` int(11) default NULL,
`student_id` int(11) default NULL,
`session_id` int(11) default NULL
) TYPE=InnoDB;
/*Table structure for table `subject_syllabus_association` */
DROP TABLE IF EXISTS `subject_syllabus_association`;
CREATE TABLE `subject_syllabus_association` (
`academic_session_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
`syllabus_id` int(11) NOT NULL default '0',
`association_date` datetime default NULL,
PRIMARY KEY (`academic_session_id`,`subject_id`,`syllabus_id`)
) TYPE=InnoDB;
/*Table structure for table `supplementary_subject_processing` */
DROP TABLE IF EXISTS `supplementary_subject_processing`;
CREATE TABLE `supplementary_subject_processing` (
`promotion_event_id` mediumint(9) default NULL,
|
|
|
Goto Forum:
Current Time: Mon May 12 22:27:12 EDT 2025
Powered by FUDForum. Page generated in 0.03732 seconds |
Home