Page 93 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc
P. 93
Annex IX
Col # Column Name Data Type Not Null? Comments
25 MAGAZINE NUMBER(3)
26 NEWSPAPER NUMBER(3)
27 MAP NUMBER(3)
28 GLOBE NUMBER(3)
29 COMP_BOUGHT NUMBER(3)
30 COMP_GOVT NUMBER(3)
31 OTHER_COMP NUMBER(3)
32 PLAY_GROUND VARCHAR2(2)
33 ELICTRICITY_DIST VARCHAR2(2)
34 TOILET VARCHAR2(2)
35 LAD_TOILET VARCHAR2(2)
36 TUBE_WELL VARCHAR2(2)
37 TAP VARCHAR2(2)
38 TRANSPORT VARCHAR2(2)
39 COMM_CENTER VARCHAR2(2)
40 GAS VARCHAR2(2)
41 CANTEEN VARCHAR2(2)
42 GYM VARCHAR2(2)
43 ST_PALIAMENT VARCHAR2(2)
44 OTHER_FACILITY VARCHAR2(2)
45 COM_ID VARCHAR2(15)
46 TEC_RES NUMBER(8,4)
48 MANAGEMENT CHAR(1)
49 LEVEL_EDU CHAR(2)
50 LIB_USE NUMBER(2)
Table RESULT_SSC
Col # Column Name Data Type Not Null? Comments
1 YEAR 1 NUMBER(4) Y
CHAR(2) Y
2 DIV_CODE 2
3 DIST_CODE 3 CHAR(2) Y
CHAR(2) Y
4 THANA_CODE 4
CHAR(2) Y
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y
NUMBER(4) Y
7 YEAR_EX 7
8 DEPARTMENT 8 CHAR(1) Y
9 ST_LAST_YEAR NUMBER(5)
10 TOTAL_EX_NO NUMBER(4)
11 FEMALE_EX_NO NUMBER(4)
15 TOTAL_STUDENT NUMBER(5)
16 FEMALE_STUDENT NUMBER(5)
17 EXPELLED NUMBER(3)
18 COM_ID VARCHAR2(15)
- 86 -