Magento 2.6

Tables (100)

admin_adobe_ims_webapi

  • id — int — Entity ID' primary ke
  • admin_user_id — int — NOT NULL — Admin User Id
  • access_token_hash — varchar(255) — Access Token Hash
  • access_token — text — Access Token
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • last_check_time — timestamp — NOT NULL — Last check time
  • access_token_expires_at — timestamp — NOT NULL — Access Token Expires At

admin_analytics_usage_version_log

  • id — int — Log ID' primary ke
  • last_viewed_in_version — varchar(50) — NOT NULL — Viewer last viewed on product version

admin_passwords

  • password_id — int — Password ID' primary ke
  • user_id — int — NOT NULL — User ID
  • password_hash — varchar(255) — Password Hash
  • expires — int — NOT NULL — Deprecated
  • last_updated — int — NOT NULL — Last Updated

admin_system_messages

  • identity — varchar(100) — NOT NULL — Message ID' primary ke
  • severity — smallint — NOT NULL — Problem type
  • created_at — timestamp — NOT NULL — Create date

admin_user

  • user_id — int — User ID' primary ke
  • firstname — varchar(32) — User First Name
  • lastname — varchar(32) — User Last Name
  • email — varchar(128) — User Email
  • username — varchar(40) — User Login
  • password — varchar(255) — NOT NULL — User Password
  • created — timestamp — NOT NULL — User Created Time
  • modified — timestamp — NOT NULL — User Modified Time
  • logdate — timestamp — User Last Login Time
  • lognum — smallint — NOT NULL — User Login Number
  • reload_acl_flag — smallint — NOT NULL — Reload ACL
  • is_active — smallint — NOT NULL — User Is Active
  • extra — text — User Extra Data
  • rp_token — text — Reset Password Link Token
  • rp_token_created_at — timestamp — Reset Password Link Token Creation Date
  • interface_locale — varchar(16) — NOT NULL — Backend interface locale
  • failures_num — smallint — Failure Number
  • first_failure — timestamp — First Failure
  • lock_expires — timestamp — Expiration Lock Dates
  • refresh_token — text — Email connector refresh token

admin_user_1

  • user_id — int
  • firstname — varchar(32)
  • lastname — varchar(32)
  • email — varchar(128)
  • username — varchar(40)
  • password — varchar(255)
  • created — timestamp
  • modified — timestamp
  • logdate — timestamp
  • lognum — smallint
  • reload_acl_flag — smallint
  • is_active — smallint
  • extra — text
  • rp_token — text
  • rp_token_created_at — timestamp
  • interface_locale — varchar(16)
  • failures_num — smallint
  • first_failure — timestamp
  • lock_expires — timestamp
  • refresh_token — text

admin_user_expiration

  • user_id — int — NOT NULL — User ID' primary ke
  • expires_at — datetime — NOT NULL — User Expiration Date

admin_user_session

  • id — int — Entity ID' primary ke
  • session_id — varchar(1) — Deprecated: Session ID value no longer used
  • user_id — int — Admin User ID
  • status — smallint — NOT NULL — Current Session status
  • created_at — timestamp — NOT NULL — Created Time
  • updated_at — timestamp — NOT NULL — Update Time
  • ip — varchar(15) — NOT NULL — Remote user IP

adminnotification_inbox

  • notification_id — int — Notification ID' primary ke
  • severity — smallint — NOT NULL — Problem type
  • date_added — timestamp — NOT NULL — Create date
  • title — varchar(255) — NOT NULL — Title
  • description — text — Description
  • url — varchar(255) — Url
  • is_read — smallint — NOT NULL — Flag if notification read
  • is_remove — smallint — NOT NULL — Flag if notification might be removed
  • is_amasty — smallint — NOT NULL — Is Amasty Notification
  • expiration_date — datetime — Expiration Date
  • image_url — varchar(255) — Image Url
  • is_magenest — smallint — Is Magenest
  • magenest_id — int — Magenest notification ID

adobe_stock_asset

  • id — int — Entity ID' primary ke
  • media_gallery_id — int — Media gallery ID
  • category_id — int — Category ID
  • creator_id — int — Creator ID
  • is_licensed — int — NOT NULL — Is Licensed
  • creation_date — varchar(255) — Creation Date

adobe_stock_category

  • id — int — Entity ID' primary ke
  • name — varchar(255) — Name

adobe_stock_creator

  • id — int — ID' primary ke
  • name — varchar(255) — Asset creator's name

adobe_user_profile

  • id — int — Entity ID' primary ke
  • admin_user_id — int — NOT NULL — Admin User Id
  • name — varchar(255) — NOT NULL — Display Name
  • email — varchar(255) — NOT NULL — user profile email
  • image — varchar(255) — NOT NULL — user profile avatar
  • account_type — varchar(255) — Account Type
  • access_token — text — Access Token
  • refresh_token — text — Refresh Token
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • access_token_expires_at — timestamp — NOT NULL — Access Token Expires At

amasty_amlocator_attribute

  • attribute_id — int — Attribute Id' primary ke
  • frontend_label — varchar(255) — NOT NULL — Default Label
  • attribute_code — varchar(255) — NOT NULL — Attribute Code
  • frontend_input — varchar(50) — NOT NULL — Frontend Input
  • is_required — smallint — Is Required
  • label_serialized — text — Attribute Labels by store

