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)