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