상품관리
테이블 (4)
customers
- cno — varchar(5)
- cname — varchar(10)
- address — varchar(50)
- email — varchar(20)
- phone — varchar(20)
orderdetails
- orderno — varchar(10) — 외래 키 → orders.orderno
- pno — varchar(5) — 외래 키 → products.pno
- qty — int(5)
- cost — int(8)
orders
- orderno — varchar(10)
- orderdate — varchar(8)
- address — VARCHAR(50)
- phone — varchar(20)
- status — VARCHAR(5)
- cno — varchar(5) — 외래 키 → customers.cno
products
- pno — varchar(5)
- pname — varchar(20)
- cost — int(8)
- stock — int(5)