111

Tables (12)

Animal Sale (Untitled2)

  • Animal Sale ID (Key) — Primary key — NOT NULL
  • Sales No (Key2) — Foreign key → SALES.Sales No — NOT NULL
  • Employee ID (Key22) — Foreign key → SALES.Employee ID — NOT NULL
  • Customer ID (Key3) — Foreign key → SALES.Customer ID — NOT NULL
  • Name (Field2)
  • Category (Field3)
  • Breed (Field4)
  • DoB (Field5)
  • Gender (Field6)
  • Registration (Field7)
  • Color (Field8)
  • ListPrice (Field9)
  • SalePrice (Field10)
  • Animal SubTotal (Field11)

Branch (Untitled6)

  • branch_num (Key) — Primary key — NOT NULL
  • staff_num (Key2) — Foreign key → Staff.staff_num — NOT NULL
  • street (Field)
  • city (Field2)
  • state (Field3)
  • zip code (Field4)
  • tel (Field5)

Catalog (Untitled9)

  • Catalog_num (Key) — Primary key — NOT NULL
  • category (Field)

Customer (Untitled4)

  • Customer ID (Key) — Primary key — NOT NULL
  • Name (Field2)
  • Address (Field3)
  • City, state, postcode (Field4)

Customer (Untitled12)

  • customer_num (Key) — Primary key — NOT NULL
  • rental_num (Key2) — Foreign key → Rental_history.rental_num — NOT NULL
  • first name (Field)
  • last name (Field2)
  • address (Field3)
  • registed_date (Field4)
  • cnt_rented (Field5)

Employee (Untitled5)

  • Employee ID (Key) — Primary key — NOT NULL
  • Name (Field2)
  • Sales No (Field)

Merchandise Sale (Untitled3)

  • Merchandise Sale ID (Key) — Primary key — NOT NULL
  • Sales No (Key2) — Foreign key → SALES.Sales No — NOT NULL
  • Employee ID (Key22) — Foreign key → SALES.Employee ID — NOT NULL
  • Customer ID (Key3) — Foreign key → SALES.Customer ID — NOT NULL
  • Item (Field)
  • Description (Field2)
  • Category (Field3)
  • ListPrice (Field4)
  • SalePrice (Field5)
  • QuantitySold (Field6)
  • TotltemSalePrice (Field7)

Movie (Untitled8)

  • movie_num (Key) — Primary key — NOT NULL
  • Catalog_num (Key2) — Foreign key → Catalog.Catalog_num — NOT NULL
  • title (Field)
  • catalog_num (Field2)
  • actors (Field3)

Rental_history (Untitled11)

  • rental_num (Key) — Primary key — NOT NULL
  • video_num (Field)
  • customer_num (Field2)
  • rented_date (Field3)
  • returned_date (Field4)

SALES (Untitled)

  • Sales No (Key) — Primary key — NOT NULL
  • Employee ID (Key2) — Foreign key → Employee.Employee ID — NOT NULL
  • Customer ID (Key3) — Foreign key → Customer.Customer ID — NOT NULL
  • Date (Field2)
  • Merchandise SubTotal (Field3)
  • SubTotal (Field4)
  • Tax (Field5)
  • Total (Field6)

Staff (Untitled7)

  • staff_num (Key) — Primary key — NOT NULL
  • name (Field)
  • position (Field2)
  • salary (Field3)
  • branch (Field4)

Video (Untitled10)

  • video_num (Key) — Primary key — NOT NULL
  • movie_num (Key2) — Foreign key → Movie.movie_num — NOT NULL
  • rental_num (Key3) — Foreign key → Rental_history.rental_num — NOT NULL
  • branch_num (Key4) — Foreign key → Branch.branch_num — NOT NULL
  • status (Field2)