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