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