-- Oracle Table Definition
--
-- RCS Revision
--   $Id: resources.oracle,v 1.1 1999/02/02 17:08:02 roberts Exp $
--

CREATE TABLE resources (
    tag varchar2(10) NOT NULL PRIMARY KEY,
    serno varchar2(25) NOT NULL,
    manuf varchar2(20),
    model varchar2(20),
    type char(2),
    parent varchar2(10),
    location varchar2(10),
    descrip varchar2(80)
);

CREATE INDEX resources_serno_idx ON resources (serno);
