ERDtest

Tables (3)

CART (장바구니)

  • CODE (코드) — NUMBER — Foreign key → PRODUCT.CODE — NOT NULL
  • NAME (이름) — NVACHAR2
  • COUNT (담은갯수) — NUMBER
  • PRICE (총가격) — NUMBER

ORDER (Untitled2)

  • ORDERNO (주문번호) — NUMBER — Primary key — NOT NULL
  • CODE (코드2) — NUMBER — Foreign key → PRODUCT.CODE — NOT NULL
  • CODE (코드) — NVACHAR2
  • NAME (이름) — NVACHAR2
  • TOTALPRICE (총가격) — NUMBER
  • ORDERDATE (주문일시) — DATE

PRODUCT (상품)

  • CODE (코드) — NUMBER — Primary key — NOT NULL
  • NAME (이름) — NVARCHAR2
  • PRICE (가격) — NUMBER
  • INFO (정보) — NVACHAR2
  • IMGCODE (이미지코드) — NVARCHAR2
  • COUNT (재고) — NUMBER