megazakaz db
Сотрудники и пользователи
user
use_id
use_name
use_fio
use_phone[]
use_phone_check(true|false)
use_mail[]
use_email_check(true|false)
use_other_info(array)
use_social_vk
use_social_fb
use_social_gp
use_social_of
use_balance
use_status_id
amount_transactions
use_personal_commission_rate
use_personal_options
use_block_delivery
user_status
uss_id
uss_name_ru
uss_name_ua
lock removal
lock_access
user_delivery_address
uda_id
uda_fio
uda_user_id
uda_city
uda_delivery_type
uda_delivery_address
uda_main_delivery_address
employee
emp_id
emp_fio
emp_email
emp_pass
emp_employees_groups_id
employee_group
emg_id
emg_name_ru
emg_name_ua
emg_options
Контакты с клиентами
сontact_with_user
cwu_id
cwu_user_id
cwu_date
cwu_type_id
cwu_source_id
cwu_gist_id
cwu_message
Поисковые запросы пользователей
search_key
sek_id
sek_key
search_graph
seg_id
id_search_key
seg_rebro
seg_ves
Посылки, заказы, аукционы пользователей
package
pac_id
pac_number
pac_status
pac_status_date
pac_user_id
pac_orders_id[]
pac_country_currency_id
pac_type_orders_delivery
pac_users_delivery_address_id
pac_number_delivery_note
pac_status_miscalculation
pac_currency_course_miscalculation
pac_status_proring
pac_sum_prices_by_sellers
pac_sum_delivery_by_country_producer
pac_sum_commission
pac_sum_clearance
pac_sum_services
pac_totalsum_orders
pac_totalsum_orders_uah
pac_weight
pac_delivery_rate
pac_totalsum_delivery_package
pac_totalsum_delivery_package_uah
pac_paid_sum_prices_by_sellers
pac_paid_sum_prices_by_sellers_uah
pac_paid_sum_delivery_by_country_producer
pac_paid_sum_delivery_by_country_producer_uah
pac_paid_sum_commission
pac_paid_sum_commission_uah
pac_paid_sum_clearance
pac_paid_sum_clearance_uah
pac_paid_sum_services
pac_paid_sum_services_uah
pac_paid_totalsum_orders
pac_paid_totalsum_orders_uah
pac_paid_weight_package
pac_paid_delivery_rate
pac_paid_totalsum_delivery_package
pac_paid_totalsum_delivery_package_uah
pac_complaints_clients_id
pac_required_tactic
order
ord_id
ord_number
ord_type
ord_status
ord_status_date
ord_country_currency_id
ord_shop_id
ord_api_seller_id
ord_storehouse_plan_id
ord_storehouse_fact_id
ord_nomenclature
ord_need_pay
ord_count_active_items
ord_sum_prices_by_sellers
ord_sum_delivery_by_country_producer
ord_sum_commission
ord_sum_clearance
ord_totalsum_items
ord_paid_sum_prices_by_sellers
ord_paid_sum_prices_by_sellers_uah
ord_paid_sum_delivery_by_country_producer
ord_paid_sum_delivery_by_country_producer_uah
ord_paid_sum_commission
ord_paid_sum_commission_uah
ord_paid_sum_clearance
ord_paid_sum_clearance_uah
ord_paid_totalsum_items
ord_paid_totalsum_items_uah
ord_services
ord_paid_services
ord_totalsum
ord_paid_totalsum
ord_paid_totalsum_uah
ord_complaints_clients_id
ord_track_numbers[]
ord_api_transporters_id[]
service
ser_id
ser_name
ser_description
ser_price
ser_status
order_account_redemption
orr_id
orr_email
orr_login
orr_data
auction
auc_id
auc_number
auc_lot_number
auc_user_id
auc_country_currecy_id
auc_status
auc_item_id
auc_count_items
auc_current_bid
auc_max_bid
auc_delivery_price
auc_commission_percent
auc_commission
auc_choky_percent
auc_choky
auc_sum
auc_totalsum
auc_date_end
order_auction_item
oai_id
oai_shop_id
oai_api_seller_id
oai_api_seller_rate
oai_article
oai_country_currency_id
oai_name
oai_link
oai_type
oai_parametrs_description_en
oai_parametrs_description
oai_item_features
oai_seller_price
oai_delivery_cost
oai_item_commission
oai_item_clearance
oai_item_cost
oai_paid_seller_price
oai_paid_seller_price_uah
oai_paid_delivery_cost
oai_paid_delivery_cost_uah
oai_paid_item_commission
oai_paid_item_commission_uah
oai_paid_item_clearance
oai_paid_item_clearance_uah
oai_paid_item_cost
oai_paid_item_cost_uah
oai_image
oai_category_id
oai_auction_id
oai_item_id
oai_check_on_odessa_storehouse
catalog_data_number
cdn_id
cdn_number
cdn_type
cdn_element_id
Категории и товары
category
cat_id
cat_main
cat_country_currency_id
cat_type_category
cat_name_ru
cat_name_ua
cat_name_de
cat_name_en
cat_image
cat_show_hide
cat_type_source
category_extends
cae_id
cae_category_id
seo_title_ru
seo_title_ua
seo_keywords_ru
seo_keywords_ua
seo_description_ru
seo_description_ua
seo_text_ru
seo_text_ua
cae_filters_sort[]
cae_edit_date
cae_edit_employee_id
cae_edit_status
products
parametr_description
pad_id
pad_shop_id
pad_name_api
pad_country_currency_id
pad_name_original
pad_name_ru
pad_name_ua
pad_transporters_id
Магазины, склады, бренды
shop(ebay, amazon, ....)
sho_id
sho_name_ru
sho_name_ua
sho_logo
sho_slogan_ru
sho_slogan_ua
sho_link
sho_country_currency_id
sho_country_icon
sho_info_ru
sho_info_ua
sho_type
sho_tax
shop_news_and_action
sna_id
sna_shop_id
sna_created_on
sna_type
0 - news
1 - actions
sna_name_ru
sna_name_ua
sna_short_description_ru
sna_short_description_ua
sna_text_ru
sna_text_ua
sna_preview_image
sna_gallery[]
seo_title_ru
seo_title_ua
seo_keywords_ru
seo_keywords_ua
seo_description_ru
seo_description_ua
brand
bra_id
bra_name_ru
bra_name_ua
bra_logo
bra_link
bra_country_currency_id
bra_info_ru
bra_info_ua
storehouse
sto_id
sto_city
sto_zip
sto_country_currency_id
sto_name_ru
sto_name_ua
sto_address
Отзывы жалобы и обращения клиентов
t_client_review
clr_id
clr_product_name
clr_product_image
clr_product_link
cir_shop_id
clr_date_purchase
clr_date_review
clr_user_id
clr_user_country
clr_text
clr_ shortened_text
clr_moderation
clr_importance
t_complaint_client
comc_id
comc_number_bid
comc_status_id
comc_num_order
comc_date
comc_topic_text
comc_user_id
comc_employee_id
comc_type
comc_match_complaints
t_chain_message_complaint
cmc_id
cmc_ansver_type_id
cmc_title
cmc_text
cmc_date
cmc attachments_id
cmc_is_delivered_letter
t_attachment_message_complaint
atmc_id
atmc_complaints_id
atmc_url_file
t_ansver_type
ant_id
ant_name
ant_employees_id_reed[]
ant_employees_id_work[]
ant_employees_id_edit[]
ant_employees_id_hide[]
t_sample_ansver
sama_id
sama_type_id
sama_title
sama_text
t_status_complaint
stc_id
stc_name_ru
stc_name_ua
stc_sort
Типы заявок и их статусы - ???
type_order
tyo_id
tyo_name
tyo_user_read_id
tyo_user_processing_id
tyo_user_edit_id
tyo_hide
status_order
sto_id
sto_type_id
sto_name
sto_sort_order
Подписная база данных
user_сommercial_interest
uci_id
uci_user_id
uci_cookie_id
uci_date_visit
uci_titles_and_weight_interests
user_subscribe
uss_id
uss_user_id
uss_name
uss_phone[]
uss_email
uss_sum_purchases
uss_amount_purchases
uss_average_check
uss_purchase_frequency_day
uss_last_purchase_days
uss_commercial_interests[]
uss_subsrible_sourse_id
uss_date_last_change
uss_date_registration
uss_registration_ip
Контекстная информация по разделам личного кабинета
contextual_information_cabinet
cic_id
cic_title_ru
cic_title_ua
cic_text_ru
cic_text_ua
cic_scope
cic_data_type
Счета, операции и транзакции
cash_account
casa_id
casa_number
casa_date
casa_source_id
casa_user_id
casa_type_id
casa_status
casa_maturity_date
casa_payment_system
casa_billing_information
casa_sum
casa_paid_sum_uah
casa_paid_sum
casa_packages_id
casa_orders_id[]
casa_services
casa_paid_services
casa_user_comment
casa_system_calls_id
casa_original_cash_account
cash_account_source
cas_id
cas_name_ru
cas_name_ua
cash_account_type
cat_id
cat_name_ru
cat_name_ua
transaction
tra_id
tra_date
tra_user_id
tra_type_payment
tra_status_id
tra_sum_uah
tra_sum
tra_cash_account_id
tra_payment_system
tra_billing_information_html
transaction_status
trs_id
trs_name_ru
trs_name_ua
Финансовые операции,Выписки банка,Лог Операций пользователей
financial_operation
fio_id
fio_date
fio_sum_uah
fio_sum
fio_cash_account_id
fio_bank_statements_id
fio_type_payment
fio_payment_info
fio_transactions_id
bank_statement
bas_id
bas_date
bas_name_ru
bas_name_ua
bas_user_id
bas_source
user_log_operation
ulo_id
ulo_date
ulo_source_data
ulo_type_operation
ulo_user_id
ulo_text_opertion
ulo_additionally
Настройки сайта
option
opt_id
opt_description
opt_theme_id
opt_key
opt_value
option_theme
oth_id
oth_theme
site_commission
sic_id
sic_rate
sic_condition_ru
sic_condition_ua
sic_sum
sic_rule
Front(Статические страницы, банера, акции)
banner
ban_id
ban_type
ban_link
ban_window
ban_image
page
pag_id
pag_name_ru
pag_name_ua
pag_help_ru
pag_help_ua
pag_type
pag_help_show_hide
pag_main_show_hide
help_category
hec_id
hec_name_ru
hec_name_ua
mini_message
mim_id
mim_text_ru
mim_text_ua
mim_link
mim_window
mim_page_id[]
heirdom
warranty_indicator
wai_id
wai_name_ru
wai_name_ua
wai_text_ru
wai_text_ua
warranty
war_id
war_text_ru
war_text_ua
war_icon
phone
pho_id
pho_number
pho_icon
method_of_pay
mop_id
mop_name_ru
mop_name_ua
mop_text_ru
mop_text_ua
mop_link
mop_logo
mop_active
delivery_method
dem_id
dem_type
dem_name_ru
dem_name_ua
dem_link
dem_logo
Валюты и языки
country_currency
coc_id
coc_currency_name_ru
coc_currency_name_ua
coc_country_name_ru
coc_country_name_ua
coc_icon
coc_symbol
coc_course
coc_accepted_methods
Перевозчики (способы доставки по Украине и за границей)
transporter
tra_id
tra_name_ru
tra_name_ua
tra_logo
tra_icon
tra_link
tra_type
0 - Украина
1- международная
tra_tax
tra_tax_type
transporter_international_type
tit_id
tit_name_ru
tit_name_ua
tit_icon
tit_term_delivery
tit_approximate_tax
tit_tax_type