이커머스

테이블 (13)

ADMIN

  • 관리자ID (ADMIN_ID) — VARCHAR2(30) — 기본 키 — NOT NULL
  • 패스워드 (PASSWORD) — VARCHAR2(255) — NOT NULL

COUPON

  • COUPON_CODE — VARCHAR2(50)
  • QUANTITY — NUMBER
  • COUPON_NAME — VARCHAR2(255)
  • CREATED_DATE — DATE
  • EXPIRY_DATE — DATE

LOGIN_HISTORY

  • LOG_ID — NUMBER
  • LOGIN_DATE — DATE — NOT NULL
  • USER_ID — VARCHAR2(30) — NOT NULL
  • USER_TYPE — VARCHAR2(20)
  • 관리자ID (ADMIN_ID) — VARCHAR2(30) — 외래 키 → ADMIN.관리자ID — NOT NULL

MEMBER

  • 회원ID (MEMBER_ID) — VARCHAR2(30) — 기본 키
  • 패스워드 (PASSWORD) — VARCHAR2(255) — NOT NULL
  • 이름 (NAME) — VARCHAR2(100) — NOT NULL
  • 나이 (AGE) — NUMBER — NOT NULL
  • 성별 (GENDER) — VARCHAR2(10)
  • 연락처 (CONTACT) — VARCHAR2(20)
  • 프로필이미지 (PROFILE_IMAGE) — VARCHAR2(255)
  • 포인트 (POINTS) — NUMBER — NOT NULL

MEMBER_COUPON

  • MEMBER_ID — VARCHAR2(30)
  • COUPON_CODE — VARCHAR2(50)
  • REGISTERED_DATE — DATE
  • EXPIRY_DATE — DATE

ORDERS

  • ORDER_ID — NUMBER
  • MEMBER_ID — VARCHAR2(30)
  • ORDER_DATE — DATE — NOT NULL
  • TOTAL_AMOUNT — NUMBER — NOT NULL
  • ORDER_STATUS — VARCHAR2(50)
  • PAYMENT_STATUS — VARCHAR2(50)

ORDER_DETAIL

  • DETAIL_ID — NUMBER
  • ORDER_ID — NUMBER
  • PRODUCT_ID — NUMBER

PAYMENT

  • PAYMENT_ID — NUMBER
  • PAYMENT_DATE — DATE — NOT NULL
  • ORDER_ID — NUMBER
  • PAYMENT_STATUS — VARCHAR2(50)

POINT_HISTORY

  • 포인트내역ID (POINT_HISTORY_ID) — NUMBER — 기본 키
  • 구분 (USE_TYPE) — VARCHAR2(20)
  • 금액 (AMOUNT) — NUMBER
  • 잔여금액 (REMAINING_BALANCE) — NUMBER
  • 회원ID (MEMBER_ID2) — VARCHAR2(30) — 외래 키 → MEMBER.회원ID

PRODUCT

  • PRODUCT_ID — NUMBER
  • PRODUCT_NAME — VARCHAR2(255) — NOT NULL
  • CATEGORY — VARCHAR2(100)
  • PRICE — NUMBER — NOT NULL
  • STOCK — NUMBER — NOT NULL
  • PRODUCT_DESCRIPTION — VARCHAR2(4000)
  • CREATED_DATE — DATE
  • PRODUCT_IMAGE — VARCHAR2(255)

SHIPPING

  • SHIPPING_ID — NUMBER
  • ORDER_DETAIL_ID — NUMBER
  • SHIPPING_STATUS — VARCHAR2(50)
  • SHIPPING_DATE — DATE

coupon (Untitled2)

  • coupon_id (Key) — 기본 키 — NOT NULL

member_coupon (Untitled)

  • no (Key2) — 기본 키 — NOT NULL
  • 회원ID (MEMBER_ID) — VARCHAR2(30) — 외래 키 → MEMBER.회원ID
  • coupon_id (Key) — 외래 키 → coupon.coupon_id — NOT NULL