SHOPPING

Tables (9)

COUPON

  • COUPON_NO — CHAR(8) — Primary key — NOT NULL
  • SELLER_ID — VARCHAR2(50) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
  • COUPON_DATE — DATE
  • COUPON_PRICE — NUMBER

SHOPPING_MEMBER

  • MEMBER_ID — VARCHAR2(30) — Primary key — NOT NULL
  • MEMBER_GRADE_NO — NUMBER(1) — Foreign key → SHOPPING_MEMBER_GRADE.MEMBER_GRADE_NO — NOT NULL
  • MEMBER_PASSWD — VARCHAR2(30) — NOT NULL
  • MEMBER_NAME — VARCHAR2(30)
  • MEMBER_TEL — CHAR(11)
  • MEMBER_EMAIL — VARCHAR2(50)
  • MEMBER_POINT — NUMBER
  • MEMBER_BIRTHDAY — DATE

SHOPPING_MEMBER_ADDRESS

  • MEMBER_ID — VARCHAR2(30) — Foreign key → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • MEMBER_ADDRESS_NAME — VARCHAR2(30)
  • MEMBER_ADDRESS — VARCHAR2(100)
  • MEMBER_ADDRESS_TEL — CHAR(11)

SHOPPING_MEMBER_GRADE

  • MEMBER_GRADE_NO — NUMBER(1) — Primary key — NOT NULL
  • MEMBER_GRADE_NAME — VARCHAR2(10) — NOT NULL

SHOPPING_ORDER

  • ORDER_NO — char(8) — Primary key — NOT NULL
  • SELLER_ID — VARCHAR2(150) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
  • COUPON_NO — CHAR(8) — Foreign key → COUPON.COUPON_NO — NOT NULL
  • MEMBER_ID — VARCHAR2(30) — Foreign key → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_NO — CHAR(8) — Foreign key → SHOPPING_PRODUCT.PRODUCT_NO — NOT NULL
  • ORDER_DATE — DATE
  • ORDER_ADDRESS — VARCHAR2(50)
  • ORDER_ADDRESS_NAME — VARCHAR2(50)
  • ORDER_ADDRESS_TEL — CHAR(11)
  • ORDER_EA — NUMBER
  • ORDER_CREDIT_MONEY — NUMBER
  • ORDER_PARCEL_STATE — NUMBER(1)
  • ORDER_CREDIT_KIND — NUMBER(1)
  • ORDER_STATE — NUMBER(1)

SHOPPING_PARCEL

  • PARCEL_NO — CHAR(4) — Primary key — NOT NULL
  • SELLER_ID — VARCHAR2(150) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
  • PARCEL_NAME — VARCHAR2(50)
  • PARCEL_TEL_NO — CHAR(11)
  • PARCEL_PRICE — NUMBER

SHOPPING_PRODUCT

  • PRODUCT_NO — CHAR(8) — Primary key — NOT NULL
  • SELLER_ID — VARCHAR2(30) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
  • PRODUCT_NAME — VARCHAR2(50)
  • PRODUCT_ORIGIN — VARCHAR2(50)
  • PRODUCT_EA — NUMBER
  • PRODUCT_PRICE — NUMBER
  • PRODUCT_KC_NO — VARCHAR2(24)
  • PRODUCT_MAIN_IMG — VARCHAR2(300)
  • PRODUCT_THUMNAIL_IMG — VARCHAR2(300)
  • PRODUCT_ENABLE — NUMBER(1)
  • PRODUCT_REG_DATE — DATE

SHOPPING_PRODUCT_REVIEW

  • PRODUCT_NO — CHAR(8) — Foreign key → SHOPPING_PRODUCT.PRODUCT_NO — NOT NULL
  • MEMBER_ID — VARCHAR2(30) — Foreign key → SHOPPING_MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_REVIEW_CONTENT — VARCHAR2(1500)
  • PRODUCT_REVIEW_STAR — NUMBER(1)
  • PRODUCT_REVIEW_DATE — DATE

SHOPPING_SELLER

  • SELLER_ID — VARCHAR2(30) — Primary key — NOT NULL
  • SELLER_PASSWD — VARCHAR2(30) — NOT NULL
  • SELLER_BUSINESS_NO — CHAR(10) — NOT NULL
  • SELLER_BUSINESS_NAME — VARCHAR2(50)
  • SELLER_CEO — VARCHAR2(30)
  • SELLER_EMAIL — VARCHAR2(50)
  • SELLER_BUSINESS_TEL — CHAR(11)
  • SELLER_BUSINESS_TEL_NO — CHAR(20)
  • SELLER_BUSINESS_ADRESS (SELLER_ADRESS) — VARCHAR2(100)