abs

 

 
activities  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

PRI

 

 

Clubs

varchar(30)

YES

 

(NULL)

 

Sports

varchar(30)

YES

 

(NULL)

 

OfficeHeld

varchar(30)

YES

 

(NULL)

 

FuturePlan

varchar(200)

YES

 

(NULL)

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

activities

0

PRIMARY

1

AdmissionNo

A

2

(NULL)

(NULL)

 

BTREE

 

Back

 
additionalreportinfo  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(12)

 

 

 

 

MaxAttendance

int(10)

YES

 

(NULL)

 

AttainAttendance

int(10)

YES

 

(NULL)

 

PromotedTo

varchar(10)

YES

 

(NULL)

 

NextTermBegins

varchar(25)

YES

 

(NULL)

 

Interest

varchar(150)

YES

 

(NULL)

 

Attitude

varchar(150)

YES

 

(NULL)

 

Conduct

varchar(150)

YES

 

(NULL)

 

TeacherRemark

varchar(150)

YES

 

(NULL)

 

TeacherSign

varchar(15)

YES

 

(NULL)

 

HeadRemark

varchar(150)

YES

 

(NULL)

 

HeadSign

varchar(15)

YES

 

(NULL)

 

Aggregate

int(10)

YES

 

(NULL)

 

Indexes

Back

 
admissionqualification  
Fields
Field Type Null Key Default Extra

FormNo

varchar(20)

 

 

 

 

Years

varchar(50)

YES

 

(NULL)

 

Institution

varchar(100)

YES

 

(NULL)

 

Qualification

varchar(60)

YES

 

(NULL)

 

Subjects

varchar(50)

YES

 

(NULL)

 

Grade

varchar(4)

YES

 

(NULL)

 

OLevel

int(10)

YES

 

(NULL)

 

ALevel

int(10)

YES

 

(NULL)

 

Sssce

int(10)

YES

 

(NULL)

 

Diploma

int(10)

YES

 

(NULL)

 

PostDiploma

int(10)

YES

 

(NULL)

 

Degree

int(10)

YES

 

(NULL)

 

Masters

int(10)

YES

 

(NULL)

 

Phd

int(10)

YES

 

(NULL)

 

ProgrammeID

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
admissionregister  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

FNAME

varchar(20)

YES

 

(NULL)

 

CLASSFORM

varchar(25)

YES

 

(NULL)

 

FATHER

varchar(40)

YES

 

(NULL)

 

PERADDRESS

varchar(100)

YES

 

(NULL)

 

REGION

varchar(40)

YES

 

(NULL)

 

HOMETOWN

varchar(30)

YES

 

(NULL)

 

MNAME

varchar(20)

YES

 

(NULL)

 

LNAME

varchar(20)

YES

 

(NULL)

 

MOTHER

varchar(30)

YES

 

(NULL)

 

ADMISSIONDATE

varchar(50)

YES

 

(NULL)

 

TERMSECTION

varchar(20)

YES

 

(NULL)

 

CORADDRESS

varchar(100)

YES

 

(NULL)

 

COUNTRY

varchar(40)

YES

 

(NULL)

 

COURSESUBJECT

varchar(50)

YES

 

(NULL)

 

RESSTATUS

varchar(30)

YES

 

(NULL)

 

TELEPHONE

varchar(15)

YES

 

(NULL)

 

DATEOFBIRTH

varchar(50)

YES

 

(NULL)

 

EMAIL

varchar(60)

YES

 

(NULL)

 

REMARKS

varchar(100)

YES

 

(NULL)

 

SEX

varchar(10)

YES

 

(NULL)

 

CLASSFORMDESC

varchar(100)

YES

 

(NULL)

 

ACADEMICYEAR

varchar(25)

YES

 

(NULL)

 

PROMOSTATUS

varchar(20)

YES

 

(NULL)

 

CourseDescription

varchar(100)

YES

 

(NULL)

 

Department

varchar(100)

YES

 

(NULL)

 

Faculty

varchar(100)

YES

 

(NULL)

 

StatusOld

varchar(20)

YES

 

(NULL)

 

FatherName

varchar(50)

YES

 

(NULL)

 

MotherName

varchar(50)

YES

 

(NULL)

 

GName

varchar(50)

YES

 

(NULL)

 

GAddress

varchar(50)

YES

 

(NULL)

 

GAddress1

varchar(50)

YES

 

(NULL)

 

GAddress2

varchar(50)

YES

 

(NULL)

 

Gtel

varchar(50)

YES

 

(NULL)

 

Gemail

varchar(50)

YES

 

(NULL)

 

PreviousSchool

varchar(200)

YES

 

(NULL)

 

GResidence

varchar(100)

YES

 

(NULL)

 

HearSchool

varchar(200)

YES

 

(NULL)

 

OtherWards

varchar(100)

YES

 

(NULL)

 

HseNo

varchar(50)

YES

 

(NULL)

 

GuardianID

varchar(50)

YES

 

(NULL)

 

House

varchar(10)

YES

 

(NULL)

 

Religion

varchar(100)

YES

 

(NULL)

 

Transport

varchar(20)

YES

 

(NULL)

 

AdminDate

varchar(20)

YES

 

(NULL)

 

Status

varchar(20)

YES

 

(NULL)

 

Scholarship

varchar(50)

YES

 

(NULL)

 

Relationship

varchar(50)

YES

 

(NULL)

 

ADMISSIONDATEREV

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
admissionrequirement  
Fields
Field Type Null Key Default Extra

ProgrammeID

varchar(50)

 

 

 

 

CoreSubject1

varchar(50)

YES

 

(NULL)

 

CoreGrade1

varchar(4)

YES

 

(NULL)

 

CoreSubject2

varchar(50)

YES

 

(NULL)

 

CoreGrade2

varchar(4)

YES

 

(NULL)

 

CoreSubject3

varchar(50)

YES

 

(NULL)

 

CoreGrade3

varchar(4)

YES

 

(NULL)

 

ReqSubject1

varchar(50)

YES

 

(NULL)

 

ReqGrade1

varchar(4)

YES

 

(NULL)

 

ReqSubject2

varchar(50)

YES

 

(NULL)

 

ReqGrade2

varchar(4)

YES

 

(NULL)

 

ReqSubject3

varchar(50)

YES

 

(NULL)

 

ReqGrade3

varchar(4)

YES

 

(NULL)

 

AgeLimit

int(10)

YES

 

(NULL)

 

SssAggregate

int(10)

YES

 

(NULL)

 

OtherReq1

varchar(50)

YES

 

(NULL)

 

OtherReq2

varchar(50)

YES

 

(NULL)

 

ProgrammeDesc

varchar(200)

YES

 

(NULL)

 

LevelID

varchar(50)

YES

 

(NULL)

 

Dept

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
applicationadmission  
Fields
Field Type Null Key Default Extra

FormNo

varchar(20)

 

 

 

 

LName

varchar(20)

YES

 

(NULL)

 

MName

varchar(20)

YES

 

(NULL)

 

FName

varchar(20)

YES

 

(NULL)

 

CurrentAddress

varchar(100)

YES

 

(NULL)

 

PAddress

varchar(100)

YES

 

(NULL)

 

BDate

varchar(25)

YES

 

(NULL)

 

Gender

varchar(10)

YES

 

(NULL)

 

BusenessAddress

varchar(100)

YES

 

(NULL)

 

ResAddress

varchar(100)

YES

 

(NULL)

 

YrExpirence

varchar(25)

YES

 

(NULL)

 

Fax

varchar(20)

YES

 

(NULL)

 

Email

varchar(50)

YES

 

(NULL)

 

WorkPlace

varchar(100)

YES

 

(NULL)

 

StChoice

varchar(100)

YES

 

(NULL)

 

NdChoice

varchar(100)

YES

 

(NULL)

 

RdChoice

varchar(100)

YES

 

(NULL)

 

SponsorName

varchar(50)

YES

 

(NULL)

 

SponsorAddress

varchar(100)

YES

 

(NULL)

 

SponsorEmail

varchar(50)

YES

 

(NULL)

 

SponsorTel

varchar(50)

YES

 

(NULL)

 

AggregateObtained

int(10)

YES

 

(NULL)

 

AdmissionStatus

varchar(20)

YES

 

(NULL)

 

NoofSubjects

int(10)

YES

 

(NULL)

 

Indexes

Back

 
applicationpath  
Fields
Field Type Null Key Default Extra

ApplicationPath

blob

YES

 

(NULL)

 

Indexes

Back

 
assessmentregister  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(12)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

Assignment1

float(15,0)

YES

 

(NULL)

 

Assignment2

float(15,0)

YES

 

(NULL)

 

Assignment3

float(15,0)

YES

 

(NULL)

 

Assignment4

float(15,0)

YES

 

(NULL)

 

Assignment5

float(15,0)

YES

 

(NULL)

 

Assignment6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

ClassTest1

float(15,0)

YES

 

(NULL)

 

ClassTest2

float(15,0)

YES

 

(NULL)

 

ClassTest3

float(15,0)

YES

 

(NULL)

 

ClassTest4

float(15,0)

YES

 

(NULL)

 

ClassTest5

float(15,0)

YES

 

(NULL)

 

ClassTest6

float(15,0)

YES

 

(NULL)

 

SubTotal1

float(15,0)

YES

 

(NULL)

 

Homework1

float(15,0)

YES

 

(NULL)

 

Homework2

float(15,0)

YES

 

(NULL)

 

Homework3

float(15,0)

YES

 

(NULL)

 

Homework4

float(15,0)

YES

 

(NULL)

 

Homework5

float(15,0)

YES

 

(NULL)

 

Homework6

float(15,0)

YES

 

(NULL)

 

SubTotal2

float(15,0)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ExamScoreActual

float(15,0)

YES

 

(NULL)

 

OverAllTotal

double(7,0)

YES

 

(NULL)

 

PositionInSubject

varchar(20)

YES

 

(NULL)

 

TotalClassScorePercentage

float(15,0)

YES

 

(NULL)

 

Mark

double(7,0)

YES

 

(NULL)

 

SubjectPosition

int(10)

YES

 

(NULL)

 

AssignmentTotal

float(15,0)

YES

 

(NULL)

 

TestTotal

float(15,0)

YES

 

(NULL)

 

HomeworkTotal

float(15,0)

YES

 

(NULL)

 

TotalClassScore

float(15,0)

YES

 

(NULL)

 

NoofRoll

varchar(10)

YES

 

(NULL)

 

Indexes

Back

 
assignment  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(12)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

Assignment1

float(15,0)

YES

 

(NULL)

 

Assignment2

float(15,0)

YES

 

(NULL)

 

Assignment3

float(15,0)

YES

 

(NULL)

 

Assignment4

float(15,0)

YES

 

(NULL)

 

Assignment5

float(15,0)

YES

 

(NULL)

 

Assignment6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

NoofCredit

int(10)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
attendancedata  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

YEAR

varchar(10)

YES

 

(NULL)

 

CLASS

varchar(15)

YES

 

(NULL)

 

SCHOOL

varchar(45)

YES

 

(NULL)

 

FEASIBLEATTENDANCE

varchar(4)

YES

 

(NULL)

 

ACTUALATTENDANCE

varchar(4)

YES

 

(NULL)

 

TRANSFERINFOR

varchar(45)

YES

 

(NULL)

 

Indexes

Back

 
audit_log  
Fields
Field Type Null Key Default Extra

ID

int(10)

YES

 

(NULL)

 

aud_SessionID

varchar(50)

YES

 

(NULL)

 

aud_User

varchar(50)

YES

 

(NULL)

 

aud_Date

varchar(25)

YES

 

(NULL)

 

aud_Form

varchar(50)

YES

 

(NULL)

 

time_in

varchar(25)

YES

 

(NULL)

 

time_out

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
audit_trail  
Fields
Field Type Null Key Default Extra

ID

int(10)

YES

 

(NULL)

 

aud_SessionID

varchar(50)

YES

 

(NULL)

 

aud_User

varchar(50)

YES

 

(NULL)

 

aud_Date

varchar(25)

YES

 

(NULL)

 

aud_Form

varchar(50)

YES

 

(NULL)

 

time_in

varchar(25)

YES

 

