Dog project

Tables (50)

Admin (관리자)

  • admin_no (관리자 번호) — NUMBER — Primary key — NOT NULL
  • admin_id (관리자 아이디) — VARCHAR2(20)
  • admin_pw (관리자 비밀번호) — VARCHAR2(20)
  • admin_name (관리자 이름) — VARCHAR2(20)
  • admin_hiredate (관리자 입사일) — DATE

Order (주문)

  • order_no (주문번호) — NUMBER — Primary key — NOT NULL
  • customer_no (PK) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • order_status_no (주문상태코드) — NUMBER — Foreign key → order_status.order_status_no — NOT NULL
  • order_payment_method (결제수단) — VARCHAR2(100)
  • order_payment_credit (적립되는 금액) — NUMBER
  • order_discount (할인금액) — NUMBER
  • order_date (주문일) — DATE

biz (판매자)

  • biz_no (판매자 번호) — NUMBER — Primary key — NOT NULL
  • biz_id (아이디(사업자번호)) — VARCHAR2(10)
  • biz_pw (비밀번호) — VARCHAR2(100)
  • biz_name (브랜드명) — VARCHAR2(100)
  • biz_phone (연락처) — VARCHAR2(100)
  • biz_email (이메일) — VARCHAR2(100)
  • biz_main_img (메인이미지) — VARCHAR2(100)
  • biz_address (사업장 소재지) — VARCHAR2(100)
  • biz_status (입점상태(승인 여부)) — NUMBER
  • biz_commission (수수료) — NUMBER
  • biz_reg_date (가입일) — DATE
  • biz_auth_date (승인일) — DATE

biz_list (브랜드찜)

  • biz_list_no (브랜드찜) — NUMBER — Primary key — NOT NULL
  • customer_no (PK) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • biz_no (판매자 번호) — NUMBER — Foreign key → biz.biz_no — NOT NULL
  • biz_list_reg_date (등록일) — DATE

cart (장바구니)

  • cart_no (장바구니pk) — NUMBER — Primary key — NOT NULL
  • customer_no (PK) — NUMBER — Foreign key → customer.customer_no — NOT NULL

cart_list (장바구니 담긴 상품)

  • cart_list_no (장바구니 담긴 상품 pk) — NUMBER — Primary key — NOT NULL
  • cart_no (장바구니pk) — NUMBER — Foreign key → cart.cart_no — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_amount (수량) — NUMBER
  • cart_product_add_date (담은 날짜) — DATE

community_board (게시판)

  • community_board_no (글번호) — NUMBER — Primary key — NOT NULL
  • community_board_category_no (카테고리 번호) — NUMBER — Foreign key → community_board_category.community_board_category_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • community_board_title (글제목) — VARCHAR2(100)
  • community_board_content (글내용) — VARCHAR2(1000)
  • community_board_read_count (조회수) — NUMBER
  • community_board_reg_date (등록일) — DATE

community_board_category (게시판 카테고리)

  • community_board_category_no (카테고리 번호) — NUMBER — Primary key — NOT NULL
  • community_board_category_name (카테고리 이름) — VARCHAR(20)

community_board_comment (게시판 댓글)

  • community_board_comment_no (댓글번호) — NUMBER — Primary key — NOT NULL
  • community_board_no (글번호) — NUMBER — Foreign key → community_board.community_board_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • community_board_comment_content (댓글 내용) — VARCHAR2(1000)
  • community_board_comment_reg_date (날짜) — DATE

community_board_images (게시판 첨부 사진)

  • community_board_images_no (pk) — NUMBER — Primary key — NOT NULL
  • community_board_no (글번호) — NUMBER — Foreign key → community_board.community_board_no — NOT NULL
  • community_board_image_link (이미지 주소) — VARCHAR2(100)

community_board_like (게시글 좋아요)

  • community_board_like_no (pk) — NUMBER — Primary key — NOT NULL
  • community_board_no (글번호) — NUMBER — Foreign key → community_board.community_board_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL

community_board_report (게시판 신고)

  • community_board_report_no (신고번호) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • community_board_no (글번호) — NUMBER — Foreign key → community_board.community_board_no — NOT NULL
  • report_category_no (신고사유번호) — NUMBER — Foreign key → report_category.report_category_no — NOT NULL
  • community_board_report_content (신고 내용) — VARCHAR2(1000)
  • community_board_report_date (신고일) — DATE

