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)