Tables in the pubs2 Database

In each of the tables in the pubs2 database, the column header specifies the column name, its datatype (including any user-defined datatypes), and its null or not null status. The column header also specifies any defaults, rules, triggers, and indexes that affect the column.

• publishers Table
  The publishers table contains the publisher name and ID, and the city and state in which each publisher is located.
• authors Table
  The authors table contains the name, telephone number, author ID, and other information about authors.
• titles Table
  The titles table contains the title id, title, type, publisher ID, price, and other information about titles.
• titleauthor Table
  the titleauthor table shows the author ID, title ID, and royalty of titles by percentage.
• salesdetail Table
  The salesdetail table shows the store ID, order ID, title number, quantity of sales, and discounts of sales.
• sales Table
  The sales table contains store IDs, order numbers, and dates of sales.
• stores Table
  The stores table contains the names, addresses, ID numbers, and payment terms for stores.
• roysched Table
  The roysched table contains royalties, defined as a percentage of price.
• discounts Table
  The discounts table contains discounts in stores.
• blurbs Table
  The blurbs table contains sample blurbs for books.
• au_pix Table
  The author_pix table contains photographs of authors in the pubs2 database.