Page 89 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Col # Column Name Data Type Not Null? Comments
28 ROAD_LOC VARCHAR2(12)
29 RIVER_NAME VARCHAR2(30)
30 RIVER_DIST1 NUMBER(3)
31 RIVER_DIST2 NUMBER(4)
32 RIVER_LOC VARCHAR2(12)
33 VARIFICATION CHAR(1)
34 POLICE_ST_DIST1 NUMBER(3)
35 POLICE_ST_DIST2 NUMBER(4)
36 POLICE_ST_LOC VARCHAR2(12)
37 UNION_OFF_DIST1 NUMBER(3)
38 UNION_OFF_DIST2 NUMBER(4)
39 UNION_LOC VARCHAR2(12)
40 ADJACENT_PLACE_NAME VARCHAR2(30)
41 ADJACENT_PLACE_DIST1 NUMBER(3)
42 ADJACENT_PLACE_DIST2 NUMBER(4)
43 ADJACENT_PLACE_LOC VARCHAR2(12)
44 REASON VARCHAR2(35)
46 COM_ID VARCHAR2(15)

Table GOVT_FACILITY_DEVELOPMENT

Col # Column Name Data Type Not Null? Comments
1 YEAR NUMBER(4)
2 DIV_CODE CHAR(2)
3 DIST_CODE CHAR(2)
4 THANA_CODE CHAR(2)
5 UNION_CODE CHAR(2)
6 INST_CODE CHAR(4)
7 YEAR_DEVELOP NUMBER(4)
8 FACILITY CHAR(1)
9 TYPE CHAR(1)
10 PROJECT_NAME VARCHAR2(30)
11 AMOUNT_FACILITY NUMBER(12,2)
12 DATE_APP VARCHAR2(11)
13 COM_ID VARCHAR2(15)

- 82 -