toy-project

Tables (8)

CATEGORY (상품-카테고리)

  • CAREGORY_ID (Key) — INT — Primary key — NOT NULL
  • NAME (카테고리명)
  • PARENT (부모인덱스) — INT

MEMBER (회원)

  • ID (Key) — BIGINT — Primary key — NOT NULL
  • EMAIL (이메일) — VARCHAR(100)
  • PASSWORD (패스워드) — VARCHAR(50)
  • NAME (이름) — VARCHAR(10)
  • PHONE (휴대폰번호) — VARCHAR(15)
  • ROLE (역할) — VARCHAR(10)
  • REG_DT (등록일) — DATETIME
  • MOD_DT (수정일) — DATETIME

ORDER (주문)

  • ORDER_ID (Key) — BIGINT — Primary key — NOT NULL
  • MEMBER_ID (회원ID) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
  • RCPNT_NAME (이름) — VARCHAR(10)
  • RCPNT_ADDRESS (주소) — VARCHAR(100)
  • RCPNT_PHONE (휴대폰번호) — VARCHAR(15)
  • COMMENTS (요청사항) — VARCHAR(100)
  • TOTAL_PRICE (합계금액) — INT
  • REG_DT (주문일시) — DATETIME
  • MOD_DT (수정일) — DATETIME

ORDER_EVENT (주문 이벤트)

  • ORDER_EVENT_ID (Key) — BIGINT — Primary key — NOT NULL
  • ORDER_ID (주문아이디) — BIGINT — Foreign key → ORDER.ORDER_ID — NOT NULL
  • STATUS_CD (상태코드) — CHAR(3)
  • REG_DT (등록시각) — DATETIME

ORDER_EVENT_PAYMENT (주문 결제)

  • ORDER_EVENT_PAYMENT_ID (Key) — BIGINT — Primary key — NOT NULL
  • ORDER_EVENT_ID (주문이벤트ID) — BIGINT — Foreign key → ORDER_EVENT.ORDER_EVENT_ID — NOT NULL
  • METHOD_CD (결제수단코드) — CHAR(3) — 정수 OR 바차
  • PAYMENT_PRICE (결제금액) — INT

ORDER_ITEM (주문 상세)

  • ORDER_ITEM_ID (Key) — Primary key — NOT NULL
  • ORDER_ID (주문ID) — BIGINT — Foreign key → ORDER.ORDER_ID — NOT NULL
  • PRODUCT_ID (상품ID) — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • PRODUCT_NAME (상품명)
  • PRODUCT_PRICE (상품가격)
  • PAYMENT_PRICE (결제금액)
  • QUANTITY (수량) — INT
  • FREE_DELIVERY_YN (무료배송여부)
  • DELIVERY_FEE (배송료)

PRODUCT (상품)

  • PRODUCT_ID (Key) — BIGINT — Primary key — NOT NULL
  • CATEGORY_ID (카테고리ID) — INT — Foreign key → CATEGORY.CAREGORY_ID — NOT NULL
  • NAME (상품명) — VARCHAR(100)
  • QUANTITY (수량) — INT
  • PRICE (가격) — INT
  • FREE_DELIVERY_YN (무료배송여부) — VARCHAR(1)
  • DELIVERY_FEE (배송료) — INT
  • SCORE (평점) — DECIMAL(4,2)
  • VIEW_CNT (조회수)
  • DEL_YN (삭제여부) — CHAR(1)
  • REG_DT (등록일) — DATETIME
  • MOD_DT (수정일) — DATETIME

REVIEW (상품평)

  • REVIEW_ID (Key) — Primary key — NOT NULL
  • MEMBER_ID (회원ID) — BIGINT — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCT_ID (상품ID) — BIGINT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • SCORE (점수) — TINYINT
  • COMMENTS (평가코멘트) — VARCHAR(300)
  • DEL_YN (삭제여부) — CHAR(1)
  • REG_DT (등록일) — DATETIME
  • MOD_DT (수정일) — DATETIME