![[BACK]](/cvsweb/icons/back.gif){kind=icon}
Return to OracleDemo.dbmodela CVS log ![[TXT]](/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvsweb/icons/dir.gif){kind=icon}
Up to [NeXTSTEP 3.3 examples] / Examples / DatabaseKit / AssociationOracle|
Return to OracleDemo.dbmodela CVS log | Up to [NeXTSTEP 3.3 examples] / Examples / DatabaseKit / AssociationOracle |
1.1 root 1: Adaptor = OracleAdaptor;
2: Login = "scott/tiger@T:localhost:ORACLE";
3: Entities =
4: (
5: (Bonus, BONUS, "", Y,
6: (
7: (commission, COMM, "", N, d, "", "", "", N, N, N, N),
8: (employeeName, ENAME, "", N, "*", "", "", "", N, N, N, N),
9: (job, JOB, "", N, "*", "", "", "", N, N, N, N),
10: (salary, SAL, "", N, d, "", "", "", N, N, N, N))),
11: (Customer, CUSTOMER, "", N,
12: (
13: (address, ADDRESS, "", N, "*", "", "", "", N, N, N, N),
14: (area, AREA, "", N, d, "", "", "", N, N, N, N),
15: (city, CITY, "", N, "*", "", "", "", N, N, N, N),
16: (creditLimit, CREDITLIMIT, "", N, d, "", "", "", N, N, N, N),
17: (customerID, CUSTID, "", N, i, "", "", "", N, N, Y, N),
18: (name, NAME, "", N, "*", "", "", "", N, N, N, N),
19: (phone, PHONE, "", N, "*", "", "", "", N, N, N, N),
20: (representativeID, REPID, "", N, i, "", "", "", N, N, N, N),
21: (state, STATE, "", N, "*", "", "", "", N, N, N, N),
22: (zipcode, ZIP, "", N, "*", "", "", "", N, N, N, N),
23: (orders, Relationship11, "", Y, N, N, N, N, N, N, Order,
24: (customerID),
25: (customerID)),
26: (representative, Relationship12, "", Y, Y, N, N, N, N, N, Employee,
27: (representativeID),
28: (empID)),
29: (purchases, Relationship13, "", Y, N, N, N, N, N, N, Sales,
30: (customerID),
31: (customerID)))),
32: (Department, DEPT, "", N,
33: (
34: (deptNo, DEPTNO, "", N, i, "", "", "", N, N, Y, N),
35: (name, DNAME, "", N, "*", "", "", "", N, N, N, N),
36: (location, LOC, "", N, "*", "", "", "", N, N, N, N),
37: (employees, Relationship4, "", Y, N, N, N, N, N, N, Employee,
38: (deptNo),
39: (deptNo)))),
40: (Employee, EMP, "", N,
41: (
42: (commission, COMM, "", N, d, "", "", "", N, N, N, N),
43: (deptNo, DEPTNO, "", N, i, "", "", "", N, N, N, N),
44: (empID, EMPNO, "", N, i, "", "", "", N, N, Y, N),
45: (name, ENAME, "", N, "*", "", "", "", N, N, N, N),
46: (hiredate, HIREDATE, "", N, "*", "", "", "", N, N, N, N),
47: (job, JOB, "", N, "*", "", "", "", N, N, N, N),
48: (managerID, MGR, "", N, d, "", "", "", N, N, N, N),
49: (salary, SAL, "", N, d, "", "", "", N, N, N, N),
50: (department, Relationship9, "", Y, Y, N, N, N, N, N, Department,
51: (deptNo),
52: (deptNo)),
53: (directReports, Relationship10, "", Y, N, N, N, N, N, N, Employee,
54: (empID),
55: (managerID)),
56: (manager, Relationship11, "", Y, Y, N, N, N, N, N, Employee,
57: (managerID),
58: (empID)),
59: (customers, Relationship12, "", Y, N, N, N, N, N, N, Customer,
60: (empID),
61: (representativeID)),
62: (sales, Relationship13, "", Y, N, N, N, N, N, N, Sales,
63: (empID),
64: (representativeID)))),
65: (LineItems, ITEM, "", Y,
66: (
67: (actualPrice, ACTUALPRICE, "", N, d, "", "", "", N, N, N, N),
68: (lineNumber, ITEMID, "", N, i, "", "", "", N, N, Y, N),
69: (total, ITEMTOT, "", N, d, "", "", "", N, N, N, N),
70: (orderID, ORDID, "", N, i, "", "", "", N, N, Y, N),
71: (productID, PRODID, "", N, i, "", "", "", N, N, N, N),
72: (quantity, QTY, "", N, i, "", "", "", N, N, N, N),
73: (order, Relationship7, "", Y, Y, N, N, N, N, N, Order,
74: (orderID),
75: (orderID)),
76: (product, Relationship8, "", Y, Y, N, N, N, N, N, Product,
77: (productID),
78: (productID)))),
79: (Order, ORD, "", N,
80: (
81: (commissionPlan, COMMPLAN, "", N, "*", "", "", "", N, N, N, N),
82: (customerID, CUSTID, "", N, i, "", "", "", N, N, N, N),
83: (orderDate, ORDERDATE, "", N, "*", "", "", "", N, N, N, N),
84: (orderID, ORDID, "", N, i, "", "", "", N, N, Y, N),
85: (shipDate, SHIPDATE, "", N, "*", "", "", "", N, N, N, N),
86: (total, TOTAL, "", N, d, "", "", "", N, N, N, N),
87: (customer, Relationship7, "", Y, Y, N, N, N, N, N, Customer,
88: (customerID),
89: (customerID)),
90: (lineItems, Relationship8, "", Y, N, N, N, N, N, N, LineItems,
91: (orderID),
92: (orderID)))),
93: (Price, PRICE, "", Y,
94: (
95: (endDate, ENDDATE, "", N, "*", "", "", "", N, N, N, N),
96: (minPrice, MINPRICE, "", N, d, "", "", "", N, N, N, N),
97: (productID, PRODID, "", N, i, "", "", "", N, N, N, N),
98: (startDate, STARTDATE, "", N, "*", "", "", "", N, N, N, N),
99: (standardPrice, STDPRICE, "", N, d, "", "", "", N, N, N, N))),
100: (Product, PRODUCT, "", N,
101: (
102: (description, DESCRIP, "", N, "*", "", "", "", N, N, N, N),
103: (productID, PRODID, "", N, i, "", "", "", N, N, Y, N),
104: (prices, Relationship3, "", Y, N, N, N, N, N, N, Price,
105: (productID),
106: (productID)),
107: (sales, Relationship4, "", Y, N, N, N, N, N, N, Sales,
108: (productID),
109: (productID)),
110: (orderLines, Relationship5, "", Y, N, N, N, N, N, N, LineItems,
111: (productID),
112: (productID)))),
113: (Sales, SALES, "", N,
114: (
115: (amount, AMOUNT, "", N, d, "", "", "", N, N, N, N),
116: (customerID, CUSTID, "", N, i, "", "", "", N, N, Y, N),
117: (customerName, CUSTNAME, "", N, "*", "", "", "", N, N, N, N),
118: (productID, PRODID, "", N, i, "", "", "", N, N, Y, N),
119: (productName, PRODNAME, "", N, "*", "", "", "", N, N, N, N),
120: (representativeID, REPID, "", N, i, "", "", "", N, N, Y, N),
121: (representative, Relationship7, "", Y, Y, N, N, N, N, N, Employee,
122: (representativeID),
123: (empID)),
124: (product, Relationship8, "", Y, Y, N, N, N, N, N, Product,
125: (productID),
126: (productID)),
127: (customer, Relationship9, "", Y, Y, N, N, N, N, N, Customer,
128: (customerID),
129: (customerID)))),
130: (SalaryGrade, SALGRADE, "", Y,
131: (
132: (grade, GRADE, "", N, i, "", "", "", N, N, Y, N),
133: (highSalary, HISAL, "", N, d, "", "", "", N, N, N, N),
134: (lowSalary, LOSAL, "", N, d, "", "", "", N, N, N, N))));
135: Version = 3.1;
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.