MINISHOP
Tables (5)
ONECHANGE
- 환불번호 (CNO) — NUMBER — Primary key
- 주문번호 (ONO) — NUMBER — Foreign key → ONEORDER.ONO
- 카테고리 (CAT2) — NVARCHAR2(4) — NOT NULL
- 택배사 (DELI) — NVARCHAR2(10) — NOT NULL
ONEMEMBER
- 회원ID (MID) — NVARCHAR2(20) — Primary key
- 회원PW (MPW) — NVARCHAR2(30)
- 회원이름 (MNAME) — NVARCHAR2(5) — NOT NULL
- 회원주소 (MADDR) — NVARCHAR2(50) — NOT NULL
- 회원연락처 (MPHONE) — NVARCHAR2(13)
- 이메일 (MEMAIL) — NVARCHAR2(50)
ONEORDER
- ONO — NUMBER — Primary key
- 판매자ID (SNO) — NVARCHAR2(20) — Foreign key → ONESELLER.판매자ID
- 상품ID (PID) — NVARCHAR2(20) — Foreign key → PRODUCT.상품ID
- 회원ID (MID) — NVARCHAR2(20) — Foreign key → ONEMEMBER.회원ID
- 주문ID (OID) — NVARCHAR2(20)
- 주문수량 (OCNT) — NUMBER — NOT NULL
- 가격합계 (OTOTAL) — NUMBER
ONESELLER
- 판매자ID (SNO) — NVARCHAR2(20) — Primary key
- 회원ID (MID) — NVARCHAR2(20) — Foreign key → ONEMEMBER.회원ID
- 판매자주소 (SADDR) — NVARCHAR2(50) — NOT NULL
- 판매회사명 (SCNAME) — NVARCHAR2(5) — NOT NULL
- 판매자연락처 (SPHONE) — NVARCHAR2(13)
PRODUCT
- 상품ID (PID) — NVARCHAR2(20) — Primary key
- 판매자ID (SNO2) — NVARCHAR2(20) — Foreign key → ONESELLER.판매자ID
- 상품명 (PNAME) — NVARCHAR2(50) — NOT NULL
- 가격 (PRICE) — NUMBER — NOT NULL
- 상품이미지 (IMG) — NVARCHAR2(100)
- 상품코드 (PCODE) — NUMBER — NOT NULL
- 카테고리 (CAT) — NVARCHAR2(10)