Store
테이블 (7)
animalSale (Untitled4)
- animal_id (Key) — 기본 키 — NOT NULL
- animal_name (Field2)
- anmimal_category (Field3)
- breed (Field4) — boolean
- birth (Field5)
- gender (Field6)
- registration (Field7)
- color (Field8)
- animal_list_price (Field9)
customer (Untitled2)
- customer_id (Key) — 기본 키 — NOT NULL
- cust_name (Field2)
- address (Field3)
- city (Field4)
- state (Field5)
- postCode (Field6)
employee (Untitled3)
- employee_id (Key) — 기본 키 — NOT NULL
- empl_name (Field2)
merchandiseSale (Untitled5)
- item_id (Key) — 기본 키 — NOT NULL
- item_name (Field2)
- item_desc (Field3)
- item_category (Field4)
- item_llist_price (Field5)
salesInfo (Untitled)
- sales_no (Key) — 기본 키 — NOT NULL
- date (Field2)
- ms_total (Field5)
- as_total (Field6)
- customer_id (Key3) — 외래 키 → customer.customer_id — NOT NULL
- employee_id (Key5) — 외래 키 → employee.employee_id — NOT NULL
동물세일 (Untitled6)
- sales_no (Key) — 외래 키 → salesInfo.sales_no — NOT NULL
- animal_id (Key2) — 외래 키 → animalSale.animal_id — NOT NULL
판매세일 (CopyOfUntitled6)
- sales_no (Key) — 외래 키 → salesInfo.sales_no — NOT NULL
- item_id (Key2) — 외래 키 → merchandiseSale.item_id — NOT NULL