WACS: Database Schemas

create table idmap
( identryno			number(7) primary key,
  imodelno		        number(6) references models,
  istatus			char(1),
  isite				varchar2(20) not null,
  ikey                          varchar2(30),
  ialtkey			varchar2(30),
  iname				varchar2(30),
  inotes			varchar2(80), 
  iactive			char(1),
  ichanged			date,
  ichecked			date,
  iadded			date,
  iamended			date
);