|
|
1.1 root 1: Adaptor = SybaseAdaptor;
2: Login = "sa@SYBASE/pubs";
3: Entities =
4: (
5: (Author, authors, "", N,
6: (
7: (address, address, "", N, "*", "", "", "", N, N, N, N),
8: (firstName, au_fname, "", N, "*", "", "", "", N, N, N, N),
9: (authorID, au_id, "", N, "*", "", "", "", N, N, Y, N),
10: (lastName, au_lname, "", N, "*", "", "", "", N, N, N, N),
11: (city, city, "", N, "*", "", "", "", N, N, N, N),
12: (contract, contract, "", N, i, "", "", "", N, N, N, N),
13: (phone, phone, "", N, "*", "", "", "", N, N, N, N),
14: (state, state, "", N, "*", "", "", "", N, N, N, N),
15: (zipCode, zip, "", N, "*", "", "", "", N, N, N, N),
16: (titles, Relationship1, "", Y, Y, N, N, N, N, N, TitleAuthor,
17: (authorID),
18: (authorID)))),
19: (Discount, discounts, "", N,
20: (
21: (discountAmount, discount, "", N, d, "", "", "", N, N, N, N),
22: (discountType, discounttype, "", N, "*", "", "", "", N, N, N, N),
23: (highQuantity, highqty, "", N, i, "", "", "", N, N, N, N),
24: (lowQuantity, lowqty, "", N, i, "", "", "", N, N, N, N),
25: (storeID, stor_id, "", N, "*", "", "", "", N, N, N, N),
26: (store, Relationship9, "", Y, Y, N, N, N, N, N, Store,
27: (storeID),
28: (storeID)))),
29: (Publisher, publishers, "", N,
30: (
31: (city, city, "", N, "*", "", "", "", N, N, N, N),
32: (publisherID, pub_id, "", N, "*", "", "", "", N, N, Y, N),
33: (name, pub_name, "", N, "*", "", "", "", N, N, N, N),
34: (state, state, "", N, "*", "", "", "", N, N, N, N),
35: (titles, Relationship12, "", Y, N, N, N, N, N, N, Title,
36: (publisherID),
37: (publisherID)))),
38: (RoyaltySchedule, roysched, "", N,
39: (
40: (highRange, hirange, "", N, i, "", "", "", N, N, N, N),
41: (lowRange, lorange, "", N, i, "", "", "", N, N, N, N),
42: (royalty, royalty, "", N, i, "", "", "", N, N, Y, N),
43: (titleID, title_id, "", N, "*", "", "", "", N, N, Y, N),
44: (title, Relationship7, "", Y, Y, N, N, N, N, N, Title,
45: (titleID),
46: (titleID)))),
47: (Sale, sales, "", N,
48: (
49: (date, date, "", N, "*", "", "", "", N, N, N, N),
50: (orderNumber, ord_num, "", N, "*", "", "", "", N, N, Y, N),
51: (paymentTerms, payterms, "", N, "*", "", "", "", N, N, N, N),
52: (quantity, qty, "", N, i, "", "", "", N, N, N, N),
53: (storeID, stor_id, "", N, "*", "", "", "", N, N, N, N),
54: (titleID, title_id, "", N, "*", "", "", "", N, N, Y, N),
55: (title, Relationship1, "", Y, Y, N, N, N, N, N, Title,
56: (titleID),
57: (titleID)),
58: (store, Relationship4, "", Y, Y, N, N, Y, N, N, Store,
59: (storeID),
60: (storeID)))),
61: (Store, stores, "", N,
62: (
63: (city, city, "", N, "*", "", "", "", N, N, N, N),
64: (state, state, "", N, "*", "", "", "", N, N, N, N),
65: (address, stor_address, "", N, "*", "", "", "", N, N, N, N),
66: (storeID, stor_id, "", N, "*", "", "", "", N, N, Y, N),
67: (name, stor_name, "", N, "*", "", "", "", N, N, N, N),
68: (zip, zip, "", N, "*", "", "", "", N, N, N, N),
69: (sales, Relationship5, "", Y, N, N, N, Y, N, N, Sale,
70: (storeID),
71: (storeID)),
72: (discounts, Relationship10, "", Y, N, N, N, N, N, N, Discount,
73: (storeID),
74: (storeID)))),
75: (TitleAuthor, titleauthor, "", Y,
76: (
77: (authorID, au_id, "", N, "*", "", "", "", N, N, Y, Y),
78: (authorOrder, au_ord, "", N, i, "", "", "", N, N, N, N),
79: (royaltyPer, royaltyper, "", N, i, "", "", "", N, N, N, N),
80: (titleID, title_id, "", N, "*", "", "", "", N, N, Y, Y),
81: (author, Relationship2, "", Y, Y, N, N, Y, N, N, Author,
82: (authorID),
83: (authorID)),
84: (title, Relationship3, "", Y, Y, N, N, Y, N, N, Title,
85: (titleID),
86: (titleID)))),
87: (Title, titles, "", N,
88: (
89: (advance, advance, "", N, "*", "", "", "", N, N, N, N),
90: (notes, notes, "", N, "*", "", "", "", N, N, N, N),
91: (price, price, "", N, "*", "", "", "", N, N, N, N),
92: (publisherID, pub_id, "", N, "*", "", "", "", N, N, N, N),
93: (publicationDate, pubdate, "", N, "*", "", "", "", N, N, N, N),
94: (actualRoyalty, royalty, "", N, i, "", "", "", N, N, N, N),
95: (name, title, "", N, "*", "", "", "", N, N, N, N),
96: (titleID, title_id, "", N, "*", "", "", "", N, N, Y, N),
97: (type, type, "", N, "*", "", "", "", N, N, N, N),
98: (yearToDateSales, ytd_sales, "", N, i, "", "", "", N, N, N, N),
99: (authors, Relationship1, "", Y, N, N, N, N, N, N, TitleAuthor,
100: (titleID),
101: (titleID)),
102: (sales, Relationship6, "", Y, N, N, N, Y, N, N, Sale,
103: (titleID),
104: (titleID)),
105: (publisher, Relationship8, "", Y, Y, N, N, Y, N, Y, "",
106: (publisherID),
107: ()),
108: (possibleRoyalties, Relationship11, "", Y, N, N, N, Y, N, N, RoyaltySchedule,
109: (titleID),
110: (titleID)))),
111: (TitleView, titleview, "", N,
112: (
113: (authorLastName, au_lname, "", N, "*", "", "", "", N, N, N, N),
114: (authorOrder, au_ord, "", N, i, "", "", "", N, N, N, N),
115: (price, price, "", N, "*", "", "", "", N, N, N, N),
116: (publisherID, pub_id, "", N, "*", "", "", "", N, N, N, N),
117: (title, title, "", N, "*", "", "", "", N, N, N, N),
118: (yearToDateSales, ytd_sales, "", N, i, "", "", "", N, N, N, N))));
119: Version = 3.1;
This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.