CREATE TABLE DEPT
       (DEPTNO NUMBER( 2 ) CONSTRAINT PK_DEPT PRIMARY KEY,
	DNAME VARCHAR2( 14 ) ,
	LOC VARCHAR2( 13 ) ) ;

CREATE TABLE EMP
       (EMPNO NUMBER( 4 ) CONSTRAINT PK_EMP PRIMARY KEY,
	ENAME VARCHAR2( 10 ),
	JOB VARCHAR2( 9 ),
	MGR NUMBER( 4 ),
	HIREDATE DATE,
	SAL NUMBER( 7 , 2 ),
	COMM NUMBER( 7 , 2 ),
	DEPTNO NUMBER( 2 ) CONSTRAINT FK_DEPTNO REFERENCES DEPT);

.... дальше идут inserts.

Class User.dept Extends %Persistent
{

  Property deptno As %Numeric [ Required ];

  Index deptnoIndex On deptno [ Unique ];

  Property dname As %String;

  Property loc As %String;

}



Class User.emp Extends %Persistent
{

  Property empno As %Numeric [ Required ];

  Index empnoIndex On empno [ Unique ];

  Property ename As %String;

  Property job As %String;

  Property mgr As %Numeric;

  Property hiredate As %Date;

  Property sal As %Currency;

  Property deptno As %Numeric;


}

Class User.dept Extends %Persistent
{

Property dname As %String(MAXLEN =  14 );

Property loc As %String(MAXLEN =  13 );

Relationship emps As User.emp [ Cardinality = many, Inverse = dept ];

}

Class User.emp Extends %Persistent
{

Index deptIndex On dept;

ForeignKey FKdept(dept) References User.dept();

Property ename As %String(MAXLEN =  10 );

Property job As %String(MAXLEN =  9 );

Property mgr As %Numeric;

Property hiredate As %Date;

Property sal As %Currency;

Property comm As %Numeric;

Relationship dept As User.dept [ Cardinality = one, Inverse = emps ];

}