Primary keys are italicized:

authors (au_id, au_lname, au_fname, phone, address, city, state, zip)
  au_id: Author ID, domain ID (i.e. character - 11 bytes)
  au_lname: Last Name, domain character - 40 bytes
  au_fname: First Name, domain character - 40 bytes 
  phone: Phone #, domain character - 12 bytes 
  address: Address, domain character - 40 bytes
  city: City, domain character - 20 bytes 
  state: State, domain character - 2 bytes
  zip: Zip Code, domain character - 5 bytes


publishers (pub_id, pub_name, city, state)
  pub_id: Publisher ID, domain character - 4 bytes
  pub_name: Publisher Name, domain character - 40 bytes
  city: City, domain character - 20 bytes 
  state: State, domain character - 2 bytes


roysched (title_id, lorange, hirange, royalty)
  title_id: Title ID, domain TID (i.e. character - 6 bytes)
  lorange: Low Range, domain integer
  hirange: High Range, domain integer
  royalty: Royalty, domain integer


sales (stor_id, ord_num, date, qty, payterms, title_id)
  stor_id: Store ID, domain character - 4 bytes
  ord_num: Order #, domain character - 20 bytes
  date: Order date, domain datetime 
  qty: Quantity, domain integer 
  payterms: Payment terms, domain character - 12 bytes
  title_id: Title ID, domain TID (i.e. character - 6 bytes)


titleauthor (au_id, title_id, au_ord, royaltyper)
  au_id: Author ID, domain ID (i.e. character - 11 bytes)
  title_id: Title ID, domain TID (i.e. character - 6 bytes)
  au_ord: Order, domain integer 
  royaltyper: Royalty %, domain integer 


titles (title_id, title, type, pub_id, price, advance, royalty, ytd_sales, notes, pubdate)
  title_id: Title ID, domain TID (i.e. character - 6 bytes)
  title: Title, domain character - 80 bytes
  type: Type, domain character - 12 bytes 
  pub_id: Publishers ID, domain character - 4 bytes 
  price: Price, domain money 
  advance: Advance, domain money 
  royalty: Royalty, domain integer 
  ytd_sales: Year-to-date sales, domain integer
  notes: Notes, domain text
  pubdate: Publication date, domain datetime


stores (stor_id, stor_name, stor_address, city, state, zip)
  stor_id: Store ID, domain character - 4 bytes
  stor_name: Store name, domain character - 40 bytes 
  stor_address: Store address, domain character - 40 bytes
  city: City, domain character - 20 bytes 
  state: State, domain character - 2 bytes
  zip: Zip Code, domain character - 5 bytes


discount (discount_type, stor_id, lowqty, highqty, discount)
  discount_type: Discount type: domain character - 40 bytes
  stor_id: Title ID, domain character - 4 bytes
  lowqty: Low Range, domain integer
  highqty: High Range, domain integer
  discount: Royalty, domain float