test
Tables (4)
customers (고객)
- cno (고객넘버) — varchars(5) — Primary key — NOT NULL
- cname (고객이름) — varchar(10)
- address (주소) — varchar(20)
- email (이메일) — varchar(20)
- phone (전화번호) — varchar(20)
orderdetail (주문정보)
- pno (상품넘버) — varchar(10) — Foreign key → products.pno — NOT NULL
- orderno (주문넘버) — varchar(10) — Foreign key → orders.orderno — NOT NULL
- qty (수량) — int(5)
- cost (가격) — int(8)
orders (주문)
- orderno (주문넘버) — varchar(10) — Primary key — NOT NULL
- address (주소) — varchar(20)
- phone (전화번호) — varchar(20)
- status (현황) — varchar(5)
- cno (고객넘버) — varchars(5) — Foreign key → customers.cno — NOT NULL
products (상품)
- pno (상품넘버) — varchar(10) — Primary key — NOT NULL
- pname (상품이름) — varchar(20)
- cost (가격) — int(8)
- stock (재고) — int(5)