Return to SybaseDemo.dbmodela CVS log

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

Sample Programs from NeXSTEP 3.3

Adaptor = SybaseAdaptor;
Login = "sa@SYBASE/pubs";
Entities = 
(
	(Author, authors, "", N, 
		(
			(address, address, "", N, "*", "", "", "", N, N, N, N), 
			(firstName, au_fname, "", N, "*", "", "", "", N, N, N, N), 
			(authorID, au_id, "", N, "*", "", "", "", N, N, Y, N), 
			(lastName, au_lname, "", N, "*", "", "", "", N, N, N, N), 
			(city, city, "", N, "*", "", "", "", N, N, N, N), 
			(contract, contract, "", N, i, "", "", "", N, N, N, N), 
			(phone, phone, "", N, "*", "", "", "", N, N, N, N), 
			(state, state, "", N, "*", "", "", "", N, N, N, N), 
			(zipCode, zip, "", N, "*", "", "", "", N, N, N, N), 
			(titles, Relationship1, "", Y, Y, N, N, N, N, N, TitleAuthor, 
				(authorID), 
				(authorID)))), 
	(Discount, discounts, "", N, 
		(
			(discountAmount, discount, "", N, d, "", "", "", N, N, N, N), 
			(discountType, discounttype, "", N, "*", "", "", "", N, N, N, N), 
			(highQuantity, highqty, "", N, i, "", "", "", N, N, N, N), 
			(lowQuantity, lowqty, "", N, i, "", "", "", N, N, N, N), 
			(storeID, stor_id, "", N, "*", "", "", "", N, N, N, N), 
			(store, Relationship9, "", Y, Y, N, N, N, N, N, Store, 
				(storeID), 
				(storeID)))), 
	(Publisher, publishers, "", N, 
		(
			(city, city, "", N, "*", "", "", "", N, N, N, N), 
			(publisherID, pub_id, "", N, "*", "", "", "", N, N, Y, N), 
			(name, pub_name, "", N, "*", "", "", "", N, N, N, N), 
			(state, state, "", N, "*", "", "", "", N, N, N, N), 
			(titles, Relationship12, "", Y, N, N, N, N, N, N, Title, 
				(publisherID), 
				(publisherID)))), 
	(RoyaltySchedule, roysched, "", N, 
		(
			(highRange, hirange, "", N, i, "", "", "", N, N, N, N), 
			(lowRange, lorange, "", N, i, "", "", "", N, N, N, N), 
			(royalty, royalty, "", N, i, "", "", "", N, N, Y, N), 
			(titleID, title_id, "", N, "*", "", "", "", N, N, Y, N), 
			(title, Relationship7, "", Y, Y, N, N, N, N, N, Title, 
				(titleID), 
				(titleID)))), 
	(Sale, sales, "", N, 
		(
			(date, date, "", N, "*", "", "", "", N, N, N, N), 
			(orderNumber, ord_num, "", N, "*", "", "", "", N, N, Y, N), 
			(paymentTerms, payterms, "", N, "*", "", "", "", N, N, N, N), 
			(quantity, qty, "", N, i, "", "", "", N, N, N, N), 
			(storeID, stor_id, "", N, "*", "", "", "", N, N, N, N), 
			(titleID, title_id, "", N, "*", "", "", "", N, N, Y, N), 
			(title, Relationship1, "", Y, Y, N, N, N, N, N, Title, 
				(titleID), 
				(titleID)), 
			(store, Relationship4, "", Y, Y, N, N, Y, N, N, Store, 
				(storeID), 
				(storeID)))), 
	(Store, stores, "", N, 
		(
			(city, city, "", N, "*", "", "", "", N, N, N, N), 
			(state, state, "", N, "*", "", "", "", N, N, N, N), 
			(address, stor_address, "", N, "*", "", "", "", N, N, N, N), 
			(storeID, stor_id, "", N, "*", "", "", "", N, N, Y, N), 
			(name, stor_name, "", N, "*", "", "", "", N, N, N, N), 
			(zip, zip, "", N, "*", "", "", "", N, N, N, N), 
			(sales, Relationship5, "", Y, N, N, N, Y, N, N, Sale, 
				(storeID), 
				(storeID)), 
			(discounts, Relationship10, "", Y, N, N, N, N, N, N, Discount, 
				(storeID), 
				(storeID)))), 
	(TitleAuthor, titleauthor, "", Y, 
		(
			(authorID, au_id, "", N, "*", "", "", "", N, N, Y, Y), 
			(authorOrder, au_ord, "", N, i, "", "", "", N, N, N, N), 
			(royaltyPer, royaltyper, "", N, i, "", "", "", N, N, N, N), 
			(titleID, title_id, "", N, "*", "", "", "", N, N, Y, Y), 
			(author, Relationship2, "", Y, Y, N, N, Y, N, N, Author, 
				(authorID), 
				(authorID)), 
			(title, Relationship3, "", Y, Y, N, N, Y, N, N, Title, 
				(titleID), 
				(titleID)))), 
	(Title, titles, "", N, 
		(
			(advance, advance, "", N, "*", "", "", "", N, N, N, N), 
			(notes, notes, "", N, "*", "", "", "", N, N, N, N), 
			(price, price, "", N, "*", "", "", "", N, N, N, N), 
			(publisherID, pub_id, "", N, "*", "", "", "", N, N, N, N), 
			(publicationDate, pubdate, "", N, "*", "", "", "", N, N, N, N), 
			(actualRoyalty, royalty, "", N, i, "", "", "", N, N, N, N), 
			(name, title, "", N, "*", "", "", "", N, N, N, N), 
			(titleID, title_id, "", N, "*", "", "", "", N, N, Y, N), 
			(type, type, "", N, "*", "", "", "", N, N, N, N), 
			(yearToDateSales, ytd_sales, "", N, i, "", "", "", N, N, N, N), 
			(authors, Relationship1, "", Y, N, N, N, N, N, N, TitleAuthor, 
				(titleID), 
				(titleID)), 
			(sales, Relationship6, "", Y, N, N, N, Y, N, N, Sale, 
				(titleID), 
				(titleID)), 
			(publisher, Relationship8, "", Y, Y, N, N, Y, N, Y, "", 
				(publisherID), 
				()), 
			(possibleRoyalties, Relationship11, "", Y, N, N, N, Y, N, N, RoyaltySchedule, 
				(titleID), 
				(titleID)))), 
	(TitleView, titleview, "", N, 
		(
			(authorLastName, au_lname, "", N, "*", "", "", "", N, N, N, N), 
			(authorOrder, au_ord, "", N, i, "", "", "", N, N, N, N), 
			(price, price, "", N, "*", "", "", "", N, N, N, N), 
			(publisherID, pub_id, "", N, "*", "", "", "", N, N, N, N), 
			(title, title, "", N, "*", "", "", "", N, N, N, N), 
			(yearToDateSales, ytd_sales, "", N, i, "", "", "", 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.