SFC_20220127

Tables (12)

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)

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
  • q&a_comment (Field4) — VARCHAR2(4000)

member_cart (Untitled5)

  • wishlist_no (Key) — NUMVER — Primary key — NOT NULL
  • member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
  • product_no (Key3) — NUMVER — Foreign key → productinfo.product_no — NOT NULL

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
  • product_no (Key3) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
  • review_title (Field) — VARCHAR2(300)
  • review_content (Field2) — VARCHAR2(4000)
  • review_writedate (Field3) — DATE
  • review_comment (Field4) — VARCHAR2(4000)

member_review_imageboard (CopyOfUntitled12)

  • q&a_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_image (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_imageboard (Untitled14)

  • productinfo_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
  • product_no (Key2) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
  • productinfo_image_name (Field) — VARCHAR2(300)
  • productinfo_image_url (Field2) — VARCHAR2(1000)