Table Layouts

HomeTable Layouts

Table Name Fiel Name Data Type Character Length Accept Null Values Primary Key Foreign Key Default Unique Key Description Created Date Storage Location Remarks
Branch_Subject_Division_Year id INT 11 Yes Yes No Contains Id also Primary key of table
school_id VARCHAR 20 No No No Null Contains School id
CourseLevelPID VARCHAR 20 No No No Null
DeptID VARCHAR 20 No No No Null Department Id of member
BranchID VARCHAR 20 No No No Null Branch Id of member
SemesterID VARCHAR 20 No No No Null Semester Id of member
DevisionId VARCHAR 20 No No No Null
Intruduce_YeqarID VARCHAR 20 No No No Null
SubjectTitle VARCHAR 200 No No No Null
SubjectCode VARCHAR 50 No No No Null
SubjectType VARCHAR 20 No No No Null
SubjectShortName VARCHAR 20 No No No Null
IsEnable VARCHAR 10 No No No Null
UpdatedBy VARCHAR 30 No No No Null
CourseLevel VARCHAR 20 No No No Null
DeptName VARCHAR 100 No No No Null
BranchName VARCHAR 100 No No No Null
SemesterName VARCHAR 30 No No No Null
DivisionName VARCHAR 50 No No No Null
Year VARCHAR 20 No No No Null
ExtSemesterId VARCHAR 100 No No No Null
ExtSchoolSubjectId VARCHAR 100 No No No Null
ExtYearID VARCHAR 100 No No No Null
ExtBranchId VARCHAR 100 No No No Null
ExtDivisionID VARCHAR 100 No No No Null
ExtDeptId VARCHAR 100 No No No Null
upload_date DATETIME No No No Null
uploaded_by VARCHAR 50 No No No Null
batch_id VARCHAR 255 No No No Null
Class id INT 11 Yes Yes No
class VARCHAR 100 No No No Null
ExtClassID VARCHAR 20 No No No Null
school_id VARCHAR 100 No No No Null
school_staff_id INT 10 No No No Null
course_level VARCHAR 20 No No No Null
batch_id VARCHAR 60 No No No Null
DTE_college_list id INT 11 Yes Yes No
college_code VARCHAR 30 No No No NULL
stream TEXT No No No NULL
college_name VARCHAR 50 No No No NULL
college_location VARCHAR 30 No No No NULL
intake VARCHAR 50 No No No NULL
principal_name VARCHAR 30 No No No NULL
contact_number VARCHAR 30 No No No NULL
alternate_contact VARCHAR 30 No No No NULL
college_email VARCHAR 30 No No No NULL
tpo_name VARCHAR 30 No No No NULL
tpo_contact VARCHAR 30 No No No NULL
tpo_email VARCHAR 30 No No No NULL
number_of_teachers VARCHAR 30 No No No NULL
number_of_students VARCHAR 30 No No No NULL
number_of_subjects VARCHAR 20 No No No NULL
date_Updated DATETIME No No No NULL
source VARCHAR 30 No No No NULL
Division id INT 11 Yes Yes No
ExtDivisionID INT 11 No No No NULL
DivisionName VARCHAR 100 No No No NULL
school_id VARCHAR 120 No No No NULL
batch_id VARCHAR 255 No No No NULL
EmployeeImages EmployeeRegCode VARCHAR 20 No No No NULL
EmployeeName VARCHAR 100 No No No NULL
Image LONGBLOB No No No NULL
Institution_directory inst_id INT 11 Yes Yes No
state VARCHAR 50 No No No NULL
district VARCHAR 50 No No No NULL
university_type VARCHAR 50 No No No NULL
university_name VARCHAR 100 No No No NULL
college_name VARCHAR 100 No No No NULL
college_type VARCHAR 50 No No No NULL
address VARCHAR 100 No No No NULL
website VARCHAR 50 No No No NULL
management VARCHAR 50 No No No NULL
year_of_establishment VARCHAR 50 No No No NULL
specialised_in VARCHAR 50 No No No NULL
location VARCHAR 30 No No No NULL
upload_year VARCHAR 15 No No No NULL
country_id VARCHAR 20 No No No NULL
type VARCHAR 20 No No No NULL
test VARCHAR 45 No No No NULL
contact VARCHAR 100 No No No NULL
college_email VARCHAR 100 No No No NULL
source VARCHAR 45 No No No NULL
calculated_lat DOUBLE No No No NULL
calculated_lon DOUBLE No No No NULL
GPS_lat DOUBLE No No No NULL
GPS_lon DOUBLE No No No NULL
college_code VARCHAR 45 No No No NULL
stream VARCHAR 45 No No No NULL
intake VARCHAR 45 No No No NULL
principal_name VARCHAR 45 No No No NULL
tpo_name VARCHAR 45 No No No NULL
tpo_contact VARCHAR 45 No No No NULL
tpo_email VARCHAR 45 No No No NULL
number_of_teachers VARCHAR 45 No No No NULL
number_of_students VARCHAR 45 No No No NULL
number_of_subjects VARCHAR 45 No No No NULL
date_Updated DATETIME No No No NULL
PicklistHeader id INT 11 Yes Yes No
school_id VARCHAR 20 No No No NULL
PicklistID VARCHAR 20 No No No NULL
PicklistName VARCHAR 40 No No No NULL
Description VARCHAR 60 No No No NULL
IsEnabled VARCHAR 20 No No No NULL
IsApproved VARCHAR 20 No No No NULL
IsAppRejected VARCHAR 20 No No No NULL
AppComment VARCHAR 20 No No No NULL
IsFreezed VARCHAR 20 No No No NULL
CreatedBy VARCHAR 20 No No No NULL
CreatedOn DATETIME No No No NULL
ModifiedBy VARCHAR 20 No No No NULL
ModifiedOn DATETIME No No No NULL
IsArchived VARCHAR 20 No No No NULL
ScanningReport ID INT 11 Yes Yes No
batch_id VARCHAR 60 No No No NULL
DateTimeStamp TIMESTAMP Yes No No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
ErrorText VARCHAR 500 No No No NULL
ErrorCount INT 11 No No No NULL
StudentSemesterRecord id INT 11 Yes Yes No
student_id VARCHAR 100 Yes No No
ExtYearID VARCHAR 20 Yes No No
ExtDivisionID VARCHAR 50 Yes No No
ExtSemesterId VARCHAR 50 Yes No No
ExtBranchId VARCHAR 50 Yes No No
ExtDeptId VARCHAR 50 Yes No No
ExtCourseLevelID VARCHAR 50 Yes No No
SemesterScore VARCHAR 20 No No No NULL
DivisionId VARCHAR 20 No No No NULL
Semesterid VARCHAR 20 No No No NULL
BranchId VARCHAR 20 No No No NULL
DepartmentId VARCHAR 20 No No No NULL
AcademicYearId VARCHAR 10 No No No NULL
school_id VARCHAR 50 No No No NULL
UpdatedBy VARCHAR 30 No No No NULL
IsCurrentSemester VARCHAR 5 No No No NULL
BranchName VARCHAR 50 No No No NULL
Specialization VARCHAR 50 No No No NULL
DeptName VARCHAR 50 No No No NULL
CourseLevel VARCHAR 20 No No No NULL
SemesterName VARCHAR 50 No No No NULL
AcdemicYear VARCHAR 10 No No No NULL
DivisionName VARCHAR 30 No No No NULL
Academic_Score VARCHAR 20 No No No NULL
batch_id VARCHAR 60 Yes No No
Tbl_proud_points_log Proud_id INT 11 Yes Yes No
Parent_member_id INT 50 No No No NULL
Proud_Points INT 5 No No No NULL
Teacher_member_id VARCHAR 50 No No No NULL
Student_member_id VARCHAR 50 No No No NULL
Reason VARCHAR 100 No No No NULL
Comment VARCHAR 100 No No No NULL
Point_datestamp DATETIME No No No NULL
aicte_ACR_activity_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_all_feedback_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
scadmin_state VARCHAR 45 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_college_info id INT 11 Yes Yes No
college_id VARCHAR 50 Yes No No
college_name VARCHAR 255 Yes No No
apply_id VARCHAR 50 Yes No No
aicte_id VARCHAR 255 Yes No No
impliment_date DATE No No No NULL
informer_name VARCHAR 150 Yes No No
informer_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
designation VARCHAR 50 Yes No No
email_id VARCHAR 255 No No No NULL
phone_no VARCHAR 20 No No No NULL
erp_incharge_nm VARCHAR 150 No No No NULL
erp_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
erp_incharge_mob VARCHAR 20 No No No NULL
erp_incharge_email VARCHAR 150 No No No NULL
it_incharge_nm VARCHAR 150 No No No NULL
it_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
it_incharge_mob VARCHAR 20 No No No NULL
it_incharge_email VARCHAR 150 No No No NULL
aicte_incharge_nm VARCHAR 150 No No No NULL
aicte_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
aicte_incharge_mob VARCHAR 20 No No No NULL
aicte_incharge_email VARCHAR 150 No No No NULL
tpo_incharge_nm VARCHAR 150 No No No NULL
tpo_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
tpo_incharge_mob VARCHAR 20 No No No NULL
tpo_incharge_email VARCHAR 150 No No No NULL
art_incharge_nm VARCHAR 150 No No No NULL
art_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
art_incharge_mob VARCHAR 20 No No No NULL
art_incharge_email VARCHAR 150 No No No NULL
student_incharge_nm VARCHAR 150 No No No NULL
student_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
student_incharge_mob VARCHAR 20 No No No NULL
student_incharge_email VARCHAR 150 No No No NULL
admin_incharge_nm VARCHAR 150 No No No NULL
admin_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
admin_incharge_mob VARCHAR 20 No No No NULL
admin_incharge_email VARCHAR 150 No No No NULL
exam_incharge_nm VARCHAR 150 No No No NULL
exam_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
exam_incharge_mob VARCHAR 20 No No No NULL
exam_incharge_email VARCHAR 150 No No No NULL
nss_incharge_nm VARCHAR 150 No No No NULL
nss_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
nss_incharge_mob VARCHAR 20 No No No NULL
nss_incharge_email VARCHAR 150 No No No NULL
ncc_incharge_nm VARCHAR 150 No No No NULL
ncc_incharge_mob VARCHAR 20 No No No NULL
ncc_incharge_email VARCHAR 150 No No No NULL
abvp_incharge_nm VARCHAR 150 No No No NULL
abvp_incharge_mob VARCHAR 20 No No No NULL
abvp_incharge_email VARCHAR 150 No No No NULL
nsui_incharge_nm VARCHAR 150 No No No NULL
nsui_incharge_mob VARCHAR 20 No No No NULL
nsui_incharge_email VARCHAR 150 No No No NULL
reg_date TIMESTAMP No No No CURRENT_TIMESTAMP
placement_help VARCHAR 10 No No No NULL
placement_incharge_nm VARCHAR 150 No No No NULL
placement_meet_date DATETIME No No No ‘0000-00-00 00:00:00’
sports_incharge_nm VARCHAR 150 No No No NULL
sports_incharge_mob VARCHAR 20 No No No NULL
sports_incharge_email VARCHAR 150 No No No NULL
sports_meet_date DATETIME No No No NULL
placement_incharge_mob VARCHAR 20 No No No NULL
placement_incharge_email VARCHAR 150 No No No NULL
aicte_cont_to_society_activity_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_dept_activity_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
 aicte_email_setup id INT 3 Yes Yes No
