상품관리

테이블 (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)