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