Page 97 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table T_INFO

Col # Column Name Data Type Not Null? Comments

1 YEAR 1 NUMBER(4) Y
2 DIV_CODE 2 CHAR(2) Y
3 DIST_CODE 3 CHAR(2) Y
4 THANA_CODE 4 CHAR(2) Y
5 UNION_CODE 5 CHAR(2) Y
6 INST_CODE 6 CHAR(4) Y
7 SL_NO 7 NUMBER(3) Y
8 NAME VARCHAR2(40)
9 DESIG_CODE CHAR(2)
10 INDEX_NO VARCHAR2(10)
11 B_DATE VARCHAR2(10)
12 SEX VARCHAR2(1)
13 RELIGION VARCHAR2(1)
14 P_SCALE NUMBER(2)
15 IST_J_DATE VARCHAR2(10)
16 P_POST_J_DATE VARCHAR2(10)
17 MPO_DATE VARCHAR2(10)
18 SUBJ_CODE VARCHAR2(2)
19 CLASS_P_WEEK NUMBER(2)
20 EDU_CODE VARCHAR2(2)
21 CLASS_OBT NUMBER(1)
22 HI_DEGREE NUMBER(1)
28 SCALE VARCHAR2(20)
29 SUBJ_NAME VARCHAR2(40)
30 EDU_LEVEL VARCHAR2(40)
31 DESIG_NAME VARCHAR2(30)

College Database in BANBEIS

# of # of
Table Name Size Description of Tables
Cols Indexes
C_BUILD_INFO 25 2 2M Academic Building information
C_BUIL_USE 18 1 256K Use of the academic building
C_COMMUNITY_SERVICES 15 1 640K Community service information
C_FURNITURE_TOOLS 10 1 5M Furniture, equipment information
C_GIS_INFORMATION 47 2 2M GIS location information of the school
C_GOVT_FACILITY_DEVELOPMENT 14 1 704K Gov’t. Development facilities information
C_INC_EXP_INFO 13 1 6M Income and Expenditure information
C_INST_ADD_INFO 16 2 640K Additional data of the school
C_INST_INFO 43 2 3M Basic information of the school
C_MONTHLY_FEES 20 2 896K Student Fees information
C_PHYSICAL_ADV 50 2 960K Physical facilities information

- 90 -