coupon_discount_type (쿠폰할인방식)

  • coupon_discount_type_no (쿠폰할인방식번호) — NUMBER — Primary key — NOT NULL
  • coupon_discount_type_name (쿠폰할인방식이름) — VARCHAR2(20)

coupon_list (고객 쿠폰함)

  • coupon_list_no (쿠폰함 번호) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • Field

coupon_target (쿠폰 적용대상)

  • coupon_target_no (쿠폰적용대상 번호) — NUMBER — Primary key — NOT NULL
  • coupon_target_name (쿠폰적용대상) — VARCHAR2(100)

coupon_template (쿠폰 템플릿)

  • coupon_template_no (쿠폰 템플릿 번호) — NUMBER — Primary key — NOT NULL
  • coupon_target_no (쿠폰적용대상 번호) — NUMBER — Foreign key → coupon_target.coupon_target_no — NOT NULL
  • coupon_discount_type_no (쿠폰할인방식번호) — NUMBER — Foreign key → coupon_discount_type.coupon_discount_type_no — NOT NULL
  • coupon_template_target_no (쿠폰적용대상코드) — NUMBER
  • coupon_image (쿠폰 이미지) — VARCHAR2(100)
  • coupon_name (쿠폰 이름) — VARCHAR2(20)
  • coupon_description (쿠폰 내용) — VARCHAR2(100)
  • coupon_issue_date (쿠폰 발급일) — DATE
  • coupon_expire_date (쿠폰 만료일) — DATE
  • coupon_start_date (쿠폰시작일) — DATE
  • coupon_template_discount_ratio (쿠폰할인율/금액) — NUMBER
  • coupon_template_minimum_order_price (최소주문금액) — NUMBER
  • coupon_template_max_discount_price (최대할인금액) — NUMBER

cs_inquiry (1대1문의)

  • cs_inquiry_no (문의번호) — NUMBER — Primary key — NOT NULL
  • cs_inquiry_category_no (문의유형번호) — NUMBER — Foreign key → cs_inquiry_category.cs_inquiry_category_no — NOT NULL
  • customer_no (PK) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • cs_inquiry_title (문의 제목) — VARCHAR(20)
  • cs_inquiry_context (문의내용) — VARCHAR2(1000)
  • cs_inquiry_date (문의날짜) — DATE

cs_inquiry_category (문의유형)

  • cs_inquiry_category_no (문의유형번호) — NUMBER — Primary key — NOT NULL
  • cs_inquiry_name (문의유형) — VARCHAR2(20)

cs_inquiry_files (1대1문의 파일첨부)

  • cs_inquiry_files_no (pk) — NUMBER — Primary key — NOT NULL
  • cs_inquiry_no (문의번호) — NUMBER — Foreign key → cs_inquiry.cs_inquiry_no — NOT NULL
  • cs_inquiry_files_link (파일주소) — VARCHAR2(100)

cs_inquiry_reply (1대1문의 답변)

  • cs_inquiry_reply_no (답변번호) — NUMBER — Primary key — NOT NULL
  • admin_no (관리자 번호) — NUMBER — Foreign key → Admin.admin_no — NOT NULL
  • cs_inquiry_no (문의번호) — NUMBER — Foreign key → cs_inquiry.cs_inquiry_no — NOT NULL
  • cs_inquiry_reply_context (답변내용) — VARCHAR2(1000)
  • cs_inquiry_reply_date (답변일) — DATE

customer (고객)

  • customer_no (고객번호) — NUMBER — Primary key — NOT NULL
  • customer_id (아이디(이메일)) — VARCHAR2(100)
  • customer_pw (비밀번호) — VARCHAR2(100)
  • customer_name (이름) — VARCHAR2(100)
  • customer_birth (생년월일) — DATE
  • customer_nickname (닉네임) — VARCHAR2(100)
  • customer_gender (성별) — VARCHAR2(1)
  • customer_credit (적립금) — NUMBER
  • customer_phone (연락처) — VARCHAR2(100)
  • customer_status (인증 여부) — VARCHAR2(1)
  • customer_update (수정일) — DATE
  • customer_reg_date (가입일) — DATE

customer_address (고객 주소록)

  • customer_address_no (고객주소번호) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • customer_address_name (배송지명) — VARCHAR2(100)
  • customer_receiver_name (수령인) — VARCHAR2(100)
  • customer_address (도로명 주소) — VARCHAR2(100)
  • customer_detail_address (상세주소) — VARCHAR2(100)
  • customer_address_phone (연락처) — VARCHAR2(100)

