쇼핑몰ERD

테이블 (4)

CUSTOMERS

  • CNO — NUMBER(5) — 기본 키
  • CNAME — VARCHAR2(10) — NOT NULL
  • ADDRESS — VARCHAR2(50) — NOT NULL
  • EMAIL — VARCHAR2(20) — NOT NULL
  • PHONE — VARCHAR2(20) — NOT NULL

ORDERDETAIL

  • ORDERNO — NUMBER(10) — 외래 키 → ORDERS.ORDERNO — NOT NULL
  • PNO — NUMBER(5) — 외래 키 → PRODUCTS.PNO — NOT NULL
  • QTY — NUMBER(5) — NOT NULL
  • COST — NUMBER(8) — NOT NULL

ORDERS

  • ORDERNO — NUMBER(10) — 기본 키
  • ORDERDATE — DATE — NOT NULL
  • ADDRESS — VARCHAR2(50) — NOT NULL
  • PHONE — VARCHAR2(20) — NOT NULL
  • STATUS — VARCHAR2(20) — NOT NULL — CHECK(STATUS IN ('결제완료', '배송중', '배송완료'))
  • CNO — NUMBER(5) — 외래 키 → CUSTOMERS.CNO — NOT NULL

PRODUCTS

  • PNO — NUMBER(5) — 기본 키
  • PNAME — VARCHAR2(20) — NOT NULL
  • COST — NUMBER(8) — NOT NULL
  • STOCK — NUMBER(5) — NOT NULL