물리 스키마

테이블 (7)

BOARD (게시글)

  • MEMBER_ID (회원아이디) — VARCHAR2(100) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
  • BOARD_NUMBER (글번호) — NUMBER
  • BOARD_TITLE (글제목) — VARCHAR2(200)
  • BOARD_CONTENT (글내용) — VARCHER2(1000)
  • REG_DATE (작성일자) — DATE

CLOTHING PRODUCTS (의류상품)

  • PRODUCTS NUMBER (상품번호) — NUMBER — 기본 키 — NOT NULL
  • PRODUCTS NAME (상품멍) — VARCHAR2(500)
  • SIZE (사이즈) — VARCHAR2(100)
  • COLOR (칼라) — VARCHAR2(200)
  • INVENTORY (재고량) — NUMBER
  • UNIT PRICE (단가) — NUMBER

EXCHANGE_ORDER (교환주문)

  • EXCHANGE_NUMBER (교환 주문번호) — NUMBER — 기본 키 — NOT NULL
  • EXCHANGE_ORDER (교환주문) — NUMBER — 외래 키 → ORDER.EXCHANGE_ORDER — NOT NULL
  • REFUND_ORDER (환불주문) — NUMBER — 외래 키 → ORDER.REFUND_ORDER — NOT NULL
  • EXCHANGE_REASON (교환사유) — VARCHER2(1000)
  • EXCHANGE_COLOR (교환 색상) — VARCHAR2(200)
  • EXCHANGE_SIZE (교환 사이즈) — VARCHAR2(100)
  • EXCHANGE_QUANTITY (교환수량) — NUMBER
  • EXCHANGE_ADDERESS (교환 배송지) — VARCHER2(1000)
  • EXCHANGE_DATE (교환일자) — DATE

MANUFACTURER (제조업체)

  • MANUFACTURER_NAME (제조업체명) — VARCHAR2(100)
  • MANUFACTURER_PHONE (제조업체 전화번호) — NUMBER
  • MANUFACTURER_ADDRESS (제조업체 주소) — VARCHER2(1000)
  • MANAGER (담당자) — VARCHAR2(200)
  • PRODUCTS NUMBER (상품번호) — NUMBER — 외래 키 → CLOTHING PRODUCTS.PRODUCTS NUMBER — NOT NULL

MEMBER (회원)

  • MEMBER_ID (회원아이디) — VARCHAR2(100) — 기본 키 — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR2(200)
  • NAME (이름) — VARCHAR2(200)
  • AGE (나이) — NUMBER
  • ADDRESS (주소) — VARCHER2(1000)
  • PHONE (전화번호) — NUMBER
  • RATING (등급) — VARCHAR2(100)
  • RESERVES (적립금) — NUMBER

ORDER (주문)

  • EXCHANGE_ORDER (교환주문) — NUMBER — 기본 키 — NOT NULL
  • REFUND_ORDER (환불주문) — NUMBER — 기본 키 — NOT NULL
  • ORDER_NUMBER (주문번호) — NUMBER
  • ORDER_COLOR (주문 색상) — VARCHAR2(200)
  • ORDER_SIZE (주문 사이즈) — VARCHAR2(100)
  • ORDER_QUANTITY (주문수량) — NUMBER
  • ORDER_ADDRESS (배송주소) — VARCHER2(1000)
  • PRODUCTS NUMBER (상품번호) — NUMBER — 외래 키 → CLOTHING PRODUCTS.PRODUCTS NUMBER — NOT NULL
  • MEMBER_ID (회원아이디) — VARCHAR2(100) — 외래 키 → MEMBER.MEMBER_ID — NOT NULL

REFUND_ORDER (환불주문)

  • REFUND_NUMBER (환불 주문번호) — NUMBER — 기본 키 — NOT NULL
  • EXCHANGE_ORDER (교환주문) — NUMBER — 외래 키 → ORDER.EXCHANGE_ORDER — NOT NULL
  • REFUND_ORDER (환불주문) — NUMBER — 외래 키 → ORDER.REFUND_ORDER — NOT NULL
  • REFUND_REASON (환불 사유) — VARCHER2(1000)
  • REFUND_COLOR (환불 색상) — VARCHAR2(200)
  • REFUND_SIZE (환불 사이즈) — VARCHAR2(100)
  • REFUND_QUANTITY (환불 수량) — NUMBER
  • REFUND_ADDERESS (환불 주소) — VARCHER2(1000)
  • REFUND_DATE (환불 일자) — DATE