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