shop_2022/02/06

Tables (14)

admin (Untitled15)

  • admin_no (Key) — NUMVER — Primary key — NOT NULL
  • admin_id (Field) — VARCHAR2(100)
  • admin_pw (Field2) — VARCHAR2(100)
  • admin_nick (Field3) — VARCHAR2(100)

admin_Q&A _comment (Untitled6)

  • admin_q&a_comment_no (Key) — NUMBER — Primary key — NOT NULL
  • q&a_no (Key2) — NUMVER — Foreign key → member_Q&A.q&a_no — NOT NULL
  • q&a_comment_content (Field) — VARCHAR2(4000)
  • q&a_comment_writedate (Field2) — DATE

category (Untitled2)

  • category_no (Key) — NUMVER — Primary key — NOT NULL
  • category_name (Field6) — VARCHAR2(100)

member (Untitled)

  • member_no (Key) — NUMVER — Primary key — NOT NULL
  • member_id (Field) — VARCHAR2(100)
  • member_pw (Field2) — VARCHAR2(100)
  • member_gender (Field3) — VARCHAR2(1)
  • member_birth (Field4) — DATE
  • member_phone (Field5) — VARCHAR2(30)
  • member_email (Field6) — VARCHAR2(100)
  • member_joindate (Field7) — DATE
  • member_address (Field8) — VARCHAR2(500)

member_Q&A (Untitled10)

  • q&a_no (Key) — NUMVER — Primary key — NOT NULL
  • member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
  • category_no (Key3) — NUMVER — Foreign key → category.category_no — NOT NULL
  • q&a_title (Field) — VARCHAR2(300)
  • q&a_content (Field2) — VARCHAR2(4000)
  • q&a_writedate (Field3) — DATE

member_cart (Untitled5)

  • cart_no (Key) — NUMVER — Primary key — NOT NULL
  • member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
  • option_no (Field2) — NUMBER — Foreign key → product_option.option_no
  • order_count (Field) — NUMVER

member_order (Untitled9)

  • order_no (Key) — NUMVER — Primary key — NOT NULL
  • member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
  • option_no (Field5) — NUMBER — Foreign key → product_option.option_no
  • order_date (Field) — DATE
  • order_price (Field2) — NUMVER
  • order_count (Field3) — NUMVER
  • order_payment (Field4) — VARCHAR2(100)

member_q&a_imageboard (Untitled12)

  • q&a_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
  • q&a_no (Key2) — NUMVER — Foreign key → member_Q&A.q&a_no — NOT NULL
  • member_no (Key22) — NUMVER — Foreign key → member_Q&A.member_no — NOT NULL
  • category_no (Key3) — NUMVER — Foreign key → member_Q&A.category_no — NOT NULL
  • q&a_image_ name (Field) — VARCHAR2(300)
  • q&a_image_url (Field2) — VARCHAR2(1000)

member_review (Untitled11)

  • review_no (Key) — NUMVER — Primary key — NOT NULL
  • member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
  • order_no (Key3) — NUMVER — Foreign key → member_order.order_no — NOT NULL
  • review_value (Field) — VARCHAR2(300)
  • review_content (Field2) — VARCHAR2(4000)
  • review_writedate (Field3) — DATE

member_review_comment (Untitled7)

  • review_comment_no (Key) — NUMBER — Primary key — NOT NULL
  • review_no (Key2) — NUMVER — Foreign key → member_review.review_no — NOT NULL
  • order_no (Key3) — NUMVER — Foreign key → member_review.order_no — NOT NULL
  • review_comment_content (Field) — VARCHAR2(4000)
  • review_comment_writedate (Field2) — DATE

member_review_imageboard (CopyOfUntitled12)

  • review_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
  • review_no (Key2) — NUMVER — Foreign key → member_review.review_no — NOT NULL
  • review_image_ name (Field) — VARCHAR2(300)
  • review_image_url (Field2) — VARCHAR2(1000)

product_option (Untitled4)

  • option_no (Field) — NUMBER — Primary key
  • product_no (Key) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
  • option_name (Field2) — VARCHAR2(300)
  • product_count (Field4) — NUMBER

productinfo (Untitled3)

  • product_no (Key) — NUMVER — Primary key — NOT NULL
  • category_no (Key2) — NUMVER — Foreign key → category.category_no — NOT NULL
  • product_name (Field) — VARCHAR2(300)
  • product_thumbnail (Field2) — VARCHAR2(300)
  • product_price (Field3) — NUMVER
  • product_saleprice (Field4) — NUMVER
  • product_writedate (Field5) — DATE
  • product_content (Field6) — VARCHAR2(4000)
  • product_warning (Field9) — VARCHAR2(4000)

productinfo_image (Untitled14)

  • product_image_no (Key) — NUMVER — Primary key — NOT NULL
  • product_no (Key2) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
  • product_image_name (Field) — VARCHAR2(300)
  • product_image_url (Field2) — VARCHAR2(1000)