amasty_amlocator_attribute_option

  • value_id — int — Value Id' primary ke
  • attribute_id — int — NOT NULL — Attribute Id
  • options_serialized — text — Value And Store
  • is_default — text — This is Default Option
  • sort_order — int — Sort order

amasty_amlocator_content_location_index

  • record_id — int — Record ID' primary ke
  • location_id — int — NOT NULL — Location Id
  • store_list_html — text — Store List Html
  • popup_html — text — Popup Html

amasty_amlocator_gallery

  • id — int — Id' primary ke
  • location_id — int — NOT NULL — Location Id
  • image_name — text — NOT NULL — Image Name
  • is_base — tinyint(1) — NOT NULL — Base Image Flag

amasty_amlocator_location

  • id — int — Block Id' primary ke
  • name — varchar(255) — NOT NULL
  • country — varchar(255) — NOT NULL
  • city — varchar(255) — NOT NULL
  • zip — varchar(255) — NOT NULL
  • address — text — Location Address
  • status — smallint — Location Status
  • lat — decimal(11, 8) — Location Latitude
  • lng — decimal(11, 8) — Location Longitude
  • photo — text — Location Photo
  • marker — text — Location Marker
  • position — smallint — Location Position
  • state — varchar(255) — NOT NULL
  • description — text — Location Description
  • phone — varchar(255)
  • email — varchar(255)
  • website — text — Location Website
  • category — text — Location Category
  • actions_serialized — text — Actions Serialized
  • store_img — text — NOT NULL — Store image
  • stores — text — NOT NULL — Stores Ids
  • schedule — int
  • marker_img — text — NOT NULL — Marker Image
  • show_schedule — tinyint(1) — NOT NULL — Show schedule
  • url_key — varchar(255) — Url Key
  • meta_title — varchar(255) — Meta Title
  • meta_description — text — Meta Description
  • meta_robots — text — Meta Robots
  • short_description — text — Short Description
  • canonical_url — varchar(255) — Canonical Url
  • condition_type — smallint — NOT NULL — Condition Type
  • curbside_enabled — tinyint(1) — NOT NULL — Curbside enabled
  • curbside_conditions_text — text — Curbside conditions text

amasty_amlocator_location_index

  • location_id — int — NOT NULL — Location Id
  • product_id — int — NOT NULL — Product ID
  • store_id — int — NOT NULL — Store ID
  • id — int — Id' primary ke

amasty_amlocator_review

  • id — int — Id' primary ke
  • location_id — int — NOT NULL — Location Id
  • customer_id — int — NOT NULL — Customer Id
  • review_text — text — NOT NULL — Text
  • rating — int — NOT NULL — Rating
  • placed_at — timestamp — NOT NULL — Placed Date
  • published_at — timestamp — Approved Date
  • status — smallint — NOT NULL — Status

amasty_amlocator_schedule

  • id — int — Schedule Id' primary ke
  • name — varchar(255) — NOT NULL — Schedule Name
  • schedule — text — NOT NULL — Schedule

amasty_amlocator_store_attribute

  • entity_id — int — Entity Id' primary ke
  • attribute_id — int — NOT NULL — Attribute Id
  • store_id — int — NOT NULL — Store Location Id
  • value — varchar(255) — NOT NULL — Attribute Value

amasty_ampromo_items_storage

  • quote_id — int — Primary key — NOT NULL — Quote ID
  • sku — varchar(255) — Primary key — NOT NULL — Promo Product's SKU
  • rule_id — int — Primary key — NOT NULL — Salesrule Entity ID
  • allowed_qty — float — Allowed Qty
  • reserved_qty — float — Reserved Qty
  • rule_type — int — NOT NULL — Rule Type
  • minimal_price — float — Minimal Price
  • discount_item — varchar(255) — Promo Item's Discount
  • discount_amount — float — Discount Amount
  • auto_add — tinyint(1) — NOT NULL — Auto Add Flag
  • is_item_deleted — tinyint(1) — NOT NULL — Is Deleted Flag

amasty_ampromo_rule

  • entity_id — int — Entity ID' primary ke
  • salesrule_id — int — NOT NULL — Salesrule Entity Id
  • sku — text — NOT NULL — Promo Products SKUs
  • type — smallint — NOT NULL — Promo Rule Type
  • top_banner_show_gift_images — tinyint(1) — NOT NULL — Show Gift Name
  • after_product_banner_show_gift_images — tinyint(1) — NOT NULL — Show Gift Images
  • items_discount — varchar(255) — Promo Items Discount
  • minimal_items_price — float — Minimal Price
  • apply_tax — tinyint(1) — NOT NULL — Apply tax on original price of promo items added for free
  • apply_shipping — tinyint(1) — NOT NULL — Apply shipping on promo items added for free
  • top_banner_show_gift_name — tinyint(1) — NOT NULL — Show Gift Images
  • after_product_banner_show_gift_name — tinyint(1) — NOT NULL — Show Gift Name

