megazakaz db

Больше похоже на это

Chapter2 Transaction Processing in the AIS

от SISI YANG

System map

от Khanh Nguyen

SSP Flow Control

от vyshnavi chutti

Skateboard

от Bajwa Tanya

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

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

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

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

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

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