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