Page 95 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

23 MANAGEMENT CHAR(1)
24 STUDENT_TYPE CHAR(1)

Table ST_DROP_OUT
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
4 THANA_CODE 4 CHAR(2) Y
5 UNION_CODE 5 CHAR(2) Y
6 INST_CODE 6 CHAR(4) Y
7 CLASS_NAME 7 CHAR(2) Y
8 GROUP_NAME 8 CHAR(1) Y
9 STUDENT_T NUMBER(4)
10 STUDENT_F NUMBER(4)
11 PROMOTION_T NUMBER(4)
12 PROMOTION_F NUMBER(4)
13 FAIL_T NUMBER(3)
14 FAIL_F NUMBER(3)
15 DROP_OUT_T NUMBER(3)
16 DROP_OUT_F NUMBER(3)
17 COM_ID VARCHAR2(15)
18 STIPEND NUMBER(3)

Table TEACHER_STAFF_NO

Col # Column Name Data Type Not Null? Comments
1 YEAR 1 NUMBER(4) Y
2 DIV_CODE 2 CHAR(2) Y
CHAR(2) Y
3 DIST_CODE 3
4 THANA_CODE 4 CHAR(2) Y
CHAR(2) Y
5 UNION_CODE 5
6 INST_CODE 6 CHAR(4) Y
7 DESIG_CODE 7 CHAR(2) Y
8 APP_POST_NO NUMBER(2)
9 IN_SERVICE_T NUMBER(3)
10 IN_SERVICE_F NUMBER(3)
11 MPO_TOTAL NUMBER(3)
12 MPO_FEMALE NUMBER(3)
13 COM_ID VARCHAR2(15)
15 LEVEL_EDU CHAR(2)
16 MANAGEMENT CHAR(1)
17 STUDENT_TYPE CHAR(1)

- 88 -