ABCMART
Tables (9)
TB_CARTS (장바구니)
- CART_NO (장바구니번호) — NUMBER — Primary key — NOT NULL
- PRODUCT_DETAIL_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
- MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
- PRODUCT_AMOUNT (상품수량) — NUMBER
TB_MEMBERS (회원)
- MEMBER_NO — NUMBER — Primary key — NOT NULL
- MEMBER_NAME — VERCHAR2
- MEMBER_ID (아이디) — VERCHAR2
- MEMBER_PWD (비밀번호) — VERCHAR2
- MEMBER_EMAIL (이메일) — VERCHAR2
- MEMBER_TEL (전화번호) — VERCHAR2
- MEMBER_ADDRESS (주소) — VERCHAR2
- MEMBER_PCT (포인트) — NUMBER
- MEMBER_REGISTERED_DATE (회원등록일) — DATE
- MEMBER_DELETED (탈퇴) — VERCHAR2
- MEMBER_DELETED_DATE (탈퇴날짜) — DATE
TB_ORDERS (주문)
- ORDER_NO (주문번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
- ORDER_STATUS (주문상태) — VERCHAR2
- ORDER_DATE (주문날짜) — VERCHAR2
- ORDER_TOTAL_PRICE (총 결제금액) — NUMBER
- CANCEL_REASON (취소사유) — VERCHAR2
- CANCEL_STATUS (취소상태) — VERCHAR2
- CANCELED_DATE (취소날짜) — VERCHAR2
TB_ORDER_ITEM (주문상품)
- ORDER_NO (주문번호) — NUMBER — Foreign key → TB_ORDERS.ORDER_NO — NOT NULL
- PRODUCT_DETAIL_NO (재고번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
- PRODUCT_AMOUNT (상품수량) — NUMBER
- REVIEW_STAUTS (리뷰상태) — VERCHAR2
TB_PRODUCT (상품)
- PRODUCT_NO (상품번호) — NUMBER — Primary key — NOT NULL
- PRODUCT_CATEGORY (카테고리)
- PROUDCT_NAME (상품명) — VERCHAR2
- PRODUCT_IMG (이미지) — VERCHAR2
- PRODUCT_BRAND (브랜드) — VERCHAR2
- PRODUCT_PRICE (가격) — NUMBER
- PRODUCT_DISPRICE (할인가격) — NUMBER
- PRODUCT_GENDER (성별) — VERCHAR2
- PRODUCT_CREATED_DATE (등록일) — NUMBER
TB_PRODUCT_STOCKS (재고테이블)
- PRODUCT_DETAIL_NO (재고번호) — NUMBER — Primary key — NOT NULL
- PRODUCT_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT.PRODUCT_NO — NOT NULL
- PRODUCT_SIZE (사이즈) — NUMBER
- PRODUCT_STORCK (수량) — NUMBER
TB_QNA (q&a)
- QUESTION_NO (QNA번호) — NUMBER — Primary key — NOT NULL
- PRODUCT_NO (상품번호) — NUMBER — Foreign key → TB_PRODUCT.PRODUCT_NO — NOT NULL
- MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
- QUESTION_TITLE (제목) — VERCHAR2
- QUESTION_CONTENT (내용) — VERCHAR2
- QUESTION_DATE (등록일) — VERCHAR2
- QUESTION_ANSWERED (답변여부) — VERCHAR2
- ANSWERED_CONTENT (답변내용)
TB_REVIEWS (리뷰)
- REVEIW_NO (리뷰번호) — NUMBER — Primary key — NOT NULL
- PRODUCT_DETAIL_NO (재고번호) — NUMBER — Foreign key → TB_PRODUCT_STOCKS.PRODUCT_DETAIL_NO — NOT NULL
- MEMBER_NO — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
- REVIEW_CONTENT (리뷰내용) — VERCHAR2
- REVIEW_LIKE_COUNT (좋아요) — NUMBERR
- REVIEW_DATE (등록일) — SYSDATE
- REVIEW_DELETED (삭제여부) — VERCHAR2
TB_REVIEW_LIKERS (좋아요)
- MEMBER_NO (회원번호) — NUMBER — Foreign key → TB_MEMBERS.MEMBER_NO — NOT NULL
- REVEIW_NO (리뷰번호) — Foreign key → TB_REVIEWS.REVEIW_NO — NOT NULL