*  ----------  Access 2.0 SQL Schema  -----------    *

*           RELATIONS FOR OEs  *

CREATE TABLE OE_mr_ID (mr_ID INTEGER4);

CREATE INDEX OE_mr_IDNDX ON OE_mr_ID (mr_ID) WITH PRIMARY;

CREATE TABLE OE_hw_ID (hw_ID INTEGER4);

CREATE INDEX OE_hw_IDNDX ON OE_hw_ID (hw_ID) WITH PRIMARY;

CREATE TABLE OE_date (date DATE);

CREATE INDEX OE_dateNDX ON OE_date (date) WITH PRIMARY;

CREATE TABLE OE_major (major INTEGER2);

CREATE INDEX OE_majorNDX ON OE_major (major) WITH PRIMARY;

CREATE TABLE OE_minor (minor INTEGER2);

CREATE INDEX OE_minorNDX ON OE_minor (minor) WITH PRIMARY;

CREATE TABLE OE_name (name TEXT(96));

CREATE INDEX OE_nameNDX ON OE_name (name) WITH PRIMARY;

CREATE TABLE OE_release (release TEXT(16));

CREATE INDEX OE_releaseNDX ON OE_release (release) WITH PRIMARY;

CREATE TABLE OE_description (description TEXT(96));

CREATE INDEX OE_descriptionNDX ON OE_description (description) WITH PRIMARY;

CREATE TABLE OE_url (url TEXT(96));

CREATE INDEX OE_urlNDX ON OE_url (url) WITH PRIMARY;

CREATE TABLE OE_bus (bus TEXT(16));

CREATE INDEX OE_busNDX ON OE_bus (bus) WITH PRIMARY;

CREATE TABLE OE_cache (cache INTEGER4);

CREATE INDEX OE_cacheNDX ON OE_cache (cache) WITH PRIMARY;

CREATE TABLE OE_capacity (capacity INTEGER4);

CREATE INDEX OE_capacityNDX ON OE_capacity (capacity) WITH PRIMARY;

CREATE TABLE OE_chipset (chipset TEXT(16));

CREATE INDEX OE_chipsetNDX ON OE_chipset (chipset) WITH PRIMARY;

CREATE TABLE OE_clock (clock DOUBLE);

CREATE INDEX OE_clockNDX ON OE_clock (clock) WITH PRIMARY;

CREATE TABLE OE_depth (depth INTEGER4);

CREATE INDEX OE_depthNDX ON OE_depth (depth) WITH PRIMARY;

CREATE TABLE OE_note (note TEXT(96));

CREATE INDEX OE_noteNDX ON OE_note (note) WITH PRIMARY;

CREATE TABLE OE_refresh (refresh INTEGER4);

CREATE INDEX OE_refreshNDX ON OE_refresh (refresh) WITH PRIMARY;

CREATE TABLE OE_resolution (resolution INTEGER4);

CREATE INDEX OE_resolutionNDX ON OE_resolution (resolution) WITH PRIMARY;

CREATE TABLE OE_setting (setting TEXT(16));

CREATE INDEX OE_settingNDX ON OE_setting (setting) WITH PRIMARY;

CREATE TABLE OE_category (category TEXT(16));

CREATE INDEX OE_categoryNDX ON OE_category (category) WITH PRIMARY;

CREATE TABLE results (rs_ID INTEGER4,
 iteration INTEGER4,
 note TEXT(96) CONSTRAINT REF1 REFERENCES OE_note(note),
 result DOUBLE,
 date DATE CONSTRAINT REF2 REFERENCES OE_date(date),
 item_ID INTEGER4);

CREATE INDEX resultsNDX ON results (rs_ID) WITH PRIMARY;

CREATE TABLE OE_uut_ID (uut_ID INTEGER4,
 description TEXT(96) CONSTRAINT REF3 REFERENCES OE_description(description),
 model TEXT(32),
 name TEXT(96) CONSTRAINT REF4 REFERENCES OE_name(name),
 type TEXT(16));

CREATE INDEX OE_uut_IDNDX ON OE_uut_ID (uut_ID) WITH PRIMARY;

CREATE TABLE CONTACT (cn_ID INTEGER4,
 date DATE CONSTRAINT REF5 REFERENCES OE_date(date),
 description TEXT(96) CONSTRAINT REF6 REFERENCES OE_description(description),
 email TEXT(6),
 name TEXT(96) CONSTRAINT REF7 REFERENCES OE_name(name),
 postal TEXT(96),
 type TEXT(16),
 url TEXT(96) CONSTRAINT REF8 REFERENCES OE_url(url));

CREATE INDEX CONTACTNDX ON CONTACT (cn_ID) WITH PRIMARY;

CREATE TABLE OE_iq_ID (iq_ID INTEGER4,
 cn_ID INTEGER4 CONSTRAINT REF9 REFERENCES CONTACT(cn_ID));

CREATE INDEX OE_iq_IDNDX ON OE_iq_ID (iq_ID) WITH PRIMARY;

CREATE TABLE operator (ad_ID INTEGER4,
 cn_ID INTEGER4 CONSTRAINT REF10 REFERENCES CONTACT(cn_ID));

CREATE INDEX operatorNDX ON operator (ad_ID) WITH PRIMARY;

CREATE TABLE OE_ts_ID (ts_ID INTEGER4,
 cn_ID INTEGER4 CONSTRAINT REF11 REFERENCES CONTACT(cn_ID));

CREATE INDEX OE_ts_IDNDX ON OE_ts_ID (ts_ID) WITH PRIMARY;