Page 87 - Microsoft Word - Bangladesh_Diagnostic_E_final5.doc

Annex IX

Table BUIL_USE

Col # Column Name Data Type Not Null? Comments

1 YEAR 1 NUMBER(4) Y
2 DIV_CODE 2 CHAR(2) Y
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_USE 7 NUMBER(2) Y
8 OFFICE_USE NUMBER(2)
9 TEACH_USE NUMBER(2)
10 LIB_USE NUMBER(2)
11 HOSTEL_USE NUMBER(2)
12 TEC_RES_USE NUMBER(2)
13 LAB_USE NUMBER(2)
14 COMP_USE NUMBER(2)
15 OTH_USE NUMBER(2)
16 COM_ID VARCHAR2(15)
17 TOT_USE NUMBER(3)

Table COMMUNITY_SERVICES

Col # Column Name Data Type Not Null? Comments
1 YEAR 1 NUMBER(4) Y
CHAR(2) Y
2 DIV_CODE 2
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 BOYS_SCOUT NUMBER(3)
8 GIRLS_GUIDE NUMBER(3)
9 RED_CRESENT NUMBER(3)
10 HEALTH_FACILITY NUMBER(3)
11 TRANSPORTATION NUMBER(2)
12 COM_ID VARCHAR2(15)

- 80 -