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