Primary Keys

Oracle 7 primary key definitions generated from the OPM schema shown in section 3 are contained in file Example_primarykeys.ORA7:

ALTER TABLE CLASSES
    ADD CONSTRAINT pk_CLASSES_1__cid
    PRIMARY KEY ("_cid");

ALTER TABLE COURSE
    ADD CONSTRAINT pk_COURSE_2__oid
    PRIMARY KEY ("_oid");

ALTER TABLE COURSE_references
    ADD CONSTRAINT pk_COURSE_refe_3__aid
    PRIMARY KEY ("_aid");

ALTER TABLE DATABASES
    ADD CONSTRAINT pk_DATABASES_4__dbid
    PRIMARY KEY ("_dbid");

ALTER TABLE DEPARTMENT
    ADD CONSTRAINT pk_DEPARTMENT_5__oid
    PRIMARY KEY ("_oid");

ALTER TABLE DepartmentNames
    ADD CONSTRAINT pk_DepartmentN_6__code
    PRIMARY KEY ("_code");

ALTER TABLE FACULTY
    ADD CONSTRAINT pk_FACULTY_7__oid
    PRIMARY KEY ("_oid");

ALTER TABLE OBJECTS
    ADD CONSTRAINT pk_OBJECTS_8__oid
    PRIMARY KEY ("_oid");

ALTER TABLE PERSON
    ADD CONSTRAINT pk_PERSON_9__oid
    PRIMARY KEY ("_oid");

ALTER TABLE REFERENCE
    ADD CONSTRAINT pk_REFERENCE_10__oid
    PRIMARY KEY ("_oid");

ALTER TABLE STUDENT
    ADD CONSTRAINT pk_STUDENT_12__oid
    PRIMARY KEY ("_oid");

ALTER TABLE STUDENT_attends
    ADD CONSTRAINT pk_STUDENT_att_13__aid
    PRIMARY KEY ("_aid");

ALTER TABLE "_vCOURSE"
    ADD CONSTRAINT pk__vCOURSE_14__oid
    PRIMARY KEY ("_oid", "_version");

ALTER TABLE "_vFACULTY"
    ADD CONSTRAINT pk__vFACULTY_15__oid
    PRIMARY KEY ("_oid", "_version");

ALTER TABLE "_vSTUDENT"
    ADD CONSTRAINT pk__vSTUDENT_16__oid
    PRIMARY KEY ("_oid", "_version");