SHOPPING DB구축

테이블 (9)

MEMBER (SHOPPING_MEMBER)

  • Key (MEMBER_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Key (MEMBER_GRADE_NO) — NUMBER(1) — 외래 키 → Untitled.Key — NOT NULL
  • Field (MEMBER_PASSWD) — VARCHAR2(30) — NOT NULL
  • Field2 (MEMBER_NAME) — VARCHAR2(30)
  • Field (MEMBER_TEL) — CHAR(11)
  • Field3 (MEMBER_EMAIL) — VARCHAR2(50)
  • Field (MEMBER_POINT) — NUMBER
  • Field (MEMBER_BIRTHDAY) — DATE

Untitled (SHOPPING_MEMBER_ADDRESS)

  • Key (MEMBER_ID) — VARCHAR2(30) — 외래 키 → MEMBER.Key — NOT NULL
  • Field (MEMBER_ADDRESS_NAME) — VARCHAR2(30)
  • Field (MEMBER_ADDRESS) — VARCHAR2(100)
  • Field (MEMBER_ADDRESS_TEL) — CHAR(11)

Untitled (SHOPPING_MEMBER_GRADE)

  • Key (MEMBER_GRADE_NO) — NUMBER(1) — 기본 키 — NOT NULL
  • Field (MEMBER_GRADE_NAME) — VARCHAR2(15)

Untitled (SHOPPING_PRODUCT)

  • Key (PRODUCT_NO) — CHAR(8) — 기본 키 — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PRODUCT_NAME) — VARCHAR2(50)
  • Field (PRODUCT_ORIGIN) — VARCHAR2(50)
  • Field (PRODUCT_EA) — NUMBER
  • Field (PRODUCT_PRICE) — NUMBER
  • Field (PRODUCT_KC_NO) — VARCHAR2(24)
  • Field (PRODUCT_MAIN_IMG) — VARCHAR2(300)
  • Field (PRODUCT_THUMBNAIL_IMG) — VARCHAR2(300)
  • Field (PRODUCT_ENABLE) — NUMBER(1)
  • Field (PRODUCT_REG_DATE) — DATE

Untitled (SHOPPING_SELLER)

  • Key (SELLER_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Field (SELLER_PASSWD) — VARCHAR2(30) — NOT NULL
  • Field (SELLER_BUSINESS_NO) — CHAR(10) — NOT NULL
  • Field (SELLER_BUSINESS_NAME) — VARCHAR2(50)
  • Field (SELLER_CEO) — VARCHAR2(30)
  • Field (SELLER_EMAIL) — VARCHAR2(50)
  • Field (SELLER_BUSINESS_TEL) — CHAR(11)
  • Field (SELLER_BUSINESS_TEL_NO) — CHAR(20)
  • Field (SELELR_BUSINESS_ADDRESS) — VARCHAR2(100)

Untitled (SHOPPING_PRODUCT_REVIEW)

  • Key (MEMBER_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Key (PRODUCT_NO) — CHAR(8) — 기본 키 — NOT NULL
  • Field (PRODUCT_REVIEW_CONTENT) — VARCHAR2(1500)
  • Field (PRODUCT_STAR) — NUMBER(1)
  • Field (PRODUCT_REVIEW_DATE) — DATE

Untitled (SHOPPING_COUPON)

  • Key (COUPON_NO) — CHAR(8) — 기본 키 — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (COUPON_EXPIRE_DATE) — DATE
  • Field (COUPON_PRICE) — NUMBER

Untitled (SHOPPING_ORDER)

  • Key (ORDER_NO) — CHAR(8) — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — VARCHAR2(30) — 외래 키 → MEMBER.Key — NOT NULL
  • Key (PRODUCT_NO) — CHAR(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (COUPON_NO) — CHAR(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (ORDER_DATE) — DATE
  • Field (ORDER_ADDRESS) — VARCHAR2(100)
  • Field (ORDER_ADDRESS_NAME) — VARCHAR2(50)
  • Field2 (ORDER_ADDRESS_TEL) — CHAR(11)
  • Field (ORDER_EA) — NUMBER
  • Field (ORDER_CREDIT_MONEY) — NUMBER
  • Field (ORDER_PARCEL_STATE) — NUMBER(1)
  • Field (ORDER_CREDIT_KIND) — NUMBER(1)
  • Field (ORDER_STATE) — NUMBER(1)

Untitled (SHOPPING_PARCEL)

  • Key (PARCEL_NO) — CHAR(4) — 기본 키 — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (PARCEL_NAME) — VARCHAR2(50)
  • Field (PARCEL_TEL_NO) — CHAR(11)
  • Field (PARCEL_PRICE) — NUMBER