Categories: All - settings - search - orders - transactions

by Oleg Rassadnikov 7 years ago

625

megazakaz db

The text provides detailed information on various aspects of logistics and business operations. It outlines the different transportation methods available for domestic and international shipping, specifying the associated icons, taxes, and delivery terms.

megazakaz db

Перевозчики (способы доставки по Украине и за границей)

transporter_international_type

tit_tax_type
tit_approximate_tax
tit_term_delivery
tit_icon
tit_name_ua
tit_name_ru
tit_id

transporter

tra_tax_type
tra_tax
tra_type
1- международная
0 - Украина
tra_link
tra_icon
tra_logo
tra_name_ua
tra_name_ru

Валюты и языки

country_currency

coc_accepted_methods
coc_course
coc_symbol
coc_icon
coc_country_name_ua
coc_country_name_ru
coc_currency_name_ua
coc_currency_name_ru
coc_id

megazakaz db

Front(Статические страницы, банера, акции)

delivery_method
dem_logo
dem_link
dem_name_ua
dem_name_ru
dem_type
dem_id
method_of_pay
mop_active
mop_logo
mop_link
mop_text_ua
mop_text_ru
mop_name_ua
mop_name_ru
mop_id
phone
pho_icon
pho_number
pho_id
warranty
war_icon
war_text_ua
war_text_ru
war_id
warranty_indicator
wai_text_ua
wai_text_ru
wai_name_ua
wai_name_ru
wai_id
mini_message
heirdom
mim_page_id[]
mim_window

old

new

mim_link
mim_text_ua
mim_text_ru
mim_id
help_category
hec_name_ua
hec_name_ru
hec_id
page
pag_main_show_hide
pag_help_show_hide
pag_type

photoPage

videoPhotoPage

videoPage

static

landing

pag_help_ua
pag_help_ru
pag_name_ua
pag_name_ru
pag_id
banner
ban_image
ban_window
ban_link
ban_type
ban_id

Настройки сайта

site_commission
sic_rule
sic_sum
sic_condition_ua
sic_condition_ru
sic_rate
sic_id
option_theme
oth_theme
oth_id
option
opt_value
opt_key
opt_theme_id
opt_description
opt_id

Финансовые операции,Выписки банка,Лог Операций пользователей

user_log_operation
ulo_additionally
ulo_text_opertion
ulo_user_id
ulo_type_operation
ulo_source_data
ulo_date
ulo_id
bank_statement
bas_source
bas_user_id
bas_name_ua
bas_name_ru
bas_date
bas_id
financial_operation
fio_transactions_id
fio_payment_info
fio_type_payment

Вывод

Пополнение

fio_bank_statements_id
fio_cash_account_id
fio_sum
fio_sum_uah
fio_date
fio_id

Счета, операции и транзакции

transaction_status
trs_name_ua
trs_name_ru
trs_id
transaction
tra_billing_information_html
tra_payment_system
tra_cash_account_id
tra_sum
tra_sum_uah
tra_status_id
tra_type_payment
tra_user_id
tra_date
tra_id
cash_account_type
cash_account_source
cas_name_ua
cas_name_ru
cas_id
cash_account
casa_original_cash_account
casa_system_calls_id
casa_user_comment
casa_paid_services
casa_services
casa_orders_id[]
casa_packages_id
casa_paid_sum
casa_paid_sum_uah
casa_sum
casa_billing_information
casa_payment_system
casa_maturity_date
casa_status

Отменен

Не погашен

Погашен

casa_type_id
casa_user_id
casa_source_id
casa_date
casa_number
casa_id

Контекстная информация по разделам личного кабинета

contextual_information_cabinet
cic_data_type
cic_scope
cic_text_ua
cic_text_ru
cic_title_ua
cic_title_ru
cic_id

Подписная база данных

user_subscribe
uss_registration_ip
uss_date_registration
uss_date_last_change
uss_subsrible_sourse_id
uss_commercial_interests[]
uss_last_purchase_days
uss_purchase_frequency_day
uss_average_check
uss_amount_purchases
uss_sum_purchases
uss_email
uss_phone[]
uss_name
uss_user_id
user_сommercial_interest
uci_titles_and_weight_interests
uci_date_visit
uci_cookie_id
uci_user_id
uci_id

