SFC_JBS

Tables (12)

Untitled (member_info)

  • Key (member_no) — INT — Primary key — NOT NULL
  • Field (member_id) — VARCHAR(100)
  • Field (member_pw) — VARCHAR(100)
  • Field (member_gender) — VARCHAR(1)
  • Field (member_birth) — DATETIME
  • Field (member_phone) — VARCHAR(40)
  • Field (member_email) — VARCHAR(100)
  • Field (member_joindate) — DATETIME
  • Field (member_address) — VARCHAR(1000)

Untitled (category)

  • Key (category_no) — INT — Primary key — NOT NULL
  • Field (category_name) — VARCHAR(100)

Untitled (product_option)

  • Key (option_no) — INT — Primary key — NOT NULL
  • Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (product_count) — INT
  • Field (option_name) — VARCHAR(300)

Untitled (product)

  • Key (product_no) — INT — Primary key — NOT NULL
  • Key (category_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (product_name) — VARCHAR(300)
  • Field (product_price) — INT
  • Field (product_saleprice) — INT
  • Field (product_content) — VARCHAR(4000)
  • Field (product_warning) — VARCHAR(4000)
  • Field (product_writedate) — DATETIME
  • Field (product_image) — VARCHAR(1000)

Untitled (cart)

  • Key (cart_no) — INT — Primary key — NOT NULL
  • Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL

Untitled (product_image)

  • Key (product_image_no) — INT — Primary key — NOT NULL
  • Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (product_image_url) — VARCHAR(1000)
  • Field (product_image_name) — VARCHAR(500)

Untitled (admin)

  • Key (admin_no) — INT — Primary key — NOT NULL
  • Field (admin_id) — VARCHAR(100)
  • Field (admin_pw) — VARCHAR(100)
  • Field (admin_nick) — VARCHAR(100)

Untitled (member_qna)

  • Key (qna_no) — INT — Primary key — NOT NULL
  • Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (category_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (qna_title) — VARCHAR(500)
  • Field (qna_content) — VARCHAR(4000)
  • Field (qna_writedate) — DATETIME
  • Field (qna_comment) — VARCHAR(4000)

Untitled (qna_image)

  • Key (qna_Image_no) — INT — Primary key — NOT NULL
  • Key (qna_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (qna_Image_url) — VARCHAR(1000)
  • Field (qna_Image_name) — VARCHAR(500)

Untitled2 (order)

  • Key (order_no) — INT — Primary key — NOT NULL
  • Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (option_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (order_date) — DATETIME
  • Field (order_price) — INT
  • Field (order_count) — INT
  • Field (order_payment) — VARCHAR(100)

Untitled2 (member_review)

  • Key (review_no) — INT — Primary key — NOT NULL
  • Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (review_title) — VARCHAR(500)
  • Field (review_content) — VARCHAR(4000)
  • Field (review_writedate) — DATETIME
  • Field (review_comment) — VARCHAR(4000)

Untitled2 (review_image)

  • Key (review_image_no) — INT — Primary key — NOT NULL
  • Key (review_no) — INT — Foreign key → Untitled2.Key — NOT NULL
  • Field (review_image_url) — VARCHAR(1000)
  • Field (review_image_name) — VARCHAR(500)