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)