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)