amasty_amshopby_filter_setting

  • setting_id — smallint — Setting id' primary ke
  • filter_code — varchar(100) — NOT NULL — Filter code (Deprecated)
  • is_multiselect — smallint — NOT NULL — Is multiselect
  • display_mode — smallint — NOT NULL — Display mode
  • is_seo_significant — smallint — NOT NULL — Is seo significant
  • slider_step — decimal(12, 4) — NOT NULL — Slider Step
  • units_label_use_currency_symbol — tinyint(1) — NOT NULL — is Units label used currency symbol
  • units_label — varchar(255) — NOT NULL — Units label
  • index_mode — int — NOT NULL — Robots Index Mode
  • follow_mode — int — NOT NULL — Robots Follow Mode
  • is_expanded — smallint — NOT NULL — Is filter expanded
  • sort_options_by — smallint — NOT NULL — Sort Options By
  • show_product_quantities — smallint — NOT NULL — Show Product Quantities
  • is_show_search_box — smallint — NOT NULL — Show Search Box
  • number_unfolded_options — smallint — NOT NULL — Number of unfolded options
  • tooltip — text — NOT NULL — Tooltip
  • is_use_and_logic — smallint — NOT NULL — Is Use And Logic
  • add_from_to_widget — tinyint(1) — NOT NULL — Add From To Widget
  • visible_in_categories — varchar(255) — NOT NULL — Visible In Categories
  • categories_filter — text — NOT NULL — Categories Filter
  • attributes_filter — varchar(255) — NOT NULL — Attributes Filter
  • attributes_options_filter — varchar(255) — NOT NULL — Attributes Options Filter
  • block_position — smallint — NOT NULL — Show in the Block
  • slider_min — decimal(12, 4) — Slider Min Value
  • slider_max — decimal(12, 4) — Slider Max Value
  • rel_nofollow — smallint — NOT NULL — Add rel=nofollow
  • show_icons_on_product — tinyint(1) — NOT NULL — Show options images block on product view page
  • category_tree_display_mode — smallint — NOT NULL — Category Tree Display Mode
  • limit_options_show_search_box — bigint — NOT NULL — Show Search Box When Number Options
  • position_label — smallint — NOT NULL — Position label
  • top_position — int — NOT NULL — Filter top sort order for block_position=Both
  • side_position — int — NOT NULL — Filter side sort order for block_position=Both
  • attribute_url_alias — text — NOT NULL — Attribute URL Alias
  • attribute_code — varchar(100) — Attribute code
  • hide_zeros — tinyint — NOT NULL — Hide Zeros
  • range_algorithm — smallint — Range Algorithm
  • range_step — decimal(12, 4) — Range Step Value
  • attribute_id — smallint — Related EAV attribute ID

amasty_amshopby_group_attr

  • group_id — smallint — Group_id' primary ke
  • attribute_id — smallint — NOT NULL — Attribute_id
  • name — varchar(255) — NOT NULL — Name
  • group_code — varchar(50) — NOT NULL — Group_code
  • url — varchar(255) — Url
  • position — smallint — NOT NULL — Position
  • visual — varchar(255) — Visual
  • type — smallint — NOT NULL — Type
  • enabled — tinyint(1) — NOT NULL — Enabled

amasty_amshopby_group_attr_option

  • group_option_id — smallint — Group_option_id' primary ke
  • group_id — smallint — NOT NULL — Group_id
  • option_id — int — NOT NULL — Option ID
  • sort_order — smallint — NOT NULL — Sort Order

amasty_amshopby_group_attr_value

  • group_option_id — smallint — Group_option_id' primary ke
  • group_id — smallint — NOT NULL — Group_id
  • value — varchar(20) — NOT NULL — Option Value
  • sort_order — smallint — NOT NULL — Sort Order

amasty_amshopby_option_setting

  • option_setting_id — int — Option setting id' primary ke
  • filter_code — varchar(255) — NOT NULL — Filter_code
  • value — int — NOT NULL — Attribute Option ID
  • store_id — int — NOT NULL — Store id
  • url_alias — varchar(255) — Url alias
  • is_featured — smallint — Is featured
  • meta_title — text — Meta title
  • meta_description — text — Meta description
  • meta_keywords — text — Meta keywords
  • title — text — Title
  • description — text — Description
  • image — varchar(255) — Image
  • top_cms_block_id — smallint — Top cms block id
  • bottom_cms_block_id — smallint — Bottom cms block id
  • slider_position — int — Slider Position
  • slider_image — varchar(255) — Slider Image
  • short_description — text — Short description for product page or tooltip
  • small_image_alt — varchar(255) — Small Image alt
  • is_show_in_slider — smallint — Is show in slider
  • is_show_in_widget — tinyint(1) — Is show in widget
  • attribute_code — varchar(255) — NOT NULL — Attribute Code
  • image_alt — varchar(255) — Image alt

amasty_amshopby_page

  • page_id — smallint — Page ID' primary ke
  • position — varchar(255) — NOT NULL — Position
  • url — varchar(255) — Url
  • title — varchar(255) — Title
  • description — text — description
  • meta_title — varchar(255) — Meta Title
  • meta_keywords — text — Page Meta Keywords
  • meta_description — text — Page Meta Description
  • conditions — mediumtext — Conditions
  • categories — varchar(255) — Categories
  • top_block_id — smallint — Top Block ID
  • bottom_block_id — smallint — Bottom Block ID
  • image — varchar(255) — Image
  • tag_robots — varchar(20) — NOT NULL — Tag_robots