email_id INT 5 No No No ‘0’
email_template_id INT 11 No No No NULL
sms_template_id INT 11 No No No ‘0’
group_member_id INT 11 No No No NULL
created_date TIMESTAMP No No No CURRENT_TIMESTAMP
is_active INT 2 No No No ‘0’
aicte_ind_ACR_activity_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_ind_contToSoc_activity_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_ind_dept_activity_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_ind_feedback_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
scadmin_state VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
group_member_id VARCHAR 255 No No No NULL
aicte_ind_inst_activity_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_ind_student_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_ind_teaching_process_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
dept_name VARCHAR 50 No No No NULL
teacher_id VARCHAR 50 No No No NULL
teacher_name VARCHAR 50 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_institute_activity_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_student_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
aicte_teaching_process_feedback_all_summary_report id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
school_name VARCHAR 150 No No No NULL
teaching_process VARCHAR 50 No No No NULL
student_feedback VARCHAR 50 No No No NULL
dept_activity VARCHAR 50 No No No NULL
inst_activity VARCHAR 50 No No No NULL
acr VARCHAR 50 No No No NULL
cont_society VARCHAR 50 No No No NULL
total_on_100 VARCHAR 50 No No No NULL
total_on_scale_10 VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
all_india_college_list id VARCHAR 11 Yes No No ‘0’
college_code VARCHAR 50 No No No NULL
college_name VARCHAR 255 No No No NULL
college_address VARCHAR 255 No No No NULL
Principle_name VARCHAR 50 No No No NULL
contact_no VARCHAR 50 No No No NULL
college_email VARCHAR 50 No No No NULL
tpo_email VARCHAR 50 No No No NULL
tpo_pno VARCHAR 15 No No No NULL
tpo_name VARCHAR 255 No No No NULL
no_of_teacher VARCHAR 15 No No No NULL
no_of_student VARCHAR 15 No No No NULL
number_of_sub VARCHAR 15 No No No NULL
website VARCHAR 50 No No No NULL
college_type VARCHAR 20 No No No NULL
state VARCHAR 50 No No No NULL
district VARCHAR 50 No No No NULL
from_source VARCHAR 50 No No No NULL
blog BlogID INT 10 Yes Yes No
BlogTitle VARCHAR 25 No No No NULL
Description TEXT No No No NULL
featureimage VARCHAR 50 No No No NULL
MemberID INT 50 No No No NULL
EntityType INT 10 No No No NULL
PRN_TID INT 11 No No No NULL
SchoolID VARCHAR 50 No No No NULL
cnt_likes INT 50 No No No NULL
avg_star_cnt INT 50 No No No NULL
name VARCHAR 100 No No No NULL
date DATETIME No No No NULL
activity_id VARCHAR 255 No No No NULL
activity_type VARCHAR 45 No No No NULL
activity VARCHAR 45 No No No NULL
rating INT 11 No No No NULL
g_stu_PRN VARCHAR 45 No No No NULL
g_stu_school_id VARCHAR 45 No No No NULL
cart id INT 11 Yes Yes No
Member_ID VARCHAR 100 No No No NULL
entity_id INT 11 No No No NULL
user_id INT 11 No No No NULL
coupon_id INT 11 No No No NULL
for_points INT 11 No No No NULL
timestamp TIMESTAMP No No No CURRENT_TIMESTAMP
available_points INT 11 No No No NULL
categories id INT 11 Yes Yes No
category VARCHAR 30 No No No NULL
DefaultCategoryImage VARCHAR 100 No No No NULL
ci_sessions id VARCHAR 40 Yes Yes No ‘0’
ip_address VARCHAR 45 No No No ‘0’
user_agent VARCHAR 120 No No No NULL
last_activity INT 10 No No No ‘0’
data TEXT No No No NULL
timestamp VARCHAR 250 No No No NULL
currencies id INT 11 Yes Yes No
currency VARCHAR 20 No No No NULL
error_import_student_points id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
sc_teacher_id VARCHAR 50 No No No NULL
sc_stud_id VARCHAR 50 No No No NULL
sc_entites_id VARCHAR 50 No No No NULL
sc_studentpointlist_id VARCHAR 50 No No No NULL
method VARCHAR 10 No No No NULL
judgement VARCHAR 100 No No No NULL
marks VARCHAR 50 No No No NULL
grade VARCHAR 50 No No No NULL
percentile VARCHAR 50 No No No NULL
outof VARCHAR 50 No No No NULL
points VARCHAR 50 No No No NULL
activity_type VARCHAR 50 No No No NULL
old_point_date VARCHAR 50 No No No NULL
error_code VARCHAR 255 No No No NULL
batch_no VARCHAR 50 No No No NULL
point_date DATETIME Yes No No
game_master id INT 11 Yes Yes No
game_id VARCHAR 255 No No No NULL
game_name VARCHAR 255 No No No NULL
school_id VARCHAR 255 No No No NULL
mobile_no VARCHAR 255 No No No NULL
sc_member_id VARCHAR 255 No No No NULL
member_type VARCHAR 255 No No No NULL
user_name_game VARCHAR 255 No No No NULL
exp VARCHAR 255 No No No NULL
levels VARCHAR 255 No No No NULL
kills VARCHAR 255 No No No NULL
badges VARCHAR 255 No No No NULL
current_score VARCHAR 255 No No No NULL
email VARCHAR 255 No No No NULL
no_of_points VARCHAR 255 No No No NULL
image_name VARCHAR 255 No No No NULL
device_id VARCHAR 255 No No No NULL
mac_address VARCHAR 255 No No No NULL
update_date DATETIME No No No NULL
stard_time DATETIME No No No NULL
end_time DATETIME No No No NULL
import_student_points id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
sc_teacher_id VARCHAR 50 No No No NULL
sc_stud_id VARCHAR 50 No No No NULL
sc_entites_id VARCHAR 50 No No No NULL
sc_studentpointlist_id VARCHAR 50 No No No NULL
method VARCHAR 10 No No No NULL
judgement VARCHAR 100 No No No NULL
marks VARCHAR 50 No No No NULL
grade VARCHAR 50 No No No NULL
percentile VARCHAR 100 No No No NULL
outof VARCHAR 50 No No No NULL
points VARCHAR 50 No No No NULL
activity_type VARCHAR 50 No No No NULL
old_point_date VARCHAR 50 No No No NULL
batch_no VARCHAR 50 No No No NULL
point_date DATETIME Yes No No
parent_gcmid id INT 11 Yes Yes No
parent_id INT 11 No No No NULL
gcm_id TEXT No No No NULL
type VARCHAR 15 No No No NULL
picklistValue id INT 11 Yes Yes No
school_id VARCHAR 20 No No No NULL
PicklistValueID VARCHAR 20 No No No NULL
PicklistValueName VARCHAR 40 No No No NULL
PicklistValueCode VARCHAR 20 No No No NULL
PicklistID VARCHAR 20 No No No NULL
Description VARCHAR 40 No No No NULL
IsEnabled VARCHAR 20 No No No NULL
IsApproved VARCHAR 20 No No No NULL
IsAppRejected VARCHAR 20 No No No NULL
AppComment VARCHAR 20 No No No NULL
IsFreezed VARCHAR 20 No No No NULL
IsArchived VARCHAR 20 No No No NULL
IsConfigured VARCHAR 20 No No No NULL
CreatedBy VARCHAR 40 No No No NULL
old_CreatedOn VARCHAR 20 No No No NULL
ModifiedBy VARCHAR 40 No No No NULL
old_ModifiedOn VARCHAR 20 No No No NULL
CreatedOn DATETIME Yes No No
ModifiedOn DATETIME Yes No No
purcheseSoftreward id INT 50 Yes Yes No
Member_ID VARCHAR 50 No No No NULL
user_id VARCHAR 100 No No No NULL
userType VARCHAR 100 No No No NULL
school_id VARCHAR 50 No No No NULL
reward_id VARCHAR 50 No No No NULL
point VARCHAR 75 No No No NULL
date TIMESTAMP No No No CURRENT_TIMESTAMP
raw_Branch_Subject_Division_Year id INT 11 Yes Yes No
school_id VARCHAR 20 Yes No No
ExtSemesterId INT 11 No No No NULL
ExtBranchId INT 11 No No No NULL
ExtDivisionID INT 11 No No No NULL
ExtDeptId INT 11 No No No NULL
ExtSchoolSubjectId INT 11 No No No NULL
ExtYearID INT 11 No No No NULL
CourseLevelPID VARCHAR 20 No No No NULL
DeptID VARCHAR 20 No No No NULL
BranchID VARCHAR 20 No No No NULL
SemesterID VARCHAR 20 No No No NULL
DevisionId VARCHAR 20 No No No NULL
Intruduce_YeqarID VARCHAR 20 No No No NULL
SubjectTitle VARCHAR 200 Yes No No
SubjectCode VARCHAR 50 Yes No No
SubjectType VARCHAR 20 Yes No No
SubjectShortName VARCHAR 20 Yes No No
IsEnable VARCHAR 10 Yes No No
UpdatedBy VARCHAR 30 Yes No No
CourseLevel VARCHAR 20 Yes No No
DeptName VARCHAR 100 Yes No No
BranchName VARCHAR 100 Yes No No
SemesterName VARCHAR 100 Yes No No
DivisionName VARCHAR 100 Yes No No
Year VARCHAR 20 Yes No No
status VARCHAR 100 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 20 No No No NULL
validity VARCHAR 20 No No No NULL
Branch_Subject_Division_Year_ID INT 11 No No No NULL
upload_date DATETIME Yes No No
raw_Class id INT 11 Yes Yes No
class VARCHAR 100 No No No NULL
ExtClassID VARCHAR 20 No No No NULL
school_id VARCHAR 20 Yes No No
school_staff_id INT 10 No No No NULL
course_level VARCHAR 20 No No No NULL
status VARCHAR 20 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 20 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_Division id INT 11 Yes Yes No
ExtDivisionID INT 11 No No No NULL
DivisionName VARCHAR 100 No No No NULL
school_id VARCHAR 20 Yes No No
status VARCHAR 20 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_StudentSemesterRecord id INT 11 Yes Yes No
student_id VARCHAR 100 Yes No No
ExtYearID VARCHAR 20 No No No NULL
ExtDivisionID VARCHAR 20 No No No NULL
ExtSemesterId VARCHAR 20 No No No NULL
ExtBranchId VARCHAR 20 No No No NULL
ExtDeptId VARCHAR 20 No No No NULL
ExtCourseLevelID VARCHAR 20 No No No NULL
SemesterScore VARCHAR 20 No No No NULL
DivisionId VARCHAR 20 No No No NULL
Semesterid VARCHAR 20 No No No NULL
BranchId VARCHAR 60 No No No NULL
DepartmentId VARCHAR 20 No No No NULL
AcademicYearId VARCHAR 10 No No No NULL
school_id VARCHAR 50 No No No NULL
UpdatedBy VARCHAR 30 No No No NULL
IsCurrentSemester VARCHAR 5 No No No NULL
BranchName VARCHAR 50 No No No NULL
Specialization VARCHAR 50 No No No NULL
DeptName VARCHAR 50 No No No NULL
CourseLevel VARCHAR 20 No No No NULL
SemesterName VARCHAR 50 No No No NULL
AcdemicYear VARCHAR 10 No No No NULL
DivisionName VARCHAR 10 No No No NULL
Academic_Score VARCHAR 20 No No No NULL
status VARCHAR 20 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 20 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_CourseLevel id INT 11 Yes Yes No
ExtCourseLevelID VARCHAR 20 No No No NULL
CourseLevel VARCHAR 30 No No No NULL
school_id VARCHAR 20 No No No NULL
status VARCHAR 255 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_academic_Year id INT 11 Yes Yes No
ExtYearID INT 11 No No No NULL
Academic_Year VARCHAR 20 No No No NULL
Year VARCHAR 20 No No No NULL
school_id VARCHAR 50 No No No NULL
Enable VARCHAR 5 No No No NULL
status VARCHAR 255 No No No NULL
old_upload_date VARCHAR 40 No No No NULL
uploaded_by VARCHAR 40 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 15 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_branch_master id INT 11 Yes Yes No
ExtBranchId INT 15 No No No NULL
branch_id VARCHAR 60 Yes No No
branch_Name VARCHAR 50 No No No NULL
Specialization VARCHAR 100 No No No NULL
Branch_code VARCHAR 20 No No No NULL
Course_Name VARCHAR 50 No No No NULL
degree_code VARCHAR 50 No No No NULL
Duration VARCHAR 10 No No No NULL
Dept_Id VARCHAR 10 No No No NULL
DepartmentName VARCHAR 100 No No No NULL
school_id VARCHAR 50 Yes No No
IsEnabled VARCHAR 50 No No No NULL
status VARCHAR 255 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 20 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_class_subject_master id INT 11 Yes Yes No
class VARCHAR 50 No No No NULL
class_id VARCHAR 50 No No No NULL
subject_name VARCHAR 150 No No No NULL
subject_id VARCHAR 150 No No No NULL
subject_type VARCHAR 150 No No No NULL
subject_short_name VARCHAR 150 No No No NULL
subject_credit VARCHAR 150 No No No NULL
semester_id VARCHAR 150 No No No NULL
semester VARCHAR 150 No No No NULL
branch_id VARCHAR 250 No No No NULL
branch VARCHAR 250 No No No NULL
dept_id VARCHAR 250 No No No NULL
department VARCHAR 250 No No No NULL
school_id VARCHAR 150 No No No NULL
course_level VARCHAR 50 No No No NULL
academic_year VARCHAR 50 No No No NULL
academic_yearID VARCHAR 50 No No No NULL
batch_id VARCHAR 150 No No No NULL
uploaded_by VARCHAR 45 No No No NULL
uploaded_date DATETIME No No No NULL
subject_code VARCHAR 50 No No No NULL
status VARCHAR 50 No No No NULL
upload_date DATETIME No No No NULL
validity VARCHAR 50 No No No NULL
raw_tbl_degree_master id INT 11 Yes Yes No
Degee_name VARCHAR 50 No No No NULL
ExtDegreeID VARCHAR 20 No No No NULL
Degree_code VARCHAR 10 No No No NULL
course_level VARCHAR 50 No No No NULL
school_id VARCHAR 20 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
status VARCHAR 255 No No No NULL
raw_tbl_department_master id INT 11 Yes Yes No
Dept_code VARCHAR 20 No No No NULL
Dept_Name VARCHAR 100 No No No NULL
ExtDeptId VARCHAR 20 No No No NULL
Establiment_Year VARCHAR 10 No No No NULL
PhoneNo VARCHAR 30 No No No NULL
FaxNo VARCHAR 30 No No No NULL
Email_Id VARCHAR 50 No No No NULL
School_ID VARCHAR 20 No No No NULL
Is_Enabled TINYINT 1 No No No NULL
status VARCHAR 255 No No No NULL
old_upload_date VARCHAR 40 No No No NULL
uploaded_by VARCHAR 50 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 15 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_school_subject id INT 11 Yes Yes No
ExtSchoolSubjectId INT 15 No No No NULL
subject_id VARCHAR 50 No No No NULL
Branch_ID VARCHAR 10 No No No NULL
subject VARCHAR 100 No No No NULL
school_id VARCHAR 20 No No No NULL
school_staff_id VARCHAR 10 No No No NULL
Subject_Code VARCHAR 20 No No No NULL
Semester_id VARCHAR 15 No No No NULL
Year_ID VARCHAR 10 No No No NULL
Degree_name VARCHAR 50 No No No NULL
Subject_type VARCHAR 30 No No No NULL
subject_credit INT 10 No No No NULL
Course_Level_PID VARCHAR 20 No No No NULL
Dept_id VARCHAR 70 No No No NULL
Subject_short_name VARCHAR 40 No No No NULL
status VARCHAR 20 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 20 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 20 No No No NULL
upload_date DATETIME Yes No No
raw_tbl_semester_master Semester_Id INT 11 Yes Yes No
ExtSemesterId INT 15 No No No NULL
Semester_Name VARCHAR 50 No No No NULL
ExtBranchId INT 15 No No No NULL
Branch_ID INT 11 No No No NULL
Branch_name VARCHAR 100 No No No NULL
Semester_credit VARCHAR 30 No No No NULL
Is_regular_semester VARCHAR 10 No No No NULL
Year_Id VARCHAR 10 No No No NULL
Semester_start_Date VARCHAR 20 No No No NULL
Semester_End_date VARCHAR 20 No No No NULL
Dept_Id VARCHAR 20 No No No NULL
Department_Name VARCHAR 100 No No No NULL
school_id VARCHAR 50 No No No NULL
Is_enable VARCHAR 20 No No No NULL
CourseLevel VARCHAR 30 No No No NULL
class VARCHAR 50 No No No NULL
status VARCHAR 255 No No No NULL
old_upload_date VARCHAR 20 No No No NULL
uploaded_by VARCHAR 40 No No No NULL
batch_id VARCHAR 60 No No No NULL
validity VARCHAR 15 No No No NULL
upload_date DATETIME Yes No No
referral_activity_log referral_tracking_id INT 11 Yes Yes No
sender_member_id VARCHAR 50 No No No NULL
sender_user_type VARCHAR 45 No No No NULL
receiver_country_code INT 11 No No No NULL
receiver_mobile_number VARCHAR 40 No No No NULL
receiver_email_id VARCHAR 45 No No No NULL
old_invitation_sent_datestamp VARCHAR 100 No No No NULL
acceptance_flag VARCHAR 45 No No No NULL
old_accepted_datestamp VARCHAR 100 No No No NULL
receiver_member_id VARCHAR 50 No No No NULL
method VARCHAR 45 No No No NULL
receiver_user_type VARCHAR 45 No No No NULL
firstname VARCHAR 45 Yes No No
middlename VARCHAR 45 Yes No No
lastname VARCHAR 45 Yes No No
point VARCHAR 45 Yes No No ‘0’
referral_id INT 11 Yes No No
invitation_sent_datestamp DATETIME Yes No No
accepted_datestamp DATETIME Yes No No
referral_activity_reasons id INT 11 Yes Yes No
reason VARCHAR 45 No No No NULL
reason_id INT 5 No No No NULL
row_all_india_college_list id VARCHAR 11 No No No NULL
college_code VARCHAR 50 No No No NULL
college_name VARCHAR 255 No No No NULL
college_address VARCHAR 255 No No No NULL
Principle_name VARCHAR 50 No No No NULL
contact_no VARCHAR 50 No No No NULL
college_email VARCHAR 50 No No No NULL
tpo_email VARCHAR 50 No No No NULL
tpo_pno VARCHAR 15 No No No NULL
tpo_name VARCHAR 255 No No No NULL
no_of_teacher VARCHAR 15 No No No NULL
no_of_student VARCHAR 15 No No No NULL
number_of_sub VARCHAR 15 No No No NULL
website VARCHAR 50 No No No NULL
college_type VARCHAR 20 No No No NULL
state VARCHAR 50 No No No NULL
district VARCHAR 50 No No No NULL
from_source VARCHAR 50 No No No NULL
upload_date DATETIME No No No NULL
uploaded_by VARCHAR 45 No No No NULL
batch_id VARCHAR 45 No No No NULL
validity VARCHAR 45 No No No NULL
rule_engine_for_referral_activity id INT 11 Yes Yes No
from_user VARCHAR 45 No No No NULL
From_entityid INT 5 No No No NULL
to_user VARCHAR 45 No No No NULL
To_entityid INT 5 No No No NULL
points FLOAT No No No NULL
referal_reason VARCHAR 45 No No No NULL
referal_reason_id INT 5 No No No NULL
group_member_id VARCHAR 45 No No No NULL
school_id VARCHAR 45 No No No NULL
school_type VARCHAR 50 No No No NULL
is_enable INT 3 No No No NULL
datestamp DATETIME No No No NULL
school_rule_engine id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
blue_points_teacher VARCHAR 10 No No No NULL
water_points VARCHAR 10 No No No NULL
brown_points VARCHAR 10 No No No NULL
parent_to_teacher VARCHAR 10 No No No NULL
parent_to_student VARCHAR 10 No No No NULL
student_share_points VARCHAR 10 No No No NULL
teacher_share_points VARCHAR 10 No No No NULL
sponsor_coupon VARCHAR 10 No No No NULL
parent_proud_points VARCHAR 10 No No No NULL
softreward softrewardId INT 10 Yes Yes No
user VARCHAR 50 No No No NULL
rewardType VARCHAR 50 No No No NULL
fromRange VARCHAR 100 No No No NULL
imagepath VARCHAR 100 No No No NULL
sport_school_all_details id INT 11 Yes Yes No
ac_year VARCHAR 50 No No No NULL
state_name VARCHAR 50 No No No NULL
district_code VARCHAR 50 No No No NULL
district_name VARCHAR 50 No No No NULL
blkcd VARCHAR 50 No No No NULL
blkname VARCHAR 50 No No No NULL
clucd VARCHAR 50 No No No NULL
cluname VARCHAR 50 No No No NULL
vilcd VARCHAR 50 No No No NULL
vilname VARCHAR 50 No No No NULL
schcd VARCHAR 50 No No No NULL
schname VARCHAR 50 No No No NULL
schstatus VARCHAR 50 No No No NULL
pancd VARCHAR 50 No No No NULL
edublkcd VARCHAR 50 No No No NULL
habitcd VARCHAR 50 No No No NULL
aconstcd VARCHAR 50 No No No NULL
municipalcd VARCHAR 50 No No No NULL
city VARCHAR 50 No No No NULL
schmgt_desc VARCHAR 50 No No No NULL
schmgt VARCHAR 50 No No No NULL
schcat VARCHAR 50 No No No NULL
rururbid VARCHAR 50 No No No NULL
schcat_desc VARCHAR 50 No No No NULL
rururb VARCHAR 50 No No No NULL
lowclass VARCHAR 50 No No No NULL
highclass VARCHAR 50 No No No NULL
email VARCHAR 50 No No No NULL
c1_b VARCHAR 50 No No No NULL
c1_g VARCHAR 50 No No No NULL
c2_b VARCHAR 50 No No No NULL
c2_g VARCHAR 50 No No No NULL
c3_b VARCHAR 50 No No No NULL
c3_g VARCHAR 50 No No No NULL
c4_b VARCHAR 50 No No No NULL
c4_g VARCHAR 50 No No No NULL
c5_b VARCHAR 50 No No No NULL
c5_g VARCHAR 50 No No No NULL
c6_b VARCHAR 50 No No No NULL
c6_g VARCHAR 50 No No No NULL
c7_b VARCHAR 50 No No No NULL
c7_g VARCHAR 50 No No No NULL
c8_b VARCHAR 50 No No No NULL
c8_g VARCHAR 50 No No No NULL
c9_b VARCHAR 50 No No No NULL
c9_g VARCHAR 50 No No No NULL
c10_b VARCHAR 50 No No No NULL
c10_g VARCHAR 50 No No No NULL
c11_b VARCHAR 50 No No No NULL
c11_g VARCHAR 50 No No No NULL
c12_b VARCHAR 50 No No No NULL
c12_g VARCHAR 50 No No No NULL
totalb VARCHAR 50 No No No NULL
totalg VARCHAR 50 No No No NULL
total VARCHAR 50 No No No NULL
tch_m VARCHAR 50 No No No NULL
tch_f VARCHAR 50 No No No NULL
tch_t VARCHAR 50 No No No NULL
uploaded_by INT 11 Yes No No
uploaded_on DATETIME Yes No No
group_member_id INT 11 Yes No No
storeScadminState id INT 11 Yes Yes No
scadminState VARCHAR 150 No No No NULL
deptName VARCHAR 150 No No No NULL
acdYear VARCHAR 45 No No No NULL
storeSchoolIDdeptName id INT 11 Yes Yes No
school_id VARCHAR 50 No No No NULL
dept_name VARCHAR 50 No No No NULL
academic_year VARCHAR 45 No No No NULL
student_gcmid id INT 11 Yes Yes No
Stud_Member_Id VARCHAR 50 No No No NULL
student_id VARCHAR 100 No No No NULL
std_PRN VARCHAR 100 No No No NULL
gcm_id VARCHAR 200 No No No NULL
type VARCHAR 15 No No No NULL
tbl_360_activities_data dept_act_id INT Yes Yes No
semesterID INT No No No NULL
semester_name VARCHAR 50 No No No NULL
activityID INT No No No NULL
activity_name VARCHAR 50 No No No NULL
tID VARCHAR 20 No No No NULL
Receiver_tID VARCHAR 20 No No No NULL
schoolID VARCHAR 50 No No No NULL
deptID VARCHAR 50 No No No NULL
credit_point INT No No No NULL
criteria VARCHAR 50 No No No NULL
enclosure_no VARCHAR 50 No No No NULL
branch_id INT No No No NULL
courselevel_ID INT No No No NULL
Academic_YearID INT No No No NULL
Academic_Year VARCHAR 50 No No No NULL
Division_id INT No No No NULL
Class_ID INT No No No NULL
Class VARCHAR 50 No No No NULL
Emp_type_id INT No No No NULL
group_member_id INT 11 No No No NULL
created_date DATETIME No No No NULL
updated_date DATETIME No No No NULL
branch_name VARCHAR 50 No No No NULL
activity_level_id VARCHAR 50 No No No NULL
courselevel_name VARCHAR 45 No No No NULL
Emp_type_id_receiver VARCHAR 45 No No No NULL
receiver_teacher_name VARCHAR 255 No No No NULL
deptName VARCHAR 50 No No No NULL
act_img VARCHAR 1200 No No No NULL
tbl_360_activities_datacol VARCHAR 45 No No No NULL
tbl_360activities act360_id INT 11 Yes Yes No
act360_activity VARCHAR 200 No No No NULL
act360_activity_level_ID VARCHAR 50 No No No NULL
act360_credit_points VARCHAR 50 No No No NULL
act360_school_ID VARCHAR 50 No No No NULL
group_member_id INT 11 No No No NULL
act360_t_ID VARCHAR 50 No No No NULL
tbl_360activity_level actL360_ID INT 11 Yes Yes No
actL360_activity_level VARCHAR 50 No No No NULL
actL360_enable INT No No No NULL
total_points TINYINT 3 No No No NULL
reward_points INT 3 No No No NULL
tbl_360feedback_template feed360_ID INT 11 Yes Yes No
feed360_academic_year_ID VARCHAR 50 No No No NULL
feed360_semester_ID VARCHAR 50 No No No NULL
feed360_branch_ID VARCHAR 50 No No No NULL
feed360_dept_ID VARCHAR 50 No No No NULL
feed360_process_ID VARCHAR 50 No No No NULL
feed360_course_ID VARCHAR 50 No No No NULL
feed360_classes_scheduled VARCHAR 50 No No No NULL
feed360_actual_classes VARCHAR 50 No No No NULL
feed360_points INT No No No NULL
feed360_encluserNo INT No No No NULL
feed360_teacher_id VARCHAR 50 No No No NULL
feed360_school_id VARCHAR 50 No No No NULL
feed360_subject_code VARCHAR 50 No No No NULL
feed360_subject_name VARCHAR 45 No No No NULL
feed360_course_level VARCHAR 45 No No No NULL
feed360_division_id VARCHAR 45 No No No NULL
feed360_img VARCHAR 1200 No No No NULL
feed360_group_member_id VARCHAR 45 No No No NULL
tbl_360teaching_process tea_pro_id INT 11 Yes Yes No
tea_pro_semester VARCHAR 50 No No No NULL
tea_pro_course_name VARCHAR 450 No No No NULL
tea_pro_schedule_class VARCHAR 50 No No No NULL
tea_pro_actual_class VARCHAR 50 No No No NULL
tbl_ActivityLog ActivityLogID INT 11 Yes Yes No
Stud_Member_Id VARCHAR 50 No No No NULL
Teacher_Member_Id VARCHAR 50 No No No NULL
SchoolA_Member_Id VARCHAR 50 No No No NULL
EntityID VARCHAR 100 No No No NULL
Entity_type VARCHAR No No No NULL
EntityID_2 VARCHAR 100 No No No NULL
Entity_Type_2 VARCHAR 20 No No No NULL
EntityID_3 VARCHAR 100 No No No NULL
Entity_Type_3 VARCHAR 20 No No No NULL
Timestamp TIMESTAMP Yes No No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
TimeZone VARCHAR 20 No No No NULL
Activity TEXT No No No NULL
quantity VARCHAR 20 No No No NULL
unit VARCHAR 20 No No No NULL
Method VARCHAR 20 No No No NULL
Device VARCHAR 20 No No No NULL
CountryCode VARCHAR No No No NULL
school_id VARCHAR No No No NULL
tbl_Batch_Master id INT Yes Yes No
batch_id VARCHAR 60 No No No NULL
input_file_name VARCHAR 80 No No No NULL
file_type VARCHAR 40 No No No NULL
old_uploaded_date_time VARCHAR 50 No No No NULL
uploaded_by VARCHAR 50 No No No NULL
entity VARCHAR 20 No No No NULL
school_id VARCHAR 20 No No No NULL
num_records_uploaded INT 20 No No No NULL
num_errors_records INT 20 No No No NULL
num_error_count INT 11 Yes No No
num_errors_scid INT 20 No No No NULL
num_errors_name INT 11 No No No NULL
num_errors_sprn VARCHAR No No No NULL
num_duplicates_record INT 20 No No No NULL
num_correct_records INT 20 No No No NULL
num_newrecords_inserted VARCHAR 20 No No No NULL
num_records_updated INT 20 No No No NULL
display_table_name VARCHAR 120 No No No NULL
db_table_name VARCHAR 120 No No No NULL
existing_records VARCHAR 20 No No No NULL
uploaded_date_time DATETIME Yes No No
academic_year VARCHAR 50 No No No NULL
semester_type VARCHAR No No No NULL
tbl_CourseLevel id INT 11 Yes Yes No
ExtCourseLevelID VARCHAR 20 No No No NULL
CourseLevel VARCHAR 30 No No No NULL
school_id VARCHAR 20 No No No NULL
batch_id VARCHAR 60 No No No NULL
group_member_id INT 50 No No No NULL
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
Table List
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
Table List
Table: tbl_LoginStatus
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
RowID INT(11) Yes Yes No
Member_ID VARCHAR(100) No No No NULL
EntityID VARCHAR(100) No No No NULL
Entity_type VARCHAR No No No NULL
FirstLoginTime DATETIME Yes No No
old_FirstLoginTime VARCHAR(55) No No No NULL
FirstMethod VARCHAR(50) No No No NULL
FirstDevicetype VARCHAR(20) No No No NULL
FirstDeviceDetails VARCHAR(100) No No No NULL
FirstPlatformOS VARCHAR(50) No No No NULL
FirstIPAddress VARCHAR(100) No No No NULL
FirstLatitude VARCHAR(20) No No No NULL
FirstLongitude VARCHAR(20) No No No NULL
FirstBrowser VARCHAR(100) No No No NULL
LatestLoginTime DATETIME Yes No No
old_LatestLoginTime VARCHAR(55) No No No NULL
LatestMethod VARCHAR(50) No No No NULL
LatestDevicetype VARCHAR(20) No No No NULL
LatestDeviceDetails VARCHAR(100) No No No NULL
LatestPlatformOS VARCHAR(50) No No No NULL
LatestIPAddress VARCHAR(100) No No No NULL
LatestLatitude VARCHAR(20) No No No NULL
LatestLongitude VARCHAR(20) No No No NULL
LatestBrowser VARCHAR(100) No No No NULL
LogoutTime DATETIME Yes No No
old_LogoutTime VARCHAR(55) No No No NULL
CountryCode VARCHAR No No No NULL
school_id VARCHAR(20) No No No NULL
calculated_country VARCHAR(45) No No No NULL
Table List
Table: tbl_academic_Year
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
ExtYearID INT(11) No No No NULL
Academic_Year VARCHAR(20) No No No NULL
Year VARCHAR(20) No No No NULL
school_id VARCHAR(50) No No No NULL
Enable VARCHAR(5) No No No NULL
batch_id VARCHAR(60) No No No NULL
group_member_id INT(11) No No No ‘0’
Table List
Table: tbl_accept_coupon
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
Vendor_Member_Id VARCHAR(50) No No No NULL
sponsored_id INT(11) No No No NULL
stud_id VARCHAR(100) No No No NULL
quantity INT(11) No No No NULL
coupon_id VARCHAR(25) No No No NULL
points INT(11) No No No NULL
product_name VARCHAR(255) No No No NULL
issue_date DATETIME Yes No No
old_issue_date VARCHAR(25) No No No NULL
user_type VARCHAR(40) No No No NULL
school_id VARCHAR(20) No No No NULL
Table List
Table: tbl_activity_type
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
activity_type VARCHAR(50) No No No NULL
school_id VARCHAR(50) No No No NULL
group_member_id INT(11) No No No NULL
Table List
Table: tbl_aicte_selected
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
ID INT(11) Yes Yes No
scadmin_ID BIGINT(20) No No No NULL
scadmin_school_id VARCHAR(25) No No No NULL
Table List
Table: tbl_app_downloads
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
user_name VARCHAR(45) No No No NULL
user_type VARCHAR(45) No No No NULL
device_type VARCHAR(45) No No No NULL
country_code INT(11) No No No NULL
contact_number BIGINT(12) No No No NULL
email VARCHAR(45) No No No NULL
datetime DATETIME No No No NULL
Table List
Table: tbl_branch
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
br_id INT(11) Yes Yes No
school_id INT(11) No No No NULL
br_branch VARCHAR(250) No No No NULL
Table List
Table: tbl_branch_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
ExtBranchId INT(15) No No No NULL
branch_id VARCHAR(255) No No No NULL
branch_Name VARCHAR(50) No No No NULL
Specialization VARCHAR(50) No No No NULL
Branch_code VARCHAR(20) No No No NULL
Course_Name VARCHAR(20) No No No NULL
degree_code VARCHAR(50) No No No NULL
Duration VARCHAR No No No NULL
Dept_Id VARCHAR No No No NULL
DepartmentName VARCHAR(100) No No No NULL
school_id VARCHAR(20) No No No NULL
IsEnabled VARCHAR(5) No No No NULL
batch_id VARCHAR No No No NULL
Table List
Table: tbl_city
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
city_id INT(11) Yes Yes No
country_id INT(11) No No No NULL
state_id INT(11) No No No NULL
district VARCHAR(40) No No No NULL
sub_district VARCHAR(40) No No No NULL
area VARCHAR(40) No No No NULL
latitude VARCHAR(15) No No No NULL
longitude VARCHAR(15) No No No NULL
Table List
Table: tbl_class_subject_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
class VARCHAR(50) Yes No No
subject_code VARCHAR(20) Yes No No
subject_name VARCHAR(50) Yes No No
subject_type VARCHAR(20) No No No NULL
subject_short_name VARCHAR(30) No No No NULL
subject_credit VARCHAR(20) No No No NULL
semester_id VARCHAR(20) No No No NULL
semester VARCHAR(50) No No No NULL
branch_id VARCHAR No No No NULL
branch VARCHAR(50) No No No NULL
dept_id VARCHAR No No No NULL
department VARCHAR(50) No No No NULL
school_id VARCHAR No No No NULL
course_level VARCHAR No No No NULL
academic_year VARCHAR No No No NULL
batch_id VARCHAR(60) No No No NULL
uploaded_by VARCHAR(20) No No No NULL
uploaded_date DATETIME Yes No No ‘0000-00-00 00:00:00’
Table List
Table: tbl_cookie_adminstaff
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT Yes Yes No
stf_name VARCHAR(150) No No No NULL
exprience VARCHAR(50) No No No NULL
designation VARCHAR(150) No No No NULL
address VARCHAR(150) No No No NULL
country VARCHAR No No No NULL
city VARCHAR(50) No No No NULL
statue VARCHAR(50) No No No NULL
dob DATE No No No NULL
old_dob TEXT No No No NULL
age VARCHAR No No No NULL
gender VARCHAR(50) No No No NULL
email VARCHAR(100) No No No NULL
CountryCode INT(9) No No No NULL
phone VARCHAR(12) No No No NULL
pass VARCHAR(150) No No No NULL
userPoint VARCHAR(100) No No No NULL
qualification VARCHAR(150) No No No NULL
dataTime DATETIME No No No NULL
group_status VARCHAR(60) No No No NULL
group_member_id INT(11) No No No ‘0’
group_mnemonic_name VARCHAR(45) No No No NULL
Table List
Table: tbl_cookieadmin
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
admin_name VARCHAR(100) Yes No No
admin_email VARCHAR(100) No No No NULL
admin_password VARCHAR(100) No No No NULL
group_type VARCHAR(60) Yes No No
group_name VARCHAR(150) Yes No No
country_code INT(9) No No No NULL
mobile_no BIGINT(11) Yes No No
address TEXT No No No NULL
group_mnemonic_name VARCHAR(40) Yes No No
balance_green_point INT(11) Yes No No
balance_blue_point INT(11) Yes No No
balance_water_point INT(11) Yes No No
current_ay VARCHAR(20) No No No NULL
current_sem_type VARCHAR(20) No No No NULL
Table List
Table: tbl_coordinator
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Co_Member_id VARCHAR(50) Yes No No
Stud_Member_Id VARCHAR(50) Yes No No
Teacher_Member_Id VARCHAR(50) Yes No No
teacher_id VARCHAR(100) Yes No No
stud_id VARCHAR(100) Yes No No
status VARCHAR(20) Yes No No
pointdate DATETIME Yes No No
old_pointdate VARCHAR(20) No No No NULL
school_id VARCHAR(20) Yes No No
Table List
Table: tbl_country
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
country_id INT(11) Yes Yes No
country VARCHAR(40) Yes No No
is_enabled INT(11) Yes No No ‘0’
code VARCHAR(4) No No No NULL
iso2code VARCHAR(3) No No No NULL
capital VARCHAR(40) No No No NULL
lat VARCHAR No No No NULL
long VARCHAR No No No NULL
calling_code VARCHAR(20) No No No NULL
Table List
Table: tbl_coupons
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
stud_complete_name VARCHAR(255) No No No NULL
cp_stud_id VARCHAR(100) No No No NULL
school_id VARCHAR(50) No No No NULL
cp_code VARCHAR(255) No No No NULL
amount VARCHAR(55) No No No NULL
item VARCHAR(255) No No No NULL
activity VARCHAR(55) No No No NULL
sponsored_id INT(11) No No No NULL
status VARCHAR(20) Yes No No ‘yes’
validity DATETIME Yes No No
old_validity VARCHAR(25) No No No NULL
cp_gen_date DATETIME Yes No No
old_cp_gen_date VARCHAR(55) No No No NULL
original_point VARCHAR(45) No No No NULL
Table List
Table: tbl_datafile_weightage
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id TINYINT(3) Yes Yes No
table_name VARCHAR(100) Yes No No
tbl_name VARCHAR(100) No No No NULL
academic_year_required VARCHAR(5) No No No NULL
seq_no TINYINT(3) No No No NULL
weightage TINYINT(3) No No No NULL
school_type VARCHAR(100) No No No NULL
Table List
Table: tbl_degree_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
ExtDegreeID VARCHAR(20) No No No NULL
Degee_name VARCHAR(50) No No No NULL
Degree_code VARCHAR No No No NULL
course_level VARCHAR(50) No No No NULL
school_id VARCHAR(20) No No No NULL
batch_id VARCHAR(60) No No No NULL
Table List
Table: tbl_department_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Dept_code VARCHAR(20) No No No NULL
Dept_Name VARCHAR(100) No No No NULL
ExtDeptId VARCHAR(20) No No No NULL
Establiment_Year VARCHAR No No No NULL
PhoneNo VARCHAR(30) No No No NULL
Fax_No VARCHAR(30) No No No NULL
Email_Id VARCHAR(50) No No No NULL
School_ID VARCHAR(100) No No No NULL
Is_Enabled TINYINT(1) No No No NULL
batch_id VARCHAR(60) No No No NULL
landline VARCHAR(100) No No No NULL
Table List
Table: tbl_distribute_points_by_cookieadmin
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
assigned_by VARCHAR(30) No No No NULL
points INT No No No NULL
point_color VARCHAR(15) No No No NULL
entity_name VARCHAR(80) No No No NULL
entity_id VARCHAR(20) No No No NULL
date DATETIME Yes No No
old_date VARCHAR(25) No No No NULL
time VARCHAR(15) No No No NULL
Table List
Table: tbl_email_parameters
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
e_id INT(11) Yes Yes No
email_id VARCHAR(255) No No No NULL
email_password VARCHAR(255) No No No NULL
host VARCHAR(100) No No No NULL
port VARCHAR(100) No No No NULL
use_default INT(2) No No No ‘0’
protocol VARCHAR(20) No No No ‘smtp’
Table List
Table: tbl_email_sms_templates
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
type VARCHAR(100) No No No NULL
subject VARCHAR(100) No No No NULL
email_body TEXT No No No NULL
email_marathi TEXT No No No NULL
sms_body TEXT No No No NULL
sms_marathi TEXT No No No NULL
created_on DATETIME No No No NULL
created_by VARCHAR(100) No No No NULL
modified_on DATETIME No No No NULL
modified_by VARCHAR(100) No No No NULL
Table List
Table: tbl_entites
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
sc_entities VARCHAR(55) No No No NULL
sc_id INT(11) No No No NULL
Table List
Table: tbl_error_log
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
error_type VARCHAR(15) No No No NULL
error_description VARCHAR(250) No No No NULL
data TEXT No No No NULL
datetime DATETIME Yes No No
old_datetime VARCHAR(40) No No No NULL
user_type VARCHAR(15) No No No NULL
member_id VARCHAR(100) No No No NULL
school_id VARCHAR(30) No No No NULL
name VARCHAR(30) No No No NULL
phone VARCHAR(15) No No No NULL
email VARCHAR(30) No No No NULL
app_name VARCHAR(30) No No No NULL webscreen_name
subroutine_name VARCHAR(60) No No No NULL page_name
line VARCHAR(150) No No No NULL
status VARCHAR No No No NULL solved/unsolved
assignment_date DATETIME No No No NULL
assigned_to VARCHAR(30) No No No NULL
resolution_date DATETIME No No No NULL
resolved_by VARCHAR(30) No No No NULL
last_programmer_name VARCHAR(100) No No No NULL
webservice_name VARCHAR(100) No No No NULL
webmethod_name VARCHAR(100) No No No NULL
programmer_error_message VARCHAR(100) No No No NULL
device_name VARCHAR(255) No No No NULL
device_OS_version VARCHAR(255) No No No NULL
ip_address VARCHAR(255) No No No NULL
source VARCHAR(255) No No No NULL
Table List
Table: tbl_fcm_api_key
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
app_fcm_key VARCHAR(255) No No No NULL
api_key VARCHAR(255) No No No NULL
Table List
Table: tbl_games
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
subject_code VARCHAR(45) Yes No No
name VARCHAR(100) Yes No No
regional_name VARCHAR(100) Yes No No
category_name VARCHAR(100) Yes No No
regional_category_name VARCHAR(100) Yes No No
uploaded_by INT(11) Yes No No
uploaded_on DATETIME Yes No No
group_member_id INT(11) Yes No No
Table List
Table: tbl_giftcards
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
card_no VARCHAR(50) No No No NULL
amount INT(100) No No No NULL
issue_date DATETIME Yes No No
old_issue_date VARCHAR(50) No No No NULL
valid_to VARCHAR(50) No No No NULL
status VARCHAR(50) No No No NULL
Table List
Table: tbl_giftof_bluepoint
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
coupon_id VARCHAR(50) No No No NULL
entities_id INT(11) No No No NULL
user_id VARCHAR(100) No No No NULL
points INT(11) No No No NULL
old_issue_date VARCHAR(50) No No No NULL
issue_date DATETIME Yes No No
Table List
Table: tbl_giftof_rewardpoint
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
Id INT(11) Yes Yes No
coupon_id INT(100) No No No NULL
point INT(11) No No No NULL
old_issue_date VARCHAR(30) No No No NULL
issue_date DATETIME Yes No No
user_id VARCHAR(100) No No No NULL
entity INT(11) No No No NULL
parent_id INT(11) No No No NULL
Table List
Table: tbl_giftof_waterpoint
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
coupon_id VARCHAR(30) No No No NULL
entities_id INT(8) No No No NULL
user_id VARCHAR(20) No No No NULL
points INT(11) No No No NULL
old_issue_date VARCHAR(30) No No No NULL
issue_date DATETIME Yes No No
Table List
Table: tbl_group_type
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
group_type VARCHAR(50) Yes No No
Table List
Table: tbl_insert_receipt
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) No No No NULL
sp_id INT(11) No No No NULL
ReceiptNo VARCHAR(255) No No No NULL
Name VARCHAR(255) No No No NULL
Email VARCHAR(255) No No No NULL
sp_phone VARCHAR(20) No No No NULL
Amount VARCHAR(50) No No No NULL
Validity DATETIME Yes No No
old_Validity VARCHAR(255) No No No NULL
Timestamp TIMESTAMP No No No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Table List
Table: tbl_like_status
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Member_ID VARCHAR(50) No No No NULL
from_entity INT(11) No No No NULL
from_user_id VARCHAR(100) No No No NULL
to_entity INT(11) No No No NULL
to_user_id VARCHAR(100) No No No NULL
active_status INT(1) No No No NULL
Table List
Table: tbl_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
school_id VARCHAR(100) No No No NULL
method_id INT(11) No No No NULL
range_id INT(11) No No No NULL
from_range VARCHAR(50) No No No NULL
to_range VARCHAR(50) No No No NULL
points INT(11) No No No NULL
activity_id INT(11) No No No NULL
subject_id VARCHAR(50) No No No NULL
Table List
Table: tbl_master_action_log
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
action_tracking_number INT(11) Yes Yes No
action_date_time DATETIME Yes No No
old_action_date_time VARCHAR(45) No No No NULL
action_code TEXT No No No NULL
action_description VARCHAR(100) No No No NULL
actor_mem_id VARCHAR(50) No No No NULL
actor_name VARCHAR(100) No No No NULL
actor_entity_type VARCHAR(45) No No No NULL
receiver_mem_id VARCHAR(50) No No No NULL
receiver_name VARCHAR(100) No No No NULL
receiver_entity_type VARCHAR(45) No No No NULL
third_party_mem_id VARCHAR(50) No No No NULL
third_party_name VARCHAR(45) No No No NULL
third_party_entity_type VARCHAR(45) No No No NULL
points VARCHAR(45) No No No NULL
coupon_id VARCHAR(45) No No No NULL
product VARCHAR(45) No No No NULL
value VARCHAR(45) No No No NULL
currency VARCHAR(45) No No No NULL
Table List
Table: tbl_member_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
member_name VARCHAR(90) No No No NULL
gender VARCHAR(7) No No No NULL
dob DATE No No No NULL
tenth_percentage VARCHAR(5) No No No NULL
tenth_YOP VARCHAR(6) No No No NULL
tenth_board VARCHAR(50) No No No NULL
twelve_percentage VARCHAR(5) No No No NULL
twelve_YOP VARCHAR(6) No No No NULL
twelve_board VARCHAR(50) No No No NULL
diploma_percentage VARCHAR(5) No No No NULL
diploma_YOP VARCHAR(6) No No No NULL
diploma_board VARCHAR(50) No No No NULL
mob_no VARCHAR(12) No No No NULL
alternate_mob_no VARCHAR(12) No No No NULL
email_id VARCHAR(35) No No No NULL
native_place VARCHAR(30) No No No NULL
permanant_add VARCHAR(80) No No No NULL
Table List
Table: tbl_member_org
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
member_id VARCHAR(50) No No No NULL
org_id VARCHAR(50) No No No NULL
org_type VARCHAR(20) No No No NULL
emp_id VARCHAR(50) No No No NULL
emp_type VARCHAR(20) No No No NULL
Table List
Table: tbl_membership_discount
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(5) Yes Yes No
SponsorID INT(5) Yes No No
MemberID INT(5) Yes No No
prn_tid INT(5) Yes No No
name CHAR(25) No No No NULL
school_name CHAR(100) No No No NULL
school_id VARCHAR(20) Yes No No
Entity_name CHAR(30) No No No NULL
Entity_type INT(5) Yes No No
product VARCHAR(100) Yes No No
discount INT(5) Yes No No
date DATETIME Yes No No
Table List
Table: tbl_menu
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(5) Yes Yes No
org_type_id VARCHAR(20) No No No NULL
entity_type INT(5) No No No NULL
entity_name VARCHAR(20) No No No NULL
menu_key VARCHAR(50) No No No NULL
menu_level VARCHAR(50) No No No NULL
menu_name VARCHAR(50) No No No NULL
menu_url VARCHAR(150) No No No NULL
menu_active CHAR(1) No No No NULL
parent_menu_id INT(5) No No No NULL
Table List
Table: tbl_method
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
method_name VARCHAR(50) No No No NULL
method_flag VARCHAR(20) No No No NULL
group_member_id INT(11) No No No NULL
school_id VARCHAR(50) No No No NULL
Table List
Table: tbl_onlinesubject_activity_achivement
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
a_id INT(11) Yes Yes No
a_desc VARCHAR(50) No No No NULL
a_activity_id VARCHAR(11) No No No NULL
a_sub_activity_id VARCHAR(11) No No No NULL
a_alloc_points INT(11) No No No NULL
Table List
Table: tbl_organization_type
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(5) Yes Yes No
org_id VARCHAR(20) No No No NULL
org_type VARCHAR(50) No No No NULL
Table List
Table: tbl_otp
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
mobileno VARCHAR(45) No No No NULL
email VARCHAR(45) No No No NULL
otp VARCHAR(45) No No No NULL
Table List
Table: tbl_parent
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
Id INT(11) Yes Yes No
Parent_Member_id VARCHAR(50) No No No NULL
Stud_Member_Id VARCHAR(50) No No No NULL
std_PRN VARCHAR(100) No No No NULL
Name VARCHAR(255) No No No NULL
Father_name VARCHAR(255) No No No NULL
Mother_name VARCHAR(255) No No No NULL
email_id VARCHAR(255) No No No NULL
CountryCode INT(9) No No No NULL
Phone VARCHAR(15) No No No NULL
Local_gardian_phone VARCHAR(15) No No No NULL
Password VARCHAR(15) No No No NULL
DateOfBirth DATE Yes No No
old_DateOfBirth VARCHAR(15) No No No NULL
Age INT(15) No No No NULL
Gender VARCHAR(15) No No No NULL
Qualification VARCHAR(255) No No No NULL
Occupation VARCHAR(255) No No No NULL
p_img_path VARCHAR(255) No No No NULL
stud_id INT(11) No No No NULL
Address VARCHAR(255) No No No NULL
country VARCHAR(255) No No No NULL
state VARCHAR(255) No No No NULL
city VARCHAR(255) No No No NULL
school_id VARCHAR(255) No No No NULL
Class VARCHAR(255) No No No NULL
network VARCHAR(25) No No No NULL
balance_points INT(11) No No No NULL
reg_date DATETIME No No No NULL
balance_blue_points INT(11) No No No NULL
assigned_blue_points INT(11) No No No NULL
distributed_purple INT(15) No No No NULL
FamilyIncome VARCHAR(60) No No No NULL
college_mnemonic VARCHAR(20) No No No NULL
batch_id VARCHAR(20) No No No NULL
input_file_name VARCHAR(70) No No No NULL
no_record_uploaded INT(15) No No No NULL
file_type VARCHAR(70) No No No NULL
uploaded_date_time DATETIME Yes No No
old_uploaded_date_time VARCHAR(60) No No No NULL
uploaded_by VARCHAR(80) No No No NULL
error_status VARCHAR(80) No No No NULL
group_status VARCHAR(60) No No No NULL
GCM VARCHAR(60) No No No NULL
FB VARCHAR(60) No No No NULL
GPLUS VARCHAR(60) No No No NULL
group_member_id INT(11) No No No ‘0’
Table List
Table: tbl_parent_student
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
student_prn VARCHAR(100) No No No NULL
student_id VARCHAR(100) No No No NULL students database id
parent_id VARCHAR(50) No No No NULL
school_id VARCHAR(15) No No No NULL
Table List
Table: tbl_permission
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
permission_id INT(20) Yes Yes No
school_id VARCHAR No No No NULL
s_a_st_id INT(20) No No No NULL school_admin_staff_id
cookie_admin_staff_id INT(100) No No No NULL
school_staff_name VARCHAR(150) No No No NULL
cookie_staff_name VARCHAR(150) No No No NULL
permission LONGTEXT No No No NULL
current_date DATETIME No No No NULL
Table List
Table: tbl_program
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
pro_id INT(11) Yes Yes No
pro_program VARCHAR(150) No No No NULL
Table List
Table: tbl_project_event
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id TINYINT(4) Yes Yes No
project_id VARCHAR(20) Yes No No
project_name VARCHAR(60) Yes No No
project_info TEXT No No No NULL
Project_Sponsor VARCHAR(50) No No No NULL
event_date_start DATETIME No No No NULL
event_date_end DATETIME No No No NULL
project_origin VARCHAR No No No NULL
origin_id VARCHAR(50) No No No NULL
Table List
Table: tbl_question
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
que_ID INT(11) Yes Yes No
que_display_number VARCHAR No No No NULL
que_question VARCHAR(250) No No No NULL
que_rating INT(11) No No No NULL
que_subject VARCHAR(100) No No No NULL
que_order INT(11) No No No NULL
que_is_sub INT(11) No No No NULL
que_main_que INT(11) No No No NULL
que_is_active INT(11) No No No NULL
Table List
Table: tbl_raw_parent
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
parent_Id INT(11) Yes Yes No
std_PRN VARCHAR(100) No No No NULL
Name VARCHAR(200) No No No NULL
Father_name VARCHAR(150) No No No NULL
Mother_name VARCHAR(150) No No No NULL
email_id VARCHAR(50) No No No NULL
Phone VARCHAR(20) No No No NULL
Local_gardian_phone VARCHAR(200) No No No NULL
Password VARCHAR(50) No No No NULL
DateOfBirth DATE Yes No No
old_DateOfBirth VARCHAR(15) No No No NULL
Age INT No No No NULL
Gender VARCHAR No No No NULL
Qualification VARCHAR(50) No No No NULL
Occupation VARCHAR(150) No No No NULL
p_img_path TEXT No No No NULL
stud_id INT(11) No No No NULL
Address TEXT No No No NULL
country VARCHAR(30) No No No NULL
state VARCHAR(40) No No No NULL
city VARCHAR(50) No No No NULL
school_id VARCHAR(20) No No No NULL
Class VARCHAR(30) No No No NULL
network VARCHAR(40) No No No NULL
FamilyIncome VARCHAR(60) No No No NULL
reg_date DATETIME No No No NULL
balance_blue_points INT(11) No No No NULL
assigned_blue_points INT(11) No No No NULL
batch_id VARCHAR(30) No No No NULL
input_file_name VARCHAR(80) No No No NULL
no_record_uploaded INT(30) No No No NULL
file_type VARCHAR(50) No No No NULL
uploaded_date_time DATETIME Yes No No
old_uploaded_date_time VARCHAR(30) No No No NULL
uploaded_by VARCHAR(50) No No No NULL
college_mnemonic VARCHAR(20) No No No NULL
error_status VARCHAR(30) No No No NULL
status VARCHAR(255) No No No NULL
upload_date DATETIME No No No NULL
validity VARCHAR(20) No No No NULL
balance_point INT(11) No No No NULL
Table List
Table: tbl_raw_student
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(12) Yes Yes No
s_staff_id INT No No No NULL
s_roll_no VARCHAR(30) No No No NULL
s_PRN VARCHAR(100) No No No NULL
s_complete_name VARCHAR(200) No No No NULL
s_firstname VARCHAR(50) No No No NULL
s_middlename VARCHAR(50) No No No NULL
s_lastname VARCHAR(500) No No No NULL
s_father_name VARCHAR(150) No No No NULL
s_complete_father_name VARCHAR(150) No No No NULL
s_dob DATE Yes No No
old_s_dob VARCHAR(30) No No No NULL
s_age INT No No No NULL
s_school_name VARCHAR(200) No No No NULL
s_school_id VARCHAR(15) No No No NULL
s_branch VARCHAR(200) No No No NULL
s_dept VARCHAR(200) No No No NULL
s_semester VARCHAR(50) No No No NULL
s_year VARCHAR(40) No No No NULL
s_class VARCHAR(100) No No No NULL
s_div VARCHAR(40) No No No NULL
s_permanant_address TEXT No No No NULL
s_permanant_village TEXT No No No NULL
s_permanant_taluka TEXT No No No NULL
s_permanant_district TEXT No No No NULL
s_permanant_pincode TEXT No No No NULL
s_temporary_address TEXT No No No NULL
s_city VARCHAR(50) No No No NULL
s_state VARCHAR(50) No No No NULL
s_country VARCHAR(50) No No No NULL
s_country_code VARCHAR(15) No No No NULL
s_gender VARCHAR No No No NULL
s_hobbies VARCHAR(100) No No No NULL
s_class_teacher_name VARCHAR(40) No No No NULL
s_email VARCHAR(60) No No No NULL
s_internal_emailid VARCHAR(80) No No No NULL
s_username VARCHAR(30) No No No NULL
s_password VARCHAR(50) No No No NULL
s_date DATETIME Yes No No
old_s_date VARCHAR(50) No No No NULL
s_phone VARCHAR(15) No No No NULL
s_image_path VARCHAR(55) No No No NULL
s_parent_id INT(15) Yes No No
latitude FLOAT No No No NULL
logitude FLOAT No No No NULL
batch_id VARCHAR(60) No No No NULL
input_file_name VARCHAR(60) No No No NULL
no_record_uploaded INT No No No NULL
file_type VARCHAR(30) No No No NULL
uploaded_date_time DATETIME Yes No No
old_uploaded_date_time VARCHAR(55) No No No NULL
uploaded_by VARCHAR(50) No No No NULL
error_records VARCHAR(30) No No No NULL
s_specialization VARCHAR(200) No No No NULL
s_course_level VARCHAR(50) No No No NULL
s_academic_year VARCHAR(25) No No No NULL
mnemonic VARCHAR(15) No No No NULL
ExtBranchId VARCHAR(30) No No No NULL
ExtDeptId VARCHAR(30) No No No NULL
ExtSemesterId VARCHAR(30) No No No NULL
status VARCHAR(255) No No No NULL
validity VARCHAR(30) No No No NULL
upload_date DATETIME Yes No No
error_msg VARCHAR(255) Yes No No
group_member_id INT(11) Yes No No
Table List
Table: tbl_raw_teacher
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(12) Yes Yes No
t_id VARCHAR(100) No No No NULL
t_complete_name VARCHAR(60) No No No NULL
t_name VARCHAR(30) No No No NULL
t_middlename VARCHAR(30) No No No NULL
t_lastname VARCHAR(30) No No No NULL
t_school_name VARCHAR(250) No No No NULL
t_school_id VARCHAR(50) No No No NULL
t_school_staff_id INT No No No NULL
t_exprience VARCHAR(50) No No No NULL
t_dept VARCHAR(100) No No No NULL
t_DeptID VARCHAR(255) No No No NULL
t_subject VARCHAR(255) No No No NULL
t_class VARCHAR(255) No No No NULL
t_qualification VARCHAR(55) No No No NULL
t_address TEXT No No No NULL
t_city VARCHAR(50) No No No NULL
t_state VARCHAR(50) No No No NULL
t_country VARCHAR(50) No No No NULL
t_dob DATE Yes No No
old_t_dob VARCHAR(30) No No No NULL
t_age INT(11) No No No NULL
t_gender VARCHAR No No No NULL
t_email VARCHAR(200) No No No NULL
t_internal_email VARCHAR(40) No No No NULL
t_password VARCHAR(40) No No No NULL
t_date DATETIME Yes No No
old_t_date VARCHAR(50) No No No NULL
t_phone VARCHAR(15) No No No NULL
CountryCode INT(11) No No No NULL
t_landline VARCHAR(50) No No No NULL
batch_id VARCHAR(255) No No No NULL
input_file_name VARCHAR(50) No No No NULL
file_type VARCHAR(50) No No No NULL
no_record_uploaded INT(15) No No No NULL
uploaded_date_time DATETIME Yes No No
old_uploaded_date_time VARCHAR(55) No No No NULL
uploaded_by VARCHAR(50) No No No NULL
error_records VARCHAR(50) No No No NULL
t_permanent_village VARCHAR(30) No No No NULL
t_permanent_taluka VARCHAR(30) No No No NULL
t_permanent_district VARCHAR(30) No No No NULL
t_permanent_pincode VARCHAR No No No NULL
t_date_of_appointment VARCHAR(50) No No No NULL
t_emp_type_pid VARCHAR(25) No No No NULL
college_mnemonic VARCHAR(15) No No No NULL
status VARCHAR(255) No No No NULL
upload_date DATETIME Yes No No
validity VARCHAR(30) No No No NULL
group_member_id INT(11) Yes No No
error_msg VARCHAR(255) Yes No No
created_by INT(11) Yes No No
created_on DATETIME Yes No No
Table List
Table: tbl_rawdata
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
tbl_name VARCHAR(40) No No No NULL
tot_columns VARCHAR(40) No No No NULL
school_id VARCHAR(40) No No No NULL
A VARCHAR(40) No No No NULL
B VARCHAR(40) No No No NULL
C VARCHAR(40) No No No NULL
D VARCHAR(40) No No No NULL
E VARCHAR(40) No No No NULL
F VARCHAR(40) No No No NULL
G VARCHAR(40) No No No NULL
H VARCHAR(40) No No No NULL
I VARCHAR(40) No No No NULL
J VARCHAR(40) No No No NULL
K VARCHAR(40) No No No NULL
L VARCHAR(40) No No No NULL
M VARCHAR(40) No No No NULL
N VARCHAR(40) No No No NULL
O VARCHAR(40) No No No NULL
P VARCHAR(40) No No No NULL
Q VARCHAR(40) No No No NULL
R VARCHAR(40) No No No NULL
S VARCHAR(40) No No No NULL
T VARCHAR(40) No No No NULL
U VARCHAR(40) No No No NULL
V VARCHAR(40) No No No NULL
W VARCHAR(40) No No No NULL
X VARCHAR(40) No No No NULL
Y VARCHAR(40) No No No NULL
Z VARCHAR(40) No No No NULL
uploaded_by VARCHAR(40) No No No NULL
timestamp DATETIME No No No NULL
filename VARCHAR(40) No No No NULL
iflag VARCHAR No No No NULL
temp_filename VARCHAR(50) No No No NULL
Table List
Table: tbl_request
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
Teacher_Member_Id VARCHAR(50) No No No NULL
Stud_Co_Member_id VARCHAR(50) No No No NULL
stud_id1 VARCHAR(100) No No No NULL
stud_id2 VARCHAR(100) No No No NULL
requestdate DATETIME Yes No No
old_requestdate VARCHAR(50) No No No NULL
points INT(11) No No No NULL
reason VARCHAR(255) No No No NULL
achievement_id INT(11) No No No NULL
student_comment VARCHAR(255) No No No NULL
flag VARCHAR No No No NULL
entitity_id1 INT(11) No No No NULL
entitity_id INT(11) No No No NULL
activity_type VARCHAR(20) No No No NULL
school_id VARCHAR(30) No No No NULL
teacher_comment VARCHAR(255) No No No NULL
activity_image VARCHAR(255) No No No NULL
Table List
Table: tbl_roles
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(5) Yes Yes No
role_id VARCHAR(20) No No No NULL
role_name VARCHAR(20) No No No NULL
menu_access TEXT No No No NULL
Table List
Table: tbl_salesperson
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
person_id INT(11) Yes Yes No
p_name VARCHAR(50) No No No NULL
p_email VARCHAR(50) No No No NULL
p_password VARCHAR(50) No No No NULL
CountryCode INT(9) No No No NULL
p_phone VARCHAR(25) No No No NULL
p_image VARCHAR(50) No No No NULL
Table List
Table: tbl_school
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
school_name VARCHAR(200) No No No NULL
school_address VARCHAR(200) No No No NULL
school_email VARCHAR(200) No No No NULL
password VARCHAR(200) No No No NULL
school_mnemonic VARCHAR(100) No No No NULL
date DATETIME Yes No No
old_date VARCHAR(200) No No No NULL
phone INT(11) No No No NULL
school_website VARCHAR(200) No No No NULL
school_balance_point INT(11) No No No NULL
school_assigned_point INT(11) No No No NULL
school_head_nm VARCHAR(200) No No No NULL
school_latitude VARCHAR(255) No No No NULL
school_longitude VARCHAR(255) No No No NULL
school_type VARCHAR(60) No No No NULL
Table List
Table: tbl_school_admin
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
name VARCHAR(255) No No No NULL
email VARCHAR(255) No No No NULL
password VARCHAR(55) No No No NULL
school_name VARCHAR(255) No No No NULL
school_id VARCHAR(30) No No No NULL
school_pattern VARCHAR(100) No No No NULL
DTECode VARCHAR(50) No No No NULL
stream VARCHAR(100) No No No NULL
lat DOUBLE No No No NULL
lon DOUBLE No No No NULL
address TEXT No No No NULL
education VARCHAR(55) No No No NULL
img_path VARCHAR(255) No No No NULL
CountryCode INT(9) No No No NULL
mobile VARCHAR(15) No No No NULL
default_activities TINYINT(1) No No No NULL
school_assigned_point INT(11) No No No NULL
school_balance_point INT(11) No No No NULL
scadmin_city VARCHAR(25) No No No NULL
scadmin_country VARCHAR(25) No No No NULL
scadmin_dob DATE Yes No No
old_scadmin_dob VARCHAR(30) No No No NULL
scadmin_gender VARCHAR(40) No No No NULL
scadmin_age INT(11) No No No NULL
reg_date VARCHAR(30) No No No NULL
scadmin_state VARCHAR(30) No No No NULL
assign_blue_points INT(100) No No No NULL
balance_blue_points INT(11) No No No NULL
assign_water_point INT(11) No No No ‘0’
balance_water_point INT(11) No No No ‘0’
thanqu_flag VARCHAR(25) No No No NULL
batch_id VARCHAR(100) No No No NULL
school_type VARCHAR(60) No No No NULL
email_status VARCHAR(100) Yes No No
email_time_log VARCHAR(500) Yes No No
send_sms_status VARCHAR(200) Yes No No
sms_time_log VARCHAR(200) Yes No No
group_member_id INT(11) Yes No No
group_status VARCHAR(100) Yes No No
proud_point_percentage VARCHAR(45) No No No NULL
uploaded_by INT(11) Yes No No
group_type VARCHAR(20) Yes No No
group_name VARCHAR(100) Yes No No
group_admin_id VARCHAR(45) No No No NULL
is_accept_terms INT(2) No No No ‘0’ 0 stand for not accepted and 1 for accepted
accept_terms_date DATETIME No No No NULL
aicte_permanent_id VARCHAR(50) No No No NULL
aicte_application_id VARCHAR(255) No No No NULL
old_school_id VARCHAR(30) No No No NULL
Table List
Table: tbl_school_admin_raw
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
name VARCHAR(50) No No No NULL
email VARCHAR(50) No No No NULL
password VARCHAR(50) No No No NULL
school_name VARCHAR(100) No No No NULL
stream VARCHAR(50) No No No NULL
school_id VARCHAR(50) Yes No No
DTECode VARCHAR(50) No No No NULL
address VARCHAR(200) No No No NULL
mobile VARCHAR(20) No No No NULL
batch_id VARCHAR(25) No No No NULL
error_code VARCHAR(100) No No No NULL
error_msg VARCHAR(255) Yes No No
school_type VARCHAR(60) Yes No No
scadmin_city VARCHAR(30) Yes No No
scadmin_country VARCHAR(30) Yes No No
CountryCode INT(5) Yes No No
group_member_id INT(11) Yes No No
reg_date DATETIME Yes No No
uploaded_by VARCHAR(45) No No No NULL
aicte_permanent_id VARCHAR(50) No No No NULL
aicte_application_id VARCHAR(50) No No No NULL
Table List
Table: tbl_school_adminstaff
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT Yes Yes No
stf_name VARCHAR(150) No No No NULL
school_id VARCHAR No No No NULL dynamic create id form javascript
school_name VARCHAR(255) No No No NULL
exprience VARCHAR(50) No No No NULL
designation VARCHAR(150) No No No NULL
addd VARCHAR(150) No No No NULL
country VARCHAR No No No NULL
city VARCHAR(50) No No No NULL
statue VARCHAR(50) No No No NULL
dob VARCHAR(50) No No No NULL
age VARCHAR No No No NULL
gender VARCHAR(15) No No No NULL
email VARCHAR(50) No No No NULL
img_path VARCHAR(255) No No No NULL
CountryCode INT(9) No No No NULL
phone VARCHAR(12) No No No NULL
pass VARCHAR(150) No No No NULL
userPoint VARCHAR(100) No No No NULL
qualification VARCHAR(150) No No No NULL
currentDate DATETIME No No No NULL
group_member_id INT(11) No No No NULL
delete_flag INT(1) No No No NULL
Table List
Table: tbl_school_datacount
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
school_id VARCHAR(50) Yes No No
academic_year VARCHAR(30) Yes No No
semister_type VARCHAR Yes No No
tbl_name VARCHAR(100) Yes No No
tbl_display_name VARCHAR(100) Yes No No
uploaded_records INT(6) No No No ‘0’
expected_records INT(6) No No No ‘0’
inserted_date TIMESTAMP Yes No No CURRENT_TIMESTAMP
updated_date TIMESTAMP Yes No No ‘0000-00-00 00:00:00’
Table List
Table: tbl_school_datastatus
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
school_id VARCHAR(100) Yes No No
group_id INT(11) Yes No No
table_name VARCHAR(100) Yes No No
weightage TINYINT(3) Yes No No
academic_year VARCHAR(50) No No No NULL
Table List
Table: tbl_school_subject
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No subject master
ExtSchoolSubjectId INT(15) No No No NULL
subject_id VARCHAR(50) No No No NULL
Branch_ID VARCHAR No No No NULL
subject VARCHAR(100) No No No NULL
image VARCHAR(255) Yes No No
school_id VARCHAR(20) No No No NULL
school_staff_id VARCHAR No No No NULL
Subject_Code VARCHAR(20) No No No NULL
Semester_id VARCHAR(25) No No No NULL
Year_ID VARCHAR No No No NULL
Degree_name VARCHAR(20) No No No NULL
Subject_type VARCHAR(30) No No No NULL
subject_credit INT No No No NULL
Course_Level_PID VARCHAR(20) No No No NULL
Dept_id VARCHAR(70) No No No NULL
Subject_short_name VARCHAR(40) No No No NULL
Uploaded_by VARCHAR(20) No No No NULL
batch_id VARCHAR(50) No No No NULL
group_member_id INT(11) Yes No No
Table List
Table: tbl_selected_vendor_coupons
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
entity_id INT(11) No No No NULL
user_id INT(11) No No No NULL
coupon_id INT(11) No No No NULL
for_points INT(11) No No No NULL
timestamp TIMESTAMP No No No CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
code VARCHAR(15) No No No NULL
used_flag TEXT No No No NULL
sponsor_id INT(11) No No No NULL
old_valid_until VARCHAR(15) No No No NULL
school_id VARCHAR No No No NULL
valid_until DATETIME Yes No No
Table List
Table: tbl_semester_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
Semester_Id INT(11) Yes Yes No
ExtSemesterId INT(15) No No No NULL
Semester_Name VARCHAR(50) No No No NULL
ExtBranchId INT(15) No No No NULL
Branch_ID VARCHAR(20) No No No NULL
Branch_name VARCHAR(100) No No No NULL
Semester_credit VARCHAR(30) No No No NULL
Is_regular_semester VARCHAR No No No NULL
Year_Id VARCHAR No No No NULL
Semester_start_Date VARCHAR(20) No No No NULL
Semester_End_date VARCHAR(20) No No No NULL
Dept_Id VARCHAR(20) No No No NULL
Department_Name VARCHAR(100) No No No NULL
school_id VARCHAR(100) No No No NULL
Is_enable VARCHAR(20) No No No NULL
CourseLevel VARCHAR(20) No No No NULL
class VARCHAR(50) No No No NULL
batch_id VARCHAR(60) No No No NULL
Table List
Table: tbl_shifts
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
shif_ID INT(11) Yes Yes No
shif_shift VARCHAR(255) No No No NULL
shif_school_ID INT(11) No No No NULL
Table List
Table: tbl_single_file_upload_error
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
group_member_id INT(11) Yes No No
school_id VARCHAR(45) Yes No No
school_name VARCHAR(255) Yes No No
student_PRN VARCHAR(100) Yes No No
student_name VARCHAR(255) Yes No No
student_email_id VARCHAR(50) Yes No No
student_mobile_no BIGINT(15) Yes No No
teacher_id VARCHAR(100) Yes No No
teacher_name VARCHAR(255) Yes No No
teacher_email_id VARCHAR(50) Yes No No
teacher_mobile_no BIGINT(15) Yes No No
teacher_emp_type_id VARCHAR(45) Yes No No
subject_code VARCHAR(50) Yes No No
subject_name VARCHAR(255) Yes No No
academic_year VARCHAR(50) No No No NULL
error_message VARCHAR(255) Yes No No
upload_date DATETIME Yes No No
uploaded_by VARCHAR(255) Yes No No
batch_id VARCHAR(255) Yes No No
input_file_name VARCHAR(255) Yes No No
Table List
Table: tbl_social_points
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
media_name VARCHAR(50) No No No NULL
media_logo VARCHAR(50) No No No NULL
points INT(11) No No No NULL
Table List
Table: tbl_special_project
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
project_name VARCHAR(100) No No No NULL
project_code VARCHAR(30) No No No NULL
project_enabled INT(2) No No No ‘1’
created_date TIMESTAMP Yes No No CURRENT_TIMESTAMP
Table List
Table: tbl_special_project_coordinators
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
college_id VARCHAR(50) No No No NULL
college_name VARCHAR(250) No No No NULL
special_project_name VARCHAR(100) No No No NULL
special_project_id VARCHAR(30) No No No NULL
special_project_coordinator_name VARCHAR(150) No No No NULL
special_project_coordinator_phone VARCHAR(150) No No No NULL
special_project_coordinator_email VARCHAR(150) No No No NULL
created_date TIMESTAMP Yes No No CURRENT_TIMESTAMP
Table List
Table: tbl_sponsor_payment
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
cust_name VARCHAR(100) No No No NULL
cust_address TEXT No No No NULL
cust_city VARCHAR(100) No No No NULL
cust_zip_code INT(20) No No No NULL
cust_state VARCHAR(100) No No No NULL
cust_country VARCHAR(100) No No No NULL
cust_country_Code INT(9) No No No NULL
cust_email VARCHAR(255) No No No NULL
cust_school_id VARCHAR(55) No No No NULL
cust_id VARCHAR(100) No No No NULL
cust_coupon_id INT(30) No No No NULL
cust_product_code VARCHAR(100) No No No NULL
cust_entity_id INT No No No NULL
cust_sponsor_id VARCHAR(50) No No No NULL
cust_sponsor_name VARCHAR(255) No No No NULL
cust_sponsor_address TEXT No No No NULL
cust_sponsor_city VARCHAR(55) No No No NULL
cust_sponsor_country VARCHAR(55) No No No NULL
cust_sponsor_country_code VARCHAR(55) No No No NULL
cust_sponsor_state VARCHAR(50) No No No NULL
cust_sponsor_email VARCHAR(255) No No No NULL
cust_sponsor_phone VARCHAR(50) No No No NULL
cust_actual_amount INT(50) No No No NULL
cust_paid_amount INT(50) No No No NULL
cust_discount_per INT(50) No No No NULL
cust_pay_mode VARCHAR(50) No No No NULL
cust_pay_status VARCHAR(50) No No No NULL
cust_pay_trans_id VARCHAR(255) No No No NULL
cust_date_time DATETIME Yes No No
Table List
Table: tbl_sponsored
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Vendor_Member_Id VARCHAR(50) No No No NULL
Sponser_type VARCHAR(255) No No No NULL
Sponser_product VARCHAR(255) No No No NULL
school_id INT(11) No No No NULL
points_per_product VARCHAR(25) No No No NULL
sponsered_date DATETIME Yes No No
old_sponsered_date VARCHAR(20) No No No NULL
valid_no_of_student INT(25) No No No NULL
validity VARCHAR(55) No No No ‘valid’
sponsor_id INT(11) No No No NULL
product_image TEXT No No No NULL
valid_until DATETIME Yes No No
old_valid_until VARCHAR(20) No No No NULL
category INT(11) No No No NULL
product_price FLOAT No No No ‘0’
discount FLOAT No No No NULL
buy INT(11) No No No NULL
get INT(11) No No No NULL
saving FLOAT No No No NULL
offer_description TEXT No No No NULL
daily_limit VARCHAR(11) No No No NULL
total_coupons VARCHAR(11) No No No NULL
priority INT(11) No No No NULL
coupon_code_ifunique VARCHAR(20) No No No NULL
currency VARCHAR(20) No No No NULL
daily_counter VARCHAR(20) No No No NULL
old_reset_date VARCHAR(20) No No No NULL
reset_date DATETIME Yes No No
revenue_percent FLOAT Yes No No
revenue_per_visit DOUBLE Yes No No
Table List
Table: tbl_sponsorer
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Vendor_Member_Id VARCHAR(50) No No No NULL
sp_name VARCHAR(255) No No No NULL
sp_address TEXT No No No NULL
sp_city VARCHAR(55) No No No NULL
sp_dob DATE Yes No No
old_sp_dob VARCHAR(55) No No No NULL
sp_gender VARCHAR(15) No No No NULL
sp_country VARCHAR(55) No No No NULL
sp_state VARCHAR(50) No No No NULL
sp_email VARCHAR(255) No No No NULL
CountryCode INT(9) No No No NULL
sp_phone VARCHAR(60) No No No NULL
sp_password VARCHAR(25) No No No NULL
sp_date DATETIME Yes No No
old_sp_date VARCHAR(55) No No No NULL
sp_occupation VARCHAR(255) No No No NULL
sp_company VARCHAR(255) No No No NULL
sp_website VARCHAR(255) No No No NULL
sp_img_path VARCHAR(255) No No No NULL
school_id VARCHAR(55) No No No NULL
register_throught VARCHAR(255) No No No NULL
lat VARCHAR(255) No No No NULL
lon VARCHAR(255) No No No NULL
sales_p_lon VARCHAR(30) No No No NULL
sales_p_lat VARCHAR(30) No No No NULL
calculated_lat VARCHAR(50) No No No NULL
calculated_lon VARCHAR(50) No No No NULL
pin VARCHAR(11) No No No NULL
sales_person_id INT(11) No No No NULL
expiry_date DATETIME Yes No No
old_expiry_date VARCHAR(25) No No No NULL
amount VARCHAR(25) No No No NULL
v_status VARCHAR No No No NULL
v_likes INT(11) No No No NULL
v_category VARCHAR(100) No No No NULL
temp_phone VARCHAR(20) No No No NULL
otp_phone VARCHAR(5) No No No NULL
temp_email VARCHAR(30) No No No NULL
otp_email VARCHAR(5) No No No NULL
sp_landline VARCHAR(30) No No No NULL
source VARCHAR(50) No No No NULL
calback_date_time DATETIME Yes No No
owner_id VARCHAR(20) No No No NULL
LastInsertOrUpdate TIMESTAMP No No No CURRENT_TIMESTAMP
old_calback_date_time VARCHAR(80) No No No NULL
comment VARCHAR(80) No No No NULL
v_responce_status VARCHAR(20) No No No NULL
entity_id INT(20) No No No NULL
user_member_id INT(30) No No No NULL
platform_source VARCHAR(30) No No No NULL
app_version VARCHAR(20) No No No NULL
payment_method VARCHAR(50) No No No NULL
current_marketing VARCHAR(100) No No No NULL
current_market_val VARCHAR(45) Yes No No
discount VARCHAR(100) No No No NULL
discount_val VARCHAR(45) Yes No No
minimum_discount INT(15) No No No NULL
points_for_minimum_discount INT(15) No No No NULL
digital_marketing VARCHAR(200) No No No NULL
digital_market_val VARCHAR(45) Yes No No
sponaor_img_path VARCHAR(500) No No No NULL
rolling_message TEXT No No No NULL
field_message TEXT No No No NULL
prefered INT(2) No No No NULL
webpage_name VARCHAR(45) No No No NULL
Table List
Table: tbl_state
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
state_id INT(11) Yes Yes No
country_id INT(11) No No No NULL
state VARCHAR(40) No No No NULL
Table List
Table: tbl_stud_first_login
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id TINYINT(6) Yes Yes No
school_id VARCHAR(50) Yes No No
default_points INT(3) Yes No No
Table List
Table: tbl_student
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
Roll_no INT(11) No No No NULL
std_PRN VARCHAR(100) No No No NULL
std_complete_name VARCHAR(255) No No No NULL
std_name VARCHAR(255) No No No NULL
std_lastname VARCHAR(30) No No No NULL
std_Father_name VARCHAR(255) No No No NULL
std_complete_father_name VARCHAR(60) No No No NULL
std_dob DATE Yes No No
old_std_dob TEXT No No No NULL
std_age INT(11) No No No NULL
std_school_name VARCHAR(255) No No No NULL
school_id VARCHAR(50) No No No NULL
sc_staff_id INT No No No NULL
std_branch VARCHAR(200) No No No NULL
std_dept VARCHAR(200) No No No NULL
std_year VARCHAR(30) No No No NULL
std_semester VARCHAR(30) No No No NULL
std_class VARCHAR(55) No No No NULL
Specialization VARCHAR(200) No No No NULL
std_address TEXT No No No NULL
std_city VARCHAR(55) No No No NULL
std_country VARCHAR(55) No No No NULL
country_code VARCHAR(11) No No No NULL
std_gender VARCHAR(15) No No No NULL
std_div VARCHAR(55) No No No NULL
std_hobbies VARCHAR(255) No No No NULL
std_classteacher_name VARCHAR(255) No No No NULL
std_img_path VARCHAR(255) No No No NULL
std_email VARCHAR(255) No No No NULL
std_username VARCHAR(55) No No No NULL
std_password VARCHAR(55) No No No NULL
std_date DATETIME Yes No No
old_std_date VARCHAR(55) No No No NULL
parent_id INT(11) No No No NULL
latitude VARCHAR(255) No No No NULL
longitude VARCHAR(255) No No No NULL
std_phone VARCHAR(55) No No No NULL
std_state VARCHAR(25) No No No NULL
used_blue_points INT(11) No No No NULL
balance_bluestud_points INT(11) No No No NULL
used_water_points INT(11) No No No ‘0’
balance_water_points INT(200) No No No NULL
batch_id VARCHAR(255) No No No NULL
error_records VARCHAR(30) No No No NULL
send_unsend_status VARCHAR(20) Yes No No ‘Unsend’
email_status VARCHAR(25) Yes No No ‘Unsend’
Temp_address TEXT No No No NULL
permanent_address TEXT No No No NULL
Permanent_village TEXT No No No NULL
Permanent_taluka TEXT No No No NULL
Permanent_district TEXT No No No NULL
Permanent_pincode TEXT No No No NULL
Email_Internal VARCHAR(100) No No No NULL
Admission_year_id VARCHAR(50) No No No NULL
Academic_Year VARCHAR(50) No No No NULL
Course_level VARCHAR(50) No No No NULL
Iscoordinator VARCHAR No No No NULL
Gcm_id TEXT No No No NULL
college_mnemonic VARCHAR(30) No No No NULL
fb_id VARCHAR(20) No No No NULL
gplus_id VARCHAR(100) No No No NULL
ExtBranchId VARCHAR(30) No No No NULL
ExtDeptId VARCHAR(30) No No No NULL
ExtSemesterId VARCHAR(30) No No No NULL
validity VARCHAR(30) No No No NULL
status VARCHAR(30) No No No NULL
uploaded_by INT(11) Yes No No
upload_date DATETIME No No No NULL
linkedin_id VARCHAR(100) No No No NULL
RegistrationSource VARCHAR(50) No No No NULL
sms_time_log DATETIME No No No NULL
email_time_log DATETIME No No No NULL
sms_response VARCHAR(100) No No No NULL
group_member_id INT(11) Yes No No
entity_type_id INT(11) No No No NULL
emp_designation VARCHAR(100) No No No NULL
reporting_manager_id VARCHAR(100) No No No NULL
group_status VARCHAR(60) No No No NULL
is_accept_terms INT(2) No No No ‘0’ 0 stand for not accepted and 1 for accepted
accept_terms_date DATETIME No No No NULL
Teacher_Member_Id INT(11) No No No NULL
promotion TINYINT(1) No No No ‘0’
first_login_date DATETIME No No No NULL
last_login_date DATETIME No No No NULL
Table List
Table: tbl_student_feedback
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
stu_feed_ID INT(11) Yes Yes No
stu_feed_student_ID VARCHAR(150) No No No NULL
stu_feed_academic_year INT(100) No No No NULL
stu_feed_semester_ID VARCHAR(50) No No No NULL
stu_feed_branch_ID VARCHAR(50) No No No NULL
stu_feed_dept_ID VARCHAR(50) No No No NULL
stu_feed_que_ID VARCHAR(50) No No No NULL
stu_feed_que VARCHAR(50) No No No NULL
stu_feed_points INT(11) No No No NULL
stu_feed_school_id VARCHAR(100) No No No NULL
stu_feed_subj VARCHAR(150) No No No NULL
stud_subjcet_code VARCHAR(150) No No No NULL
stu_feed_teacher_id VARCHAR(45) No No No NULL
stu_feed_course_level VARCHAR(45) No No No NULL
stu_feed_comment VARCHAR(255) No No No NULL
stu_feed_group_member_id VARCHAR(45) No No No NULL
Table List
Table: tbl_student_point
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
sc_stud_id VARCHAR(100) No No No NULL
sc_entites_id INT(11) No No No NULL
sc_teacher_id VARCHAR(100) No No No NULL
sc_studentpointlist_id VARCHAR(55) No No No NULL
subject_id VARCHAR(22) No No No NULL
sc_point INT(15) No No No NULL
sc_outofpoint INT(15) No No No NULL
point_date DATETIME Yes No No
old_point_date VARCHAR(25) No No No NULL
sc_status VARCHAR(15) No No No NULL
marks VARCHAR(20) No No No NULL
method VARCHAR(20) No No No NULL
reason VARCHAR(255) No No No NULL
comment VARCHAR(255) No No No NULL
activity_type VARCHAR(15) No No No NULL
coordinate_id VARCHAR(100) No No No NULL
type_points VARCHAR(50) No No No NULL
school_id VARCHAR(100) No No No NULL
Receiver_SchoolID VARCHAR(100) No No No NULL
referral_id BIGINT(20) Yes No No
activity_id INT(11) Yes No No
teacher_member_id BIGINT(20) Yes No No
sc_id VARCHAR(20) No No No NULL
sc_list VARCHAR(50) No No No NULL
sc_type VARCHAR(11) No No No NULL
Branch_ID VARCHAR(50) No No No NULL
subject VARCHAR(55) No No No NULL
Subject_Code VARCHAR(45) No No No NULL
Year_ID VARCHAR(45) No No No NULL
Course_Level_PID VARCHAR(45) No No No NULL
Dept_id VARCHAR(45) No No No NULL
Uploaded_by VARCHAR(45) No No No NULL
a_desc VARCHAR(45) No No No NULL
a_alloc_points VARCHAR(45) No No No NULL
Semester_id VARCHAR(45) No No No NULL
source VARCHAR(50) No No No NULL
category VARCHAR(100) No No No NULL
sub_category VARCHAR(100) No No No NULL
Table List
Table: tbl_student_project_intersect
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
std_PRN VARCHAR(50) Yes No No
std_member_id VARCHAR(50) No No No NULL
school_id VARCHAR(50) Yes No No
project_id VARCHAR(30) No No No NULL
source VARCHAR(50) No No No NULL
date_time TIMESTAMP Yes No No CURRENT_TIMESTAMP
geo_lat VARCHAR(100) No No No NULL
geo_long VARCHAR(100) No No No NULL
treecount TINYINT(4) No No No NULL
Table List
Table: tbl_student_project_transaction
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
std_PRN VARCHAR(50) Yes No No
std_member_id VARCHAR(50) No No No NULL
school_id VARCHAR(50) Yes No No
project_id VARCHAR(30) No No No NULL
source VARCHAR(50) No No No NULL
date_time TIMESTAMP Yes No No CURRENT_TIMESTAMP
geo_lat VARCHAR(100) No No No NULL
geo_long VARCHAR(100) No No No NULL
object_photo VARCHAR(255) No No No NULL
Table List
Table: tbl_student_recognition
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
student_recognition VARCHAR(40) No No No NULL
school_id VARCHAR No No No NULL
Table List
Table: tbl_student_reward
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
sc_assigned_by VARCHAR(11) No No No NULL
sc_reward VARCHAR(255) No No No NULL
sc_total_point INT(11) No No No NULL
sc_stud_id VARCHAR(100) No No No NULL
online_flag VARCHAR(60) No No No NULL
sc_date DATETIME Yes No No
old_sc_date VARCHAR(55) No No No NULL
yellow_points INT(20) Yes No No ‘0’
purple_points INT(11) No No No NULL
school_id VARCHAR(20) No No No NULL
Receiver_SchoolID VARCHAR(100) No No No NULL
brown_point VARCHAR(50) No No No NULL
Table List
Table: tbl_student_subject
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
stud_sub_id INT(100) Yes Yes No
ExtSemesterId INT(25) No No No NULL
ExtBranchId INT(25) No No No NULL
ExtSchoolSubjectId INT(25) No No No NULL
ExtYearID INT(25) No No No NULL
ExtDivisionID INT(25) No No No NULL
student_id VARCHAR(100) No No No NULL
teacher_ID VARCHAR(100) No No No NULL
school_id VARCHAR(100) No No No NULL
school_staff_id VARCHAR(50) No No No NULL
subjcet_code VARCHAR(100) No No No NULL
subjectName VARCHAR(500) No No No NULL
Division_id VARCHAR(50) No No No NULL
Semester_id VARCHAR(100) No No No NULL
Branches_id VARCHAR(100) No No No NULL
Department_id VARCHAR(100) No No No NULL
CourseLevel VARCHAR(100) No No No NULL
AcademicYear VARCHAR(100) No No No NULL
status VARCHAR(50) No No No NULL
upload_date VARCHAR(100) No No No NULL
uploaded_by VARCHAR(150) No No No NULL
batch_id VARCHAR(100) No No No NULL
validity VARCHAR(25) No No No NULL
tbl_student_subject_master_id INT(30) No No No NULL
error_msg VARCHAR(255) Yes No No
group_member_id INT(11) Yes No No
group_admin_id VARCHAR(45) No No No NULL
Table List
Table: tbl_student_subject_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(150) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
Teacher_Member_Id VARCHAR(50) No No No NULL
ExtSemesterId INT(25) No No No NULL
ExtBranchId INT(25) No No No NULL
ExtSchoolSubjectId INT(25) No No No NULL
ExtYearID INT(25) No No No NULL
ExtDivisionID INT(25) No No No NULL
student_id VARCHAR(100) No No No NULL
teacher_ID VARCHAR(100) No No No NULL
school_id VARCHAR(100) No No No NULL
school_staff_id VARCHAR(50) No No No NULL
subjcet_code VARCHAR(100) Yes Yes No ”
subjectName VARCHAR(500) No No No NULL
Division_id VARCHAR(50) No No No NULL
Semester_id VARCHAR(100) No No No NULL
Branches_id VARCHAR(100) No No No NULL
Department_id VARCHAR(100) No No No NULL
CourseLevel VARCHAR(100) No No No NULL
AcademicYear VARCHAR(100) No No No NULL
old_upload_date VARCHAR(100) No No No NULL
uploaded_by VARCHAR(150) No No No NULL
batch_id VARCHAR(60) No No No NULL
group_member_id INT(11) Yes No No
upload_date DATETIME Yes No No
Table List
Table: tbl_student_subject_registration
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(12) Yes Yes No
Student_Reg_Code VARCHAR(20) No No No NULL
Division_ID VARCHAR(15) No No No NULL
Semester_ID VARCHAR(15) No No No NULL
Branches_Subject_Detail_ID VARCHAR(40) No No No NULL
Subject_Details_ID VARCHAR(30) No No No NULL
Subject_Category_ID VARCHAR(50) No No No NULL
Subject_Code VARCHAR(30) No No No NULL
Year_ID VARCHAR(20) No No No NULL
College_ID VARCHAR(15) No No No NULL
Is_Enabled VARCHAR(20) No No No NULL
Created_By VARCHAR(40) No No No NULL
Created_On DATETIME No No No NULL
Modified_By VARCHAR(40) No No No NULL
Modified_On DATETIME No No No NULL
Table List
Table: tbl_studentpointslist
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
sc_id INT(11) Yes Yes No
sc_list VARCHAR(250) No No No NULL
sc_type INT(11) No No No NULL
sc_outofpoint INT(15) No No No NULL
school_id VARCHAR(50) No No No NULL
group_member_id INT(11) No No No NULL
marks INT(11) No No No NULL
Table List
Table: tbl_subject
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No tbl_teacher_subject
subject TEXT No No No NULL
teacher_id VARCHAR(100) No No No NULL
school_id INT(11) No No No NULL
Table List
Table: tbl_subjectdetails
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(12) Yes Yes No
subject_id VARCHAR(50) No No No NULL
Subject_Code VARCHAR(40) No No No NULL
Semester_ID VARCHAR(20) No No No NULL
Table List
Table: tbl_teacher
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Teacher_Member_Id VARCHAR(50) No No No NULL
t_id VARCHAR(100) No No No NULL
t_complete_name VARCHAR(55) No No No NULL
t_name VARCHAR(50) No No No NULL
t_middlename VARCHAR(50) No No No NULL
t_lastname VARCHAR(50) No No No NULL
t_current_school_name VARCHAR(255) No No No NULL
school_id VARCHAR(50) No No No NULL
t_school_staff_id INT(100) No No No NULL
t_dept VARCHAR(100) No No No NULL
t_DeptID VARCHAR(255) No No No NULL
t_exprience VARCHAR(55) No No No NULL
t_designation VARCHAR(50) Yes No No
t_subject VARCHAR(255) No No No NULL
t_class VARCHAR(255) No No No NULL
t_qualification VARCHAR(55) No No No NULL
t_address TEXT No No No NULL
t_city VARCHAR(55) No No No NULL
t_dob DATE Yes No No
old_t_dob VARCHAR(25) No No No NULL
t_age INT(11) No No No NULL
t_gender VARCHAR(25) No No No NULL
t_country VARCHAR(55) No No No NULL
t_email VARCHAR(255) No No No NULL
t_internal_email VARCHAR(40) No No No NULL
t_password VARCHAR(55) No No No NULL
t_date DATETIME Yes No No
old_t_date VARCHAR(55) No No No NULL
t_pc VARCHAR(255) No No No NULL
CountryCode INT(9) No No No NULL
t_phone VARCHAR(50) No No No NULL
t_landline VARCHAR(50) No No No NULL
tc_balance_point INT(11) No No No NULL
tc_used_point INT(11) No No No NULL
state VARCHAR(50) No No No NULL
balance_blue_points INT(11) No No No NULL
used_blue_points INT(11) No No No NULL
batch_id VARCHAR(255) No No No NULL
error_records VARCHAR(30) No No No ‘Correct’
send_unsend_status VARCHAR No No No ‘Unsend’
email_status VARCHAR(25) No No No ‘Unsend’
t_temp_address VARCHAR(50) No No No NULL
t_permanent_village VARCHAR(50) No No No NULL
t_permanent_taluka VARCHAR(50) No No No NULL
t_permanent_district VARCHAR(50) No No No NULL
t_permanent_pincode VARCHAR(50) No No No NULL
t_date_of_appointment VARCHAR(30) No No No NULL
t_appointment_type_pid VARCHAR(20) No No No NULL
t_emp_type_pid VARCHAR(25) No No No NULL
entity_type_id INT(11) No No No NULL
college_mnemonic VARCHAR(50) No No No NULL
water_point INT(11) No No No NULL
brown_point VARCHAR(50) No No No NULL
email_time_log DATETIME No No No NULL
sms_time_log DATETIME No No No NULL
created_by INT(11) No No No NULL
created_on DATETIME No No No NULL
reporting_manager_id VARCHAR(100) No No No NULL
group_member_id INT(11) No No No NULL
school_type VARCHAR(45) No No No NULL
group_status VARCHAR(45) No No No NULL
sms_response VARCHAR(100) No No No NULL
t_academic_year VARCHAR(15) No No No NULL
is_accept_terms INT(2) No No No ‘0’ 0 stand for not accepted and 1 for accepted
accept_terms_date DATETIME No No No NULL
Stud_Member_Id INT(11) No No No NULL
first_login_date DATETIME No No No NULL
last_login_date DATETIME No No No NULL
Table List
Table: tbl_teacher_coupon
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Teacher_Member_Id VARCHAR(50) No No No NULL
coupon_id VARCHAR(50) No No No NULL
amount INT(11) No No No NULL
old_issue_date VARCHAR(50) No No No NULL
old_validity_date VARCHAR(50) No No No NULL
user_id VARCHAR(100) No No No NULL
used_points VARCHAR(20) No No No NULL
status VARCHAR(50) No No No NULL
original_point VARCHAR(100) No No No NULL
issue_date DATETIME Yes No No
validity_date DATETIME Yes No No
Table List
Table: tbl_teacher_designation
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
school_id VARCHAR(45) No No No NULL
designation VARCHAR(45) No No No NULL
Table List
Table: tbl_teacher_point
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Teacher_Member_Id VARCHAR(50) No No No NULL
sc_teacher_id VARCHAR(100) No No No NULL
sc_entities_id VARCHAR(100) No No No NULL
assigner_id VARCHAR(100) No No No NULL
sc_thanqupointlist_id INT(11) No No No NULL
sc_point INT(11) No No No NULL
point_date DATETIME Yes No No
old_point_date VARCHAR(50) No No No NULL
method VARCHAR(100) No No No NULL
reason VARCHAR(255) No No No NULL
comment VARCHAR(255) No No No NULL
activity_type VARCHAR(100) No No No NULL
school_id VARCHAR(30) No No No NULL
Receiver_SchoolID VARCHAR(100) No No No NULL
point_type VARCHAR(20) No No No NULL
reward_type VARCHAR(250) No No No NULL
referral_id BIGINT(20) Yes No No
source VARCHAR(50) No No No NULL
category VARCHAR(100) No No No NULL
sub_category VARCHAR(100) No No No NULL
Table List
Table: tbl_teacher_subject_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
tch_sub_id INT(50) Yes Yes No
Teacher_Member_Id VARCHAR(50) No No No NULL
ExtSemesterId INT(25) No No No NULL
ExtBranchId INT(25) No No No NULL
ExtSchoolSubjectId INT(25) No No No NULL
ExtYearID INT(25) No No No NULL
ExtDivisionID VARCHAR(25) No No No NULL
ExtDeptId VARCHAR(50) No No No NULL
teacher_id VARCHAR(100) No No No NULL
school_id VARCHAR(100) No No No NULL
school_staff_id INT(100) No No No NULL
subjcet_code VARCHAR(100) No No No NULL
subjectName VARCHAR(150) No No No NULL
Division_id VARCHAR(50) No No No NULL
Semester_id VARCHAR(50) No No No NULL
Branches_id VARCHAR(150) No No No NULL
Department_id VARCHAR(100) No No No NULL
CourseLevel VARCHAR(100) No No No NULL
AcademicYear VARCHAR(100) No No No NULL
upload_date DATETIME No No No NULL
uploaded_by VARCHAR(150) No No No NULL
batch_id VARCHAR(60) No No No NULL
reporting_manager_id VARCHAR(100) No No No NULL
Table List
Table: tbl_teachr_subject_row
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
tch_sub_id INT(50) Yes Yes No
ExtSemesterId INT(25) No No No NULL
ExtBranchId INT(25) No No No NULL
ExtSchoolSubjectId INT(25) No No No NULL
ExtYearID INT(25) No No No NULL
ExtDivisionID VARCHAR(25) No No No NULL
ExtDeptId INT(25) No No No NULL
teacher_id VARCHAR(100) No No No NULL
school_id VARCHAR(100) No No No NULL
school_staff_id VARCHAR(100) No No No NULL
subjcet_code VARCHAR(100) No No No NULL
subjectName VARCHAR(150) No No No NULL
Division_id VARCHAR(100) No No No NULL
Semester_id VARCHAR(100) No No No NULL
Branches_id VARCHAR(100) No No No NULL
Department_id VARCHAR(100) No No No NULL
CourseLevel VARCHAR(100) No No No NULL
AcademicYear VARCHAR(100) No No No NULL
status VARCHAR(100) No No No NULL
upload_date DATETIME No No No NULL
uploaded_by VARCHAR(150) No No No NULL
batch_id VARCHAR(20) No No No NULL
validity VARCHAR(50) Yes No No
Table List
Table: tbl_thanqyoupointslist
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
t_list VARCHAR(100) No No No NULL
school_id VARCHAR(50) No No No NULL
group_member_id INT(11) No No No ‘0’
Table List
Table: tbl_timetable
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
timeT_ID INT(11) Yes Yes No
timeT_academic_year_ID INT(11) No No No NULL
timeT_semester_ID INT(11) No No No NULL
timeT_branch_ID INT(11) No No No NULL
timeT_dept_ID INT(11) No No No NULL
Table List
Table: tbl_vol_spect_master
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(5) Yes Yes No
category VARCHAR(20) Yes No No
name VARCHAR(100) Yes No No
mobile DOUBLE Yes No No
otp VARCHAR(25) Yes No No
otp_status CHAR Yes No No
total_points INT(50) No No No NULL
registered_on DATETIME Yes No No
reward_points INT(5) No No No NULL
school_id VARCHAR(25) Yes No No
Table List
Table: tbl_waterpoint
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
Stud_Member_Id VARCHAR(50) No No No NULL
Teacher_Member_Id VARCHAR(50) No No No NULL
Parent_Member_Id VARCHAR(45) No No No NULL
group_Member_Id VARCHAR(50) Yes No No
School_Member_Id VARCHAR(50) Yes No No
coupon_id BIGINT(15) No No No NULL
entities_id INT(11) Yes No No
stud_id VARCHAR(100) No No No NULL
school_id VARCHAR(50) No No No NULL
points INT(11) No No No NULL
old_issue_date VARCHAR(50) No No No NULL
issue_date DATETIME Yes No No
Table List
Table: teacher_gcmid
Table Comments
Columns
Name Data Type Nullable PK FK Default Comment
id INT(11) Yes Yes No
teacher_id VARCHAR(100) Yes No No
teacher_PRN VARCHAR(100) Yes No No
gcm_id VARCHAR(300) Yes No No
type VARCHAR(15) No No No NULL