프로젝트과제

테이블 (5)

COUPON (쿠폰)

  • ID (PK) — NUMBER — 기본 키 — NOT NULL
  • CODE (코드) — VARCHAR(255)
  • DISCOUNT_TYPE (할인유형) — VARCHAR(255)
  • VALUE (가치) — NUMBER
  • VALID_FROM (유효시작일자) — DATE
  • VALID_TO (유효종료일자) — DATE
  • MIN_ORDER_PRICE (최소주문금액) — NUMBER
  • MAX_DISCOUNT (최대할인금액) — NUMBER
  • CREATED_AT (생성일자) — DATE
  • UPDATED_AT (수정일자) — DATE

MEMBER (고객)

  • MEMBER_ID (PK) — NUMBER — 기본 키 — NOT NULL
  • EMAIL (이메일) — VARCHAR(255)
  • NAME (이름) — VARCHAR(255)
  • TIER (등급) — VARCHAR(255)
  • CREATED_AT (생성일자) — DATE
  • UPDATED_AT (수정일자) — DATE

ORDER (주문)

  • ORDER_ID (PK) — NUMBER — 기본 키 — NOT NULL
  • MEMBER_ID (PK2) — NUMBER — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • TOTAL_PRICE (총액) — NUMBER
  • STATUS (상태) — VARCHAR(50)
  • VERSION (버젼) — NUMBER
  • CREATED_AT (생성일자) — DATE
  • UPDATED_AT (수정일자) — DATE

ORDER_ITEM (주문상품)

  • ORDER_ITEM_ID (PK) — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_ID (PK3) — NUMBER — 외래 키 → PRODUCT.PRODUCT_ID — NOT NULL
  • ORDER_ID (PK2) — NUMBER — 외래 키 → ORDER.ORDER_ID — NOT NULL
  • QUANTITY (수량) — NUMBER
  • PRICE_AT_ORDER (주문시점가격) — NUMBER
  • CREATED_AT (생성일자) — DATE
  • UPDATED_AT (수정일자) — DATE

PRODUCT (상품)

  • PRODUCT_ID (PK) — NUMBER — 기본 키 — NOT NULL
  • NAME (이름) — VARCHAR(255)
  • PRICE (가격) — NUMBER
  • STOCK_QTY (재고수량) — NUMBER
  • STATUS (상태) — VARCHAR(20)
  • CATEGORY (분류) — VARCHAR(255)
  • CREATED_AT (생성일자) — DATE
  • UPDATED_AT (수정일자) — DATE