amasty_amshopby_page_store

  • page_id — smallint — Primary key — NOT NULL — Page ID
  • store_id — smallint — Primary key — NOT NULL — Store ID

amasty_banners_lite_banner_data

  • entity_id — int — Entity ID' primary ke
  • salesrule_id — int — NOT NULL — Salesrule Entity Id
  • banner_type — int — NOT NULL — Banner Type
  • banner_image — text — Banner Image
  • banner_alt — varchar(255) — Banner Alt
  • banner_hover_text — varchar(255) — Banner Hover Text
  • banner_link — varchar(255) — Banner Link

amasty_banners_lite_rule

  • entity_id — int — Entity ID' primary ke
  • salesrule_id — int — NOT NULL — Salesrule Entity Id
  • banner_product_sku — text — Banner Type
  • banner_product_categories — text — Banner Image
  • show_banner_for — int — Banner Alt

amasty_blog_author

  • author_id — int — Author Id' primary ke
  • facebook_profile — varchar(255) — Facebook Profile
  • twitter_profile — varchar(255) — Twitter profile
  • linkedin_profile — varchar(255) — Linkedin Profile
  • image — varchar(255) — Image
  • youtube_profile — varchar(255) — Youtube Profile
  • instagram_profile — varchar(255) — Instagram Profile
  • tiktok_profile — varchar(255) — TikTok Profile

amasty_blog_author_store

  • author_id — int — Primary key — NOT NULL — Author Id
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • name — varchar(255) — Name
  • meta_title — varchar(255) — Meta Title
  • meta_tags — varchar(255) — Meta Tags
  • meta_description — text — Meta Description
  • url_key — varchar(255) — Url Key
  • job_title — varchar(255) — Job Title
  • short_description — mediumtext — Short Description
  • description — mediumtext — Description
  • meta_robots — varchar(50) — Meta Robots

amasty_blog_categories

  • category_id — int — Category Id' primary ke
  • sort_order — int — NOT NULL — Sort Order
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • parent_id — int(11) — Parent Id
  • path — varchar(255) — NOT NULL — path
  • level — int — NOT NULL — Level

amasty_blog_categories_store

  • category_id — int — Primary key — NOT NULL — Category Id
  • store_id — int — Primary key — NOT NULL — Store Id
  • name — mediumtext — Name
  • status — smallint — Status
  • meta_title — varchar(255) — Meta title
  • meta_description — text — Meta description
  • meta_tags — varchar(255) — Meta tags
  • url_key — varchar(255) — Url Key
  • description — text — Category description
  • meta_robots — varchar(50) — Meta Robots

amasty_blog_comments

  • comment_id — bigint — Comment Id' primary ke
  • post_id — int — NOT NULL — Post Id
  • store_id — smallint — NOT NULL — Store Id
  • status — smallint — NOT NULL — Status
  • customer_id — int — Customer Id
  • reply_to — bigint — Reply To
  • message — text — Message
  • name — varchar(255) — Name
  • email — varchar(255) — Email
  • session_id — varchar(255) — Session Id
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At

amasty_blog_post_helpful

  • vote_id — int — Vote Id' primary ke
  • post_id — int — NOT NULL — Post table id
  • type — smallint — type
  • ip — text — ip

amasty_blog_posts

  • post_id — int — Subscription Id' primary ke
  • status — smallint — NOT NULL — Status
  • title — mediumtext — NOT NULL — Title
  • url_key — varchar(255) — NOT NULL — Url Key
  • use_comments — int — NOT NULL — Use Comments
  • short_content — text — Short Content
  • full_content — longtext — NOT NULL — Full Content
  • meta_title — varchar(255) — Meta Title
  • meta_tags — varchar(255) — Meta Tags
  • meta_description — text — Meta Description
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — NOT NULL — Updated At
  • published_at — timestamp — NOT NULL
  • recently_commented_at — timestamp — NOT NULL
  • user_define_publish — smallint — NOT NULL — User Define Publish
  • notify_on_enable — smallint — NOT NULL — Notify On Enable
  • display_short_content — smallint — NOT NULL — Display Short Content
  • comments_enabled — smallint — NOT NULL — Comments Enabled
  • views — int — NOT NULL — Views
  • post_thumbnail — text — Post Thumbnail
  • list_thumbnail — text — List Thumbnail
  • thumbnail_url — text — Thumbnail Url
  • grid_class — varchar(2) — NOT NULL — Grid Class
  • canonical_url — text — Canonical Url
  • sub_heading — text — Sub Heading
  • left_recent_thumbnail — text — HP left thumbnail
  • right_recent_thumbnail — text — HP right thumbnail
  • property_icon_thumbnail — text — HP icon
  • post_thumbnail_alt — varchar(255) — NOT NULL — Thumbnail Post Alt
  • list_thumbnail_alt — varchar(255) — NOT NULL — Thumbnail Post Alt
  • author_id — int — Author Id
  • related_post_ids — text — NOT NULL — Related Post Ids
  • is_featured — tinyint(1) — NOT NULL — Is Featured
  • meta_robots — varchar(50) — Meta Robots
  • edited_at — timestamp
  • is_open_graph_enabled — tinyint(1) — Add Open Graph Metadata
  • open_graph_meta_title — mediumtext — Open Graph Title
  • open_graph_meta_description — text — Open Graph Description
  • open_graph_meta_type — varchar(255) — Open Graph Type

