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)