Test

Tables (14)

tbl_addr

  • addr_no — NUMBER
  • user_id — VARCHAR2(100)
  • postCode — varchar2(100)
  • roadAddr — varchar2(100)
  • detailAddr — varchar2(100)
  • addr_name — varchar2(100)

tbl_cart

  • cart_no — NUMBER
  • cart_mem_id — VARCHAR(100)
  • cart_pro_no — VARCHAR(100)
  • cart_cnt — NUMBER(38)

tbl_client

  • client_no — number(38)
  • client_title — varchar2(100) — NOT NULL
  • contact_password — varchar2(100) — NOT NULL
  • client_cont — varchar2(4000) — NOT NULL
  • client_cont_reply — varchar2(4000)
  • client_category — varchar2(50) — NOT NULL
  • client_date — date
  • user_id — varchar2(100) — NOT NULL

tbl_faq

  • faq_no — number(38)
  • faq_category — varchar2(100) — NOT NULL
  • faq_title — varchar2(1000) — NOT NULL
  • faq_cont — varchar2(4000) — NOT NULL

tbl_like

  • like_no — NUMBER
  • like_mem_id — VARCHAR(100)
  • like_pro_no — VARCHAR(100)

tbl_member

  • user_no — number(38)
  • user_id — varchar2(100)
  • user_pwd — varchar2(100)
  • user_name — varchar2(100)
  • user_birth — varchar2(100)
  • user_gender — varchar2(50)
  • postcode — varchar2(100)
  • roadAddr — varchar2(100)
  • detailAddr — varchar2(100)
  • user_email — varchar2(100)
  • user_phone — varchar2(100)
  • user_state — number(38)
  • join_date — date
  • del_date — date
  • del_cont — varchar2(2000)
  • mail_key — varchar2(100)
  • mail_auth — number(38)

tbl_notice

  • notice_no — number(38)
  • notice_title — varchar2(1000) — NOT NULL
  • notice_cont — varchar2(4000) — NOT NULL
  • notice_date — date

tbl_order

  • order_no — NUMBER(38)
  • order_product_title — VARCHAR2(100)
  • order_date — DATE
  • order_cnt — NUMBER
  • order_invoice — VARCHAR2(100)
  • order_total — NUMBER(38)
  • user_id — VARCHAR2(100)

tbl_order_detail

  • order_detail_no — NUMBER
  • order_no — NUMBER(38)
  • order_detail_mid — VARCHAR2(100)
  • order_detail_fno — NUMBER(38)
  • order_detail_cnt — VARCHAR2(100)

tbl_product

  • product_no — number(38)
  • product_title — varchar2(100) — NOT NULL
  • product_price — varchar2(4000) — NOT NULL
  • product_maker — varchar2(100) — NOT NULL
  • product_type — varchar2(100) — NOT NULL
  • product_type2 — varchar2(100) — NOT NULL
  • product_cont1 — varchar2(4000) — NOT NULL
  • product_cont2 — varchar2(4000)
  • product_cont3 — varchar2(4000)
  • product_cont4 — varchar2(4000)
  • product_cont5 — varchar2(4000) — NOT NULL
  • product_cont6 — varchar2(4000)
  • product_cont7 — varchar2(4000)
  • product_cont8 — varchar2(4000)
  • product_score — varchar2(100)
  • product_count — varchar2(1000)
  • product_date — date

tbl_product_qna

  • qna_no — NUMBER
  • qna_product_no — NUMBER(38)
  • qna_mem_id — VARCHAR2(100)
  • qna_title — VARCHAR2(100)
  • qna_content — VARCHAR2(100)
  • qna_reply — VARCHAR2(100)
  • qna_date — date

tbl_reviews

  • re_no — NUMBER
  • re_pro_no — VARCHAR2(10)
  • re_mem_id — VARCHAR2(100)
  • re_title — VARCHAR2(100)
  • re_content — VARCHAR2(4000)
  • re_image1 — VARCHAR2(4000)
  • re_image2 — VARCHAR2(4000)
  • re_image3 — VARCHAR2(4000)
  • re_star — NUMBER(38)
  • re_date — DATE

test_chatmessage

  • roomId — varchar2(50)
  • writer — varchar2(50)
  • message — varchar2(4000)

test_chatroom

  • roomId — varchar2(500)
  • name — varchar2(500)