Page 88 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table FURNITURE_TOOLS

Col # Column Name Data Type Not Null? Comments
1 FURNITURE_CODE 7 CHAR(2) Y
NUMBER(4) Y
2 YEAR 1
3 DIV_CODE 2 CHAR(2) Y
4 DIST_CODE 3 CHAR(2) Y
CHAR(2) Y
5 THANA_CODE 4
6 UNION_CODE 5 CHAR(2) Y
CHAR(4) Y
7 INST_CODE 6
8 USED_NO NUMBER(4)
9 COM_ID VARCHAR2(15)

Table GIS_INFORMATION

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 MAUZA_CODE CHAR(3)
CHAR(4) Y
7 INST_CODE 6
8 INST_NAME VARCHAR2(50)
9 VILL_NAME VARCHAR2(30)
10 DAG_NO_CS CHAR(4)
11 DAG_NO_SA CHAR(4)
12 DAG_NO_RS CHAR(4)
13 MAUZA_YEAR_CS CHAR(7)
14 MAUZA_YEAR_SA CHAR(7)
15 MAUZA_YEAR_RS CHAR(7)
16 SEAT_NO_CS NUMBER(4)
17 SEAT_NO_SA NUMBER(4)
18 SEAT_NO_RS NUMBER(4)
19 MAUZA_NO_CS VARCHAR2(25)
20 MAUZA_NO_SA VARCHAR2(25)
21 MAUZA_NO_RS VARCHAR2(25)
22 MAUZA_JL_NO_CS NUMBER(4)
23 MAUZA_JL_NO_SA NUMBER(4)
24 MAUZA_JL_NO_RS NUMBER(4)
25 ROAD_NAME VARCHAR2(30)
26 ROAD_DIST1 NUMBER(3)
27 ROAD_DIST2 NUMBER(4)

- 81 -