/*
--   $Id: resources.interbase,v 1.1 1999/06/10 22:44:13 billf Exp $
--
-- Table structure for table 'resources'
--
*/

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

CREATE INDEX resources_serno_idx ON resources (serno);