amasty_blog_posts_category

  • post_id — int — Primary key — NOT NULL — Post Id
  • category_id — int — Primary key — NOT NULL — Category Id

amasty_blog_posts_products

  • post_id — int — Primary key — NOT NULL — Post Id
  • product_id — int — Primary key — NOT NULL — Product Id
  • position — int — NOT NULL — Sort order on frontend

amasty_blog_posts_store

  • post_id — int — Primary key — NOT NULL — Post Id
  • store_id — int — Primary key — NOT NULL — Store Id
  • status — smallint — Status
  • published_at — timestamp
  • title — mediumtext — Title
  • short_content — text — Short Content
  • full_content — longtext — Full Content
  • meta_title — varchar(255) — Meta Title
  • meta_description — text — Meta Description
  • meta_tags — varchar(255) — Meta Tags
  • meta_robots — varchar(50) — Meta Robots
  • canonical_url — text — Canonical Url
  • post_thumbnail_alt — varchar(255) — Thumbnail Post Alt
  • list_thumbnail_alt — varchar(255) — Thumbnail List Alt
  • url_key — varchar(255) — Url Key

amasty_blog_posts_tag

  • post_id — int — Primary key — NOT NULL — Post Id
  • tag_id — int — Primary key — NOT NULL — Tag Id

amasty_blog_tags

  • tag_id — int — Tag Id' primary ke

amasty_blog_tags_store

  • tag_id — int — Primary key — NOT NULL — Tag Id
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • name — varchar(255) — Name
  • meta_title — varchar(255) — Meta Title
  • meta_tags — varchar(255) — Meta Tags
  • meta_description — text — Meta Description
  • url_key — varchar(255) — Url Key
  • meta_robots — varchar(50) — Meta Robots

amasty_blog_views

  • view_id — bigint — View Id' primary ke
  • post_id — int — NOT NULL — Post Id
  • customer_id — int — Customer Id
  • session_id — varchar(255) — NOT NULL — Session Id
  • remote_addr — bigint — NOT NULL — Remote Address
  • store_id — smallint — NOT NULL — Store Id
  • created_at — timestamp — NOT NULL — Created At
  • referer_url — varchar(255) — Referer Url

amasty_conditions_quote

  • id — int — ID' primary ke
  • quote_id — int — Quote ID
  • payment_code — text — NOT NULL — Payment Code For Quote

amasty_emailunsubscribe_relation

  • type_id — int — Primary key — NOT NULL — Type Id
  • email — varchar(255) — Primary key — NOT NULL — Customer Email
  • entity_id — int — Primary key — NOT NULL — Entity Id

amasty_emailunsubscribe_type

  • type_id — int — Type Id' primary ke
  • type — varchar(255) — NOT NULL — Notification type

aw_arep_product_performance

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • product_id — int — Primary key — NOT NULL — Product Id
  • payment_method — varchar(128) — Primary key — NOT NULL — Payment Method
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate
  • total_revenue_excl_tax — decimal(12, 4) — NOT NULL — Total Revenue (excl. Tax)
  • total_cost — decimal(12, 4) — NOT NULL — Total Cost

aw_arep_product_performance_category

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • product_id — int — Primary key — NOT NULL — Product Id
  • category_id — int — Primary key — NOT NULL — Category Id
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate
  • total_revenue_excl_tax — decimal(12, 4) — NOT NULL — Total Revenue (excl. Tax)
  • total_cost — decimal(12, 4) — NOT NULL — Total Cost

aw_arep_product_performance_coupon_code

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • product_id — int — Primary key — NOT NULL — Product Id
  • coupon_code — varchar(100) — Primary key — NOT NULL — Coupon Code
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate
  • total_revenue_excl_tax — decimal(12, 4) — NOT NULL — Total Revenue (excl. Tax)
  • total_cost — decimal(12, 4) — NOT NULL — Total Cost

aw_arep_product_performance_manufacturer

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • product_id — int — Primary key — NOT NULL — Product Id
  • manufacturer — varchar(255) — Primary key — NOT NULL — Manufacturer
  • parent_id — int — Primary key — NOT NULL — Parent Id
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate
  • total_revenue_excl_tax — decimal(12, 4) — NOT NULL — Total Revenue (excl. Tax)
  • total_cost — decimal(12, 4) — NOT NULL — Total Cost

aw_arep_product_variant_performance

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • product_id — int — Primary key — NOT NULL — Product Id
  • parent_id — int — Primary key — NOT NULL — Parent Id
  • parent_product_id — int — Primary key — NOT NULL — Parent Product Id
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate

aw_arep_quarter

  • start_date — date — NOT NULL — First day of quarter
  • end_date — date — NOT NULL — End day of quarter

aw_arep_report_configuration

  • id — int — ID' primary ke
  • report_name — varchar(255) — NOT NULL — Report Name
  • configuration — longtext — Report Configuration