(NULL)

 

time_out

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
awards  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

DATE

varchar(25)

YES

 

(NULL)

 

AWARD

varchar(30)

YES

 

(NULL)

 

REMARKS

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
balancesheet  
Fields
Field Type Null Key Default Extra

AccountNo

varchar(20)

 

 

 

 

AccountName

varchar(200)

 

 

 

 

MemoCode

char(3)

 

 

 

 

ControlCode

varchar(50)

YES

 

(NULL)

 

MemoDescription

varchar(200)

 

 

 

 

AmtThisYr

decimal(19,4)

YES

 

(NULL)

 

FAssetTotalThisYr

decimal(19,4)

YES

 

(NULL)

 

CAssetTotalThisYr

decimal(19,4)

YES

 

(NULL)

 

CLiabTotalThisYr

decimal(19,4)

YES

 

(NULL)

 

CapitalThisYr

decimal(19,4)

YES

 

(NULL)

 

LTermTermCapitalThisYr

decimal(19,4)

YES

 

(NULL)

 

AmtPreYr

decimal(19,4)

YES

 

(NULL)

 

FAssetTotalPreYr

decimal(19,4)

YES

 

(NULL)

 

CAssetTotalPreYr

decimal(19,4)

YES

 

(NULL)

 

CLiabTotalPreYr

decimal(19,4)

YES

 

(NULL)

 

CapitalPreYr

decimal(19,4)

YES

 

(NULL)

 

LTermTermCapitalPreYr

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
billingtable  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

FNAME

varchar(50)

YES

 

(NULL)

 

MNAME

varchar(50)

YES

 

(NULL)

 

LNAME

varchar(50)

YES

 

(NULL)

 

CLASSFORM

varchar(50)

YES

 

(NULL)

 

TERM

varchar(50)

YES

 

(NULL)

 

ACADEMICYR

varchar(50)

YES

 

(NULL)

 

FEEDESCRIPTION

blob

YES

 

(NULL)

 

AMTTOPAY

decimal(19,4)

YES

 

(NULL)

 

AMTDUE

decimal(19,4)

YES

 

(NULL)

 

TOTPAID

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

BALDATE

varchar(25)

YES

 

(NULL)

 

SFEEDESCRIPTION

blob

YES

 

(NULL)

 

SAMTTOPAY

decimal(19,4)

YES

 

(NULL)

 

SSCHOLARSHIPAMT

decimal(19,4)

YES

 

(NULL)

 

STATUS

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
billingtableclass  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

YES

 

(NULL)

 

FNAME

varchar(30)

YES

 

(NULL)

 

MNAME

varchar(30)

YES

 

(NULL)

 

LNAME

varchar(30)

YES

 

(NULL)

 

CLASSFORM

varchar(100)

YES

 

(NULL)

 

TERM

varchar(100)

YES

 

(NULL)

 

ACADEMICYR

varchar(20)

YES

 

(NULL)

 

FEEDESCRIPTION

varchar(200)

YES

 

(NULL)

 

AMTTOPAY

decimal(19,4)

YES

 

(NULL)

 

AMTDUE

decimal(19,4)

YES

 

(NULL)

 

TOTPAID

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

BALDATE

varchar(25)

YES

 

(NULL)

 

SFEEDESCRIPTION

varchar(200)

YES

 

(NULL)

 

SAMTTOPAY

decimal(19,4)

YES

 

(NULL)

 

SSCHOLARSHIPAMT

decimal(19,4)

YES

 

(NULL)

 

STATUS

varchar(10)

YES

 

(NULL)

 

Indexes

Back

 
booklist  
Fields
Field Type Null Key Default Extra

Category

varchar(200)

YES

 

(NULL)

 

Title

varchar(200)

YES

 

(NULL)

 

Author

varchar(100)

YES

 

(NULL)

 

YrPub

varchar(10)

YES

 

(NULL)

 

QtyReq

varchar(50)

YES

 

(NULL)

 

UnitPrice

decimal(19,4)

YES

 

(NULL)

 

ClassForm

varchar(50)

YES

 

(NULL)

 

Amount

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
booklistprint  
Fields
Field Type Null Key Default Extra

Category

varchar(200)

YES

 

(NULL)

 

Title

varchar(200)

YES

 

(NULL)

 

Author

varchar(100)

YES

 

(NULL)

 

YrPub

varchar(10)

YES

 

(NULL)

 

QtyReq

varchar(50)

YES

 

(NULL)

 

UnitPrice

decimal(19,4)

YES

 

(NULL)

 

ClassForm

varchar(50)

YES

 

(NULL)

 

Amount

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
broadsheet  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

CourseId1

varchar(21)

YES

 

(NULL)

 

CMark1

float(15,0)

YES

 

(NULL)

 

EMark1

float(15,0)

YES

 

(NULL)

 

grade1

varchar(4)

YES

 

(NULL)

 

CourseId2

varchar(21)

YES

 

(NULL)

 

CMark2

float(15,0)

YES

 

(NULL)

 

EMark2

float(15,0)

YES

 

(NULL)

 

grade2

varchar(4)

YES

 

(NULL)

 

CourseId3

varchar(21)

YES

 

(NULL)

 

CMark3

float(15,0)

YES

 

(NULL)

 

EMark3

float(15,0)

YES

 

(NULL)

 

grade3

varchar(4)

YES

 

(NULL)

 

CourseId4

varchar(21)

YES

 

(NULL)

 

CMark4

float(15,0)

YES

 

(NULL)

 

EMark4

float(15,0)

YES

 

(NULL)

 

grade4

varchar(4)

YES

 

(NULL)

 

CourseId5

varchar(21)

YES

 

(NULL)

 

CMark5

float(15,0)

YES

 

(NULL)

 

EMark5

float(15,0)

YES

 

(NULL)

 

grade5

varchar(4)

YES

 

(NULL)

 

CourseId6

varchar(21)

YES

 

(NULL)

 

CMark6

float(15,0)

YES

 

(NULL)

 

EMark6

float(15,0)

YES

 

(NULL)

 

grade6

varchar(4)

YES

 

(NULL)

 

CourseId7

varchar(21)

YES

 

(NULL)

 

CMark7

float(15,0)

YES

 

(NULL)

 

EMark7

float(15,0)

YES

 

(NULL)

 

grade7

varchar(4)

YES

 

(NULL)

 

CourseId8

varchar(21)

YES

 

(NULL)

 

CMark8

float(15,0)

YES

 

(NULL)

 

EMark8

float(15,0)

YES

 

(NULL)

 

grade8

varchar(4)

YES

 

(NULL)

 

CourseId9

varchar(21)

YES

 

(NULL)

 

CMark9

float(15,0)

YES

 

(NULL)

 

EMark9

float(15,0)

YES

 

(NULL)

 

grade9

varchar(4)

YES

 

(NULL)

 

CourseId10

varchar(21)

YES

 

(NULL)

 

CMark10

float(15,0)

YES

 

(NULL)

 

EMark10

float(15,0)

YES

 

(NULL)

 

grade10

varchar(4)

YES

 

(NULL)

 

CourseId11

varchar(21)

YES

 

(NULL)

 

CMark11

float(15,0)

YES

 

(NULL)

 

EMark11

float(15,0)

YES

 

(NULL)

 

grade11

varchar(4)

YES

 

(NULL)

 

CourseId12

varchar(21)

YES

 

(NULL)

 

CMark12

float(15,0)

YES

 

(NULL)

 

EMark12

float(15,0)

YES

 

(NULL)

 

grade12

varchar(4)

YES

 

(NULL)

 

CourseId13

varchar(21)

YES

 

(NULL)

 

CMark13

float(15,0)

YES

 

(NULL)

 

EMark13

float(15,0)

YES

 

(NULL)

 

grade13

varchar(4)

YES

 

(NULL)

 

CourseId14

varchar(21)

YES

 

(NULL)

 

CMark14

float(15,0)

YES

 

(NULL)

 

EMark14

float(15,0)

YES

 

(NULL)

 

grade14

varchar(4)

YES

 

(NULL)

 

CourseId15

varchar(21)

YES

 

(NULL)

 

CMark15

float(15,0)

YES

 

(NULL)

 

EMark15

float(15,0)

YES

 

(NULL)

 

grade15

varchar(4)

YES

 

(NULL)

 

Programme

varchar(50)

YES

 

(NULL)

 

Level1

varchar(50)

YES

 

(NULL)

 

Semester

varchar(20)

YES

 

(NULL)

 

AcademicYr1

varchar(20)

YES

 

(NULL)

 

Faculty

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
broadsheetprinting  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

CourseId1

varchar(21)

YES

 

(NULL)

 

CMark1

float(15,0)

YES

 

(NULL)

 

EMark1

float(15,0)

YES

 

(NULL)

 

grade1

varchar(4)

YES

 

(NULL)

 

CourseId2

varchar(21)

YES

 

(NULL)

 

CMark2

float(15,0)

YES

 

(NULL)

 

EMark2

float(15,0)

YES

 

(NULL)

 

grade2

varchar(4)

YES

 

(NULL)

 

CourseId3

varchar(21)

YES

 

(NULL)

 

CMark3

float(15,0)

YES

 

(NULL)

 

EMark3

float(15,0)

YES

 

(NULL)

 

grade3

varchar(4)

YES

 

(NULL)

 

CourseId4

varchar(21)

YES

 

(NULL)

 

CMark4

float(15,0)

YES

 

(NULL)

 

EMark4

float(15,0)

YES

 

(NULL)

 

grade4

varchar(4)

YES

 

(NULL)

 

CourseId5

varchar(21)

YES

 

(NULL)

 

CMark5

float(15,0)

YES

 

(NULL)

 

EMark5

float(15,0)

YES

 

(NULL)

 

grade5

varchar(4)

YES

 

(NULL)

 

CourseId6

varchar(21)

YES

 

(NULL)

 

CMark6

float(15,0)

YES

 

(NULL)

 

EMark6

float(15,0)

YES

 

(NULL)

 

grade6

varchar(4)

YES

 

(NULL)

 

CourseId7

varchar(21)

YES

 

(NULL)

 

CMark7

float(15,0)

YES

 

(NULL)

 

EMark7

float(15,0)

YES

 

(NULL)

 

grade7

varchar(4)

YES

 

(NULL)

 

CourseId8

varchar(21)

YES

 

(NULL)

 

CMark8

float(15,0)

YES

 

(NULL)

 

EMark8

float(15,0)

YES

 

(NULL)

 

grade8

varchar(4)

YES

 

(NULL)

 

CourseId9

varchar(21)

YES

 

(NULL)

 

CMark9

float(15,0)

YES

 

(NULL)

 

EMark9

float(15,0)

YES

 

(NULL)

 

grade9

varchar(4)

YES

 

(NULL)

 

CourseId10

varchar(21)

YES

 

(NULL)

 

CMark10

float(15,0)

YES

 

(NULL)

 

EMark10

float(15,0)

YES

 

(NULL)

 

grade10

varchar(4)

YES

 

(NULL)

 

CourseId11

varchar(21)

YES

 

(NULL)

 

CMark11

float(15,0)

YES

 

(NULL)

 

EMark11

float(15,0)

YES

 

(NULL)

 

grade11

varchar(4)

YES

 

(NULL)

 

CourseId12

varchar(21)

YES

 

(NULL)

 

CMark12

float(15,0)

YES

 

(NULL)

 

EMark12

float(15,0)

YES

 

(NULL)

 

grade12

varchar(4)

YES

 

(NULL)

 

CourseId13

varchar(21)

YES

 

(NULL)

 

CMark13

float(15,0)

YES

 

(NULL)

 

EMark13

float(15,0)

YES

 

(NULL)

 

grade13

varchar(4)

YES

 

(NULL)

 

CourseId14

varchar(21)

YES

 

(NULL)

 

CMark14

float(15,0)

YES

 

(NULL)

 

EMark14

float(15,0)

YES

 

(NULL)

 

grade14

varchar(4)

YES

 

(NULL)

 

CourseId15

varchar(21)

YES

 

(NULL)

 

CMark15

float(15,0)

YES

 

(NULL)

 

EMark15

float(15,0)

YES

 

(NULL)

 

grade15

varchar(4)

