쇼핑몰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