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