TABLE jobs pubs dbo
<> job_id smallint identity 2 5
<> job_desc varchar 50 12
<> min_lvl tinyint 1 -6
<> max_lvl tinyint 1 -6
// '1','New Hire - Job not specified','4444656','28500'  end
// '2','Chief Executive Officer','4444656','28500'  end
// '3','Business Operations Manager','4444656','28500'  end
// '4','Chief Financial Officier','4444656','28500'  end
// '5','Publisher','4444656','28500'  end
// '6','Managing Editor','4444656','28500'  end
// '7','Marketing Manager','4444656','28500'  end
// '8','Public Relations Manager','4444656','28500'  end
// '9','Acquisitions Manager','4444656','28500'  end
// '10','Productions Manager','4444656','28500'  end
// '11','Operations Manager','4444656','28500'  end
// '12','Editor','4444656','28500'  end
// '13','Sales Representative','4444656','28500'  end
// '14','Designer','4444656','28500'  end
TABLE authors pubs dbo
<> au_id id 11 12
<> au_lname varchar 40 12
<> au_fname varchar 20 12
<> phone char 12 1
<> address varchar 40 12
<> city varchar 20 12
<> state char 2 1
<> zip char 5 1
<> contract bit 1 -7
// '172-32-1176','NULL','Johnson','408 496-7223','10932 Bigge Rd.','Menlo Park','CA','94025','0'  end
// '213-46-8915','Green','Marjorie','415 986-7020','309 63rd St. #411','Oakland','CA','94618','0'  end
// '238-95-7766','Carson','Cheryl','415 548-7723','589 Darwin Ln.','Berkeley','CA','94705','0'  end
// '267-41-2394','O'Leary','Michael','408 286-2428','22 Cleveland Av. #14','San Jose','CA','95128','0'  end
// '274-80-9391','Straight','Dean','415 834-2919','5420 College Av.','Oakland','CA','94609','0'  end
// '341-22-1782','Smith','Meander','913 843-0462','10 Mississippi Dr.','Lawrence','KS','66044','0'  end
// '409-56-7008','Bennet','Abraham','415 658-9932','6223 Bateman St.','Berkeley','CA','94705','0'  end
// '427-17-2319','Dull','Ann','415 836-7128','3410 Blonde St.','Palo Alto','CA','94301','0'  end
// '472-27-2349','Gringlesby','Burt','707 938-6445','PO Box 792','Covelo','CA','95428','0'  end
// '486-29-1786','Locksley','Charlene','415 585-4620','18 Broadway Av.','San Francisco','CA','94130','0'  end
// '527-72-3246','Greene','Morningstar','615 297-2723','22 Graybar House Rd.','Nashville','TN','37215','0'  end
// '648-92-1872','Blotchet-Halls','Reginald','503 745-6402','55 Hillsdale Bl.','Corvallis','OR','97330','0'  end
// '672-71-3249','Yokomoto','Akiko','415 935-4228','3 Silver Ct.','Walnut Creek','CA','94595','0'  end
// '712-45-1867','del Castillo','Innes','615 996-8275','2286 Cram Pl. #86','Ann Arbor','MI','48105','0'  end
// '722-51-5454','DeFrance','Michel','219 547-9982','3 Balding Pl.','Gary','IN','46403','0'  end
// '724-08-9931','Stringer','Dirk','415 843-2991','5420 Telegraph Av.','Oakland','CA','94609','0'  end
// '724-80-9391','MacFeather','Stearns','415 354-7128','44 Upland Hts.','Oakland','CA','94612','0'  end
// '756-30-7391','Karsen','Livia','415 534-9219','5720 McAuley St.','Oakland','CA','94609','0'  end
// '807-91-6654','Panteley','Sylvia','301 946-8853','1956 Arlington Pl.','Rockville','MD','20853','0'  end
// '846-92-7186','Hunter','Sheryl','415 836-7128','3410 Blonde St.','Palo Alto','CA','94301','0'  end
// '893-72-1158','McBadden','Heather','707 448-4982','301 Putnam','Vacaville','CA','95688','0'  end
// '899-46-2035','Ringer','Anne','801 826-0752','67 Seventh Av.','Salt Lake City','UT','84152','0'  end
// '998-72-3567','Ringer','Albert','801 826-0752','67 Seventh Av.','Salt Lake City','UT','84152','0'  end
TABLE discounts pubs dbo
<> discounttype varchar 40 12
<> stor_id char 4 1
<> lowqty smallint 2 5
<> highqty smallint 2 5
<> discount decimal 6 3
// 'Customer Discount','8042','100','1000','5.00'  end
// 'Initial Customer','Ringer','27713','12344','10.50'  end
// 'Volume Discount','Ringer','100','1000','6.70'  end
TABLE employee pubs dbo
<> emp_id empid 9 1
<> fname varchar 20 12
<> minit char 1 1
<> lname varchar 30 12
<> job_id smallint 2 5
<> job_lvl tinyint 1 -6
<> pub_id char 4 1
<> hire_date datetime 16 93
// 'PMA42628M','Paolo','M','Accorti','13','4446216','0877','13368'  end
// 'PSA89086M','Pedro','S','Afonso','14','4446216','1389','13368'  end
// 'VPA30890F','Victoria','P','Ashworth','6','4446216','0877','13368'  end
// 'H-B39728F','Helen',' ','Bennett','12','4446216','0877','13368'  end
// 'L-B31947F','Lesley',' ','Brown','7','4446216','0877','13368'  end
// 'F-C16315M','Francisco',' ','Chang','4','4446216','9952','13368'  end
// 'PTC11962M','Philip','T','Cramer','2','4446216','9952','13368'  end
// 'A-C71970F','Aria',' ','Cruz','10','4446216','1389','13368'  end
// 'AMD15433F','Ann','M','Devon','3','4446216','9952','13368'  end
// 'ARD36773F','Anabela','R','Domingues','8','4446216','0877','13368'  end
// 'PHF38899M','Peter','H','Franken','10','4446216','0877','13368'  end
// 'PXH22250M','Paul','X','Henriot','5','4446216','0877','13368'  end
// 'CFH28514M','Carlos','F','Hernadez','5','4446216','9999','13368'  end
// 'PDI47470M','Palle','D','Ibsen','7','4446216','0736','13368'  end
// 'KJJ92907F','Karla','J','Jablonski','9','4446216','9999','13368'  end
// 'KFJ64308F','Karin','F','Josephs','14','4446216','0736','13368'  end
// 'MGK44605M','Matti','G','Karttunen','6','4446216','0736','13368'  end
// 'POK93028M','Pirkko','O','Koskitalo','10','4446216','9999','13368'  end
// 'JYL26161F','Janine','Y','Labrune','5','4446216','9901','13368'  end
// 'M-L67958F','Maria',' ','Larsson','7','4446216','1389','13368'  end
// 'Y-L77953M','Yoshi',' ','Latimer','12','4446216','1389','13368'  end
// 'LAL21447M','Laurence','A','Lebihan','5','4446216','0736','13368'  end
// 'ENL44273F','Elizabeth','N','Lincoln','14','4446216','0877','13368'  end
// 'PCM98509F','Patricia','C','McKenna','11','4446216','9999','13368'  end
// 'R-M53550M','Roland',' ','Mendel','11','4446216','0736','13368'  end
// 'RBM23061F','Rita','B','Muller','5','4446216','1622','13368'  end
// 'HAN90777M','Helvetius','A','Nagy','7','4446216','9999','13368'  end
// 'TPO55093M','Timothy','P','O'Rourke','13','4446216','0736','13368'  end
// 'SKO22412M','Sven','K','Ottlieb','5','4446216','1389','13368'  end
// 'MAP77183M','Miguel','A','Paolino','11','4446216','1389','13368'  end
// 'PSP68661F','Paula','S','Parente','8','4446216','1389','13368'  end
// 'M-P91209M','Manuel',' ','Pereira','8','4446216','9999','13368'  end
// 'MJP25939M','Maria','J','Pontes','5','4446216','1756','13368'  end
// 'M-R38834F','Martine',' ','Rance','9','4446216','0877','13368'  end
// 'DWR65030M','Diego','W','Roel','6','4446216','1389','13368'  end
// 'A-R89858F','Annette',' ','Roulet','6','4446216','9999','13368'  end
// 'MMS49649F','Mary','M','Saveley','8','4446216','0736','13368'  end
// 'CGS88322F','Carine','G','Schmitt','13','4446216','1389','13368'  end
// 'MAS70474F','Margaret','A','Smith','9','4446216','1389','13368'  end
// 'HAS54740M','Howard','A','Snyder','12','4446216','0736','13368'  end
// 'MFS52347M','Martin','F','Sommer','10','4446216','0736','13368'  end
// 'GHT50241M','Gary','H','Thomas','9','4446216','0736','13368'  end
// 'DBT39435M','Daniel','B','Tonini','11','4446216','0877','13368'  end
TABLE pub_info pubs dbo
<> pub_id char 4 1
<> logo image 2147483647 -4
<> pr_info text 2147483647 -1
TABLE publishers pubs dbo
<> pub_id char 4 1
<> pub_name varchar 40 12
<> city varchar 20 12
<> state char 2 1
<> country varchar 30 12
// '0736','New Moon Books','Boston','MA','USA'  end
// '0877','Binnet & Hardley','Washington','DC','USA'  end
// '1389','Algodata Infosystems','Berkeley','CA','USA'  end
// '1622','Five Lakes Publishing','Chicago','IL','USA'  end
// '1756','Ramona Publishers','Dallas','TX','USA'  end
// '9901','GGG&G','M黱chen','TX','Germany'  end
// '9952','Scootney Books','New York','NY','USA'  end
// '9999','Lucerne Publishing','Paris','NY','France'  end
TABLE roysched pubs dbo
<> title_id tid 6 12
<> lorange int 4 4
<> hirange int 4 4
<> royalty int 4 4
// 'BU1032','0','5000','10'  end
// 'BU1032','5001','50000','12'  end
// 'PC1035','0','2000','10'  end
// 'PC1035','2001','3000','12'  end
// 'PC1035','3001','4000','14'  end
// 'PC1035','4001','10000','16'  end
// 'PC1035','10001','50000','18'  end
// 'BU2075','0','1000','10'  end
// 'BU2075','1001','3000','12'  end
// 'BU2075','3001','5000','14'  end
// 'BU2075','5001','7000','16'  end
// 'BU2075','7001','10000','18'  end
// 'BU2075','10001','12000','20'  end
// 'BU2075','12001','14000','22'  end
// 'BU2075','14001','50000','24'  end
// 'PS2091','0','1000','10'  end
// 'PS2091','1001','5000','12'  end
// 'PS2091','5001','10000','14'  end
// 'PS2091','10001','50000','16'  end
// 'PS2106','0','2000','10'  end
// 'PS2106','2001','5000','12'  end
// 'PS2106','5001','10000','14'  end
// 'PS2106','10001','50000','16'  end
// 'MC3021','0','1000','10'  end
// 'MC3021','1001','2000','12'  end
// 'MC3021','2001','4000','14'  end