fruit
테이블 (4)
Untitled (BUY)
- Key (b_id) — Int — 기본 키 — NOT NULL
- Field (b_quantity) — Int
- Field (b_date) — datetime
- Field (b_unit) — varchar(10)
- f_name — varchar(30) — 외래 키 → 과일.f_name — NOT NULL
- Key (b_w_name) — varchar(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (WholeSaler)
- Key (w_name) — varchar(20) — 기본 키 — NOT NULL
- Field (w_location) — varchar(50)
Untitled (Sell)
- Key (s_id) — Int — 기본 키 — NOT NULL
- Field (s_date) — datetime
- Field (s_quantity) — Int
- Field (s_price) — Int
- Field (s_method) — varchar(4)
- Field (s_unit) — varchar(10)
- f_name — varchar(30) — 외래 키 → 과일.f_name — NOT NULL
과일 (FRUIT)
- f_name — varchar(30) — 기본 키 — NOT NULL
- f_price — Int
- f_stock — Int
- f_unit — varchar(10)