shopping

테이블 (9)

MEMBER_ADDRESS (SHOPPING_MEMBER_ADDRESS)

  • Key (MEMBER_ID) — VARCHAR2(30) — 외래 키 → 회원.Key — NOT NULL
  • Field (MEMBER_ADDRESS_NAME) — VARCHAR(30)
  • Field2 (MEMBER_ADDRESS) — VARCHAR2(100)
  • Field3 (MEMBER_ADDRESS_TEL) — CHAR(11)

등급 (SHOPPING_GRADE)

  • Key (GRADE_NO) — NUMBER(1) — 기본 키 — NOT NULL
  • Field (GRADE_NAME) — VARCHAR2(50)

배송업체 (SHOPPING_PARCEL)

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

상품 (SHOPPING_PRODUCT)

  • Key (PRODUCT_NO) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(50) — 외래 키 → 판매자.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(50)
  • Field (PPRODUCT_MAIN_IMG) — VARCHAR2(300)
  • Field (PRODUCT_THUMBNAIL_IMG) — VARCHAR2(300)
  • Field (PRODUCT_ENABLE) — NUMBER(1)
  • Field (PRODUCT_REG_DATE) — DATE

상품후기 (SHOPPING_PRODUCT_REVIEW)

  • Key (MEMBER_ID) — VARCHAR2(50) — 기본 키 — 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

주문 (SHOPPING_ORDER)

  • Key (ORDER_NO) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — VARCHAR2(50) — 외래 키 → 회원.Key — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(50) — 외래 키 → 판매자.Key — NOT NULL
  • Key (PRODUCT_NO) — VARCHAR2(50) — 외래 키 → 상품.Key — NOT NULL
  • Key (COUPON_NO) — VARCHAR2(50) — 외래 키 → 쿠폰.Key — NOT NULL
  • Field (ORDER_DATE) — DATE
  • Field (ORDER_ADDRESS) — VARCHAR2(50)
  • Field (ORDER_ADDRESS_NAME) — VARCHAR2(50)
  • Field (ORDER_ADDRESS_TEL) — CHAR(11)
  • Field (ORDER_EA) — NUMBER
  • Field (ORDER_CREDIT_MONEY) — NUMBER
  • Field (ORDER_PARCEL_STATE) — NUMBER(1)
  • Field (ORDER_CRIDET_KIND) — NUMBER(1)
  • Field (ORDER_STATE) — NUMBER(1)

쿠폰 (SHOPPING_COUPON)

  • Key (COUPON_NO) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key (SELLER_ID) — VARCHAR2(50) — 외래 키 → 판매자.Key — NOT NULL
  • Field (COUPON_EXPIRE_DATE) — DATE
  • Field (COUPON_PRICE) — NUMBER

판매자 (SHOPPING_SELLER)

  • Key (SELLER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (SELLER_PASSWD) — VARCHAR2(50) — NOT NULL
  • Field (SELLER_BESINESS_NO) — VARCHAR2(50) — NOT NULL
  • Field (SELLER_BUSINESS_NAME) — VARCHAR2(50)
  • Field (SELLER_CED) — VARCHAR2(50)
  • Field (SELLER_EMAIL) — VARCHAR2(50)
  • Field (SELLER_BUSINESS_TEL) — CHAR(11)
  • Field (SELLER_BUSINESS_TEL_NO) — CHAR(20)
  • Field (SELLER_BUSINESS_ADDRESS) — VARCHAR2(50)

회원 (SHOPPING_MEMBER)

  • Key (MEMBER_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Key (GRADE_NO) — NUMBER — 외래 키 → 등급.Key — NOT NULL
  • Field (MEMBER_NAME) — VARCHAR2(50) — NOT NULL
  • Field (MEMBER_PASSWD) — VARCHAR2(50)
  • Field (MEMBER_PHONE) — CHAR(11)
  • Field (MEMBER_E_MAIL) — VARCHAR2(50)
  • Field (MEMBER_POINT) — NUMBER
  • Field (MEMBER_BIRTH) — DATE