Типы заявок и их статусы - ???

status_order
sto_sort_order
sto_name
sto_type_id
type_order
tyo_hide
tyo_user_edit_id
tyo_user_processing_id
tyo_user_read_id
tyo_name
tyo_id

Отзывы жалобы и обращения клиентов

t_status_complaint
stc_sort
stc_name_ua
stc_name_ru
stc_id
t_sample_ansver
sama_text
sama_title
sama_type_id
sama_id
t_ansver_type
ant_employees_id_hide[]
ant_employees_id_edit[]
ant_employees_id_work[]
ant_employees_id_reed[]
ant_name
ant_id
t_attachment_message_complaint
atmc_url_file
atmc_complaints_id
atmc_id
t_chain_message_complaint
cmc_is_delivered_letter
cmc attachments_id
cmc_date
cmc_text
cmc_title
cmc_ansver_type_id
cmc_id
t_complaint_client
comc_match_complaints
comc_type
comc_employee_id
comc_user_id
comc_topic_text
comc_date
comc_num_order
comc_status_id
comc_number_bid
comc_id
t_client_review
clr_importance
clr_moderation
clr_ shortened_text
clr_text
clr_user_country
clr_user_id
clr_date_review
clr_date_purchase
cir_shop_id
clr_product_link
clr_product_image
clr_product_name
clr_id

Магазины, склады, бренды

storehouse
sto_address
sto_name_ua
sto_name_ru
sto_country_currency_id
sto_zip
sto_city
sto_id
brand
bra_info_ua
bra_info_ru
bra_country_currency_id
bra_link
bra_logo
bra_name_ua
bra_name_ru
bra_id
shop_news_and_action
sna_gallery[]
sna_preview_image
sna_text_ua
sna_text_ru
sna_short_description_ua
sna_short_description_ru
sna_name_ua
sna_name_ru
sna_type

1 - actions

0 - news

sna_created_on
sna_shop_id
sna_id
shop(ebay, amazon, ....)
sho_tax
sho_type
sho_info_ua
sho_info_ru
sho_country_icon
sho_country_currency_id
sho_link
sho_slogan_ua
sho_slogan_ru
sho_logo
sho_name_ua
sho_name_ru
sho_id

Категории и товары

parametr_description
pad_transporters_id
pad_name_ua
pad_name_ru
pad_name_original
pad_country_currency_id
pad_name_api
pad_shop_id
pad_id
products
category_extends
cae_edit_status
cae_edit_employee_id
cae_edit_date
cae_filters_sort[]
seo_text_ua
seo_text_ru
seo_description_ua
seo_description_ru
seo_keywords_ua
seo_keywords_ru
seo_title_ua
seo_title_ru
cae_category_id
cae_id
category
cat_type_source
cat_show_hide
cat_image
cat_name_en
cat_name_de
cat_name_ua
cat_name_ru
cat_type_category

2.ebay

1.amazon

cat_country_currency_id
cat_main
cat_id

Посылки, заказы, аукционы пользователей

