sadsa

Tables (8)

OneOnOne

  • one_no — number — Primary key — NOT NULL
  • member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
  • one_title — varchar2(100)
  • one_content — varchar2(4000)
  • one_date — date
  • one_status — number
  • one_category — varchar2(30)

Untitled

  • qna_no — number — Primary key — NOT NULL
  • qna_category — varchar2(30)
  • qna_title — varchar2(100)
  • qna_answer — varchar2(4000)

bascket

  • bascket_no — number — Primary key — NOT NULL
  • product_no — number — Foreign key → product.product_no — NOT NULL
  • member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
  • bascket_count — number

member

  • member_id — varchar2(20) — Primary key — NOT NULL
  • member_pw — varchar2(16)
  • member_name — varchar2(21)
  • member_email — varchr2(100)
  • member_contact — char(11)
  • member_post — varchar2(6)
  • member_addr1 — varchar2(300)
  • member_addr2 — varchar2(300)
  • member_birth — char(10)
  • member_point — number
  • member_level — varchar2(9)

notice

  • notice_no — number — Primary key — NOT NULL
  • notice_title — varchar2(100)
  • notice_writer — varchar2(9)
  • notice_date — date
  • notice_content — varchar2(4000)

payment

  • payment_no — number — Primary key — NOT NULL
  • product_no — number — Foreign key → product.product_no — NOT NULL
  • member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
  • payment_method — varchar2(15)
  • payment_request — varchar2(100)
  • payment_cancel — varchar2(30)

product

  • product_no — number — Primary key — NOT NULL
  • product_name — varchar2(900)
  • product_price — number
  • product_weight — number
  • product_origin — varchar2(21)
  • product_expire — char(10)

shopAfter

  • shopAfter_no — number — Primary key — NOT NULL
  • product_no — number — Foreign key → product.product_no — NOT NULL
  • member_id — varchar2(20) — Foreign key → member.member_id — NOT NULL
  • shopAfter_writer — varchar2(20)
  • shopAfter_content — varchar2(4000)
  • shopAfter_like — number
  • shopAfter_date — date