dog (고객 반려견)

  • dog_no (반려견 번호) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • dog_breed_no (견종 번호) — NUMBER — Foreign key → dog_breed.dog_breed_no — NOT NULL
  • dog_name (반려견 이름) — VARCHAR2(20)
  • dog_gender (반려견 성별) — VARCHAR2(1)
  • dog_image (반려견 사진) — VARCHAR2(100)
  • dog_weight (반려견 몸무게) — NUMBER
  • dog_introduction (반려견 소개) — VARCHAR2(100)
  • dog_birth (반려견 생일) — DATE
  • dog_profile_id (반려견 스냅 아이디) — VARCHAR2(100)

dog_breed (견종)

  • dog_breed_no (견종 번호) — NUMBER — Primary key — NOT NULL
  • dog_breed_name (품종) — VARCHAR2(50)

hashtag (해쉬태그)

  • hashtag_no (해쉬태그 번호) — NUMBER — Primary key — NOT NULL
  • hastag_name (해쉬태그명) — VARCHAR2(100)

main_category (메인카테고리)

  • main_category_no (pk) — NUMBER — Primary key — NOT NULL
  • main_category_name (카테고리명) — VARCHAR2(100)

order_product (주문상품)

  • order_product_no (주문상품pk) — NUMBER — Primary key — NOT NULL
  • order_no (주문번호) — NUMBER — Foreign key → Order.order_no — NOT NULL
  • refund_exchange_reason_no (사유 번호) — NUMBER — Foreign key → refund_exchange_reason.refund_exchange_reason_no — NOT NULL
  • order_product_status_no (주문상품상태pk) — NUMBER — Foreign key → order_product_status.order_product_status_no — NOT NULL
  • order_quantity (주문수량) — NUMBER
  • order_price (주문상품가격) — NUMBER
  • order_product_coupon_discount (쿠폰할인금액) — NUMBER

order_product_status (주문상품상태)

  • order_product_status_no (주문상품상태pk) — NUMBER — Primary key — NOT NULL
  • order_product_status_name (주문상품상태명) — VARCHAR2(100)

order_status (주문상태)

  • order_status_no (주문상태코드) — NUMBER — Primary key — NOT NULL
  • order_status_name (주문상태값) — VARCHAR2(100)

product (상품)

  • product_no (상품코드) — NUMBER — Primary key — NOT NULL
  • biz_no (판매자번호) — NUMBER — Foreign key → biz.biz_no — NOT NULL
  • sub_category_no (중분류 카테고리 번호) — NUMBER — Foreign key → sub_category.sub_category_no — NOT NULL
  • product_name (상품명) — VARCHAR2(100)
  • product_price (상품가격) — NUMBER
  • product_thumbnail (상품 대표이미지) — VARCHAR2(100)
  • product_description (상품 정보) — VARCHAR2(100)
  • product_status (품절 여부) — VARCHAR2(1)
  • product_quantity (상품 수량) — NUMBER
  • product_soldout (품절여부) — VARCHAR2(1)
  • product_reg_date (상품 등록일) — DATE

product inquriy (상품문의(고객))

  • product_inquiry_no (상품문의 번호) — NUMBER — Primary key — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_inquiry_context (상품문의내용) — VARCHAR2(1000)
  • product_inquiry_reg_date (문의일) — DATE
  • product_inquiry_reply_status (답변 여부) — VARCHAR2(1)
  • product_inquiry_is_public (공개여부) — VARCHAR2(1)

product_detail_image (상품 상세 이미지)

  • product_detail_image_no (상품 상세 이미지 pk) — NUMBER — Primary key — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_detail_image_link (이미지 주소) — VARCHAR2(100)

product_inquiry_reply (상품문의 답변(판매자))

  • product_inquiry_reply_no (답변pk) — NUMBER — Primary key — NOT NULL
  • product_inquiry_no (상품문의 번호) — NUMBER — Foreign key → product inquriy.product_inquiry_no — NOT NULL
  • product_inquiry_reply_context (답변내용) — VARCHAR2(1000)
  • product_inquiry_reply_date (답변일) — DATE

product_main_image (상품 메인 이미지)

  • product_main_image (상품 메인 이미지 pk) — NUMBER — Primary key — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_main_image_link (이미지 주소) — VARCHAR2(100)

product_review (상품리뷰)

  • product_review_no (상품리뷰pk) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • order_product_no (주문상품pk) — NUMBER — Foreign key → order_product.order_product_no — NOT NULL
  • product_review_context (리뷰내용) — VARCHAR2(2000)
  • product_review_rating (리뷰 별점) — NUMBER
  • product_review_reg_date (리뷰 작성일) — DATE