catalog_data_number
cdn_element_id
cdn_type
cdn_number
cdn_id
order_auction_item
oai_check_on_odessa_storehouse
oai_item_id
oai_auction_id
oai_category_id
oai_image
oai_paid_item_cost_uah
oai_paid_item_cost
oai_paid_item_clearance_uah
oai_paid_item_clearance
oai_paid_item_commission_uah
oai_paid_item_commission
oai_paid_delivery_cost_uah
oai_paid_delivery_cost
oai_paid_seller_price_uah
oai_paid_seller_price
oai_item_cost
oai_item_clearance
oai_item_commission
oai_delivery_cost
oai_seller_price
oai_item_features
oai_parametrs_description
oai_parametrs_description_en
oai_type
oai_link
oai_name
oai_country_currency_id
oai_article
oai_api_seller_rate
oai_api_seller_id
oai_shop_id
oai_id
auction
auc_date_end
auc_totalsum
auc_sum
auc_choky
auc_choky_percent
auc_commission
auc_commission_percent
auc_delivery_price
auc_max_bid
auc_current_bid
auc_count_items
auc_item_id
auc_status
auc_country_currecy_id
auc_user_id
auc_lot_number
auc_number
auc_id
order_account_redemption
orr_data
orr_login
orr_email
orr_id
service
ser_status
ser_price
ser_description
ser_name
ser_id
order
ord_api_transporters_id[]
ord_track_numbers[]
ord_complaints_clients_id
ord_paid_totalsum_uah
ord_paid_totalsum
ord_totalsum
ord_paid_services
ord_services
ord_paid_totalsum_items_uah
ord_paid_totalsum_items
ord_paid_sum_clearance_uah
ord_paid_sum_clearance
ord_paid_sum_commission_uah
ord_paid_sum_commission
ord_paid_sum_delivery_by_country_producer_uah
ord_paid_sum_delivery_by_country_producer
ord_paid_sum_prices_by_sellers_uah
ord_paid_sum_prices_by_sellers
ord_totalsum_items
ord_sum_clearance
ord_sum_commission
ord_sum_delivery_by_country_producer
ord_sum_prices_by_sellers
ord_count_active_items
ord_need_pay
ord_nomenclature
ord_storehouse_fact_id
ord_storehouse_plan_id
ord_api_seller_id
ord_shop_id
ord_country_currency_id
ord_status_date
ord_status
ord_type
ord_number
ord_id
package
pac_required_tactic
pac_complaints_clients_id
pac_paid_totalsum_delivery_package_uah
pac_paid_totalsum_delivery_package
pac_paid_delivery_rate
pac_paid_weight_package
pac_paid_totalsum_orders_uah
pac_paid_totalsum_orders
pac_paid_sum_services_uah
pac_paid_sum_services
pac_paid_sum_clearance_uah
pac_paid_sum_clearance
pac_paid_sum_commission_uah
pac_paid_sum_commission
pac_paid_sum_delivery_by_country_producer_uah
pac_paid_sum_delivery_by_country_producer
pac_paid_sum_prices_by_sellers_uah
pac_paid_sum_prices_by_sellers
pac_totalsum_delivery_package_uah
pac_totalsum_delivery_package
pac_delivery_rate
pac_weight
pac_totalsum_orders_uah
pac_totalsum_orders
pac_sum_services
pac_sum_clearance
pac_sum_commission
pac_sum_delivery_by_country_producer
pac_sum_prices_by_sellers
pac_status_proring
pac_currency_course_miscalculation
pac_status_miscalculation
pac_number_delivery_note
pac_users_delivery_address_id
pac_type_orders_delivery
pac_country_currency_id
pac_orders_id[]
pac_user_id
pac_status_date
pac_status
pac_number
pac_id

Поисковые запросы пользователей

search_graph
seg_ves
seg_rebro
id_search_key
seg_id
search_key
sek_key
sek_id

Контакты с клиентами

сontact_with_user
cwu_message
cwu_gist_id
cwu_source_id
cwu_type_id
cwu_date
cwu_user_id
cwu_id

Сотрудники и пользователи

employee_group
emg_options
emg_name_ua
emg_name_ru
emg_id
employee
emp_employees_groups_id
emp_pass
emp_email
emp_fio
emp_id
user_delivery_address
uda_main_delivery_address
uda_delivery_address
uda_delivery_type
uda_city
uda_user_id
uda_fio
uda_id
user_status
lock_access
lock removal
uss_name_ua
uss_name_ru
uss_id
user
use_block_delivery
use_personal_options
use_personal_commission_rate
amount_transactions
use_status_id
use_balance
use_social_of
use_social_gp
use_social_fb
use_social_vk
use_other_info(array)
use_email_check(true|false)
use_mail[]
use_phone_check(true|false)
use_phone[]
use_fio
use_name
use_id