YES

 

(NULL)

 

Programme

varchar(50)

YES

 

(NULL)

 

Level1

varchar(50)

YES

 

(NULL)

 

Semester

varchar(20)

YES

 

(NULL)

 

AcademicYr1

varchar(20)

YES

 

(NULL)

 

Faculty

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
chequeprinting  
Fields
Field Type Null Key Default Extra

PayName

varchar(100)

YES

 

(NULL)

 

AmountWords

varchar(200)

YES

 

(NULL)

 

Amount

decimal(19,4)

YES

 

(NULL)

 

PayDate

varchar(25)

YES

 

(NULL)

 

InstNo

varchar(20)

YES

 

(NULL)

 

Indexes

Back

 
classachievement  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

P1Term1

decimal(18,0)

YES

 

(NULL)

 

P1Term2

decimal(18,0)

YES

 

(NULL)

 

P1Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr1

varchar(20)

YES

 

(NULL)

 

P2Term1

decimal(18,0)

YES

 

(NULL)

 

P2Term2

decimal(18,0)

YES

 

(NULL)

 

P2Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr2

varchar(20)

YES

 

(NULL)

 

P3Term1

decimal(18,0)

YES

 

(NULL)

 

P3Term2

decimal(18,0)

YES

 

(NULL)

 

P3Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr3

varchar(20)

YES

 

(NULL)

 

P4Term1

decimal(18,0)

YES

 

(NULL)

 

P4Term2

decimal(18,0)

YES

 

(NULL)

 

P4Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr4

varchar(20)

YES

 

(NULL)

 

P5Term1

decimal(18,0)

YES

 

(NULL)

 

P5Term2

decimal(18,0)

YES

 

(NULL)

 

P5Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr5

varchar(20)

YES

 

(NULL)

 

P6Term1

decimal(18,0)

YES

 

(NULL)

 

P6Term2

decimal(18,0)

YES

 

(NULL)

 

P6Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr6

varchar(20)

YES

 

(NULL)

 

J1Term1

decimal(18,0)

YES

 

(NULL)

 

J1Term2

decimal(18,0)

YES

 

(NULL)

 

J1Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr7

varchar(20)

YES

 

(NULL)

 

J2Term1

decimal(18,0)

YES

 

(NULL)

 

J2Term2

decimal(18,0)

YES

 

(NULL)

 

J2Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr8

varchar(20)

YES

 

(NULL)

 

J3Term1

decimal(18,0)

YES

 

(NULL)

 

J3Term2

decimal(18,0)

YES

 

(NULL)

 

J3Term3

decimal(18,0)

YES

 

(NULL)

 

AcademicYr9

varchar(20)

YES

 

(NULL)

 

Summative

decimal(18,0)

YES

 

(NULL)

 

Summative40Percent

decimal(18,0)

YES

 

(NULL)

 

IndexCode

int(10)

YES

 

(NULL)

 

Total1

decimal(20,0)

YES

 

(NULL)

 

Total2

decimal(20,0)

YES

 

(NULL)

 

Total3

decimal(20,0)

YES

 

(NULL)

 

Total4

decimal(20,0)

YES

 

(NULL)

 

Total5

decimal(20,0)

YES

 

(NULL)

 

Total6

decimal(20,0)

YES

 

(NULL)

 

Total7

decimal(20,0)

YES

 

(NULL)

 

Total8

decimal(20,0)

YES

 

(NULL)

 

Total9

decimal(20,0)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

AcademicYr

varchar(20)

YES

 

(NULL)

 

Indexes

Back

 
classposition  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

ClassPosition

int(10)

YES

 

(NULL)

 

Indexes

Back

 
classtest  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(12)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ClassTest1

float(15,0)

YES

 

(NULL)

 

ClassTest2

float(15,0)

YES

 

(NULL)

 

ClassTest3

float(15,0)

YES

 

(NULL)

 

ClassTest4

float(15,0)

YES

 

(NULL)

 

ClassTest5

float(15,0)

YES

 

(NULL)

 

ClassTest6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

Indexes

Back

 
coursetable  
Fields
Field Type Null Key Default Extra

COURSEID

varchar(25)

 

 

 

 

COURSEDESCRIPTION

varchar(100)

YES

 

(NULL)

 

CREDIT

int(10)

YES

 

(NULL)

 

Indexes

Back

 
currency  
Fields
Field Type Null Key Default Extra

CurrCode

char(2)

 

 

 

 

ISO

char(3)

YES

 

(NULL)

 

Name

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
custreg  
Fields
Field Type Null Key Default Extra

CustomerNumber

varchar(6)

 

 

 

 

CustomerName

varchar(50)

YES

 

(NULL)

 

Address

varchar(50)

YES

 

(NULL)

 

BranchCode

char(2)

YES

 

(NULL)

 

IntExt

char(1)

YES

 

(NULL)

 

Classification

char(2)

YES

 

(NULL)

 

Indexes

Back

 
department  
Fields
Field Type Null Key Default Extra

DeptID

varchar(20)

 

 

 

 

DeptName

varchar(100)

YES

 

(NULL)

 

HeadName

varchar(50)

YES

 

(NULL)

 

Rank

varchar(50)

YES

 

(NULL)

 

FacultyID

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
encrypt  
Fields
Field Type Null Key Default Extra

Encrypt

varchar(50)

 

 

 

 

Counter

int(10)

YES

 

(NULL)

 

SDate

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
eventlogbook  
Fields
Field Type Null Key Default Extra

LogDate

varchar(25)

YES

 

(NULL)

 

Event

blob

YES

 

(NULL)

 

IdLog

int(10)

 

 

0

 

Indexes

Back

 
examscore  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(20)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ExamScoreActual

float(15,0)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

NoofCredit

int(10)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
exchangerate  
Fields
Field Type Null Key Default Extra

CurrencyID

int(10)

 

 

0

 

CurrencyISO

varchar(20)

YES

 

(NULL)

 

CurrencyName

varchar(50)

YES

 

(NULL)

 

ExchangeRate

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
faculty  
Fields
Field Type Null Key Default Extra

FacultyID

varchar(20)

 

 

 

 

FacultyName

varchar(100)

YES

 

(NULL)

 

FacultyHead

varchar(50)

YES

 

(NULL)

 

Rank

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
father  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

NAME

varchar(45)

YES

 

(NULL)

 

ADDRESS

varchar(50)

YES

 

(NULL)

 

OCCUPATION

varchar(60)

YES

 

(NULL)

 

EDUCATION

varchar(50)

YES

 

(NULL)

 

RELIGION

varchar(40)

YES

 

(NULL)

 

DATEOFBIRTH

varchar(25)

YES

 

(NULL)

 

NoOfWives

int(10)

YES

 

(NULL)

 

Indexes

Back

 
feebatchtable  
Fields
Field Type Null Key Default Extra

ACCOUNTNO

varchar(13)

 

 

 

 

INSTNO

varchar(20)

YES

 

(NULL)

 

POSTDATE

varchar(25)

YES

 

(NULL)

 

VALUDATE

varchar(25)

YES

 

(NULL)

 

AMOUNT

decimal(19,4)

 

 

0.0000

 

NARRATION

varchar(200)

YES

 

(NULL)

 

ACCOUNTNAME

varchar(200)

YES

 

(NULL)

 

Indexes

Back

 
feecodemisc  
Fields
Field Type Null Key Default Extra

FEECODE

varchar(40)

 

 

 

 

FEEDESCRIPTION

varchar(100)

YES

 

(NULL)

 

AMTTOPAY

decimal(19,4)

YES

 

(NULL)

 

CLASSFORM

varchar(100)

YES

 

(NULL)

 

COURSESUBJECT

varchar(100)

YES

 

(NULL)

 

ACCOUNTNO

varchar(13)

YES

 

(NULL)

 

ADMISSIONNO

varchar(20)

 

 

 

 

SCHOLARSHIPAMT

decimal(19,4)

YES

 

(NULL)

 

SCHOLARSHIPTYPE

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
feecodes  
Fields
Field Type Null Key Default Extra

FEECODE

varchar(50)

 

 

 

 

FEEDESCRIPTION

varchar(100)

 

 

 

 

AMTTOPAY

decimal(19,4)

 

 

0.0000

 

ACCOUNTNO

varchar(20)

 

 

 

 

CLASSFORM

varchar(50)

 

 

 

 

COURSESUBJECT

varchar(100)

 

 

 

 

CLASSFORMDESC

varchar(100)

 

 

 

 

STATUS

varchar(10)

YES

 

(NULL)

 

TRANSPORT

varchar(50)

YES

 

(NULL)

 

SCHOLARSHIP

varchar(50)

YES

 

(NULL)

 

BOARDING

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
feecodetable  
Fields
Field Type Null Key Default Extra

FEECODE

varchar(8)

 

 

 

 

FEEDESCRIPTION

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
feesdelete  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(13)

YES

 

(NULL)

 

PAYDATE

varchar(25)

YES

 

(NULL)

 

AMTRECEIVED

decimal(19,4)

YES

 

(NULL)

 

PAYTYPE

varchar(40)

YES

 

(NULL)

 

REASON

varchar(250)

YES

 

(NULL)

 

USERID

varchar(30)

YES

 

(NULL)

 

DATEDELETE

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
finalresultsforprinting  
Fields
Field Type Null Key Default Extra

StudentName

varchar(50)

YES

 

(NULL)

 

NoofRoll

int(10)

YES

 

(NULL)

 

Term

varchar(40)

YES

 

(NULL)

 

ClassForm

varchar(30)

YES

 

(NULL)

 

AcademicYr

varchar(30)

YES

 

(NULL)

 

ReportDate

varchar(25)

YES

 

(NULL)

 

NextTermBegins

varchar(30)

YES

 

(NULL)

 

OverAllPosition

int(10)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ClassScore

float(15,0)

YES

 

(NULL)

 

OverAllTotal

float(15,0)

YES

 

(NULL)

 

PositionInSubject

int(10)

YES

 

(NULL)

 

Remark

varchar(50)

YES

 

(NULL)

 

GPA

varchar(8)

YES

 

(NULL)

 

Grade

varchar(6)

YES

 

(NULL)

 

AdmissionNo

varchar(20)

YES

 

(NULL)

 

IndexCode

char(3)

YES

 

(NULL)

 

CourseID

varchar(20)

YES

 

(NULL)

 

NoofCredit

double(7,0)

YES

 

(NULL)

 

Indexes

Back

 
formclasstable  
Fields
Field Type Null Key Default Extra

FORMCLASS

varchar(40)

 

 

 

 

FORMCLASSDESCRIPTION

varchar(100)

 

 

 

 

NOOFROLL

decimal(18,0)

YES

 

(NULL)

 

Indexes

Back

 
furthereducation  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

FUTUREPLAN

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
genledger  
Fields
Field Type Null Key Default Extra

Accountno

varchar(13)

 

 

 

 

CurCode

char(2)

YES

 

(NULL)

 

MemoCode

varchar(5)

YES

 

(NULL)

 

CustomerNumber

varchar(6)

YES

 

(NULL)

 

AccountName

varchar(80)

YES

 

(NULL)

 

AcctypeID

char(2)

YES

 

(NULL)

 

IntExt

char(1)

YES

 

(NULL)

 

BranchCode

char(2)

YES

 

(NULL)

 

DATE

varchar(25)

YES

 

(NULL)

 

AccountStatus

char(2)

YES

 

(NULL)

 

DateofStatuschg

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
glcontrol  
Fields
Field Type Null Key Default Extra

ControlCode

char(1)

 

 

 

 

ControlDescription

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
glmemo  
Fields
Field Type Null Key Default Extra

MemoCode

char(3)

 

 

 

 

ControlCode

char(1)

YES

 

(NULL)

 

MemoDescription

varchar(50)

YES

 

(NULL)

 

Acc_Type

char(2)

YES

 

(NULL)

 

PLCodes

varchar(5)

YES

 

(NULL)

 

DrCr

char(2)

YES

 

(NULL)

 

BDrBCr

char(2)

YES

 

(NULL)

 

BalsheetCode

varchar(5)

YES

 

(NULL)

 

Indexes

Back

 
globalpath  
Fields
Field Type Null Key Default Extra

