DATABASE SPECIFICATIONS
DATABASE SPECIFICATIONS
1.
TABLE NAME : TBLGENDER FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
GID IntN/A PK, IDENTITY NONE
GDESC Varchar6 NOT NULL NONE
2.
TABLE NAME: TBLGRDLVL FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
GRDID IntN/A PRIMARY KEY,IDENTITY NONE
GRDLVLDESC VarChar15 NOT NULL NONE
GRDSECTION Varchar15 NOT NULL NONE
3.
TABLE NAME: TBLRANK FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
RANKID IntN/A PRIMARY KEY,IDENTITY NONE
RANKDESC Varchar20 NOT NULL NONE
4.
TABLE NAME: TBLDEPT FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
DEPTID IntN/A PRIMARY KEY,IDENTITY NONE
DEPTDESC Varchar20 NOT NULL NONE
5.
TABLE NAME: TBLCURRICULUM FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
CURRID IntN/A PRIMARY KEY,IDENTITY NONE
CURRDESC Varchar20 NOT NULL NONE
6.
TABLE NAME: TBLMOBILE FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
MOBILEID IntN/A PRIMARY KEY,IDENTITY NONE
USERID Varchar20 NOT NULL NONE
MOBILEDESC Varchar13 NOT NULL NONE
7.
TABLE NAME: TBLEMAIL FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
EMAILID IntN/A PRIMARY KEY,IDENTITY NONE
USERID Varchar20 NOT NULL NONE
EMAILDESC Varchar30 NOT NULL NONE
8.
TABLE NAME: TBLPARENT FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
PARENTID IntN/A PRIMARY KEY,IDENTITY NONE
FNAME Varchar30 NOT NULL NONE
MNAME Varchar30 NOT NULL NONE
LNAME Varchar30 NOT NULL NONE
ADDRESS Varchar50 NOT NULL NONE
DOB Date/Time N/A NOT NULL NONE
GENDER IntN/A FOREIGN KEY TBLGENDER
MOBILE Varchar13 NOT NULL NONE
EMAIL Varchar20 NOT NULL NONE
9.
TABLE NAME: TBLROOM FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
ROOMID IntN/A PRIMARY KEY,IDENTITY NONE
ROOMDESC Varchar20 NOT NULL NONE
GRD.LVL IntN/A FOREIGN KEY TBLGRDLVL
DEPTID IntN/A FOREIGN KEY TBLDEPT
10.
TABLE NAME: TBLSTAFF FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
STAFFID IntN/A PRIMARY KEY,IDENTITY NONE
FNAME Varchar20 NOT NULL NONE
MNAME Varchar20 NOT NULL NONE
LNAME Varchar20 NOT NULL NONE
GENDER IntN/A
1.
TABLE NAME : TBLGENDER FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
GID IntN/A PK, IDENTITY NONE
GDESC Varchar6 NOT NULL NONE
2.
TABLE NAME: TBLGRDLVL FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
GRDID IntN/A PRIMARY KEY,IDENTITY NONE
GRDLVLDESC VarChar15 NOT NULL NONE
GRDSECTION Varchar15 NOT NULL NONE
3.
TABLE NAME: TBLRANK FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
RANKID IntN/A PRIMARY KEY,IDENTITY NONE
RANKDESC Varchar20 NOT NULL NONE
4.
TABLE NAME: TBLDEPT FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
DEPTID IntN/A PRIMARY KEY,IDENTITY NONE
DEPTDESC Varchar20 NOT NULL NONE
5.
TABLE NAME: TBLCURRICULUM FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
CURRID IntN/A PRIMARY KEY,IDENTITY NONE
CURRDESC Varchar20 NOT NULL NONE
6.
TABLE NAME: TBLMOBILE FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
MOBILEID IntN/A PRIMARY KEY,IDENTITY NONE
USERID Varchar20 NOT NULL NONE
MOBILEDESC Varchar13 NOT NULL NONE
7.
TABLE NAME: TBLEMAIL FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
EMAILID IntN/A PRIMARY KEY,IDENTITY NONE
USERID Varchar20 NOT NULL NONE
EMAILDESC Varchar30 NOT NULL NONE
8.
TABLE NAME: TBLPARENT FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
PARENTID IntN/A PRIMARY KEY,IDENTITY NONE
FNAME Varchar30 NOT NULL NONE
MNAME Varchar30 NOT NULL NONE
LNAME Varchar30 NOT NULL NONE
ADDRESS Varchar50 NOT NULL NONE
DOB Date/Time N/A NOT NULL NONE
GENDER IntN/A FOREIGN KEY TBLGENDER
MOBILE Varchar13 NOT NULL NONE
EMAIL Varchar20 NOT NULL NONE
9.
TABLE NAME: TBLROOM FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
ROOMID IntN/A PRIMARY KEY,IDENTITY NONE
ROOMDESC Varchar20 NOT NULL NONE
GRD.LVL IntN/A FOREIGN KEY TBLGRDLVL
DEPTID IntN/A FOREIGN KEY TBLDEPT
10.
TABLE NAME: TBLSTAFF FIELD NAME DATA TYPE SIZE CONSTRAINT REFERENCES
STAFFID IntN/A PRIMARY KEY,IDENTITY NONE
FNAME Varchar20 NOT NULL NONE
MNAME Varchar20 NOT NULL NONE
LNAME Varchar20 NOT NULL NONE
GENDER IntN/A
References: PAYID IntN/A PRIMARY KEY,IDENTITY NONE STUDID IntN/A FOREIGN KEY TBLSTUDENT PAYDESC Varchar20 NOT NULL NONE AMOUNT Real N/A NOT NULL NONE PAY.YR IntN/A NOT NULL NONE