exercise 3
Tables (5)
animal (애완동물)
- animid (Key) — Primary key — NOT NULL
- animname (Field)
- acategory (Field2)
- breed (Field3)
- dob (Field4)
- gender (Field5)
- reg (Field6)
- color (Field7)
- alprice (Field8)
- custid (Key2) — Foreign key → customer.custid — NOT NULL
customer (고객)
- custid (Key) — Primary key — NOT NULL
- custname (Field)
- address (Field2)
- city (Field3)
- state (Field4)
- zipcode (Field5)
- empid (Key2) — Foreign key → employee.empid — NOT NULL
employee (직원)
- empid (Key) — Primary key — NOT NULL
- empname (Field)
merchandise (상품)
- item (Key) — Primary key — NOT NULL
- desc (Field2)
- mcategory (Field3)
- mlprice (Field4)
- custid (Key2) — Foreign key → customer.custid — NOT NULL
sale (할인)
- saleno (Key) — Primary key — NOT NULL
- animid (Key2) — Foreign key → animal.animid — NOT NULL
- item (Key3) — Foreign key → merchandise.item — NOT NULL
- saledate (Field)
- asubtotal (Field2)
- msubtotal (Field3)
- saletax (Field4)
- saletotal (Field5)