Path

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
gradeadmissiontable  
Fields
Field Type Null Key Default Extra

Subject

varchar(100)

 

 

 

 

Grade

varchar(4)

YES

 

(NULL)

 

Indexes

Back

 
groupposition  
Fields
Field Type Null Key Default Extra

Mark

double(7,0)

YES

 

(NULL)

 

SubjectPosition

int(10)

YES

 

(NULL)

 

Indexes

Back

 
guardian  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

ADDRESS

varchar(60)

YES

 

(NULL)

 

OCCUPATION

varchar(45)

YES

 

(NULL)

 

RELIGION

varchar(45)

YES

 

(NULL)

 

EDUCATION

varchar(45)

YES

 

(NULL)

 

RELATIONSHIPTOPUPIL

varchar(45)

YES

 

(NULL)

 

DATEGUARDIANSHIPBEGAN

varchar(25)

YES

 

(NULL)

 

NAME

varchar(45)

YES

 

(NULL)

 

Indexes

Back

 
handicaps  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

EYESIGHT

varchar(100)

YES

 

(NULL)

 

HEARING

varchar(100)

YES

 

(NULL)

 

SPEECH

varchar(100)

YES

 

(NULL)

 

ARM

varchar(100)

YES

 

(NULL)

 

LEG

varchar(100)

YES

 

(NULL)

 

CHRONICSKINOROTHERILLNESS

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
headcount  
Fields
Field Type Null Key Default Extra

Classform

varchar(10)

YES

 

(NULL)

 

CourseSubject

varchar(10)

YES

 

(NULL)

 

Boys

decimal(18,0)

YES

 

(NULL)

 

girls

decimal(18,0)

YES

 

(NULL)

 

sex

char(2)

YES

 

(NULL)

 

StudentName

varchar(60)

YES

 

(NULL)

 

Total

decimal(18,0)

YES

 

(NULL)

 

Indexes

Back

 
healthrecord  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

DATE

varchar(25)

YES

 

(NULL)

 

AGE

varchar(10)

YES

 

(NULL)

 

HEIGHT

varchar(10)

YES

 

(NULL)

 

WEIGHT

varchar(10)

YES

 

(NULL)

 

REMARKS

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
homework  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(12)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

Homework1

float(15,0)

YES

 

(NULL)

 

Homework2

float(15,0)

YES

 

(NULL)

 

Homework3

float(15,0)

YES

 

(NULL)

 

Homework4

float(15,0)

YES

 

(NULL)

 

Homework5

float(15,0)

YES

 

(NULL)

 

Homework6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

Indexes

Back

 
incomeexpenditure  
Fields
Field Type Null Key Default Extra

AccountNo

varchar(20)

 

 

 

 

AccountName

varchar(150)

YES

 

(NULL)

 

AccountBalance

decimal(19,4)

YES

 

(NULL)

 

AmountAccrued

decimal(19,4)

YES

 

(NULL)

 

AmountPrepaid

decimal(19,4)

YES

 

(NULL)

 

PLAmount

decimal(19,4)

YES

 

(NULL)

 

AmountAccrued1

decimal(19,4)

YES

 

(NULL)

 

AmountPrepaid1

decimal(19,4)

YES

 

(NULL)

 

IncomeExpenditure

varchar(100)

YES

 

(NULL)

 

ControlCode

varchar(100)

YES

 

(NULL)

 

PLDiff

decimal(19,4)

YES

 

(NULL)

 

PLDiffPreYr

decimal(19,4)

YES

 

(NULL)

 

PLDiffPreYrExp

decimal(19,4)

YES

 

(NULL)

 

PreYrBalance

decimal(19,4)

YES

 

(NULL)

 

PLDiffExp

decimal(19,4)

YES

 

(NULL)

 

AccTypeID

char(2)

YES

 

(NULL)

 

Indexes

Back

 
incomeexpendituretotal  
Fields
Field Type Null Key Default Extra

AccTypeID

char(2)

YES

 

(NULL)

 

PLDiffTotal

decimal(19,4)

YES

 

(NULL)

 

PLDiffPreYrTotal

decimal(19,4)

YES

 

(NULL)

 

Status

char(1)

YES

 

(NULL)

 

Indexes

Back

 
incomeexpendituretotale  
Fields
Field Type Null Key Default Extra

AccTypeID

char(2)

YES

 

(NULL)

 

PLDiffTotal

decimal(19,4)

YES

 

(NULL)

 

PLDiffPreYrTotal

decimal(19,4)

YES

 

(NULL)

 

Status

char(1)

YES

 

(NULL)

 

Indexes

Back

 
loan  
Fields
Field Type Null Key Default Extra

LOANID

varchar(12)

 

 

 

 

LOANTYPE

varchar(50)

YES

 

(NULL)

 

STAFFID

varchar(8)

YES

 

(NULL)

 

LOANAMT

decimal(19,4)

YES

 

(NULL)

 

STARTDATE

varchar(25)

YES

 

(NULL)

 

ENDDATE

varchar(25)

YES

 

(NULL)

 

DUROFPAY

int(10)

YES

 

(NULL)

 

AMTPAID

decimal(19,4)

YES

 

(NULL)

 

AMTLEFT

decimal(19,4)

YES

 

(NULL)

 

INTEREST

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
loanref  
Fields
Field Type Null Key Default Extra

LOANID

varchar(12)

 

 

 

 

LOANTYPE

varchar(50)

YES

 

(NULL)

 

NOTES

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
marksheet  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

lname

varchar(20)

YES

 

(NULL)

 

fname

varchar(20)

YES

 

(NULL)

 

mname

varchar(20)

YES

 

(NULL)

 

ClassForm

varchar(20)

YES

 

(NULL)

 

Term

varchar(20)

YES

 

(NULL)

 

AcademicYr

varchar(20)

YES

 

(NULL)

 

Indexes

Back

 
master  
Fields
Field Type Null Key Default Extra

ACCOUNTNO

varchar(13)

 

 

 

 

BALDATE

varchar(25)

YES

 

(NULL)

 

BOOKBAL

decimal(19,4)

YES

 

(NULL)

 

CLRBAL

decimal(19,4)

YES

 

(NULL)

 

UNCLRAMT

decimal(19,4)

YES

 

(NULL)

 

BBOOKBAL

decimal(19,4)

YES

 

(NULL)

 

BCLRBAL

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
mother  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

NAME

varchar(45)

YES

 

(NULL)

 

ADDRESS

varchar(50)

YES

 

(NULL)

 

OCCUPATION

varchar(50)

YES

 

(NULL)

 

EDUCATION

varchar(45)

YES

 

(NULL)

 

RELIGION

varchar(45)

YES

 

(NULL)

 

DATEOFBIRTH

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
noofroll  
Fields
Field Type Null Key Default Extra

NoofRoll

decimal(18,0)

YES

 

(NULL)

 

Classform

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
paybalance  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

PRI

 

 

FEECODE

varchar(100)

YES

 

(NULL)

 

BALDATE

varchar(25)

YES

 

(NULL)

 

AMTDUE130706

decimal(19,4)

 

 

0.0000

 

TOTPAID

decimal(19,4)

 

 

0.0000

 

BALANCE130706

decimal(19,4)

 

 

0.0000

 

ID

int(10)

YES

 

(NULL)

 

AMTDUEOR

decimal(19,4)

YES

 

(NULL)

 

BALANCEOR

decimal(19,4)

YES

 

(NULL)

 

TEMPBAL

decimal(19,4)

YES

 

(NULL)

 

AMTDUE

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

MESSAGE

blob

YES

 

(NULL)

 

CONCLUSION

blob

YES

 

(NULL)

 

UNDERSIGNED

varchar(200)

YES

 

(NULL)

 

RANK

varchar(200)

YES

 

(NULL)

 

FINAL

varchar(200)

YES

 

(NULL)

 

TOTPAIDOR

decimal(19,4)

YES

 

(NULL)

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

paybalance

0

PRIMARY

1

ADMISSIONNO

A

168

(NULL)

(NULL)

 

BTREE

 

Back

 
payments  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

RECEIPTNO

decimal(18,0)

 

 

0

 

PAYDATE

varchar(25)

YES

 

(NULL)

 

AMTRECEIVED

decimal(19,4)

YES

 

(NULL)

 

PAYMENTTYPE

varchar(50)

YES

 

(NULL)

 

ACCOUNTNO

varchar(20)

YES

 

(NULL)

 

TERMID

varchar(12)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

CURRENCYTYPE

varchar(20)

YES

 

(NULL)

 

CHEQUENO

varchar(25)

YES

 

(NULL)

 

NARRATION

varchar(150)

YES

 

(NULL)

 

AMOUNTCR

decimal(19,4)

YES

 

(NULL)

 

AMOUNTCR2

decimal(19,4)

YES

 

(NULL)

 

AMOUNTCR3

decimal(19,4)

YES

 

(NULL)

 

AMTINWORDS

blob

YES

 

(NULL)

 

PARENTNAME

varchar(60)

YES

 

(NULL)

 

PAYMENTS

varchar(10)

YES

 

(NULL)

 

GuardianId

varchar(10)

YES

 

(NULL)

 

Amtreceivedusd

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
payrollprint  
Fields
Field Type Null Key Default Extra

Dept

decimal(18,0)

YES

 

(NULL)

 

Category

decimal(18,0)

YES

 

(NULL)

 

StaffNo

decimal(18,0)

YES

 

(NULL)

 

JobTitle

varchar(60)

YES

 

(NULL)

 

StaffName

varchar(60)

YES

 

(NULL)

 

SSN

varchar(15)

YES

 

(NULL)

 

AnnualSalary

decimal(19,4)

YES

 

(NULL)

 

BasicSalary

decimal(19,4)

YES

 

(NULL)

 

Chalk

decimal(19,4)

YES

 

(NULL)

 

Talking

decimal(19,4)

YES

 

(NULL)

 

P_OTH1

decimal(19,4)

YES

 

(NULL)

 

DateofEntry

varchar(50)

YES

 

(NULL)

 

Overtime

decimal(19,4)

YES

 

(NULL)

 

SSF

decimal(19,4)

YES

 

(NULL)

 

IncomeTax

decimal(19,4)

YES

 

(NULL)

 

Welfare

decimal(19,4)

YES

 

(NULL)

 

P_CU

decimal(19,4)

YES

 

(NULL)

 

Emergency

decimal(19,4)

YES

 

(NULL)

 

EmergencyLoan

decimal(19,4)

YES

 

(NULL)

 

TotalEmol

decimal(19,4)

YES

 

(NULL)

 

TotalDed

decimal(19,4)

YES

 

(NULL)

 

NetIncome

decimal(19,4)

YES

 

(NULL)

 

SSF125Percent

decimal(19,4)

YES

 

(NULL)

 

P_RANGEE

varchar(4)

YES

 

(NULL)

 

P_MCODE

char(1)

YES

 

(NULL)

 

PayDate

varchar(20)

YES

 

(NULL)

 

P_HOSP

decimal(19,4)

YES

 

(NULL)

 

DomesticLoan

decimal(19,4)

YES

 

(NULL)

 

Domestic

decimal(19,4)

YES

 

(NULL)

 

BusinessLoan

decimal(19,4)

YES

 

(NULL)

 

Business

decimal(19,4)

YES

 

(NULL)

 

P_ADV

decimal(19,4)

YES

 

(NULL)

 

Bonus

decimal(19,4)

YES

 

(NULL)

 

SalAdvance

decimal(19,4)

YES

 

(NULL)

 

ACNo

varchar(15)

YES

 

(NULL)

 

TaxID

varchar(20)

YES

 

(NULL)

 

Rank

varchar(20)

YES

 

(NULL)

 

Bank

varchar(100)

YES

 

(NULL)

 

BankBranch

varchar(100)

YES

 

(NULL)

 

RentSubsidy

decimal(19,4)

YES

 

(NULL)

 

RespAllow

decimal(19,4)

YES

 

(NULL)

 

CarMaint

decimal(19,4)

YES

 

(NULL)

 

Utilities

decimal(19,4)

YES

 

(NULL)

 

LeaveAllow

decimal(19,4)

YES

 

(NULL)

 

BookAllow

decimal(19,4)

YES

 

(NULL)

 

