Page 92 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table MONTHLY_FEES
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 MONTHLY_FEES_CHARGES 7 VARCHAR2(20) Y
8 SIXTH NUMBER(7,2)
9 SEVENTH NUMBER(7,2)
10 EIGHTH NUMBER(7,2)
11 NINTH_SCIENCE NUMBER(7,2)
12 NINTH_SOCIAL_SCIENCE NUMBER(7,2)
13 TENTH_SCIENCE NUMBER(7,2)
14 TENTH_SOCIAL_SCIENCE NUMBER(7,2)
15 COM_ID VARCHAR2(15)
Table PHYSICAL_ADV
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
5 UNION_CODE 5 CHAR(2) Y
6 INST_CODE 6 CHAR(4) Y
7 LAND_BOUGHT NUMBER(8,4)
8 ABANDON_LAND NUMBER(8,4)
9 VEST_LAND NUMBER(8,4)
10 WAKF NUMBER(8,4)
11 GIFT_LAND NUMBER(8,4)
12 GOVT_LAND NUMBER(8,4)
13 OTHERS_LAND NUMBER(8,4)
14 TOTAL_LAND NUMBER(8,4)
15 HOSTEL_RES NUMBER(8,4)
16 INST_BUILD NUMBER(8,4)
17 PLAY_GROUND_USED NUMBER(8,4)
18 CULTIVATE_LAND NUMBER(8,4)
19 POND NUMBER(8,4)
20 GARDEN NUMBER(8,4)
21 OTHER_LAND_USED NUMBER(8,4)
22 TOTAL_LAND_USED NUMBER(8,4)
23 TEXT_BOOK NUMBER(5)
24 OTHER_BOOKS NUMBER(5)

- 85 -