product_review_images (상품 리뷰 이미지)

  • product_review_images_no (pk) — NUMBER — Primary key — NOT NULL
  • product_review_no (상품리뷰pk) — NUMBER — Foreign key → product_review.product_review_no — NOT NULL
  • order_product_no (주문상품pk) — NUMBER — Foreign key → product_review.order_product_no — NOT NULL
  • customer_credit (적립금) — NUMBER — Foreign key
  • product_review_images_link (이미지 주소) — VARCHAR2(100)

product_review_likes (리뷰 좋아요)

  • product_review_likes (리뷰 좋아요pk) — NUMBER — Primary key — NOT NULL
  • product_review_no (상품리뷰pk) — NUMBER — Foreign key → product_review.product_review_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL

product_wish_list (상품찜)

  • product_wish_list_no (상품찜pk) — NUMBER — Primary key — NOT NULL
  • customer_no (PK) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_wish_list_reg_date (등록일) — DATE

refund_exchange_reason (환불/교환 사유)

  • refund_exchange_reason_no (사유 번호) — NUMBER — Primary key — NOT NULL
  • refund_exchange_reason_name (사유) — VARCHAR2(100)

report_category (신고 사유)

  • report_category_no (신고사유번호) — NUMBER — Primary key — NOT NULL
  • report_reason (신고사유) — VARCHAR2(100)

snap_board (커뮤니티(스냅))

  • snap_board_no (스냅 번호) — NUMBER — Primary key — NOT NULL
  • dog_no (반려견 번호) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_board_content (스냅 글 내용) — VARCHAR2(2000)
  • snap_board_view_count (조회수) — NUMBER
  • snap_board_reg_date (등록일) — DATE
  • snap_location (장소) — VARCHAR2(100)
  • snap_thumbnail (스냅 썸네일) — VARCHAR2(100)

snap_board_comment (스냅(댓글))

  • snap_board_comment_no (댓글번호) — NUMBER — Primary key — NOT NULL
  • dog_no (반려견 번호) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_board_comment_reply_no (답글번호) — NUMBER — Foreign key → snap_board_comment_reply.snap_board_comment_reply_no — NOT NULL
  • snap_board_comment_content (댓글내용) — VARCHAR2(1000)
  • snap_board_comment_reg_date (날짜) — DATE

snap_board_comment_reply (스냅댓글(답글))

  • snap_board_comment_reply_no (답글번호) — NUMBER — Primary key — NOT NULL
  • dog_no (반려견 번호) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_board_comment_reply_content (답글내용) — VARCHAR2(1000)
  • snap_board_comment_reply_reg_date (답글날짜) — DATE

snap_board_hashtag (스냅 해쉬태그)

  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL
  • hashtag_no (해쉬태그 번호) — NUMBER — Foreign key → hashtag.hashtag_no — NOT NULL

snap_board_likes (스냅 좋아요)

  • snap_board_likes_no (좋아요 pk) — NUMBER — Primary key — NOT NULL
  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL
  • dog_no (반려견 번호) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_board_like_date (날짜) — DATE

snap_dog_tag

  • snap_dog_tag_no (강아지 태그) — NUMBER — Primary key — NOT NULL
  • dog_no (반려견 번호) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL

snap_images (스냅 이미지들)

  • snap_images_no (이미지 등록번호) — NUMBER — Primary key — NOT NULL
  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL
  • snap_image_link (이미지 주소) — VARCHAR2(100)

snap_product_tag (스냅 상품 태그)

  • snap_product_tag (태그번호) — NUMBER — Primary key — NOT NULL
  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL
  • product_no (상품코드) — NUMBER — Foreign key → product.product_no — NOT NULL

snap_report (snap 신고)

  • snap_report_no (pk) — NUMBER — Primary key — NOT NULL
  • snap_report_category_no (신고사유번호) — NUMBER — Foreign key → report_category.report_category_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • snap_board_no (스냅 번호) — NUMBER — Foreign key → snap_board.snap_board_no — NOT NULL
  • snap_report_content (신고 내용) — VARCHAR2(1000)
  • snap_report_date (신고일) — DATE

sub_category (상세 카테고리)

  • sub_category_no (pk) — NUMBER — Primary key — NOT NULL
  • main_category_no (pk2) — NUMBER — Foreign key → main_category.main_category_no — NOT NULL
  • sub_category_name (상세카테고리명) — VARCHAR2(100)