aasdf

Tables (16)

address

  • address_no — NUMBER
  • address_detail — VARCHAR2(500) — NOT NULL
  • address_basic — VARCHAR2(500) — NOT NULL
  • address_zip_num — VARCHAR2(500) — NOT NULL
  • address_representative — NUMBER
  • address_user_no — NUMBER — NOT NULL

admin_date_log

  • admin_log_no — NUMBER
  • admin_no — NUMBER
  • admin_log_last_date — DATE

admin_login

  • admin_no — NUMBER
  • admin_id — VARCHAR2(100) — NOT NULL
  • admin_pw — VARCHAR2(100) — NOT NULL
  • admin_reg_date — DATE

ask_list

  • ask_list_no — NUMBER
  • ask_list_user_no — NUMBER — NOT NULL
  • ask_list_select_no — NUMBER — NOT NULL
  • ask_list_content — VARCHAR2(4000) — NOT NULL
  • ask_list_reg_date — DATE
  • ask_list_update_date — DATE
  • ask_list_reply_content — VARCHAR2(4000)

basket

  • basket_no — NUMBER
  • basket_product_name — varchar2(1000)
  • basket_product_no — NUMBER — NOT NULL
  • basket_user_no — NUMBER — NOT NULL
  • basket_quantity — NUMBER — NOT NULL
  • basket_price — NUMBER — NOT NULL

board

  • board_no — NUMBER
  • board_title — VARCHAR2(60) — NOT NULL
  • board_content — VARCHAR2(4000) — NOT NULL
  • board_views — NUMBER
  • board_reg_date — DATE
  • board_up_date — DATE
  • board_user_no — NUMBER — NOT NULL
  • board_category_no — NUMBER — NOT NULL

boardImage

  • board_image_no — NUMBER
  • board_image_uuid — VARCHAR2(1000)
  • board_board_no — NUMBER — NOT NULL
  • board_thumbnail — NUMBER

category

  • category_no — NUMBER
  • category_major_title — VARCHAR2(60) — NOT NULL
  • category_minor_title — VARCHAR2(60) — NOT NULL
  • category_reg_date — DATE

duck_order

  • order_no — NUMBER
  • order_product_no — NUMBER — NOT NULL
  • order_num — NUMBER — NOT NULL
  • order_user_no — NUMBER — NOT NULL
  • order_reg_date — DATE
  • order_quantity — NUMBER — NOT NULL
  • order_price — NUMBER — NOT NULL
  • order_status — VARCHAR2(100)
  • order_recipient_name — VARCHAR2(100) — NOT NULL
  • order_recipient_tel — NUMBER — NOT NULL
  • order_address_zip_num — NUMBER — NOT NULL
  • order_address_basic — VARCHAR2(1000) — NOT NULL
  • order_address_detail — VARCHAR2(1000) — NOT NULL
  • order_payment_method — VARCHAR2(100) — NOT NULL
  • order_return_bank — VARCHAR2(100)
  • order_return_account — NUMBER

duck_user

  • user_no — NUMBER
  • user_id — VARCHAR2(100) — NOT NULL
  • user_pw — VARCHAR2(150) — NOT NULL
  • user_nickname — VARCHAR2(200) — NOT NULL
  • user_name — VARCHAR2(100) — NOT NULL
  • user_tel — VARCHAR2(100) — NOT NULL
  • user_admin_check — NUMBER
  • user_session_id — VARCHAR2(300)
  • user_cookie_expire_date — DATE
  • user_email — VARCHAR2(500)
  • user_profile_path — VARCHAR2(500)
  • user_profile_folder — VARCHAR2(500)
  • user_profile_file_name — VARCHAR2(1000)
  • user_profile_file_real_name — VARCHAR2(500)

favorite

  • favorite_no — NUMBER
  • favorite_category_no — NUMBER — NOT NULL
  • favorite_user_no — NUMBER — NOT NULL

notice

  • notice_no — NUMBER
  • notice_title — VARCHAR2(60) — NOT NULL
  • notice_content — VARCHAR2(4000) — NOT NULL
  • notice_views — NUMBER
  • notice_reg_date — DATE
  • notice_up_date — DATE

product

  • product_no — NUMBER
  • product_name — VARCHAR2(100) — NOT NULL
  • product_price_normal — NUMBER — NOT NULL
  • product_price_selling — NUMBER
  • product_detail — VARCHAR2(2000)NOT — NOT NULL
  • product_stock — NUMBER — NOT NULL
  • product_reg_date — DATE
  • product_up_date — DATE
  • product_category_no — NUMBER — NOT NULL

product_image

  • product_image_no — NUMBER
  • product_image_path — VARCHAR2(100) — NOT NULL
  • product_image_folder — VARCHAR2(100) — NOT NULL
  • product_image_file_name — VARCHAR2(100) — NOT NULL
  • prodcut_image_file_real_name — VARCHAR2(100) — NOT NULL
  • product_image_product_no — NUMBER
  • product_thumbnail — NUMBER

reply

  • reply_no — NUMBER
  • reply_content — VARCHAR2(4000) — NOT NULL
  • reply_reg_date — DATE
  • reply_up_date — DATE
  • reply_board_no — NUMBER — NOT NULL
  • reply_user_no — NUMBER — NOT NULL

replyLike

  • like_no — NUMBER
  • like_reply_no — NUMBER — NOT NULL
  • like_user_no — NUMBER — NOT NULL
  • like_state — NUMBER