TaxRelief

decimal(19,4)

YES

 

(NULL)

 

Other3Amt

decimal(19,4)

YES

 

(NULL)

 

Medical

decimal(19,4)

YES

 

(NULL)

 

Other3

varchar(100)

YES

 

(NULL)

 

SSFPercentage

varchar(10)

YES

 

(NULL)

 

ProvFund

decimal(19,4)

YES

 

(NULL)

 

CarLoan

decimal(19,4)

YES

 

(NULL)

 

BuildingLoan

decimal(19,4)

YES

 

(NULL)

 

RentAdvance

decimal(19,4)

YES

 

(NULL)

 

Health

decimal(19,4)

YES

 

(NULL)

 

Funeral

decimal(19,4)

YES

 

(NULL)

 

Other3Ded

varchar(100)

YES

 

(NULL)

 

Other3DedAmt

decimal(19,4)

YES

 

(NULL)

 

Other4Ded

varchar(100)

YES

 

(NULL)

 

Other4DedAmt

decimal(19,4)

YES

 

(NULL)

 

SSF175Percent

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
payrolltable  
Fields
Field Type Null Key Default Extra

Dept

decimal(18,0)

YES

 

(NULL)

 

Category

decimal(18,0)

YES

 

(NULL)

 

StaffNo

decimal(18,0)

 

 

0

 

JobTitle

varchar(60)

YES

 

(NULL)

 

StaffName

varchar(60)

YES

 

(NULL)

 

SSN

varchar(15)

YES

 

(NULL)

 

AnnualSalary

decimal(19,4)

YES

 

(NULL)

 

BasicSalary

decimal(19,4)

YES

 

(NULL)

 

Chalk

decimal(19,4)

YES

 

(NULL)

 

Talking

decimal(19,4)

YES

 

(NULL)

 

P_OTH1

decimal(19,4)

YES

 

(NULL)

 

DateofEntry

varchar(50)

YES

 

(NULL)

 

Overtime

decimal(19,4)

YES

 

(NULL)

 

SSF

decimal(19,4)

YES

 

(NULL)

 

IncomeTax

decimal(19,4)

YES

 

(NULL)

 

Welfare

decimal(19,4)

YES

 

(NULL)

 

P_CU

decimal(19,4)

YES

 

(NULL)

 

Emergency

decimal(19,4)

YES

 

(NULL)

 

EmergencyLoan

decimal(19,4)

YES

 

(NULL)

 

TotalEmol

decimal(19,4)

YES

 

(NULL)

 

TotalDed

decimal(19,4)

YES

 

(NULL)

 

NetIncome

decimal(19,4)

YES

 

(NULL)

 

SSF125Percent

decimal(19,4)

YES

 

(NULL)

 

P_RANGEE

varchar(4)

YES

 

(NULL)

 

P_MCODE

char(1)

YES

 

(NULL)

 

PayDate

varchar(20)

 

 

 

 

P_HOSP

decimal(19,4)

YES

 

(NULL)

 

DomesticLoan

decimal(19,4)

YES

 

(NULL)

 

Domestic

decimal(19,4)

YES

 

(NULL)

 

BusinessLoan

decimal(19,4)

YES

 

(NULL)

 

Business

decimal(19,4)

YES

 

(NULL)

 

P_ADV

decimal(19,4)

YES

 

(NULL)

 

Bonus

decimal(19,4)

YES

 

(NULL)

 

SalAdvance

decimal(19,4)

YES

 

(NULL)

 

ACNo

varchar(15)

YES

 

(NULL)

 

TaxID

varchar(20)

YES

 

(NULL)

 

Rank

varchar(20)

YES

 

(NULL)

 

Bank

varchar(100)

YES

 

(NULL)

 

BankBranch

varchar(100)

YES

 

(NULL)

 

RentSubsidy

decimal(19,4)

YES

 

(NULL)

 

RespAllow

decimal(19,4)

YES

 

(NULL)

 

CarMaint

decimal(19,4)

YES

 

(NULL)

 

Utilities

decimal(19,4)

YES

 

(NULL)

 

LeaveAllow

decimal(19,4)

YES

 

(NULL)

 

BookAllow

decimal(19,4)

YES

 

(NULL)

 

TaxRelief

decimal(19,4)

YES

 

(NULL)

 

Other3Amt

decimal(19,4)

YES

 

(NULL)

 

Medical

decimal(19,4)

YES

 

(NULL)

 

Other3

varchar(100)

YES

 

(NULL)

 

SSFPercentage

varchar(10)

YES

 

(NULL)

 

ProvFund

decimal(19,4)

YES

 

(NULL)

 

CarLoan

decimal(19,4)

YES

 

(NULL)

 

BuildingLoan

decimal(19,4)

YES

 

(NULL)

 

RentAdvance

decimal(19,4)

YES

 

(NULL)

 

Health

decimal(19,4)

YES

 

(NULL)

 

Funeral

decimal(19,4)

YES

 

(NULL)

 

Other3Ded

varchar(100)

YES

 

(NULL)

 

Other3DedAmt

decimal(19,4)

YES

 

(NULL)

 

Other4Ded

varchar(100)

YES

 

(NULL)

 

Other4DedAmt

decimal(19,4)

YES

 

(NULL)

 

SSF175Percent

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
periodicreceipt  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(12)

YES

 

(NULL)

 

FullName

varchar(35)

YES

 

(NULL)

 

ReceiptNo

varchar(15)

YES

 

(NULL)

 

PayType

varchar(20)

YES

 

(NULL)

 

AccNo

varchar(14)

YES

 

(NULL)

 

AmtReceived

decimal(19,4)

YES

 

(NULL)

 

Class

varchar(15)

YES

 

(NULL)

 

Paydate

varchar(25)

YES

 

(NULL)

 

AmtReceivedusd

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
personaldata  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

Surname

varchar(25)

YES

 

(NULL)

 

OtherNames

varchar(25)

YES

 

(NULL)

 

DateofBirth

varchar(25)

YES

 

(NULL)

 

Sex

varchar(10)

YES

 

(NULL)

 

HomeTown

varchar(25)

YES

 

(NULL)

 

MotherTongue

varchar(25)

YES

 

(NULL)

 

Religion

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
personalitydevelopment  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

NEATNESS

char(2)

YES

 

(NULL)

 

EMOTIONALCONTROL

char(2)

YES

 

(NULL)

 

SOCIABILITY

char(2)

YES

 

(NULL)

 

CREATIVENESS

char(2)

YES

 

(NULL)

 

INITIATIVE

char(2)

YES

 

(NULL)

 

DEPENDABILTY

char(2)

YES

 

(NULL)

 

HONESTY

char(2)

YES

 

(NULL)

 

WORKHABIT

char(2)

YES

 

(NULL)

 

LEADERSHIP

char(2)

YES

 

(NULL)

 

YEAR1

varchar(6)

YES

 

(NULL)

 

COURTESY

char(2)

YES

 

(NULL)

 

Indexes

Back

 
promotiontemp  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

 

 

 

 

Lname

varchar(30)

YES

 

(NULL)

 

Fname

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
receipttemp  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

YES

 

(NULL)

 

STUDENTNAME

varchar(35)

YES

 

(NULL)

 

RECEIPTNO

varchar(20)

YES

 

(NULL)

 

PAYDATE

varchar(25)

YES

 

(NULL)

 

AMTPAID

decimal(19,4)

YES

 

(NULL)

 

PAYTYPE

varchar(30)

YES

 

(NULL)

 

CHEQUENO

varchar(20)

YES

 

(NULL)

 

TERMID

varchar(50)

YES

 

(NULL)

 

NARRATION

varchar(150)

YES

 

(NULL)

 

AMOUNTCR

decimal(19,4)

YES

 

(NULL)

 

AMOUNTCR2

decimal(19,4)

YES

 

(NULL)

 

AMOUNTCR3

decimal(19,4)

YES

 

(NULL)

 

BALANCEBF

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

CASHIERID

varchar(30)

YES

 

(NULL)

 

AMTINWORDS

blob

YES

 

(NULL)

 

PARENTNAME

varchar(60)

YES

 

(NULL)

 

AmtReceivedusd

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
reports  
Fields
Field Type Null Key Default Extra

RFileName

varchar(50)

 

 

 

 

ReportName

varchar(50)

YES

 

(NULL)

 

ReportGroup

varchar(25)

YES

 

(NULL)

 

ReportId

varchar(5)

YES

 

(NULL)

 

Indexes

Back

 
resultprocessing  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

AssignmentTotal

float(15,0)

YES

 

(NULL)

 

TestTotal

float(15,0)

YES

 

(NULL)

 

HomeworkTotal

float(15,0)

YES

 

(NULL)

 

TotalClassScore

float(15,0)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ExamScoreActual

float(15,0)

YES

 

(NULL)

 

OverAllTotal

double(7,0)

YES

 

(NULL)

 

PositionInSubject

varchar(20)

YES

 

(NULL)

 

ClassForm

varchar(40)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

TotalClassScorePercentage

float(15,0)

YES

 

(NULL)

 

Term

varchar(30)

YES

 

(NULL)

 

AcademicYr

varchar(20)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

NoofCredit

double(7,0)

YES

 

(NULL)

 

Assignment1

float(15,0)

YES

 

(NULL)

 

Assignment2

float(15,0)

YES

 

(NULL)

 

Assignment3

float(15,0)

YES

 

(NULL)

 

Assignment4

float(15,0)

YES

 

(NULL)

 

Assignment5

float(15,0)

YES

 

(NULL)

 

Assignment6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

ClassTest1

float(15,0)

YES

 

(NULL)

 

ClassTest2

float(15,0)

YES

 

(NULL)

 

ClassTest3

float(15,0)

YES

 

(NULL)

 

ClassTest4

float(15,0)

YES

 

(NULL)

 

ClassTest5

float(15,0)

YES

 

(NULL)

 

ClassTest6

float(15,0)

YES

 

(NULL)

 

SubTotal1

float(15,0)

YES

 

(NULL)

 

Homework1

float(15,0)

YES

 

(NULL)

 

Homework2

float(15,0)

YES

 

(NULL)

 

Homework3

float(15,0)

YES

 

(NULL)

 

Homework4

float(15,0)

YES

 

(NULL)

 

Homework5

float(15,0)

YES

 

(NULL)

 

Homework6

float(15,0)

YES

 

(NULL)

 

SubTotal2

float(15,0)

YES

 

(NULL)

 

Grade

varchar(10)

YES

 

(NULL)

 

Remark

varchar(30)

YES

 

(NULL)

 

GPA

varchar(10)

YES

 

(NULL)

 

IndexCode

varchar(10)

YES

 

(NULL)

 

ClassPercent

float(15,0)

YES

 

(NULL)

 

ExamPercent

float(15,0)

YES

 

(NULL)

 

TotalMark

float(15,0)

YES

 

(NULL)

 

MaxAttendance

int(10)

YES

 

(NULL)

 

AttainAttendance

int(10)

YES

 

(NULL)

 

PromotedTo

varchar(10)

YES

 

(NULL)

 

NextTermBegins

varchar(25)

YES

 

(NULL)

 

Interest

varchar(150)

YES

 

(NULL)

 

Attitude

varchar(150)

YES

 

(NULL)

 

Conduct

varchar(150)

YES

 

(NULL)

 

TeacherRemark

varchar(150)

YES

 

(NULL)

 

TeacherSign

varchar(15)

YES

 

(NULL)

 

HeadRemark

varchar(150)

YES

 

(NULL)

 

HeadSign

varchar(15)

YES

 

(NULL)

 

Aggregate

int(10)

YES

 

(NULL)

 

VacateDate

varchar(25)

YES

 

(NULL)

 

StreamPosition

int(10)

YES

 

(NULL)

 

ClassPosition

int(10)

YES

 

(NULL)

 

Indexes

Back

 
resultprocessingprinting  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

AssignmentTotal

float(15,0)

YES

 

(NULL)

 

TestTotal

float(15,0)

YES

 

(NULL)

 

HomeworkTotal

float(15,0)

YES

 

(NULL)

 

TotalClassScore

float(15,0)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ExamScoreActual

float(15,0)

YES

 

(NULL)

 

OverAllTotal

