SAMPLE
Tables (9)
SHOPPING_COUPON
- COUPON_NO — CHAR(8) — Primary key — NOT NULL
- SELLER_ID — VARCHAR2(30) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
- COUPON_EXPIRE_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(15)
SHOPPING_ORDER
- ORDER_NO — CHAR(8) — Primary key — 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
- SELLER_ID — VARCHAR2(30) — Foreign key → SHOPPING_SELLER.SELLER_ID — NOT NULL
- COUPON_NO — CHAR(8) — Foreign key → SHOPPING_COUPON.COUPON_NO — NOT NULL
- ORDER_DATE — DATE
- ORDER_ADDRESS — VARCHAR2(100)
- 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(30) — 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_THUMBNAIL_IMG — VARCHAR2(300)
- PRODUCT_ENABLE — NUMBER(1)
- PRODUCT_REG_DATE — DATE
SHOPPING_PRODUCT_REVIEW
- MEMBER_ID — VARCHAR2(30) — Primary key — NOT NULL
- PRODUCT_NO — CHAR(8) — Primary key — NOT NULL
- PRODUCT_REVIEW_CONTENT — VARCHAR2(1500)
- PRODUCT_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_ADDRESS — VARCHAR2(100)