편의점

테이블 (6)

Employee (Untitled2)

  • Key — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • phone (Field2) — varchar(15)
  • position (Field3) — varchar(10)

Product (Untitled)

  • Key — 기본 키 — NOT NULL
  • type (Field) — varchar(10)
  • sales_price (Field2) — integer
  • purchase_price (Field3) — integer

Sales (Untitled6)

  • Key — 기본 키 — NOT NULL
  • product_count (Field3) — integer
  • total_price (Field) — integer
  • work_id (Key2) — integer — 외래 키 → Work.Key — NOT NULL
  • product_id (Key3) — integer — 외래 키 → Product.Key — NOT NULL

Wholesale_deal (Untitled5)

  • Key — 기본 키 — NOT NULL
  • product_id (Key3) — integer — 외래 키 → Product.Key — NOT NULL
  • wholesale_id (Key2) — integer — 외래 키 → Wholesaler.Key — NOT NULL

Wholesaler (Untitled4)

  • Key — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • tel (Field2) — varchar(15)
  • location (Field3) — text

Work (Untitled3)

  • Key — 기본 키 — NOT NULL
  • worked_at (Field2) — datetime
  • start_money (Field4) — integer
  • end_money (Field5) — integer
  • sale_money (Field6) — integer
  • employee_id (Key2) — integer — 외래 키 → Employee.Key — NOT NULL