double(7,0)

YES

 

(NULL)

 

PositionInSubject

varchar(20)

YES

 

(NULL)

 

ClassForm

varchar(40)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

TotalClassScorePercentage

float(15,0)

YES

 

(NULL)

 

Term

varchar(30)

YES

 

(NULL)

 

AcademicYr

varchar(20)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

NoofCredit

double(7,0)

YES

 

(NULL)

 

Assignment1

float(15,0)

YES

 

(NULL)

 

Assignment2

float(15,0)

YES

 

(NULL)

 

Assignment3

float(15,0)

YES

 

(NULL)

 

Assignment4

float(15,0)

YES

 

(NULL)

 

Assignment5

float(15,0)

YES

 

(NULL)

 

Assignment6

float(15,0)

YES

 

(NULL)

 

SubTotal

float(15,0)

YES

 

(NULL)

 

ClassTest1

float(15,0)

YES

 

(NULL)

 

ClassTest2

float(15,0)

YES

 

(NULL)

 

ClassTest3

float(15,0)

YES

 

(NULL)

 

ClassTest4

float(15,0)

YES

 

(NULL)

 

ClassTest5

float(15,0)

YES

 

(NULL)

 

ClassTest6

float(15,0)

YES

 

(NULL)

 

SubTotal1

float(15,0)

YES

 

(NULL)

 

Homework1

float(15,0)

YES

 

(NULL)

 

Homework2

float(15,0)

YES

 

(NULL)

 

Homework3

float(15,0)

YES

 

(NULL)

 

Homework4

float(15,0)

YES

 

(NULL)

 

Homework5

float(15,0)

YES

 

(NULL)

 

Homework6

float(15,0)

YES

 

(NULL)

 

SubTotal2

float(15,0)

YES

 

(NULL)

 

Grade

varchar(10)

YES

 

(NULL)

 

Remark

varchar(30)

YES

 

(NULL)

 

GPA

varchar(10)

YES

 

(NULL)

 

IndexCode

varchar(10)

YES

 

(NULL)

 

ClassPercent

float(15,0)

YES

 

(NULL)

 

ExamPercent

float(15,0)

YES

 

(NULL)

 

TotalMark

float(15,0)

YES

 

(NULL)

 

MaxAttendance

int(10)

YES

 

(NULL)

 

AttainAttendance

int(10)

YES

 

(NULL)

 

PromotedTo

varchar(10)

YES

 

(NULL)

 

NextTermBegins

varchar(25)

YES

 

(NULL)

 

Interest

varchar(150)

YES

 

(NULL)

 

Attitude

varchar(150)

YES

 

(NULL)

 

Conduct

varchar(150)

YES

 

(NULL)

 

TeacherRemark

varchar(150)

YES

 

(NULL)

 

TeacherSign

varchar(15)

YES

 

(NULL)

 

HeadRemark

varchar(150)

YES

 

(NULL)

 

HeadSign

varchar(15)

YES

 

(NULL)

 

Aggregate

int(10)

YES

 

(NULL)

 

VacateDate

varchar(25)

YES

 

(NULL)

 

StreamPosition

int(10)

YES

 

(NULL)

 

ClassPosition

int(10)

YES

 

(NULL)

 

Indexes

Back

 
results  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StudentName

varchar(50)

YES

 

(NULL)

 

ClassForm

varchar(30)

YES

 

(NULL)

 

Mark

double(7,0)

YES

 

(NULL)

 

Cmark

float(15,0)

YES

 

(NULL)

 

Emark

float(15,0)

YES

 

(NULL)

 

SubjectPosition

int(10)

 

 

0

 

Grade

varchar(30)

YES

 

(NULL)

 

Remarks

varchar(30)

YES

 

(NULL)

 

GPA

varchar(53)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

Term

varchar(30)

YES

 

(NULL)

 

AcademicYr

varchar(20)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
scholarshiptable  
Fields
Field Type Null Key Default Extra

ScholarshipCode

varchar(20)

 

 

 

 

Description

varchar(100)

YES

 

(NULL)

 

Amount

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
schoolinfo  
Fields
Field Type Null Key Default Extra

SchoolName

varchar(60)

YES

 

(NULL)

 

HeadsName

varchar(30)

YES

 

(NULL)

 

Address1

varchar(50)

YES

 

(NULL)

 

Address2

varchar(50)

YES

 

(NULL)

 

Address3

varchar(50)

YES

 

(NULL)

 

Telephone1

varchar(20)

YES

 

(NULL)

 

Telephone2

varchar(20)

YES

 

(NULL)

 

MobilePhone

varchar(20)

YES

 

(NULL)

 

EmailAddress

varchar(30)

YES

 

(NULL)

 

Fax

varchar(15)

YES

 

(NULL)

 

EmailAddress2

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
schoolsattended  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

YES

 

(NULL)

 

SCHOOLNAME

varchar(30)

YES

 

(NULL)

 

DATEOFADMISSION

varchar(25)

YES

 

(NULL)

 

AGEOFADMISSION1

char(3)

YES

 

(NULL)

 

DATEOFLASTATTEND

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
significantdata  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

PUPILWITHPARENT

varchar(20)

YES

 

(NULL)

 

NUMBEROFCHILDRENATHOMEOLDER

varchar(5)

YES

 

(NULL)

 

NUMBEROFCHILDRENATHOMEYOUNGER

varchar(5)

YES

 

(NULL)

 

LANGUAGE1

varchar(30)

YES

 

(NULL)

 

LANGUAGE2

varchar(30)

YES

 

(NULL)

 

LANGUAGE3

varchar(30)

YES

 

(NULL)

 

LANGUAGE4

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
sponsorinformation  
Fields
Field Type Null Key Default Extra

FormNo

varchar(20)

YES

 

(NULL)

 

Name

varchar(150)

YES

 

(NULL)

 

Relation

varchar(100)

YES

 

(NULL)

 

Address

varchar(250)

YES

 

(NULL)

 

Occupation

varchar(100)

YES

 

(NULL)

 

TelNo

varchar(50)

YES

 

(NULL)

 

Email

varchar(100)

YES

 

(NULL)

 

Declaredate

varchar(25)

YES

 

(NULL)

 

SignUnsign

varchar(50)

YES

 

(NULL)

 

SponsorSelf

varchar(50)

YES

 

(NULL)

 

SponsorParent

varchar(50)

YES

 

(NULL)

 

SponsorEmployer

varchar(50)

YES

 

(NULL)

 

SponsorOther

varchar(50)

YES

 

(NULL)

 

SponsorOtherSpecify

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
spouse  
Fields
Field Type Null Key Default Extra

StaffNo

varchar(15)

YES

 

(NULL)

 

SpouseName

varchar(50)

YES

 

(NULL)

 

DateOfBirth

varchar(25)

YES

 

(NULL)

 

Address

varchar(150)

YES

 

(NULL)

 

Telephone

varchar(50)

YES

 

(NULL)

 

Nationality

varchar(50)

YES

 

(NULL)

 

Occupation

varchar(50)

YES

 

(NULL)

 

Religion

varchar(50)

YES

 

(NULL)

 

DeadAlive

varchar(15)

YES

 

(NULL)

 

Indexes

Back

 
staffacademicqualification  
Fields
Field Type Null Key Default Extra

AcademicQualificationID

varchar(100)

YES

 

(NULL)

 

StaffNO

varchar(50)

YES

 

(NULL)

 

LevelOfQualification

varchar(100)

YES

 

(NULL)

 

Subjectoffered

varchar(100)

YES

 

(NULL)

 

YearOfQualification

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
staffemploymentparticulars  
Fields
Field Type Null Key Default Extra

StaffEmploymentParticularsID

varchar(50)

YES

 

(NULL)

 

StaffNO

varchar(50)

YES

 

(NULL)

 

StaffEmploymentParticulars

varchar(100)

YES

 

(NULL)

 

StaffEmploymentStartDate

varchar(50)

YES

 

(NULL)

 

StaffEmploymentEndDate

varchar(50)

YES

 

(NULL)

 

RemarksForStaff

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
stafffamily  
Fields
Field Type Null Key Default Extra

FamilyID

varchar(50)

YES

 

(NULL)

 

StaffNo

varchar(50)

YES

 

(NULL)

 

NextofKinName

varchar(100)

YES

 

(NULL)

 

RelationShip

varchar(100)

YES

 

(NULL)

 

DateofBirth

varchar(25)

YES

 

(NULL)

 

N

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
staffmembers  
Fields
Field Type Null Key Default Extra

StaffNo

varchar(50)

YES

 

(NULL)

 

StaffName

varchar(100)

YES

 

(NULL)

 

Sex

varchar(50)

YES

 

(NULL)

 

FormerName

varchar(50)

YES

 

(NULL)

 

DateofNameChange

varchar(50)

YES

 

(NULL)

 

Authority

varchar(50)

YES

 

(NULL)

 

StaffGrade

varchar(50)

YES

 

(NULL)

 

StaffDateofBirth

varchar(25)

YES

 

(NULL)

 

Nationality

varchar(50)

YES

 

(NULL)

 

Dateof1stAppointment

varchar(25)

YES

 

(NULL)

 

DateConfirmed

varchar(25)

YES

 

(NULL)

 

MaritalStatus

varchar(50)

YES

 

(NULL)

 

StaffTelephone

varchar(50)

YES

 

(NULL)

 

StaffHomeTown

varchar(50)

YES

 

(NULL)

 

StaffHomeAddress

varchar(100)

YES

 

(NULL)

 

StaffemailAddress

varchar(100)

YES

 

(NULL)

 

StaffStationAddress

varchar(100)

YES

 

(NULL)

 

StaffMobilePhoneNo

varchar(16)

YES

 

(NULL)

 

StaffSalaryPA

decimal(19,4)

YES

 

(NULL)

 

NextofKin

varchar(50)

YES

 

(NULL)

 

Relationship

varchar(100)

YES

 

(NULL)

 

StaffChild1

varchar(50)

YES

 

(NULL)

 

StaffChild1DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffChild2

varchar(50)

YES

 

(NULL)

 

StaffChild2DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffChild3

varchar(50)

YES

 

(NULL)

 

StaffChild3DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffChild4

varchar(50)

YES

 

(NULL)

 

StaffChild4DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffChild5

varchar(50)

YES

 

(NULL)

 

StaffChild5DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffChild6

varchar(50)

YES

 

(NULL)

 

StaffChild6DateofBirth

varchar(25)

YES

 

(NULL)

 

StaffLanguage1

varchar(50)

YES

 

(NULL)

 

StaffLanguage2

varchar(50)

YES

 

(NULL)

 

StaffLanguage3

varchar(50)

YES

 

(NULL)

 

StaffLanguage4

varchar(50)

YES

 

(NULL)

 

SSN

varchar(50)

YES

 

(NULL)

 

StaffChildSex1

varchar(10)

YES

 

(NULL)

 

StaffChildSex2

varchar(10)

YES

 

(NULL)

 

StaffChildSex3

varchar(10)

YES

 

(NULL)

 

StaffChildSex4

varchar(10)

YES

 

(NULL)

 

StaffChildSex5

varchar(10)

YES

 

(NULL)

 

StaffChildSex6

varchar(10)

YES

 

(NULL)

 

Indexes

Back

 
staffprofessionalqualification  
Fields
Field Type Null Key Default Extra

ProfessionalQualificationID

varchar(50)

YES

 

(NULL)

 

StaffNo

varchar(50)

YES

 

(NULL)

 

StaffProfessionalQualificationCourse

varchar(50)

YES

 

(NULL)

 

ProfessionalQualificationInstitution

varchar(50)

YES

 

(NULL)

 

ProfessionalQualificationStartYear

varchar(15)

YES

 

(NULL)

 

ProfessionalQualiificationEndYear

varchar(15)

YES

 

(NULL)

 

ProfessionalQualificationAwardDate

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
staffpromotion  
Fields
Field Type Null Key Default Extra

StaffPromotionID

varchar(50)

YES

 

(NULL)

 

StaffNO

varchar(50)

YES

 

(NULL)

 

StaffPromotionType

varchar(50)

YES

 

(NULL)

 

StaffPromotionEffectiveDate

varchar(50)

