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 (금액)