Tables in the pubs3 Database

In each of the tables in the pubs3 database, the column header specifies the column name, its datatype (including any user-defined datatypes), its null or not null status, and how it uses referential integrity.

The column header also specifies any defaults, rules, triggers, and indexes that affect the column.

• publishers Table
  The publishers table contains the publisher ID, and name, city, and state.
• authors Table
  The authors table contains the names, phone numbers, and other information about authors.
• titles Table
  The titles table contains the name, title ID, type, and other information about titles.
• titleauthor Table
  The titleauthor table contains the title and author IDs, royalty percentages, and other information about titles and authors.
• salesdetail Table
  The salesdetail table contains the store ID, order number, and other details of sales.
• sales Table
  The sales table contains the store ID, order numbers, and dates of sales.
• stores Table
  The stores table contains the store ID, store name, and other information about stores.
• store_employees Table
  The store_employees table contains the store, employer, and manager IDs, and other information about store employees.
• roysched Table
  The roysched table contains title ID, royalty percentage, and other information about title royalties.
• discounts Table
  The discount table contains the discount type, store ID, quantity, and percentage discount.
• blurbs Table
  The blurbs table contains the author ID and blurb for books in the pubs3 database.