YES

 

(NULL)

 

StaffPromotionSalary

varchar(50)

YES

 

(NULL)

 

StaffPromotionEntryPoint

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
staffrecordcard  
Fields
Field Type Null Key Default Extra

StaffRecordCardID

varchar(50)

YES

 

(NULL)

 

StaffNO

varchar(50)

YES

 

(NULL)

 

StaffTrainingInstitutions

varchar(50)

YES

 

(NULL)

 

StaffRecordCardQualification

varchar(50)

YES

 

(NULL)

 

StaffProfessionalStatus

varchar(50)

YES

 

(NULL)

 

DateOfJoinningSchool

varchar(25)

YES

 

(NULL)

 

DateOfLeavingSchool

varchar(25)

YES

 

(NULL)

 

StaffReasonOfLeaving

varchar(50)

YES

 

(NULL)

 

ClassTaught

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
standardtest  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

DATE

varchar(25)

YES

 

(NULL)

 

TESTNAME

varchar(15)

YES

 

(NULL)

 

CLASS

varchar(15)

YES

 

(NULL)

 

AGE

char(3)

YES

 

(NULL)

 

SCORE

char(3)

YES

 

(NULL)

 

ADMINISTERDBY

varchar(15)

YES

 

(NULL)

 

Indexes

Back

 
statement  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

YES

 

(NULL)

 

STUDNAME

varchar(30)

YES

 

(NULL)

 

RECEIPTNO

varchar(15)

YES

 

(NULL)

 

BALDATE

varchar(25)

YES

 

(NULL)

 

AMTDUE

decimal(19,4)

YES

 

(NULL)

 

PAYDATE

varchar(25)

YES

 

(NULL)

 

PAYTYPE

varchar(15)

YES

 

(NULL)

 

AMTPAID

decimal(19,4)

YES

 

(NULL)

 

TERM

varchar(15)

YES

 

(NULL)

 

CLASSFORM

varchar(15)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

GuardianId

varchar(10)

YES

 

(NULL)

 

Indexes

Back

 
streamposition  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(20)

YES

 

(NULL)

 

StreamPosition

int(10)

YES

 

(NULL)

 

Indexes

Back

 
students  
Fields
Field Type Null Key Default Extra

AdmissionNo

varchar(50)

 

PRI

 

 

FirstName

varchar(20)

YES

 

(NULL)

 

Class

varchar(25)

YES

 

(NULL)

 

Father

varchar(40)

YES

 

(NULL)

 

PermanentAddress

varchar(100)

YES

 

(NULL)

 

Region

varchar(40)

YES

 

(NULL)

 

Hometown

varchar(30)

YES

 

(NULL)

 

MiddleName

varchar(20)

YES

 

(NULL)

 

LastName

varchar(20)

YES

 

(NULL)

 

Mother

varchar(30)

YES

 

(NULL)

 

AdmissionDate

date

YES

 

(NULL)

 

Term

varchar(20)

YES

 

(NULL)

 

CorrespondenceAddress

varchar(200)

YES

 

(NULL)

 

HomeCountry

varchar(40)

YES

 

(NULL)

 

Course

varchar(50)

YES

 

(NULL)

 

ResidentialStatus

varchar(30)

YES

 

(NULL)

 

Telephone

varchar(15)

YES

 

(NULL)

 

DateofBirth

varchar(50)

YES

 

(NULL)

 

Email

varchar(60)

YES

 

(NULL)

 

Remarks

varchar(100)

YES

 

(NULL)

 

Sex

varchar(10)

YES

 

(NULL)

 

ClassDescription

varchar(100)

YES

 

(NULL)

 

AcademicYear

varchar(25)

YES

 

(NULL)

 

PromotionStatus

varchar(20)

YES

 

(NULL)

 

CourseDescription

varchar(100)

YES

 

(NULL)

 

Department

varchar(100)

YES

 

(NULL)

 

Faculty

varchar(100)

YES

 

(NULL)

 

StatusOld

varchar(20)

YES

 

(NULL)

 

FatherName

varchar(50)

YES

 

(NULL)

 

MotherName

varchar(50)

YES

 

(NULL)

 

GuardianName

varchar(50)

YES

 

(NULL)

 

GuardianAddress1

varchar(50)

YES

 

(NULL)

 

GuardianAddress2

varchar(50)

YES

 

(NULL)

 

GuardianAddress3

varchar(50)

YES

 

(NULL)

 

GuardianTelephoneNo

varchar(50)

YES

 

(NULL)

 

GuardianEmail

varchar(50)

YES

 

(NULL)

 

PreviousSchoolAttended

varchar(200)

YES

 

(NULL)

 

GuardianResidence

varchar(100)

YES

 

(NULL)

 

HearAboutSchool

varchar(200)

YES

 

(NULL)

 

OtherWardsInSchool

varchar(100)

YES

 

(NULL)

 

HouseNo

varchar(50)

YES

 

(NULL)

 

GuardianID

varchar(50)

YES

 

(NULL)

 

StudentHouseNo

varchar(10)

YES

 

(NULL)

 

Religion

varchar(100)

YES

 

(NULL)

 

Transport

varchar(20)

YES

 

(NULL)

 

Site

varchar(20)

YES

 

(NULL)

 

Scholarship

varchar(50)

YES

 

(NULL)

 

Relationship

varchar(50)

YES

 

(NULL)

 

AdmissionDateRev

date

YES

 

(NULL)

 

PreviousClass

varchar(20)

YES

 

(NULL)

 

PreviousTerm

varchar(20)

YES

 

(NULL)

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

students

0

PRIMARY

1

AdmissionNo

A

167

(NULL)

(NULL)

 

BTREE

 

Back

 
subjects  
Fields
Field Type Null Key Default Extra

SubjectCode

varchar(20)

 

 

 

 

ClassForm

varchar(40)

YES

 

(NULL)

 

SubjectDescription

varchar(100)

YES

 

(NULL)

 

SemesterId

int(10)

YES

 

(NULL)

 

NoofCredit

int(10)

YES

 

(NULL)

 

Indexes

Back

 
tax  
Fields
Field Type Null Key Default Extra

TAXCODE

varchar(12)

 

 

 

 

TAXRATE

float(15,0)

YES

 

(NULL)

 

MINAMT

float(15,0)

YES

 

(NULL)

 

MAXAMT

float(15,0)

YES

 

(NULL)

 

FIXEDAMT

float(15,0)

YES

 

(NULL)

 

Indexes

Back

 
teachertable  
Fields
Field Type Null Key Default Extra

TeacherID

varchar(20)

 

 

 

 

TeacherName

varchar(60)

YES

 

(NULL)

 

UserID

varchar(50)

YES

 

(NULL)

 

Subject

varchar(120)

YES

 

(NULL)

 

Class

varchar(30)

YES

 

(NULL)

 

CourseID

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
teltable  
Fields
Field Type Null Key Default Extra

Staffno

float(15,0)

YES

 

(NULL)

 

FirstName

varchar(255)

YES

 

(NULL)

 

Middlename

varchar(50)

YES

 

(NULL)

 

surName

varchar(50)

YES

 

(NULL)

 

GCODE

float(15,0)

YES

 

(NULL)

 

GRADE

varchar(50)

YES

 

(NULL)

 

Dept

varchar(255)

YES

 

(NULL)

 

NewNum

varchar(50)

YES

 

(NULL)

 

telephone

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
tempmast  
Fields
Field Type Null Key Default Extra

ACCOUNTNO

varchar(13)

 

 

 

 

BALDATE

varchar(25)

YES

 

(NULL)

 

BOOKBAL

decimal(19,4)

YES

 

(NULL)

 

CLRBAL

decimal(19,4)

YES

 

(NULL)

 

UNCLRAMT

decimal(19,4)

YES

 

(NULL)

 

BBOOKBAL

decimal(19,4)

YES

 

(NULL)

 

BCLRBAL

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
termtable  
Fields
Field Type Null Key Default Extra

TERM

varchar(40)

YES

 

(NULL)

 

ACADEMICYEAR

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
timesheet  
Fields
Field Type Null Key Default Extra

StaffNo

varchar(12)

YES

 

(NULL)

 

StaffName

varchar(60)

YES

 

(NULL)

 

Rank

varchar(50)

YES

 

(NULL)

 

FullDate

varchar(50)

YES

 

(NULL)

 

MonthYear

varchar(50)

YES

 

(NULL)

 

MonthName

varchar(20)

YES

 

(NULL)

 

WeekId

varchar(50)

YES

 

(NULL)

 

DayID

varchar(50)

YES

 

(NULL)

 

DayDesc

varchar(50)

YES

 

(NULL)

 

ReportingTime

varchar(25)

YES

 

(NULL)

 

HrsExpected

decimal(18,0)

YES

 

(NULL)

 

TimeIn1

varchar(25)

YES

 

(NULL)

 

TimeOut1

varchar(25)

YES

 

(NULL)

 

Total1

decimal(18,0)

YES

 

(NULL)

 

TimeIn2

varchar(25)

YES

 

(NULL)

 

TimeOut2

varchar(25)

YES

 

(NULL)

 

Total2

decimal(18,0)

YES

 

(NULL)

 

ExtraHrs

decimal(18,0)

YES

 

(NULL)

 

NonWorkActivity

decimal(18,0)

YES

 

(NULL)

 

DailyTotal

varchar(50)

YES

 

(NULL)

 

ExcessDeficit

varchar(50)

YES

 

(NULL)

 

Remark

varchar(50)

YES

 

(NULL)

 

Reason

varchar(200)

YES

 

(NULL)

 

Indexes

Back

 
timetable  
Fields
Field Type Null Key Default Extra

ClassForm

varchar(15)

 

 

 

 

Assembly

varchar(15)

YES

 

(NULL)

 

Registration

varchar(15)

YES

 

(NULL)

 

Break1

varchar(15)

YES

 

(NULL)

 

Break2

varchar(15)

YES

 

(NULL)

 

Prd1

varchar(15)

YES

 

(NULL)

 

Prd2

varchar(15)

YES

 

(NULL)

 

Prd3

varchar(15)

YES

 

(NULL)

 

Prd4

varchar(15)

YES

 

(NULL)

 

Prd5

varchar(15)

YES

 

(NULL)

 

Prd6

varchar(15)

YES

 

(NULL)

 

Prd7

varchar(15)

YES

 

(NULL)

 

Prd8

varchar(15)

YES

 

(NULL)

 

Prd9

varchar(15)

YES

 

(NULL)

 

Prd10

varchar(15)

YES

 

(NULL)

 

Mon

varchar(15)

YES

 

(NULL)

 

Tue

varchar(15)

YES

 

(NULL)

 

Wed

varchar(15)

YES

 

(NULL)

 

Thu

varchar(15)

YES

 

(NULL)

 

Fri

varchar(15)

YES

 

(NULL)

 

Sat

varchar(15)

YES

 

(NULL)

 

Subject1

varchar(35)

YES

 

(NULL)

 

Subject2

varchar(35)

YES

 

(NULL)

 

Subject3

varchar(35)

YES

 

(NULL)

 

Subject4

varchar(35)

YES

 

(NULL)

 

Subject5

varchar(35)

YES

 

(NULL)

 

Subject6

varchar(35)

YES

 

(NULL)

 

Subject7

varchar(35)

YES

 

(NULL)

 

Subject8

varchar(35)

YES

 

(NULL)

 

Subject9

varchar(35)

YES

 

(NULL)

 

Subject10

varchar(35)

YES

 

(NULL)

 

Subject11

varchar(35)

YES

 

(NULL)

 

Subject12

varchar(35)

YES

 

(NULL)

 

Subject13

varchar(35)

YES

 

(NULL)

 

Subject14

varchar(35)

YES

 

(NULL)

 

Subject15

varchar(35)

YES

 

(NULL)

 

Subject16

varchar(35)

YES

 

(NULL)

 

Subject17

varchar(35)

YES

 

(NULL)

 

Subject18

varchar(35)

YES

 

(NULL)

 

Subject19

varchar(35)

YES

 

(NULL)

 

Subject20

varchar(35)

YES

 

(NULL)

 

Subject21

varchar(35)

YES

 

(NULL)

 

Subject22

varchar(35)

