Definitions and explanations of all ecshop database tables

Database Structure Description

The database uses MySQL, 78 tables in total

Ecs_account_log: account change log (registered user recharge, payment, and other records)

Ecs_ad: advertisement table

Ecs_admin_action: Administrator permission table (128 function operations are defined)

Ecs_admin_log: Administrator operation log table

Ecs_admin_message: Administrator message table

Ecs_admin_user: System Administrator table

Ecs_adsense: JS serving outside the site

Ecs_ad_position: advertising position table

Ecs_affiliate_log: divided into record tables

Ecs_agency: office list

Ecs_area_region: region range table (such as distribution region)

Ecs_article: Document Table

Ecs_article_cat: Document category table

Ecs_attribute: extended attribute management table for various products

Ecs_auction_log: Auction activity bid record table

Ecs_auto_manage: automatic mounting/dismounting Management

Ecs_bonus_type: red packet type

Ecs_booking_goods: Out-of-stock registration

Ecs_brand: product brand table

Ecs_card: greeting card table

Ecs_cart: Shopping Cart

Ecs_category: product category table

Ecs_cat_recommend: Category of recommended products on the home page

Ecs_collect_goods: User item favorites table

Ecs_comment: User comment table

Ecs_crons: scheduled tasks

Ecs_email_list: email subscription table

Ecs_email_sendlist: List of emails to be sent

Ecs_error_log: Error Log

Ecs_exchange_goods: product list of point store

Ecs_favourable_activity: discount activity table

Ecs_feedback: user message table

Ecs_friend_link: Connection table

Ecs_goods: item table

Ecs_goods_activity: list of participating products (such as qibing, group buying, auction, and gift packs)

Ecs_goods_article: product related articles

Ecs_goods_attr: extended attribute table corresponding to the item

Ecs_goods_cat: Extended product category table

Ecs_goods_gallery: List of images corresponding to the product

Ecs_goods_type: All types of products on the website (such as cosmetics)

Ecs_group_goods: accessory item

Ecs_keywords: website search keyword table

Ecs_link_goods: Related Products

Ecs_mail_templates: Template table for sending emails

Ecs_member_price: Product member price list

Ecs_nav: navigation bar settings

Ecs_order_action: Order operation table

Ecs_order_goods: Order item table

Ecs_order_info: order information table

Ecs_pack: Product Packaging

Ecs_package_goods: Product table associated with Gift Packs

Ecs_payment: payment method table

Ecs_pay_log: Payment log

Ecs_plugins: plug-ins

Ecs_region: List of regions nationwide

Ecs_searchengine: Search Engine

Ecs_sessions: Website user session table

Ecs_sessions_data: user session data

Ecs_shipping: distribution method table

Ecs_shipping_area: Distribution Area table

Ecs_shop_config: website parameter configuration table

Ecs_snatch_log: log table

Ecs_stats: website Access History Table

Ecs_tag: cloud tag

Ecs_template: website template settings table

Ecs_topic: topic table

Ecs_users: Website member table

Ecs_user_account: Member recharge and withdrawal table

Ecs_user_address: member receiving Address Table

Ecs_user_bonus: User red packet table

Ecs_user_feed: User Training

Ecs_user_rank: Member level table

Ecs_virtual_card: virtual card

Ecs_volume_price: product discount price range

Ecs_vote: voting topic

Ecs_vote_log: voting log

Ecs_vote_option: voting item

Ecs_wholesale: wholesale solution table