Primary and Foreign Keys

Sybase 11 primary key and foreign key definitions generated from the OPM schema shown in section 3 are contained in file Example_spkeys.SYB11:

use Example
go
sp_primarykey CLASSES, _cid
go
sp_primarykey COURSE, _oid
go
sp_primarykey COURSE_references, _aid
go
sp_primarykey DATABASES, _dbid
go
sp_primarykey DEPARTMENT, _oid
go
sp_primarykey DepartmentNames, _code
go
sp_primarykey FACULTY, _oid
go
sp_primarykey OBJECTS, _oid
go
sp_primarykey PERSON, _oid
go
sp_primarykey REFERENCE, _oid
go
sp_primarykey STUDENT, _oid
go
sp_primarykey STUDENT_attends, _aid
go
sp_primarykey _vCOURSE, _oid, _version
go
sp_primarykey _vFACULTY, _oid, _version
go
sp_primarykey _vSTUDENT, _oid, _version
go
sp_foreignkey CLASSES, DATABASES, _dbid
go
sp_foreignkey COURSE, OBJECTS, _oid
go
sp_foreignkey COURSE, _vCOURSE, _oid, _defaultVersion
go
sp_foreignkey COURSE_references, _vCOURSE, _oid, _version
go
sp_foreignkey COURSE_references, REFERENCE, references
go
sp_foreignkey DEPARTMENT, OBJECTS, _oid
go
sp_foreignkey DEPARTMENT, DepartmentNames, name
go
sp_foreignkey FACULTY, PERSON, _oid
go
sp_foreignkey FACULTY, _vFACULTY, _oid, _defaultVersion
go
sp_foreignkey FACULTY, DEPARTMENT, department
go
sp_foreignkey PERSON, OBJECTS, _oid
go
sp_foreignkey REFERENCE, OBJECTS, _oid
go
sp_foreignkey SCLASSES, CLASSES, _class
go
sp_foreignkey SCLASSES, CLASSES, _subclass
go
sp_foreignkey STUDENT, PERSON, _oid
go
sp_foreignkey STUDENT, _vSTUDENT, _oid, _defaultVersion
go
sp_foreignkey STUDENT_attends, _vSTUDENT, _oid, _version
go
sp_foreignkey STUDENT_attends, _vCOURSE, course, _vcourse
go
sp_foreignkey STUDENT_attends, DEPARTMENT, inDepartment
go
sp_foreignkey _vCOURSE, COURSE, _oid
go
sp_foreignkey _vFACULTY, FACULTY, _oid
go
sp_foreignkey _vSTUDENT, STUDENT, _oid
quit