Kategorier: Alla - settings - search - orders - transactions

av Oleg Rassadnikov för 8 årar sedan

706

megazakaz db

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