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)