Pubs schema
Tables and views
Explore the native recordsets with their real names, schema, relationships, row counts, and direct downloads.
table authors Authors represented in the Pubs title catalogue. 9 columns · 0 links · 23 rows · 1 matches in other samples table discounts Initial, volume, and store-specific sales discounts. 5 columns · 1 links · 3 rows · 1 matches in other samples table employee Employees, their job levels, hire dates, and publisher assignments. 8 columns · 2 links · 43 rows · 2 matches in other samples table jobs Job titles and the permitted employee job-level range. 4 columns · 0 links · 14 rows · 1 matches in other samples table pub_info Publisher descriptions and the original GIF logos stored as BLOBs. 3 columns · 1 links · 8 rows · 1 matches in other samples table publishers Publishing organizations, contact details, and locations. 5 columns · 0 links · 8 rows · 3 matches in other samples table roysched Royalty percentages for title sales across sales-range bands. 4 columns · 1 links · 86 rows · 1 matches in other samples table sales Recorded sales by store, order number, date, title, quantity, and payment terms. 6 columns · 2 links · 21 rows · 2 matches in other samples table stores Retail stores that sell Pubs publications. 6 columns · 0 links · 6 rows · 2 matches in other samples table titleauthor Links authors to publications and records author order and royalty percentage. 4 columns · 2 links · 25 rows · 2 matches in other samples table titles Books and other publications with catalogue details and list prices. 10 columns · 1 links · 18 rows · 4 matches in other samples view titleview 6 columns · 0 links · 25 rows
Relationship map