Exe5-006
Tables (7)
Untitled (신발)
- Key (신발Code) — char(20) — Primary key — NOT NULL
- Key (공급자ID) — char(20) — Foreign key → Untitled4.Key — NOT NULL
- Field (이름) — char(20)
- Field (스타일) — char(20)
- Field (사이즈) — char(10)
- Field (색상) — char(10)
Untitled (판매사원)
- Key (사원ID) — char(10) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field (전화) — char(10)
- Field (직급) — char(10)
Untitled (급여)
- Key (사원ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (판매량) — char(20)
- Field (수수료) — char(20)
- Field (영업목표) — char(20)
Untitled2 (판매)
- Key (판매코드) — Primary key — NOT NULL
- Field (판매일) — char(10)
- Field (수량) — char(10)
- Field (금액) — char(10)
- Field (결재수단) — char(10)
- Key (사원ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (신발Code) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Key (고객ID) — char(10) — Foreign key → Untitled5.Key — NOT NULL
Untitled3 (신발정보)
- Key (사이즈code) — char(20) — Primary key — NOT NULL
- Key (신발Code) — char(20) — Foreign key → Untitled.Key — NOT NULL
- Field (재고량) — integer
Untitled4 (공급자)
- Key (공급자ID) — char(20) — Primary key — NOT NULL
- Field (이름) — char(20)
- Field (주소) — char(30)
- Field (전화) — char(20)
- Field
Untitled5 (고객)
- Key (고객ID) — char(10) — Primary key — NOT NULL
- Field (이름) — char(10)
- Field (주소) — char(10)
- Field (전화) — char(10)
- Field (특이사항) — text