modeling 1

Tables (19)

BOOKING (예약)

  • Key (예약번호) — Primary key — NOT NULL
  • Key (상품번호) — Foreign key → PRODUCT.Key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (주문일자)
  • Field2 (주문내역)
  • Field3 (주문상태)
  • Field4 (배송예정일)
  • Field5 (배송번호)

COUPON (쿠폰)

  • Key (쿠폰번호) — Primary key — NOT NULL
  • Field (쿠폰명)
  • Field2 (사용조건)
  • Field3 (유효기간)
  • Field (할인혜택)

COUPON_H (쿠폰이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용여부)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)
  • Key (쿠폰번호) — Foreign key → COUPON.Key — NOT NULL

CREMA_MONEY_H (크레마머니이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)

CUSTOMER (고객)

  • Key (고객번호) — Primary key — NOT NULL
  • Field2 (아이디)
  • Field3 (닉네임)
  • Field4 (이름)
  • Field5 (본인인증수단)
  • Field6 (생년월일)
  • Field (비밀번호) — NOT NULL
  • Field2 (주소)
  • Field3 (전화번호)
  • Field4 (이메일)

CUSTOMER_CLASS (고객등급)

  • Key (고객등급번호) — Primary key — NOT NULL
  • Field (고객등급기준시작금액)
  • Field2 (고객등급기준종료금액)

CUSTOMER_CLASS_H (고객등급이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Key (고객등급번호) — Foreign key → CUSTOMER_CLASS.Key — NOT NULL
  • Field (조정일)
  • Field2 (주문금액)
  • Field3 (유지기간시작일)
  • Field4 (유지기간종료일)

DEPOSIT_H (예치금이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)

DIGITAL_MONEY_H (디지털머니이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)

EMAIL_RECEPTION_CONSENT (이메일수신동의)

  • Key2 (이메일수신동의항목번호) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (이메일수신동의항목)

FAMILY_ACCOUNT_H (가족계좌이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)

GIFT (상품권)

  • Key (상품권번호) — Primary key — NOT NULL
  • Field (상품권명)
  • Field2 (상품권금액)

ORDER (주문)

  • Key (주문번호) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (주문일자)
  • Field2 (주문내역)
  • Field3 (주문상태)
  • Field4 (배송예정일)
  • Field5 (배송번호)

ORDER_ITEM (주문항목)

  • Key (주문항목번호) — Primary key — NOT NULL
  • Key (주문번호) — Foreign key → ORDER.Key — NOT NULL
  • Field (주문단가)
  • Field2 (주문수량)
  • Key (상품번호) — Foreign key → PRODUCT.Key — NOT NULL

ORDER_PAYMENT_METHOD (주문결제수단)

  • Key (순번) — Primary key — NOT NULL
  • Key (주문번호) — Foreign key → ORDER.Key — NOT NULL
  • Field (결제수단)

PRODUCT (상품)

  • Key (상품번호) — Primary key — NOT NULL
  • Field (상품명)
  • Field2 (상품설명)
  • Field3 (상품구분)
  • Field4 (저자명)
  • Field5 (역자명)
  • Field6 (출판사명)
  • Field (출판일)
  • Field2 (가격)

YES_GIFT_H (YES상품권이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (상품권금액)
  • Key (상품권번호) — Foreign key → GIFT.Key — NOT NULL
  • Field (잔액)

YES_MONEY_H (YES머니이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)

YES_POINT_H (YES포인트이력)

  • Key (순번) — Primary key — NOT NULL
  • Key (고객번호) — Foreign key → CUSTOMER.Key — NOT NULL
  • Field (일자)
  • Field2 (사용구분)
  • Field3 (내용)
  • Field4 (주문번호)
  • Field (금액)