Ecshop table structure

Ecshop Data Structure

Ecs_account_log // user account log table
Ecs_activity // activity table (Code, name, start, end, description)
Ecs_ad // ad table (location, type, name, Link, image, start, end, advertiser information, click,
Display or not)
Ecs_admin_action // manage permission allocation (parent class ID, permission code)
Ecs_admin_log // manage logs (logon time, logon administrator ID, operation description, IP address)
Ecs_admin_message // administrator message (sender ID, receiver ID, sending date, reading date, whether
Read, whether to delete, title, content)
Ecs_admin_user // administrator management (username, email, password, add time, last login time, last
Login IP address, permissions, etc)
Ecs_adsense // ad statistics (source AD, source location, click)
Ecs_ad_position // ad space (name, width, height, description, style)
Ecs_area_region // distribution region Association (distribution region ID, specific address ID)
Ecs_article // article (Category ID, title, content, author, author email, keyword, type, whether to display,
Add time, file address, open type)
Ecs_article_cat // document category (name, type, keyword, description, sorting, navigation display or not)
Ecs_attribute // product attributes (category, name, select style, type, value, search type, sorting, whether or not
Connections)
Ecs_bonus_type // red envelope (name, amount, payment start date, payment end date, use start date to make
End Date, payment type, minimum amount (issued by order), and maximum amount)
Ecs_booking_goods // out-of-stock registration (User ID registration, email, phone number, product ID, description, quantity, login)
Recording time, whether it has been processed, handling administrator, processing time, and handling remarks)
Ecs_brand // brand (name, logo, description, Link, sort, whether to display)
Ecs_card // Greeting Card (name, picture, cost, free quota, description)
Ecs_cart // shopping cart (User ID, session_id, product ID, product ID, product name, market price, purchase
Price, quantity, attribute, true product, extended code, parent class ID, type, gift, whether to handle)
Ecs_category // product category (name, keyword, description, parent class ID, sorting, whether subclass exists, template file,
Quantity Unit, whether to display by navigation)
Ecs_collect_goods // Add to Favorites (User ID, item ID, and collection time)
Ecs_comment // comment (type, type ID, email, user name, content, rating, add time, IP address, Form
State, parent class ID)
Ecs_feedback // user message (parent class ID, user ID, user name, email, title, type, content, time,
Image, whether to reply)
Ecs_friend_link // link (name, Link, logo, sorting)
Ecs_gift // gift (gift activity ID, item ID, gift price)
Ecs_gift_type // gift giving activity (name, sending type, related parameter, quantity, start, end)
Ecs_goods // product (Category ID, name, click, brand ID, supplier name, inventory, weight, market price,
Price, fitting_price (unknown), promotion price, promotion start date, end date, warning quantity, keywords, introduction,
Description, thumbnail, graph, source image, true product, extended code, shelving, sales, and Association,
Accessory association, whether gifts, whether they can be gifts, units, adding time, sorting, recycling, high-quality goods, new products, pushing
Recommendation, hot selling, red envelope ID, update date, product type, product remarks, homepage carousel)
Ecs_goods_article // item Article Association (gid, aid)
Ecs_goods_attr // item attributes (item ID, property ID, property value, property additional price)
Ecs_goods_cat // unknown
Ecs_gallery // product album (product ID, image, description, thumbnail, source image)
Ecs_goods_type // product type (name, status)
Ecs_group_buy // group buying (item ID, end date, price tier, quantity limit, description, order quantity, order,
Number of points, process, deposit, and completion)
Ecs_group_goods // accessory (parent class ID, item ID, Accessory Price)
Ecs_link_goods // item Association (item ID, Association ID, single bidirectional)
Ecs_mail_templates // mail style (Code, html, name, style, last modification date)
Ecs_member_price // member price (item ID, member grade, member price)
Ecs_order_action // order processing (Order ID, processing user, order status, delivery status, payment status, location
Time, remarks)
Ecs_order_goods // order-item (Order ID, item ID, item name, item number, item quantity, City
Field price, order price, product attribute, delivery quantity, real product, extended code, parent class ID, or gift)
Ecs_order_info // order information (many (-_-| omitted ...)
Ecs_pack // package (name, image, cost, free amount, description)
Ecs_payment // payment tool (Code, name, fee, description, sorting, configuration, status, is_cod (unknown ))
Ecs_pay_log // payment record (omitted)
Ecs_plugins // plug-in (Code, version, library, signature, and installation date)
Ecs_region // local data (nothing to mention)
Ecs_sessions // Save the session (nothing to say? ))
Ecs_shipping // delivery (Code, name, description, guaranteed price, support_cod (unknown), status)
Ecs_shipping_area // delivery region (sequence configuration)
Ecs_shop_config // set (parent class ID, code, type, range, folder, value)
Ecs_snatch // qibo qibing (activity ID, product ID, minimum price, maximum price, pricing, and point consumption)
Ecs_snatch_log // record the bid of the raiders (still nothing to say)
Ecs_stats // access record (time, IP address, access count, browser, system, language, region, source domain name,
Source Address, keyword, access link) www.2cto.com
Ecs_tag // user tag (not to mention)
Ecs_template // template region (file name, region, template library, sorting, id, quantity, type, template)
How can this problem be solved?
Ecs_users // member (some member information)
Ecs_user_account // member account (User ID, Administrator, total, add time, payment time, management remarks,
User remarks, processing type, payment tool, whether to pay)
Ecs_user_address // recipient address (omitted)
Ecs_user_bonus // user red envelope (red envelope ID, red envelope number, user ID, use time, order ID, whether it has been
Email)
Ecs_user_rank // membership level (name, minimum credit limit, maximum credit, discount, price displayed, special
Special Member)
Ecs_virtual_cart // virtual card (product ID, card number, password, add time, expiration time, whether sold out,
Crc32 verification code)
Ecs_vote // vote (name, start, end, can be selected multiple times, Statistics)
Ecs_vote_log // voting record (Voting ID, IP address, time)
Ecs_vote_option // voting content (Voting ID, entry name, and entry statistics)