[다시]ERD 연습문제 5
테이블 (5)
Untitled (supplier)
- Key (supcode) — char(30) — 기본 키 — NOT NULL
- Field (supaddress) — char(30)
- Field (supphone) — int(15)
- Field (supname) — char(20)
Untitled (customer)
- Key (ccode) — char(30) — 기본 키 — NOT NULL
- Field (caddress) — char(30)
- Field (cname) — char(20)
- Field (cphone) — int(15)
Untitled (sales)
- Key (sacode) — char(30) — 기본 키 — NOT NULL
- Field (sadate) — date
- Field (saamount) — int(4)
- Field (safees) — int(3)
- Key (scode) — char(30) — 외래 키 → shoes.Key — NOT NULL
- Key (ccode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Key (smcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
Untitled (salesman)
- Key (smcode) — char(30) — 기본 키 — NOT NULL
- Field (successrate) — int(3)
- Field (smname) — char(20)
- Field (smphone) — int(15)
shoes
- Key (scode) — char(30) — 기본 키 — NOT NULL
- Field (sstyle) — char(30)
- Field (ssize) — int(3)
- Field (scolor) — char(30)
- Field (samount) — int(3)
- Key (supcode) — char(30) — 외래 키 → Untitled.Key — NOT NULL
- Field (sprice) — int(10)