YES

 

(NULL)

 

Subject23

varchar(35)

YES

 

(NULL)

 

Subject24

varchar(35)

YES

 

(NULL)

 

Subject25

varchar(35)

YES

 

(NULL)

 

Subject26

varchar(35)

YES

 

(NULL)

 

Subject27

varchar(35)

YES

 

(NULL)

 

Subject28

varchar(35)

YES

 

(NULL)

 

Subject29

varchar(35)

YES

 

(NULL)

 

Subject30

varchar(35)

YES

 

(NULL)

 

Subject31

varchar(35)

YES

 

(NULL)

 

Subject32

varchar(35)

YES

 

(NULL)

 

Subject33

varchar(35)

YES

 

(NULL)

 

Subject34

varchar(35)

YES

 

(NULL)

 

Subject35

varchar(35)

YES

 

(NULL)

 

Subject36

varchar(35)

YES

 

(NULL)

 

Subject37

varchar(35)

YES

 

(NULL)

 

Subject38

varchar(35)

YES

 

(NULL)

 

Subject39

varchar(35)

YES

 

(NULL)

 

Subject40

varchar(35)

YES

 

(NULL)

 

Subject41

varchar(35)

YES

 

(NULL)

 

Subject42

varchar(35)

YES

 

(NULL)

 

Subject43

varchar(35)

YES

 

(NULL)

 

Subject44

varchar(35)

YES

 

(NULL)

 

Subject45

varchar(35)

YES

 

(NULL)

 

Subject46

varchar(35)

YES

 

(NULL)

 

Subject47

varchar(35)

YES

 

(NULL)

 

Subject48

varchar(35)

YES

 

(NULL)

 

Subject49

varchar(35)

YES

 

(NULL)

 

Subject50

varchar(35)

YES

 

(NULL)

 

Subject51

varchar(35)

YES

 

(NULL)

 

Subject52

varchar(35)

YES

 

(NULL)

 

Subject53

varchar(35)

YES

 

(NULL)

 

Subject54

varchar(35)

YES

 

(NULL)

 

Subject55

varchar(35)

YES

 

(NULL)

 

Subject56

varchar(35)

YES

 

(NULL)

 

Subject57

varchar(35)

YES

 

(NULL)

 

Subject58

varchar(35)

YES

 

(NULL)

 

Subject59

varchar(35)

YES

 

(NULL)

 

Subject60

varchar(35)

YES

 

(NULL)

 

Indexes

Back

 
totamtforstudent  
Fields
Field Type Null Key Default Extra

TOTAMT

decimal(19,4)

 

 

0.0000

 

BALDATE

varchar(25)

YES

 

(NULL)

 

ADMISSIONNO

varchar(20)

 

 

 

 

Indexes

Back

 
transcriptbatch  
Fields
Field Type Null Key Default Extra

StudentName

varchar(40)

YES

 

(NULL)

 

NoofRoll

int(10)

YES

 

(NULL)

 

Term

varchar(15)

YES

 

(NULL)

 

ClassForm

varchar(10)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

ReportDate

varchar(25)

YES

 

(NULL)

 

NextTermBegins

varchar(20)

YES

 

(NULL)

 

OverAllPosition

int(10)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ClassScore

float(15,0)

YES

 

(NULL)

 

OverAllTotal

float(15,0)

YES

 

(NULL)

 

PositionInSubject

int(10)

YES

 

(NULL)

 

Remark

varchar(25)

YES

 

(NULL)

 

GPA

varchar(8)

YES

 

(NULL)

 

Grade

varchar(6)

YES

 

(NULL)

 

AdmissionNo

varchar(12)

YES

 

(NULL)

 

IndexCode

char(3)

YES

 

(NULL)

 

Indexes

Back

 
transcriptforfinalprinting  
Fields
Field Type Null Key Default Extra

StudentName

varchar(70)

YES

 

(NULL)

 

NoofRoll

int(10)

YES

 

(NULL)

 

Term

varchar(40)

YES

 

(NULL)

 

ClassForm

varchar(40)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

ReportDate

varchar(25)

YES

 

(NULL)

 

NextTermBegins

varchar(40)

YES

 

(NULL)

 

OverAllPosition

int(10)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ClassScore

float(15,0)

YES

 

(NULL)

 

OverAllTotal

float(15,0)

YES

 

(NULL)

 

PositionInSubject

int(10)

YES

 

(NULL)

 

Remark

varchar(40)

YES

 

(NULL)

 

GPA

varchar(8)

YES

 

(NULL)

 

Grade

varchar(6)

YES

 

(NULL)

 

AdmissionNo

varchar(20)

YES

 

(NULL)

 

IndexCode

varchar(6)

YES

 

(NULL)

 

CourseID

varchar(40)

YES

 

(NULL)

 

NoofCredit

double(7,0)

YES

 

(NULL)

 

Indexes

Back

 
transcriptindividuals  
Fields
Field Type Null Key Default Extra

StudentName

varchar(70)

YES

 

(NULL)

 

NoofRoll

int(10)

YES

 

(NULL)

 

Term

varchar(40)

YES

 

(NULL)

 

ClassForm

varchar(40)

YES

 

(NULL)

 

AcademicYr

varchar(15)

YES

 

(NULL)

 

ReportDate

varchar(25)

YES

 

(NULL)

 

NextTermBegins

varchar(40)

YES

 

(NULL)

 

OverAllPosition

int(10)

YES

 

(NULL)

 

Subject

varchar(100)

YES

 

(NULL)

 

ExamScore

float(15,0)

YES

 

(NULL)

 

ClassScore

float(15,0)

YES

 

(NULL)

 

OverAllTotal

float(15,0)

YES

 

(NULL)

 

PositionInSubject

int(10)

YES

 

(NULL)

 

Remark

varchar(40)

YES

 

(NULL)

 

GPA

float(15,0)

YES

 

(NULL)

 

Grade

varchar(6)

YES

 

(NULL)

 

AdmissionNo

varchar(20)

YES

 

(NULL)

 

IndexCode

varchar(6)

YES

 

(NULL)

 

CourseID

varchar(40)

YES

 

(NULL)

 

NoofCredit

double(7,0)

YES

 

(NULL)

 

Indexes

Back

 
transhist  
Fields
Field Type Null Key Default Extra

ID

int(10)

 

 

0

 

ACCOUNTNO

varchar(13)

YES

 

(NULL)

 

TRNREF

varchar(12)

YES

 

(NULL)

 

INSTNO

varchar(9)

YES

 

(NULL)

 

TRNTYPE

char(2)

YES

 

(NULL)

 

POSTDATE

varchar(25)

YES

 

(NULL)

 

VALUDATE

varchar(25)

YES

 

(NULL)

 

AMOUNT

decimal(19,4)

YES

 

(NULL)

 

BASE

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

NARRATION

varchar(50)

YES

 

(NULL)

 

SFLAG

char(1)

YES

 

(NULL)

 

FOREXIND

char(1)

YES

 

(NULL)

 

USERID

varchar(8)

YES

 

(NULL)

 

TRANSHITTIME

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
transmerge  
Fields
Field Type Null Key Default Extra

ID

int(10)

YES

 

(NULL)

 

ACCOUNTNO

varchar(13)

 

 

 

 

TRNREF

varchar(12)

YES

 

(NULL)

 

INSTNO

varchar(20)

 

 

 

 

TRNTYPE

char(2)

YES

 

(NULL)

 

POSTDATE

varchar(25)

 

 

 

 

VALUDATE

varchar(25)

YES

 

(NULL)

 

AMOUNT

decimal(19,4)

 

 

0.0000

 

BASE

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

NARRATION

varchar(200)

YES

 

(NULL)

 

SFLAG

char(1)

YES

 

(NULL)

 

FOREXIND

char(1)

YES

 

(NULL)

 

USERID

varchar(40)

 

 

 

 

TRANSHITTIME

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
transmergereceipt  
Fields
Field Type Null Key Default Extra

ID

int(10)

YES

 

(NULL)

 

ACCOUNTNO

varchar(13)

YES

 

(NULL)

 

TRNREF

varchar(12)

YES

 

(NULL)

 

INSTNO

varchar(20)

YES

 

(NULL)

 

TRNTYPE

char(2)

YES

 

(NULL)

 

POSTDATE

varchar(25)

YES

 

(NULL)

 

VALUDATE

varchar(25)

YES

 

(NULL)

 

AMOUNT

decimal(19,4)

YES

 

(NULL)

 

BASE

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

NARRATION

varchar(50)

YES

 

(NULL)

 

SFLAG

varchar(200)

YES

 

(NULL)

 

FOREXIND

char(1)

YES

 

(NULL)

 

USERID

varchar(8)

YES

 

(NULL)

 

TRANSHITTIME

varchar(25)

YES

 

(NULL)

 

ACCOUNTNAME

varchar(100)

YES

 

(NULL)

 

Indexes

Back

 
transprinting  
Fields
Field Type Null Key Default Extra

ID

int(10)

YES

 

(NULL)

 

ACCOUNTNO

varchar(13)

YES

 

(NULL)

 

TRNREF

varchar(50)

YES

 

(NULL)

 

INSTNO

varchar(50)

YES

 

(NULL)

 

TRNTYPE

char(2)

YES

 

(NULL)

 

POSTDATE

varchar(25)

YES

 

(NULL)

 

VALUDATE

varchar(25)

YES

 

(NULL)

 

AMOUNT

decimal(19,4)

YES

 

(NULL)

 

BASE

decimal(19,4)

YES

 

(NULL)

 

BALANCE

decimal(19,4)

YES

 

(NULL)

 

NARRATION

varchar(200)

YES

 

(NULL)

 

SFLAG

char(1)

YES

 

(NULL)

 

FOREXIND

char(1)

YES

 

(NULL)

 

USERID

varchar(20)

YES

 

(NULL)

 

TRANSHITTIME

varchar(25)

YES

 

(NULL)

 

Indexes

Back

 
trialbalance  
Fields
Field Type Null Key Default Extra

AccountNo

varchar(20)

 

 

 

 

AcountName

varchar(100)

YES

 

(NULL)

 

CRBookBal

decimal(19,4)

YES

 

(NULL)

 

DRBookBal

decimal(19,4)

YES

 

(NULL)

 

Indexes

Back

 
unpresenetedcreditedcheques  
Fields
Field Type Null Key Default Extra

ACCOUNTNO

varchar(13)

 

 

 

 

INSTNO

varchar(20)

 

 

 

 

POSTDATE

varchar(25)

 

 

 

 

AMOUNT

decimal(19,4)

 

 

0.0000

 

NARRATION

varchar(200)

YES

 

(NULL)

 

SFLAG

char(1)

YES

 

(NULL)

 

ACCOUNTNAME

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
usergroups  
Fields
Field Type Null Key Default Extra

GrpCode

int(10)

 

 

0

 

GrpDesc

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
userlevels  
Fields
Field Type Null Key Default Extra

Userlevel

int(10)

 

 

0

 

UserlevelCode

varchar(50)

YES

 

(NULL)

 

LevelDesc

varchar(50)

YES

 

(NULL)

 

Indexes

Back

 
users  
Fields
Field Type Null Key Default Extra

UserName

varchar(20)

 

 

 

 

PassWord

varchar(50)

YES

 

(NULL)

 

Userlevel

int(10)

YES

 

(NULL)

 

GrpCode

int(10)

YES

 

(NULL)

 

Description

varchar(50)

YES

 

(NULL)

 

pass1

blob

YES

 

(NULL)

 

FullName

varchar(30)

YES

 

(NULL)

 

Indexes

Back

 
visitorslogbook  
Fields
Field Type Null Key Default Extra

LogDate

varchar(25)

YES

 

(NULL)

 

Event

blob

YES

 

(NULL)

 

logId

int(10)

YES

 

(NULL)

 

Indexes

Back

 
vocationalgoals  
Fields
Field Type Null Key Default Extra

ADMISSIONNO

varchar(20)

 

 

 

 

DATE

varchar(25)

YES

 

(NULL)

 

FIRSTPREFERENCE

varchar(40)

YES

 

(NULL)

 

SECONDPREFERENCE

varchar(40)

YES

 

(NULL)

 

Indexes

Back