home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 1997 January
/
Chip_1997-01_cd.bin
/
ms95
/
disk23
/
dir02
/
f001430.re_
/
f001430.re
Wrap
Text File
|
1996-04-02
|
2KB
|
99 lines
create table parcel
(
mslink number(10,0) not null,
old_map_no char(5),
group_no char(6),
parcel_no char(15),
trailer_no char(4),
clt_no char(30),
owner char(50),
value number(10,0),
house_num char(10),
street_name char(40),
city char(40),
state char(50),
zip_code number(10,0),
county char(50),
district char(50),
zone_class char(50),
block_num char(4),
lot_num char(4),
subd_name char(50),
parc_area number(20,4),
perimeter number(20,4),
mapid number(10,0)
);
grant all on parcel to public;
create index parcel_mslink on parcel (mslink);
create table highway
(
mslink number(10,0) not null,
hname char(40),
htype char(10),
classification char(50),
date_created char(8),
date_paved char(8),
surface_type char(50),
surface_rating number(10,0),
weight_limit number(10,0),
height_limit number(10,0),
speed_limit number(10,0),
width number(10,0),
row_width number(10,0),
length number(20,4),
num_of_lanes number(10,0),
division_status char(50),
direction char(50),
hour_traffic_vl number(10,0),
year_traffic_vl number(10,0),
city char(40),
county char(50),
state char(50),
mapid number(10,0)
);
grant all on highway to public;
create index highway_mslink on highway (mslink);
create table maps
(
mslink number(10,0) not null,
mapname char(14),
category number(10,0),
symtable char(19)
);
grant all on maps to public;
create index maps_mslink on maps (mslink);
create table features
(
mslink number(10,0) not null,
fcode char(12),
fname char(32),
category number(10,0),
tablename char(18),
ftype number(10,0),
flevel number(10,0),
fstyle number(10,0),
fweight number(10,0),
fcolor number(10,0),
digcmd char(20),
cellname char(20)
);
grant all on features to public;
create index features_mslink on features (mslink);
create table parcel_das
(
dastype integer,
formname char(64),
sqldas char(240)
);
grant all on parcel_das to public;