KOD

Tables (13)

ADDRESS (배송지 테이블)

  • ADDRESS_ID (배송지번호) — INT — Primary key
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ADDRESS_NAME (주소지 이름(별칭)) — VARCHAR(30)
  • ADDRESS_STREET (도로명주소) — VARCHAR(255)
  • ADDRESS_LAND (지번주소) — VARCHAR(255)
  • ADDRESS_DETAIL (상세주소) — VARCHAR(20)
  • ADDRESS_ZIPCODE (우편번호) — VARCHAR(20)

CART (장바구니 테이블)

  • CART_ID (장바구니번호) — INT — Primary key
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID (상품번호2) — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • CATEGORY_ID (카테고리 PK2) — INT — Foreign key → PRODUCT.CATEGORY_ID — NOT NULL
  • CART_PRODUCT_CNT (장바구니 상품수량) — INT

CATEGORY (카테고리 테이블)

  • CATEGORY_ID (카테고리 PK) — INT — Primary key — NOT NULL
  • CATEGORY_TYPE (카테고리 분류) — VARCHAR(20)

COUPON (쿠폰 테이블)

  • COUPON_ID (쿠폰 PK) — INT — Primary key — NOT NULL
  • COUPON_CONTENT (쿠폰설명) — VARCHAR(100)
  • COUPON_DISCOUNT_RATE (할인율) — INT
  • COUPON_DISCOUNT_MAX_PRICE (최대할인가격) — INT
  • COUPON_NAME (쿠폰이름) — VARCHAR(50)
  • COUPON_CODE (쿠폰코드) — VARCHAR(50)
  • COUPON_USE_DATE (쿠폰기간) — INT
  • COUPON_TYPE (쿠폰타입) — VARCHAR(50)
  • COUPON_USE_MIN_PRICE (쿠폰사용 최소금액) — INT

COUPON_CATEGORY (쿠폰 카테고리 테이블)

  • COUPON_CATEGORY_ID (쿠폰 카테고리 PK) — INT — Primary key — NOT NULL
  • CATEGORY_ID (카테고리 PK) — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • COUPON_ID (쿠폰 PK2) — INT — Foreign key → COUPON.COUPON_ID — NOT NULL

COUPON_STATUS (쿠폰상태 테이블)

  • COUPON_STATUS_ID (쿠폰상태PK) — INT — Primary key — NOT NULL
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • COUPON_ID (쿠폰 PK) — INT — Foreign key → COUPON.COUPON_ID — NOT NULL
  • ORDERCONTENT_ID (주문상세PK) — INT
  • COUPON_ISSUE_DATE (쿠폰발행일) — TIMESTAMP
  • COUPON_EXPIRE_DATE (쿠폰 만료일) — TIMESTAMP

IMAGE (이미지 테이블)

  • IMAGE_ID (이미지 PK) — INT — Primary key — NOT NULL
  • IMAGE_URL (이미지 경로) — VARCHAR(500)
  • IMAGE_CATEGORY (이미지 분류) — VARCHAR(20)
  • REVIEW_ID (리뷰번호) — INT — Foreign key → REVIEW.REVIEW_ID — NOT NULL
  • PRODUCT_ID (상품번호2) — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL

MEMBER (회원 테이블)

  • MEMBER_ID (회원ID) — VARCHAR(20) — Primary key — NOT NULL
  • MEMBER_PW (회원비밀번호) — VARCHAR(30)
  • MEMBER_NAME (회원이름) — VARCHAR(30)
  • MEMBER_EMAIL (이메일) — VARCHAR(30)
  • MEMBER_GRADE (등급) — VARCHAR(20)
  • MEMBER_ROLE (역할) — VARCHAR(20)
  • MEMBER_GENDER (성별) — VARCHAR(20)
  • MEMBER_BIRTH (생년월일) — VARCHAR(30)
  • MEMBER_PHONENUMBER (전화번호) — VARCHAR(20)
  • MEMBER_REGDATE (회원가입일) — TIMESTAMP

ORDERCONTENT (주문상세 테이블)

  • ORDERCONTENT_ID (상품별 주문번호) — INT — Primary key — NOT NULL
  • ORDERLIST_ID (주문번호2) — INT — Foreign key → ORDERLIST.ORDERLIST_ID
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → ORDERLIST.MEMBER_ID — NOT NULL
  • PRODUCT_ID (상품번호2) — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • CATEGORY_ID (카테고리 PK2) — INT — Foreign key → PRODUCT.CATEGORY_ID — NOT NULL
  • ORDERCONTENT_CNT (Field) — INT

ORDERLIST (주문번호 테이블)

  • ORDERLIST_ID (주문번호) — INT — Primary key
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • ORDERLIST_DATE (주문일시) — TIMESTAMP

PRODUCT (상품 테이블)

  • PRODUCT_ID (상품번호) — INT — Primary key — NOT NULL
  • CATEGORY_ID (카테고리 PK) — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • PRODUCT_NAME (상품명) — VARCHAR(50)
  • PRODUCT_BRAND (상품브랜드) — VARCHAR(30)
  • PRODUCT_INFO (상품정보) — VARCHAR(500)
  • PRODUCT_STOCK (상품재고) — INT
  • PRODUCT_PRICE (상품가격) — INT

REVIEW (리뷰 테이블)

  • REVIEW_ID (리뷰번호) — INT — Primary key — NOT NULL
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID (상품번호2) — INT — Foreign key → ORDERCONTENT.PRODUCT_ID — NOT NULL
  • ORDERCONTENT_ID (상품별 주문번호2) — INT — Foreign key → ORDERCONTENT.ORDERCONTENT_ID — NOT NULL
  • CATEGORY_ID (카테고리 PK2) — INT — Foreign key → ORDERCONTENT.CATEGORY_ID — NOT NULL
  • REVIEW_TITLE (리뷰 제목) — VARCHAR(100)
  • REVIEW_CONTENT (리뷰 내용) — VARCHAR(500)
  • REVIEW_DATE (리뷰 작성일시) — TIMESTAMP
  • REVIEW_SCORE (별점) — INT

WISHLIST (위시리스트 테이블)

  • WISHLIST_ID (위시리스트PK) — INT — Primary key
  • MEMBER_ID (회원ID) — VARCHAR(20) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • PRODUCT_ID (상품번호) — INT — Foreign key → PRODUCT.PRODUCT_ID — NOT NULL
  • CATEGORY_ID (카테고리 PK2) — INT — Foreign key → PRODUCT.CATEGORY_ID — NOT NULL
  • WISHLIST_ADDTIME (위시리스트 등록 시간) — TIMESTAMP