Exercise1
Tables (5)
ANIMAL
- ANIMID — INT — Primary key — NOT NULL
- ANIMNAME — VARCHAR(30)
- ACATEGORY — VARCHAR(30)
- BREED — VARCHAR(30)
- DOB — DATETIME()
- GENDER — VARCHAR(30)
- REG — VARCHAR(30)
- COLOR — VARCHAR(30)
- ALPRICE — INT
CUSTOMER
- CUSTID — bigint(20) — Primary key — NOT NULL
- CUSTNAME — varchar(255)
- ADDRESS — varchar(255)
- CITY — varchar(255)
- STATE — varchar(255)
- ZIPCODE — varchar(255)
EMPLOYEE
- EMPID — bigint(20) — Primary key — NOT NULL
- EMPNAME — varchar(255)
MERCHANDISE
- ITEM — varchar(255) — Primary key — NOT NULL
- DESCRIPTION — varchar(255)
- CATEGORY — varchar(255)
- LISTPRICE — bigint(20)
- SALEPRICE — bigint(20)
- ZIPCODE — bigint(20)
- TOTITEMSALEPRICE — bigint(20)
SALE
- SALENO — INT — Primary key — NOT NULL
- SALEDATE — DATETIME
- ASUBTOTAL — INT
- MSUBTOTAL — INT
- SALETAX — INT
- TOTITEMSALEPRICE — INT