aa
Tables (18)
cart
- cart_idx — number
- product_opt_idx — number — NOT NULL
- cart_value — varchar2(30) — NOT NULL
- product_count — number — NOT NULL
deliver_address
- user_id — varchar2(30) — NOT NULL
- user_address1 — varchar2(20) — NOT NULL
- user_address2 — varchar2(200) — NOT NULL
- user_address3 — varchar2(200) — NOT NULL
nonuserOrder_detail
- nonuserOrder_detail_idx — number
- product_opt_idx — number — NOT NULL
- nonuser_order_idx — number — NOT NULL
- product_count — number — NOT NULL
- product_price — number — NOT NULL
- order_detail_status — varchar2(50)
nonuserOrder_return
- nonuserOrder_return_idx — number
- nonuserOrder_detail_idx — number — NOT NULL
- returnType — varchar2(20) — NOT NULL
- return_reason — varchar2(3000) — NOT NULL
- bankName — varchar2(30)
- bankAccountName — varchar2(20)
- bankAccountNumber — number
nonuser_order
- nonuser_order_idx — number
- order_date — date — NOT NULL
- address1 — varchar2(20) — NOT NULL
- address2 — varchar2(50) — NOT NULL
- address3 — varchar2(50) — NOT NULL
- order_total_price — number — NOT NULL
- receiver_name — varchar2(20) — NOT NULL
- receiver_phone — varchar2(20) — NOT NULL
- nonuser_pwd — varchar2(255) — NOT NULL
- status_for_admin — varchar2(50)
notice
- notice_idx — number
- notice_writer — varchar2(100) — NOT NULL
- notice_title — varchar2(300) — NOT NULL
- notice_content — varchar2(4000) — NOT NULL
- notice_writeDate — date — NOT NULL
- show_check — varchar2(10)
- N)) — not — NOT NULL
product
- product_idx — number
- product_code — varchar2(20) — NOT NULL
- product_name — varchar2(200) — NOT NULL
- product_price — number — NOT NULL
- product_desc — varchar2(3000)
- product_date — date — NOT NULL
- product_hits — number — NOT NULL
- delete_check — varchar2(2) — NOT NULL
- show_check — varchar2(10) — NOT NULL
product_d_img
- product_d_img — varchar2(100) — NOT NULL
- product_idx — number — NOT NULL
product_opt
- product_opt_idx — number
- product_idx — number — NOT NULL
- product_size — varchar2(50) — NOT NULL
- product_color — varchar2(100) — NOT NULL
- product_stock — number — NOT NULL
product_review
- product_review_idx — number
- product_opt_idx — number — NOT NULL
- user_id — varchar2(30) — NOT NULL
- rate — number — NOT NULL
- content — varchar2(3000) — NOT NULL
- writing_date — date — NOT NULL
- delete_check — varchar2(2) — NOT NULL
product_t_img
- product_t_img — varchar2(100) — NOT NULL
- product_idx — number — NOT NULL
qna
- qna_idx — number
- user_id — varchar2(30) — NOT NULL
- qna_password — varchar2(100)
- qna_title — varchar2(300) — NOT NULL
- qna_content — varchar2(4000) — NOT NULL
- qna_writeDate — date — NOT NULL
- qna_secret — varchar2(10)
- N)) — NOT — NOT NULL
qna_reply
- qna_reply_idx — number
- qna_idx — number — NOT NULL
- content — varchar2(3000) — NOT NULL
- writing_date — date — NOT NULL
review_reply
- review_reply_idx — number
- product_review_idx — number — NOT NULL
- content — varchar2(3000) — NOT NULL
- writing_date — date — NOT NULL
userOrder_detail
- userOrder_detail_idx — number
- product_opt_idx — number — NOT NULL
- user_order_idx — number — NOT NULL
- product_count — number — NOT NULL
- product_price — number — NOT NULL
- order_detail_status — varchar2(50)
userOrder_return
- userOrder_return_idx — number
- userOrder_detail_idx — number — NOT NULL
- returnType — varchar2(20) — NOT NULL
- return_reason — varchar2(3000) — NOT NULL
- bankName — varchar2(30)
- bankAccountName — varchar2(20)
- bankAccountNumber — number
userTable
- user_id — varchar2(30) — NOT NULL
- user_idx — number — NOT NULL
- user_pwd — varchar2(255) — NOT NULL
- user_name — varchar2(20) — NOT NULL
- user_phone — varchar2(20) — NOT NULL
- user_email — varchar2(50) — NOT NULL
- email_check — varchar2(10)
- N)) — NOT — NOT NULL
- user_role — varchar2(20)
- user)) — NOT — NOT NULL
- user_grade — varchar2(20)
- gold)) — not — NOT NULL
- user_insertDate — date — NOT NULL
- user_birth — date — NOT NULL
- user_gender — varchar2(20)
- 남성)) — NOT — NOT NULL
user_order
- user_order_idx — number
- user_id — varchar2(30) — NOT NULL
- order_date — date — NOT NULL
- address1 — varchar2(20) — NOT NULL
- address2 — varchar2(50) — NOT NULL
- address3 — varchar2(50) — NOT NULL
- order_total_price — number — NOT NULL
- receiver_name — varchar2(20) — NOT NULL
- receiver_phone — varchar2(20) — NOT NULL
- status_for_admin — varchar2(50)