dog

Tables (32)

address (Untitled3)

  • address_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • address_detail_address (Field) — VARCHAR2(400)
  • address_address (우편번호) — VARCHAR2(400)
  • address_recent_shipping_date (Field2) — DATE

cart (Untitled12)

  • cart_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL

cart_product (Untitled13)

  • cart_product_no (Key) — NUMBER — Primary key — NOT NULL
  • cart_no (Key2) — NUMBER — Foreign key → cart.cart_no — NOT NULL
  • product_no (Key3) — NUMBER — Foreign key → product.product_no — NOT NULL
  • cart_product_reg_date (Field) — DATE
  • cart_product_quantity (Field2) — NUMBER

coupon_range (Untitled29)

  • coupon_range_no (Key) — NUMBER — Primary key — NOT NULL
  • coupon_range_name (Field) — VARCHAR2(10)

coupon_template (Untitled30)

  • coupon_template_no (Key) — NUMBER — Primary key — NOT NULL
  • coupon_range_no (Key2) — NUMBER — Foreign key → coupon_range.coupon_range_no — NOT NULL
  • coupon_indentical_no (Field) — NUMBER
  • Field2

customer (Untitled)

  • customer_no (고객번호) — NUMBER — Primary key — NOT NULL
  • customer_id (고객아이디(이메일)) — VARCHAR2(100)
  • customer_pw (고객비밀번호) — VARCHAR2(100)
  • customer_name (고객이름) — VARCHAR2(10)
  • customer_gender (성별) — VARCHAR2(1)
  • customer_phone (핸드폰번호) — NUMBER
  • customer_reg_date (가입일) — DATE
  • customer_nickname (Field) — VARCHAR2(50)

discount_coupon (Untitled11)

  • discount_coupon_no (Key) — NUMBERR — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • discount_coupon_rate (Field) — NUMBER
  • discount_coupon_expiry_date (Field2) — DATE
  • discount_coupon_status (Field3) — VARCHAR2(20)
  • product_category_no (Key2) — NUMBER — Foreign key → product_category.product_category_no — NOT NULL
  • vender_no (판매자번호) — NUMBER — Foreign key → vender.vender_no — NOT NULL

dog (Untitled2)

  • dog_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • dog_breed_no (Key2) — NUMBER — Foreign key → dog_breed.dog_breed_no — NOT NULL
  • dog_name (Field) — VARCHAR2(30)
  • dog_gender (Field2) — VARCHAR2(1)
  • dog_birth (Field3) — DATE
  • dog_introduction (Field4) — VARCHAR2(3000)

dog_breed (Untitled26)

  • dog_breed_no (Key) — NUMBER — Primary key — NOT NULL
  • dog_breed_name (Field) — VARCHAR2(50)

dog_follow (Untitled25)

  • dog_follow_no (Key) — NUMBER — Primary key — NOT NULL
  • dog_no (Key3) — NUMBER — Primary key — NOT NULL
  • dog_no (팔로워) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • dog_breed_no (Key2) — NUMBER — Foreign key → dog.dog_breed_no — NOT NULL

order (Untitled7)

  • order_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • order_address (Field2) — VARCHAR2(400)
  • order_date (Field) — DATE
  • order_progress (Field3) — VARCHAR2(40)
  • order_total_price (Field4) — NUMBER
  • order_payment_method (Field5) — VARCHAR2(40)
  • order_shipping_tracking_no (Field6) — NUMBER

order_product (Untitled8)

  • order_product_no (Key) — NUMBER — Primary key — NOT NULL
  • order_no (Key2) — NUMBER — Foreign key → order.order_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → order.customer_no — NOT NULL
  • order_product_quantity (Field) — NUMBER
  • order_product_final_price (Field2) — NUMBER
  • order_product_discount_amount (Field3) — NUMBER

post (Untitled20)

  • post_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • post_category_no (Key2) — NUMBER — Foreign key → post_category.post_category_no — NOT NULL
  • post_title (Field) — VARCHAR2(100)
  • post_content (Field2) — VHARCHAR2(4000)
  • post_view (Field3) — NUMBER
  • post_reg_date (Field4) — DATE

post_category (Untitled21)

  • post_category_no (Key) — NUMBER — Primary key — NOT NULL
  • post_category_name (Field) — VARCHAR2(50)

post_comment (Untitled23)

  • post_comment_no (Key) — NUMBER — Primary key — NOT NULL
  • post_no (Key2) — NUMBER — Foreign key → post.post_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • post_comment_content (Field) — VARCHAR2(4000)
  • post_comment_reg_date (Field2) — DATE

post_file (Untitled22)

  • post_file_no (Key) — NUMBER — Primary key — NOT NULL
  • post_no (Key2) — NUMBER — Foreign key → post.post_no — NOT NULL
  • post_file_original_filename (Field) — VARCHAR2(500)
  • post_file_link (Field2) — VARCHAR2(500)

post_likes (Untitled24)

  • post_likes_no (Key2) — NUMBER — Primary key — NOT NULL
  • post_no (Key) — NUMBER — Foreign key → post.post_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • post_likes_reg_date (Field) — DATE