aw_arep_sales_by_hour

  • date — date — Primary key — NOT NULL — Date
  • hour — smallint — Primary key — NOT NULL — Hour
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • number_of_orders — int — NOT NULL — Number Of Orders
  • total_qty_ordered — int — NOT NULL — Total Qty Ordered
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax_amount — decimal(12, 4) — NOT NULL — Tax Amount
  • shipping_amount — decimal(12, 4) — NOT NULL — Shipping Amount
  • discount_amount — decimal(12, 4) — NOT NULL — Discount Amount
  • other_discount_amount — decimal(12, 4) — NOT NULL — Other Discount Amount
  • total — decimal(12, 4) — NOT NULL — Total
  • total_invoiced — decimal(12, 4) — NOT NULL — Total Invoiced
  • total_refunded — decimal(12, 4) — NOT NULL — Total Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — Base To Global Rate

aw_arep_sales_detailed

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • order_id — int — Primary key — NOT NULL — Order Id
  • product_id — int — Primary key — NOT NULL — Product Id
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • order_increment_id — varchar(32) — NOT NULL — Order Increment Id
  • order_date — timestamp — NOT NULL — Order Date
  • product_name — varchar(255) — NOT NULL — Product Name
  • sku — varchar(64) — NOT NULL — SKU
  • manufacturer — varchar(255) — NOT NULL — Manufacturer
  • customer_id — int — NOT NULL — Customer Id
  • customer_email — varchar(255) — NOT NULL — Customer Email
  • customer_name — varchar(255) — NOT NULL — Customer Name
  • customer_group — varchar(32) — NOT NULL — Customer Group
  • country — varchar(255) — NOT NULL — Country
  • shipping_region — varchar(255) — NOT NULL — Shipping Region
  • shipping_city — varchar(255) — NOT NULL — Shipping City
  • shipping_zip_code — varchar(255) — NOT NULL — Shipping Postcode
  • address — varchar(255) — NOT NULL — Address
  • phone — varchar(255) — NOT NULL — Phone
  • coupon_code — varchar(255) — NOT NULL — Coupon Code
  • qty_ordered — decimal(12, 4) — NOT NULL — Qty. Ordered
  • qty_invoiced — decimal(12, 4) — NOT NULL — Qty. Invoiced
  • qty_shipped — decimal(12, 4) — NOT NULL — Qty. Shipped
  • qty_refunded — decimal(12, 4) — NOT NULL — Qty. Refunded
  • item_price — decimal(12, 4) — NOT NULL — Item Price
  • item_cost — decimal(12, 4) — NOT NULL — Item Cost
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • tax — decimal(12, 4) — NOT NULL — Tax
  • total — decimal(12, 4) — NOT NULL — Total
  • total_incl_tax — decimal(12, 4) — NOT NULL — Total Incl. Tax
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • tax_invoiced — decimal(12, 4) — NOT NULL — Tax Invoiced
  • invoiced_incl_tax — decimal(12, 4) — NOT NULL — Invoiced Incl. Tax
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • tax_refunded — decimal(12, 4) — NOT NULL — Tax Refunded
  • refunded_incl_tax — decimal(12, 4) — NOT NULL — Refunded Incl. Tax
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate
  • base_grand_total — decimal(12, 4) — NOT NULL — Grand Total (Base)
  • shipping_information — varchar(255) — NOT NULL — Shipping Information
  • shipping_amount — decimal(12, 4) — NOT NULL — Shipping Amount
  • order_modified_date — timestamp — NOT NULL — Order Modified Date
  • tax_code — varchar(100) — NOT NULL — Tax code
  • tax_percent — decimal(12, 4) — NOT NULL — Tax Percent
  • base_tax_real_amount — decimal(12, 4) — NOT NULL — Tax Real Amount (Base)
  • billing_region — varchar(255) — NOT NULL — Billing Region
  • billing_zip_code — varchar(255) — NOT NULL — Billing Postcode
  • billing_city — varchar(255) — NOT NULL — Billing City
  • customer_balance_refunded — decimal(12, 4) — NOT NULL — Customer Balance Refunded

aw_arep_sales_overview

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • payment_method — varchar(128) — Primary key — NOT NULL — Payment Method
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • orders_count — int — NOT NULL — Orders Count
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • shipping — decimal(12, 4) — NOT NULL — Shipping
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • other_discount — decimal(12, 4) — NOT NULL — Other Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate

aw_arep_sales_overview_coupon_code

  • period — date — Primary key — NOT NULL — Period
  • store_id — smallint — Primary key — NOT NULL — Store Id
  • order_status — varchar(100) — Primary key — NOT NULL — Order Status
  • coupon_code — varchar(100) — Primary key — NOT NULL — Coupon Code
  • id — int — Id
  • customer_group_id — smallint — NOT NULL — Customer Group Id
  • aw_customer_segment_id — int — NOT NULL — AW Customer Segment Id, value -1 for row with no division into segments
  • orders_count — int — NOT NULL — Orders Count
  • order_items_count — int — NOT NULL — Order Items Count
  • subtotal — decimal(12, 4) — NOT NULL — Subtotal
  • tax — decimal(12, 4) — NOT NULL — Tax
  • shipping — decimal(12, 4) — NOT NULL — Shipping
  • discount — decimal(12, 4) — NOT NULL — Discounts
  • other_discount — decimal(12, 4) — NOT NULL — Other Discounts
  • total — decimal(12, 4) — NOT NULL — Total
  • invoiced — decimal(12, 4) — NOT NULL — Invoiced
  • refunded — decimal(12, 4) — NOT NULL — Refunded
  • to_global_rate — decimal(12, 4) — NOT NULL — To Global Rate

