Return to OracleDemo.dbmodela CVS log

Up to [NeXTSTEP 3.3 examples] / Examples / DatabaseKit / OracleDemo

Sample Programs from NeXSTEP 3.3

Adaptor = OracleAdaptor;
Login = "scott/tiger@T:localhost:ORACLE";
Entities = 
(
	(Bonus, BONUS, "", Y, 
		(
			(commission, COMM, "", N, d, "", "", "", N, N, N, N), 
			(employeeName, ENAME, "", N, "*", "", "", "", N, N, N, N), 
			(job, JOB, "", N, "*", "", "", "", N, N, N, N), 
			(salary, SAL, "", N, d, "", "", "", N, N, N, N))), 
	(Customer, CUSTOMER, "", N, 
		(
			(address, ADDRESS, "", N, "*", "", "", "", N, N, N, N), 
			(area, AREA, "", N, d, "", "", "", N, N, N, N), 
			(city, CITY, "", N, "*", "", "", "", N, N, N, N), 
			(creditLimit, CREDITLIMIT, "", N, d, "", "", "", N, N, N, N), 
			(customerID, CUSTID, "", N, i, "", "", "", N, N, Y, N), 
			(name, NAME, "", N, "*", "", "", "", N, N, N, N), 
			(phone, PHONE, "", N, "*", "", "", "", N, N, N, N), 
			(representativeID, REPID, "", N, i, "", "", "", N, N, N, N), 
			(state, STATE, "", N, "*", "", "", "", N, N, N, N), 
			(zipcode, ZIP, "", N, "*", "", "", "", N, N, N, N), 
			(orders, Relationship11, "", Y, N, N, N, N, N, N, Order, 
				(customerID), 
				(customerID)), 
			(representative, Relationship12, "", Y, Y, N, N, N, N, N, Employee, 
				(representativeID), 
				(empID)), 
			(purchases, Relationship13, "", Y, N, N, N, N, N, N, Sales, 
				(customerID), 
				(customerID)))), 
	(Department, DEPT, "", N, 
		(
			(deptNo, DEPTNO, "", N, i, "", "", "", N, N, Y, N), 
			(name, DNAME, "", N, "*", "", "", "", N, N, N, N), 
			(location, LOC, "", N, "*", "", "", "", N, N, N, N), 
			(employees, Relationship4, "", Y, N, N, N, N, N, N, Employee, 
				(deptNo), 
				(deptNo)))), 
	(Employee, EMP, "", N, 
		(
			(commission, COMM, "", N, d, "", "", "", N, N, N, N), 
			(deptNo, DEPTNO, "", N, i, "", "", "", N, N, N, N), 
			(empID, EMPNO, "", N, i, "", "", "", N, N, Y, N), 
			(name, ENAME, "", N, "*", "", "", "", N, N, N, N), 
			(hiredate, HIREDATE, "", N, "*", "", "", "", N, N, N, N), 
			(job, JOB, "", N, "*", "", "", "", N, N, N, N), 
			(managerID, MGR, "", N, d, "", "", "", N, N, N, N), 
			(salary, SAL, "", N, d, "", "", "", N, N, N, N), 
			(department, Relationship9, "", Y, Y, N, N, N, N, N, Department, 
				(deptNo), 
				(deptNo)), 
			(directReports, Relationship10, "", Y, N, N, N, N, N, N, Employee, 
				(empID), 
				(managerID)), 
			(manager, Relationship11, "", Y, Y, N, N, N, N, N, Employee, 
				(managerID), 
				(empID)), 
			(customers, Relationship12, "", Y, N, N, N, N, N, N, Customer, 
				(empID), 
				(representativeID)), 
			(sales, Relationship13, "", Y, N, N, N, N, N, N, Sales, 
				(empID), 
				(representativeID)))), 
	(LineItems, ITEM, "", Y, 
		(
			(actualPrice, ACTUALPRICE, "", N, d, "", "", "", N, N, N, N), 
			(lineNumber, ITEMID, "", N, i, "", "", "", N, N, Y, N), 
			(total, ITEMTOT, "", N, d, "", "", "", N, N, N, N), 
			(orderID, ORDID, "", N, i, "", "", "", N, N, Y, N), 
			(productID, PRODID, "", N, i, "", "", "", N, N, N, N), 
			(quantity, QTY, "", N, i, "", "", "", N, N, N, N), 
			(order, Relationship7, "", Y, Y, N, N, N, N, N, Order, 
				(orderID), 
				(orderID)), 
			(product, Relationship8, "", Y, Y, N, N, N, N, N, Product, 
				(productID), 
				(productID)))), 
	(Order, ORD, "", N, 
		(
			(commissionPlan, COMMPLAN, "", N, "*", "", "", "", N, N, N, N), 
			(customerID, CUSTID, "", N, i, "", "", "", N, N, N, N), 
			(orderDate, ORDERDATE, "", N, "*", "", "", "", N, N, N, N), 
			(orderID, ORDID, "", N, i, "", "", "", N, N, Y, N), 
			(shipDate, SHIPDATE, "", N, "*", "", "", "", N, N, N, N), 
			(total, TOTAL, "", N, d, "", "", "", N, N, N, N), 
			(customer, Relationship7, "", Y, Y, N, N, N, N, N, Customer, 
				(customerID), 
				(customerID)), 
			(lineItems, Relationship8, "", Y, N, N, N, N, N, N, LineItems, 
				(orderID), 
				(orderID)))), 
	(Price, PRICE, "", Y, 
		(
			(endDate, ENDDATE, "", N, "*", "", "", "", N, N, N, N), 
			(minPrice, MINPRICE, "", N, d, "", "", "", N, N, N, N), 
			(productID, PRODID, "", N, i, "", "", "", N, N, N, N), 
			(startDate, STARTDATE, "", N, "*", "", "", "", N, N, N, N), 
			(standardPrice, STDPRICE, "", N, d, "", "", "", N, N, N, N))), 
	(Product, PRODUCT, "", N, 
		(
			(description, DESCRIP, "", N, "*", "", "", "", N, N, N, N), 
			(productID, PRODID, "", N, i, "", "", "", N, N, Y, N), 
			(prices, Relationship3, "", Y, N, N, N, N, N, N, Price, 
				(productID), 
				(productID)), 
			(sales, Relationship4, "", Y, N, N, N, N, N, N, Sales, 
				(productID), 
				(productID)), 
			(orderLines, Relationship5, "", Y, N, N, N, N, N, N, LineItems, 
				(productID), 
				(productID)))), 
	(Sales, SALES, "", N, 
		(
			(amount, AMOUNT, "", N, d, "", "", "", N, N, N, N), 
			(customerID, CUSTID, "", N, i, "", "", "", N, N, Y, N), 
			(customerName, CUSTNAME, "", N, "*", "", "", "", N, N, N, N), 
			(productID, PRODID, "", N, i, "", "", "", N, N, Y, N), 
			(productName, PRODNAME, "", N, "*", "", "", "", N, N, N, N), 
			(representativeID, REPID, "", N, i, "", "", "", N, N, Y, N), 
			(representative, Relationship7, "", Y, Y, N, N, N, N, N, Employee, 
				(representativeID), 
				(empID)), 
			(product, Relationship8, "", Y, Y, N, N, N, N, N, Product, 
				(productID), 
				(productID)), 
			(customer, Relationship9, "", Y, Y, N, N, N, N, N, Customer, 
				(customerID), 
				(customerID)))), 
	(SalaryGrade, SALGRADE, "", Y, 
		(
			(grade, GRADE, "", N, i, "", "", "", N, N, Y, N), 
			(highSalary, HISAL, "", N, d, "", "", "", N, N, N, N), 
			(lowSalary, LOSAL, "", N, d, "", "", "", N, N, N, N))));
Version = 3.1;

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.