abs |
activities
additionalreportinfo
admissionqualification
admissionregister
admissionrequirement
applicationadmission
applicationpath
assessmentregister
assignment
attendancedata
audit_log
audit_trail
awards
balancesheet
billingtable
billingtableclass
booklist
booklistprint
broadsheet
broadsheetprinting
chequeprinting
classachievement
classposition
classtest
coursetable
currency
custreg
department
encrypt
eventlogbook
examscore
exchangerate
faculty
father
feebatchtable
feecodemisc
feecodes
feecodetable
feesdelete
finalresultsforprinting
formclasstable
furthereducation
genledger
glcontrol
glmemo
globalpath
gradeadmissiontable
groupposition
guardian
handicaps
headcount
healthrecord
homework
incomeexpenditure
incomeexpendituretotal
incomeexpendituretotale
loan
loanref
marksheet
master
mother
noofroll
paybalance
payments
payrollprint
payrolltable
periodicreceipt
personaldata
personalitydevelopment
promotiontemp
receipttemp
reports
resultprocessing
resultprocessingprinting
results
scholarshiptable
schoolinfo
schoolsattended
significantdata
sponsorinformation
spouse
staffacademicqualification
staffemploymentparticulars
stafffamily
staffmembers
staffprofessionalqualification
staffpromotion
staffrecordcard
standardtest
statement
streamposition
students
subjects
tax
teachertable
teltable
tempmast
termtable
timesheet
timetable
totamtforstudent
transcriptbatch
transcriptforfinalprinting
transcriptindividuals
transhist
transmerge
transmergereceipt
transprinting
trialbalance
unpresenetedcreditedcheques
usergroups
userlevels
users
visitorslogbook
vocationalgoals
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) |
|
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) |
|
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) |
|
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) |
|
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