aw_arep_statistics_cl

  • version_id — int — Version ID' primary ke
  • entity_id — int — NOT NULL — Entity ID

aw_arep_weeks

  • start_date — date — NOT NULL — First day of week
  • end_date — date — NOT NULL — End day of Week

aw_arep_year

  • start_date — date — NOT NULL — First day of year
  • end_date — date — NOT NULL — End day of year

aw_raf_disallow_friend_discount

  • customer_id — int — Customer ID' primary ke
  • email — varchar(255) — Email

aw_raf_email_hash

  • emailhash_id — int — Hash ID' primary ke
  • advocate_id — int — NOT NULL — Advocate ID
  • friend_id — int — NOT NULL — Friend ID
  • order_id — int — NOT NULL — Order ID
  • email_hash — text — Email Hash

aw_raf_rule

  • id — int — Rule ID' primary ke
  • name — varchar(150) — NOT NULL — Name
  • status — smallint — NOT NULL — Status
  • registration_required — smallint — NOT NULL — Registration Required
  • friend_off — decimal(12, 4) — NOT NULL — Friend Off
  • friend_off_type — varchar(32) — NOT NULL — Friend Off Type
  • advocate_off — decimal(12, 4) — NOT NULL — Advocate Off
  • advocate_off_type — varchar(32) — NOT NULL — Advocate Off Type
  • advocate_earn_type — varchar(32) — NOT NULL — Advocate Earn Type
  • apply_to_shipping — smallint — NOT NULL — Apply to Shipping
  • reward_type — varchar(30) — NOT NULL — Reward Type

aw_raf_rule_website

  • rule_id — int — NOT NULL — Rule ID
  • website_id — smallint — NOT NULL — Website ID

aw_raf_summary

  • id — int — Summary ID' primary ke
  • website_id — smallint — NOT NULL — Website ID
  • customer_id — int — NOT NULL — Customer ID
  • cumulative_amount — decimal(12, 4) — NOT NULL — Cumulative Amount
  • cumulative_percent_amount — decimal(12, 4) — NOT NULL — Cumulative Percent Amount
  • cumulative_amount_updated — timestamp — Cumulative Amount
  • invited_friends — int — NOT NULL — Invited Friends
  • expiration_date — timestamp — Expiration Date
  • new_reward_subscription_status — smallint — NOT NULL — New Reward Subscription Status
  • referral_link — varchar(255) — NOT NULL — Referral Link
  • reminder_status — varchar(100) — NOT NULL — Reminder Status

aw_raf_transaction

  • id — int — Transaction ID' primary ke
  • summary_id — int — NOT NULL — Summary ID
  • created_at — timestamp — NOT NULL — Created At
  • action — varchar(150) — NOT NULL — Type
  • admin_comment — varchar(255) — archar(255) null comment 'Admin Comment
  • admin_comment_placeholder — varchar(150) — Admin Comment Placeholder
  • amount — decimal(12, 4) — NOT NULL — Amount
  • amount_type — varchar(32) — NOT NULL — Amount Type
  • balance_amount — decimal(12, 4) — NOT NULL — Current Balance Amount
  • percent_balance_amount — decimal(12, 4) — NOT NULL — Percent Balance Amount
  • status — varchar(128) — NOT NULL — Status
  • holding_period_expiration — timestamp — Holding period expiration
  • created_by — int — Created By

aw_raf_transaction_entity

  • transaction_id — int — Primary key — NOT NULL — Transaction ID
  • entity_type — varchar(150) — Primary key — NOT NULL — Entity Type
  • entity_id — int — Primary key — NOT NULL — Entity ID
  • entity_label — varchar(255) — Entity Label

aw_sarp2_access_token

  • id — int — Id' primary ke
  • token_value — varchar(255) — NOT NULL — Token Value
  • profile_id — int — NOT NULL — Profile Id
  • created_at — timestamp — NOT NULL — Created At
  • expires_at — timestamp — Expires At
  • allowed_resource — varchar(255) — Allowed resource

aw_sarp2_core_notification

  • notification_id — int — Notification Id' primary ke
  • type — varchar(255) — NOT NULL — Notification Type
  • status — varchar(255) — NOT NULL — Notification Status
  • email — varchar(128) — Email
  • name — varchar(32) — Name
  • scheduled_at — timestamp — Scheduled At
  • send_at — timestamp — Send At
  • notification_data — text — Notification Data
  • store_id — smallint — NOT NULL — Store Id
  • profile_id — int — NOT NULL — Profile Id
  • order_id — int — Order Id