product (Untitled4)

  • product_no (Key) — NUMBER — Primary key — NOT NULL
  • product_category_no (Key2) — NUMBER — Foreign key → product_category.product_category_no — NOT NULL
  • vender_no (고객번호) — NUMBER — Foreign key → vender.vender_no — NOT NULL
  • product_title (Field) — VARCHAR2(80)
  • product_description (Field2) — VARCHAR2(1000)
  • product_price (Field3) — NUMBER
  • product_stock_quantity (Field4) — NUMBER
  • reg_date (Field5) — DATE

product_category (Untitled5)

  • product_category_no (Key) — NUMBER — Primary key — NOT NULL
  • product_category_name (Field) — VARCHAR2(50)

product_detail_image (Untitled6)

  • product_detail_image_no (Key3) — NUMBER — Primary key — NOT NULL
  • product_no (Key) — NUMBER — Foreign key → product.product_no — NOT NULL
  • vender_no (고객번호) — NUMBER — Foreign key → product.vender_no — NOT NULL
  • product_detail_image_link (Field) — VARCHAR2(400)

product_main_image (CopyOfUntitled6)

  • product_main_image_no (Key3) — NUMBER — Primary key — NOT NULL
  • product_no (Key) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_main_image_link (Field) — VARCHAR2(400)

product_wishlist (Untitled9)

  • product_wishlist_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • product_no (Key2) — NUMBER — Foreign key → product.product_no — NOT NULL
  • product_wishlist_reg_date (Field) — DATE

review (Untitled27)

  • review_no (Key) — NUMBER — Primary key — NOT NULL
  • order_product_no (Key2) — NUMBER — Foreign key → order_product.order_product_no — NOT NULL
  • order_no (Key22) — NUMBER — Foreign key → order_product.order_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → order_product.customer_no — NOT NULL
  • review_content (Field) — VARCHAR2(4000)
  • review_rating (Field2) — NUMBER
  • review_reg_date (Field3) — DATE

review_image (Untitled28)

  • review_image_no (Key) — NUMBER — Primary key — NOT NULL
  • review_no (Key2) — NUMBER — Foreign key → review.review_no — NOT NULL
  • order_product_no (Key22) — NUMBER — Foreign key → review.order_product_no — NOT NULL
  • review_image_original_filename (Field) — VARCHAR2(400)
  • review_image_link (Field2) — VARCHAR2(400)

snap (Untitled14)

  • snap_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (스냅작성자번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • snap_content (Field) — VARCHAR2(4000)
  • snap_reg_date (Field2) — DATE
  • snap_view (Field3) — NUMBER
  • snap_location (Field4) — VARCHAR2(100)

snap_comment (Untitled18)

  • snap_comment_no (Key) — NUMBER — Primary key — NOT NULL
  • snap_no (Key2) — NUMBER — Foreign key → snap.snap_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • snap_commnet_content (Field) — VARCHAR2(4000)
  • snap_comment_reg_date (Field2) — DATE

snap_comment_reply (Untitled19)

  • snap_comment_reply_no (Key) — NUMBER — Primary key — NOT NULL
  • snap_comment_no (Key2) — NUMBER — Foreign key → snap_comment.snap_comment_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • snap_comment_reply_content (Field) — VARCHAR2(4000)
  • snap_comment_reply_reg_date (Field2) — DATE

snap_dog_tag (Untitled15)

  • snap_dog_tag_no (Key) — NUMBER — Primary key — NOT NULL
  • dog_no (Key2) — NUMBER — Foreign key → dog.dog_no — NOT NULL
  • snap_no (Key3) — NUMBER — Foreign key → snap.snap_no — NOT NULL

snap_likes (Untitled17)

  • snap_likes_no (Key) — NUMBER — Primary key — NOT NULL
  • snap_no (Key2) — NUMBER — Foreign key → snap.snap_no — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • snap_likes_reg_date (Field) — DATE

snap_product_tag (Untitled16)

  • snap_product_tag_no (Key) — NUMBER — Primary key — NOT NULL
  • product_no (Key2) — NUMBER — Foreign key → product.product_no — NOT NULL
  • snap_no (Key3) — NUMBER — Foreign key → snap.snap_no — NOT NULL

vender (CopyOfUntitled)

  • vender_no (판매자번호) — NUMBER — Primary key — NOT NULL
  • vender_id (판매자사업자번호) — VARCHAR2(100)
  • vender_pw (판매자비밀번호) — VARCHAR2(100)
  • vender_name (판매자이름) — VARCHAR2(10)
  • vender_phone (핸드폰번호) — NUMBER
  • vender_reg_date (가입일) — DATE
  • vender_store_name (스토어이름) — VARCHAR2(50)

vender_wishlist (Untitled10)

  • vender_wishlist_no (Key) — NUMBER — Primary key — NOT NULL
  • customer_no (고객번호) — NUMBER — Foreign key → customer.customer_no — NOT NULL
  • vender_no (판매자번호) — NUMBER — Foreign key → vender.vender_no — NOT NULL
  • vender_wishlist_reg_date (Field) — DATE