Field Report

bit

• contract (authors)

char

• phone (authors)
• state (authors)
• zip (authors)
• stor_id (discounts)
• minit (employee)
• pub_id (employee)
• pub_id (pub_info)
• pub_id (publishers)
• state (publishers)
• stor_id (sales)
• stor_id (stores)
• state (stores)
• zip (stores)
• type (titles)
• pub_id (titles)

datetime

• hire_date (employee)
• ord_date (sales)
• pubdate (titles)

decimal

• discount (discounts)

empid

• emp_id (employee)

id

• au_id (authors)
• au_id (titleauthor)

image

• logo (pub_info)

int

• lorange (roysched)
• hirange (roysched)
• royalty (roysched)
• royaltyper (titleauthor)
• royalty (titles)
• ytd_sales (titles)

money

• price (titles)
• advance (titles)

smallint

• lowqty (discounts)
• highqty (discounts)
• job_id (employee)
• job_id (jobs)
• qty (sales)

text

• pr_info (pub_info)

tid

• title_id (roysched)
• title_id (sales)
• title_id (titleauthor)
• title_id (titles)

tinyint

• job_lvl (employee)
• min_lvl (jobs)
• max_lvl (jobs)
• au_ord (titleauthor)

varchar

• au_lname (authors)
• au_fname (authors)
• address (authors)
• city (authors)
• discounttype (discounts)
• fname (employee)
• lname (employee)
• job_desc (jobs)
• pub_name (publishers)
• city (publishers)
• country (publishers)
• ord_num (sales)
• payterms (sales)
• stor_name (stores)
• stor_address (stores)
• city (stores)
• title (titles)
• notes (titles)