aw_sarp2_core_schedule

  • schedule_id — int — Core Schedule Id' primary ke
  • profile_id — int — NOT NULL — Profile Id
  • period — varchar — NOT NULL — Payments Period
  • frequency — smallint — NOT NULL — Payments Frequency
  • is_initial_paid — tinyint(1) — Is Initial Payment Paid
  • trial_count — int — Trial Payments Count
  • trial_total_count — int — Trial Payments Total Count
  • regular_count — int — Regular Payments Count
  • regular_total_count — int — Regular Payments Total Count
  • payment_data — text — Payment Data
  • is_reactivated — tinyint(1) — Is Reactivated
  • store_id — smallint — NOT NULL — Store Id
  • is_membership_model — tinyint(1) — NOT NULL — Is Membership Model
  • membership_count — int — NOT NULL — Membership Count
  • membership_total_count — int — NOT NULL — Membership Total Count
  • trial_period — varchar(255) — Trial Period
  • trial_frequency — smallint — Trial Frequency

aw_sarp2_core_schedule_item

  • schedule_id — int — Primary key — NOT NULL — Schedule Id
  • item_id — int — Core Schedule Item Id
  • parent_item_id — int — Core Schedule Parent Item
  • type — varchar(255) — NOT NULL — Schedule Item Type
  • payment_period — varchar(255) — Payment Period
  • payment_status — varchar(255) — NOT NULL — Payment Status
  • scheduled_at — timestamp — Scheduled At
  • paid_at — timestamp — Paid At
  • retry_at — timestamp — Retry At
  • retries_count — int — Retries Count
  • total_scheduled — decimal(12, 4) — Total Scheduled Amount
  • base_total_scheduled — decimal(12, 4) — Base Total Scheduled Amount
  • total_paid — decimal(12, 4) — Total Paid Amount
  • base_total_paid — decimal(12, 4) — Base Total Paid Amount
  • order_id — int — Order Id

aw_sarp2_customer_options

  • id — int — Option ID' primary ke
  • customer_id — int — NOT NULL — Customer ID
  • store_id — smallint — NOT NULL — Store Id
  • option — varchar(255) — NOT NULL — Option
  • value — varchar(255) — Option

aw_sarp2_payment_sampler

  • sampler_id — int — Payment Sampler Id' primary ke
  • method — varchar(128) — NOT NULL — Payment Method Code
  • status — varchar(255) — NOT NULL — Status
  • last_transaction_id — varchar(255) — Last Transaction Id
  • store_id — smallint — NOT NULL — Store Id
  • customer_id — int — NOT NULL — Customer Id
  • quote_id — int — Quote Id
  • amount — decimal(12, 4) — Sample Amount
  • amount_placed — decimal(12, 4) — Placed Amount
  • amount_reverted — decimal(12, 4) — Reverted Amount
  • currency_code — varchar(255) — Currency Code
  • remote_ip — varchar(32) — Remote Ip
  • additional_information — text — Additional Information
  • profile_id — int — NOT NULL — Profile Id
  • revert_attempt_number — int — NOT NULL — Number of attempts

aw_sarp2_payment_token

  • token_id — int — Token Id' primary ke
  • payment_method — varchar(128) — NOT NULL — Payment Method Code
  • type — varchar(128) — NOT NULL — Token Type
  • token_value — varchar(255) — NOT NULL — Token Value
  • created_at — timestamp — NOT NULL — Created At
  • expires_at — timestamp — Expires At
  • is_active — tinyint(1) — NOT NULL — Is Active Flag
  • details — text — Token Details

aw_sarp2_plan

  • plan_id — int — Plan Id' primary ke
  • definition_id — int — NOT NULL — Definition Id
  • status — varchar(255) — NOT NULL — Status
  • name — varchar(255) — NOT NULL — Name
  • sort_order — text — Sort Order
  • regular_price_pattern_percent — decimal(12, 4) — Regular price percentage of product price
  • trial_price_pattern_percent — decimal(12, 4) — Trial price percentage of product price
  • price_rounding — smallint — NOT NULL — Price Rounding

aw_sarp2_plan_definition

  • definition_id — int — Plan Definition Id' primary ke
  • billing_period — varchar(255) — NOT NULL — Billing Period
  • billing_frequency — smallint — NOT NULL — Billing Frequency
  • total_billing_cycles — int — Total Billing Cycles
  • start_date_type — varchar(255) — NOT NULL — Start Sate Type
  • start_date_day_of_month — smallint — Day Of Month Of Start Date
  • is_initial_fee_enabled — tinyint(1) — NOT NULL — Is Initial Fee Enabled
  • is_trial_period_enabled — tinyint(1) — NOT NULL — Is Trial Period Enabled
  • trial_total_billing_cycles — int — Trial Total Billing Cycles
  • is_membership_model_enabled — tinyint(1) — NOT NULL — Is Membership Model
  • upcoming_billing_email_offset — smallint — Upcoming billing email offset
  • trial_billing_period — varchar(255) — Trial Billing Period
  • trial_billing_frequency — smallint — Trial Billing Frequency
  • upcoming_trial_billing_email_offset — smallint — Upcoming trial billing email offset
  • is_extend_enable — tinyint(1) — NOT NULL — Is Offer Extend enable option
  • offer_extend_email_offset — smallint — Offer Extend email offset
  • offer_extend_email_template — varchar(255) — Offer Extend email template
  • is_allow_subscription_cancellation — tinyint(1) — Is Allow Cancellation of Subscription

and 20 more tables