프로젝트과제
테이블 (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