편의점
테이블 (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