yuyr/webrlvr
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
webrlvr/static_workflow/table_samples_cache.txt
yuyr f34e4a464d 完成三种构建方法
2025-06-11 17:30:06 +08:00

220 lines
31 KiB
Plaintext
Raw Permalink Blame History

--- Sample rows for table: sales_order ---
entity_id, state, status, coupon_code, protect_code, shipping_description, is_virtual, store_id, customer_id, base_discount_amount, base_discount_canceled, base_discount_invoiced, base_discount_refunded, base_grand_total, base_shipping_amount, base_shipping_canceled, base_shipping_invoiced, base_shipping_refunded, base_shipping_tax_amount, base_shipping_tax_refunded, base_subtotal, base_subtotal_canceled, base_subtotal_invoiced, base_subtotal_refunded, base_tax_amount, base_tax_canceled, base_tax_invoiced, base_tax_refunded, base_to_global_rate, base_to_order_rate, base_total_canceled, base_total_invoiced, base_total_invoiced_cost, base_total_offline_refunded, base_total_online_refunded, base_total_paid, base_total_qty_ordered, base_total_refunded, discount_amount, discount_canceled, discount_invoiced, discount_refunded, grand_total, shipping_amount, shipping_canceled, shipping_invoiced, shipping_refunded, shipping_tax_amount, shipping_tax_refunded, store_to_base_rate, store_to_order_rate, subtotal, subtotal_canceled, subtotal_invoiced, subtotal_refunded, tax_amount, tax_canceled, tax_invoiced, tax_refunded, total_canceled, total_invoiced, total_offline_refunded, total_online_refunded, total_paid, total_qty_ordered, total_refunded, can_ship_partially, can_ship_partially_item, customer_is_guest, customer_note_notify, billing_address_id, customer_group_id, edit_increment, email_sent, send_email, forced_shipment_with_invoice, payment_auth_expiration, quote_address_id, quote_id, shipping_address_id, adjustment_negative, adjustment_positive, base_adjustment_negative, base_adjustment_positive, base_shipping_discount_amount, base_subtotal_incl_tax, base_total_due, payment_authorization_amount, shipping_discount_amount, subtotal_incl_tax, total_due, weight, customer_dob, increment_id, applied_rule_ids, base_currency_code, customer_email, customer_firstname, customer_lastname, customer_middlename, customer_prefix, customer_suffix, customer_taxvat, discount_description, ext_customer_id, ext_order_id, global_currency_code, hold_before_state, hold_before_status, order_currency_code, original_increment_id, relation_child_id, relation_child_real_id, relation_parent_id, relation_parent_real_id, remote_ip, shipping_method, store_currency_code, store_name, x_forwarded_for, customer_note, created_at, updated_at, total_item_count, customer_gender, discount_tax_compensation_amount, base_discount_tax_compensation_amount, shipping_discount_tax_compensation_amount, base_shipping_discount_tax_compensation_amnt, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, shipping_incl_tax, base_shipping_incl_tax, coupon_rule_name, gift_message_id, paypal_ipn_customer_notified
1, canceled, canceled, NULL, a097e3c6e0615193119a5e6365064aae, Flat Rate - Fixed, 0, 1, 1, 0.0000, NULL, 0.0000, NULL, 36.3900, 5.0000, NULL, 5.0000, NULL, 0.0000, NULL, 29.0000, NULL, 29.0000, NULL, 2.3900, NULL, 2.3900, NULL, 1.0000, 1.0000, NULL, 36.3900, 0.0000, NULL, NULL, 36.3900, NULL, NULL, 0.0000, NULL, 0.0000, NULL, 36.3900, 5.0000, NULL, 5.0000, NULL, 0.0000, NULL, 0.0000, 0.0000, 29.0000, NULL, 29.0000, NULL, 2.3900, NULL, 2.3900, NULL, NULL, 36.3900, NULL, NULL, 36.3900, 1.0000, NULL, NULL, NULL, 0, 1, 2, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, 0.0000, 31.3900, 36.3900, NULL, 0.0000, 31.3900, 36.3900, 1.0000, 1973-12-15 00:00:00, 000000001, 1, USD, roni_cost@example.com, Veronica, Costello, NULL, NULL, NULL, NULL, NULL, NULL, NULL, USD, NULL, NULL, USD, NULL, NULL, NULL, NULL, NULL, NULL, flatrate_flatrate, USD, Main Website
Main Website Store
Default Store View, NULL, NULL, 2022-03-30 01:36:37, 2023-04-23 23:35:55, 1, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, 5.0000, 5.0000, NULL, NULL, 0
2, closed, closed, NULL, 4af608fd362986ce93d8aad4acba5e3c, Flat Rate - Fixed, 0, 1, 1, 0.0000, NULL, 0.0000, 0.0000, 39.6400, 5.0000, NULL, 5.0000, 5.0000, 0.0000, 0.0000, 32.0000, NULL, 32.0000, 32.0000, 2.6400, NULL, 2.6400, 2.6400, 1.0000, 1.0000, NULL, 39.6400, 0.0000, 39.6400, NULL, 39.6400, NULL, 39.6400, 0.0000, NULL, 0.0000, 0.0000, 39.6400, 5.0000, NULL, 5.0000, 5.0000, 0.0000, 0.0000, 0.0000, 0.0000, 32.0000, NULL, 32.0000, 32.0000, 2.6400, NULL, 2.6400, 2.6400, NULL, 39.6400, 39.6400, NULL, 39.6400, 1.0000, 39.6400, NULL, NULL, 0, 1, 4, 1, NULL, NULL, NULL, NULL, NULL, NULL, 2, 3, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 34.6400, 0.0000, NULL, 0.0000, 34.6400, 0.0000, 1.0000, 1973-12-15 00:00:00, 000000002, 1, USD, roni_cost@example.com, Veronica, Costello, NULL, NULL, NULL, NULL, NULL, NULL, NULL, USD, NULL, NULL, USD, NULL, NULL, NULL, NULL, NULL, NULL, flatrate_flatrate, USD, Main Website
Main Website Store
Default Store View, NULL, NULL, 2022-04-24 20:36:28, 2023-04-23 23:35:55, 1, 2, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 5.0000, 5.0000, NULL, NULL, 0
3, canceled, canceled, NULL, cbba92780eeda9267bc3c64ff4bdad71, Flat Rate - Fixed, 0, 1, 34, 0.0000, NULL, NULL, NULL, 160.2500, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 145.2500, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 1.0000, 1.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 160.2500, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 0.0000, 0.0000, 145.2500, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3.0000, NULL, NULL, NULL, 0, 1, 6, 1, NULL, 1, 1, NULL, NULL, NULL, 4, 5, NULL, NULL, NULL, NULL, 0.0000, 145.2500, 160.2500, NULL, 0.0000, 145.2500, 160.2500, 3.0000, NULL, 000000003, 2, USD, brian.smith@yahoo.com, Brian, Smith, NULL, NULL, NULL, NULL, NULL, NULL, NULL, USD, NULL, NULL, USD, NULL, NULL, NULL, NULL, NULL, 128.2.205.52, flatrate_flatrate, USD, Main Website
Main Website Store
Default Store View, NULL, NULL, 2022-10-27 04:32:53, 2023-04-23 23:35:56, 3, NULL, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 0
4, complete, complete, NULL, 193721b51b6bd9cbbad80daeb9c2c0b9, Flat Rate - Fixed, 0, 1, 15, 0.0000, NULL, NULL, NULL, 106.0000, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 91.0000, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 1.0000, 1.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 106.0000, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 0.0000, 0.0000, 91.0000, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3.0000, NULL, NULL, NULL, 0, 1, 8, 1, NULL, 1, 1, NULL, NULL, NULL, 5, 7, NULL, NULL, NULL, NULL, 0.0000, 91.0000, 106.0000, NULL, 0.0000, 91.0000, 106.0000, 3.0000, NULL, 000000004, 1,2, USD, janesmith456@yahoo.com, Jane, Smith, NULL, NULL, NULL, NULL, NULL, NULL, NULL, USD, NULL, NULL, USD, NULL, NULL, NULL, NULL, NULL, 128.2.205.52, flatrate_flatrate, USD, Main Website
Main Website Store
Default Store View, NULL, NULL, 2023-02-03 23:08:03, 2023-04-23 23:35:56, 3, NULL, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 0
5, canceled, canceled, NULL, 021fe2f4b27218c35c6ed8cd120cc914, Flat Rate - Fixed, 0, 1, 18, 0.0000, NULL, NULL, NULL, 137.0000, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 122.0000, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 1.0000, 1.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, 137.0000, 15.0000, NULL, NULL, NULL, 0.0000, NULL, 0.0000, 0.0000, 122.0000, NULL, NULL, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3.0000, NULL, NULL, NULL, 0, 1, 10, 1, NULL, 1, 1, NULL, NULL, NULL, 6, 9, NULL, NULL, NULL, NULL, 0.0000, 122.0000, 137.0000, NULL, 0.0000, 122.0000, 137.0000, 3.0000, NULL, 000000005, 2, USD, avidreader99@yahoo.com, Grace, Nguyen, NULL, NULL, NULL, NULL, NULL, NULL, NULL, USD, NULL, NULL, USD, NULL, NULL, NULL, NULL, NULL, 128.2.205.52, flatrate_flatrate, USD, Main Website
Main Website Store
Default Store View, NULL, NULL, 2022-08-24 05:11:45, 2023-04-23 23:35:57, 3, NULL, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 0
--- Sample rows for table: sales_order_item ---
item_id, order_id, parent_item_id, quote_item_id, store_id, created_at, updated_at, product_id, product_type, product_options, weight, is_virtual, sku, name, description, applied_rule_ids, additional_data, is_qty_decimal, no_discount, qty_backordered, qty_canceled, qty_invoiced, qty_ordered, qty_refunded, qty_shipped, base_cost, price, base_price, original_price, base_original_price, tax_percent, tax_amount, base_tax_amount, tax_invoiced, base_tax_invoiced, discount_percent, discount_amount, base_discount_amount, discount_invoiced, base_discount_invoiced, amount_refunded, base_amount_refunded, row_total, base_row_total, row_invoiced, base_row_invoiced, row_weight, base_tax_before_discount, tax_before_discount, ext_order_item_id, locked_do_invoice, locked_do_ship, price_incl_tax, base_price_incl_tax, row_total_incl_tax, base_row_total_incl_tax, discount_tax_compensation_amount, base_discount_tax_compensation_amount, discount_tax_compensation_invoiced, base_discount_tax_compensation_invoiced, discount_tax_compensation_refunded, base_discount_tax_compensation_refunded, tax_canceled, discount_tax_compensation_canceled, tax_refunded, base_tax_refunded, discount_refunded, base_discount_refunded, gift_message_id, gift_message_available, free_shipping, weee_tax_applied, weee_tax_applied_amount, weee_tax_applied_row_amount, weee_tax_disposition, weee_tax_row_disposition, base_weee_tax_applied_amount, base_weee_tax_applied_row_amnt, base_weee_tax_disposition, base_weee_tax_row_disposition
1, 1, NULL, NULL, 1, 2023-04-19 16:15:45, 2023-04-19 21:53:06, 1428, configurable, {"info_buyRequest":{"qty":"1.0000","super_attribute":{"144":"166","93":"58"},"options":[]},"attributes_info":[{"label":"Size","value":"XS","option_id":144,"option_value":"166"},{"label":"Color","value":"Red","option_id":93,"option_value":"58"}],"simple_name":"Iris Workout Top-XS-Red","simple_sku":"WS03-XS-Red","product_calculations":1,"shipment_type":0}, 1.0000, NULL, WS03-XS-Red, Iris Workout Top, NULL, 1, NULL, 0, 0, NULL, 0.0000, 1.0000, 1.0000, 0.0000, 1.0000, NULL, 29.0000, 29.0000, 29.0000, 29.0000, 8.2500, 2.3900, 2.3900, 2.3900, 2.3900, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 29.0000, 29.0000, 29.0000, 29.0000, 1.0000, NULL, NULL, NULL, NULL, NULL, 31.3900, 31.3900, 31.3900, 31.3900, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
2, 2, NULL, NULL, 1, 2023-04-19 16:15:46, 2023-04-19 16:15:47, 1492, configurable, {"info_buyRequest":{"qty":"1.0000","super_attribute":{"144":"166","93":"50"},"options":[]},"attributes_info":[{"label":"Size","value":"XS","option_id":144,"option_value":"166"},{"label":"Color","value":"Blue","option_id":93,"option_value":"50"}],"simple_name":"Minerva LumaTech™ V-Tee-XS-Blue","simple_sku":"WS08-XS-Blue","product_calculations":1,"shipment_type":0}, 1.0000, NULL, WS08-XS-Blue, Minerva LumaTech™ V-Tee, NULL, 1, NULL, 0, 0, NULL, 0.0000, 1.0000, 1.0000, 1.0000, 1.0000, NULL, 32.0000, 32.0000, 32.0000, 32.0000, 8.2500, 2.6400, 2.6400, 2.6400, 2.6400, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 32.0000, 32.0000, 32.0000, 32.0000, 32.0000, 32.0000, 1.0000, NULL, NULL, NULL, NULL, NULL, 34.6400, 34.6400, 34.6400, 34.6400, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, 2.6400, 2.6400, 0.0000, 0.0000, NULL, NULL, 0, [], NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
3, 3, NULL, 7, 1, 2023-04-19 21:52:45, 2023-04-19 21:52:45, 1222, simple, {"info_buyRequest":{"qty":1}}, 1.0000, 0, WJ02-XS-Blue, Josie Yoga Jacket-XS-Blue, NULL, 2, NULL, 0, 0, NULL, 0.0000, 0.0000, 1.0000, 0.0000, 0.0000, NULL, 56.2500, 56.2500, 56.2500, 56.2500, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 56.2500, 56.2500, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, 56.2500, 56.2500, 56.2500, 56.2500, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
4, 3, NULL, 8, 1, 2023-04-19 21:52:45, 2023-04-19 21:52:45, 1943, simple, {"info_buyRequest":{"qty":1}}, 1.0000, 0, WSH03-30-Gray, Gwen Drawstring Bike Short-30-Gray, NULL, 2, NULL, 0, 0, NULL, 0.0000, 0.0000, 1.0000, 0.0000, 0.0000, NULL, 50.0000, 50.0000, 50.0000, 50.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 50.0000, 50.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, 50.0000, 50.0000, 50.0000, 50.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
5, 3, NULL, 9, 1, 2023-04-19 21:52:45, 2023-04-19 21:52:45, 1149, simple, {"info_buyRequest":{"qty":1}}, 1.0000, 0, WH09-XS-Red, Ariel Roll Sleeve Sweatshirt-XS-Red, NULL, 2, NULL, 0, 0, NULL, 0.0000, 0.0000, 1.0000, 0.0000, 0.0000, NULL, 39.0000, 39.0000, 39.0000, 39.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 39.0000, 39.0000, 0.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, 39.0000, 39.0000, 39.0000, 39.0000, 0.0000, 0.0000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
--- Sample rows for table: eav_entity_type ---
entity_type_id, entity_type_code, entity_model, attribute_model, entity_table, value_table_prefix, entity_id_field, is_data_sharing, data_sharing_key, default_attribute_set_id, increment_model, increment_per_store, increment_pad_length, increment_pad_char, additional_attribute_table, entity_attribute_collection
1, customer, Magento\Customer\Model\ResourceModel\Customer, Magento\Customer\Model\Attribute, customer_entity, NULL, NULL, 1, default, 1, Magento\Eav\Model\Entity\Increment\NumericValue, 0, 8, 0, customer_eav_attribute, Magento\Customer\Model\ResourceModel\Attribute\Collection
2, customer_address, Magento\Customer\Model\ResourceModel\Address, Magento\Customer\Model\Attribute, customer_address_entity, NULL, NULL, 1, default, 2, NULL, 0, 8, 0, customer_eav_attribute, Magento\Customer\Model\ResourceModel\Address\Attribute\Collection
3, catalog_category, Magento\Catalog\Model\ResourceModel\Category, Magento\Catalog\Model\ResourceModel\Eav\Attribute, catalog_category_entity, NULL, NULL, 1, default, 3, NULL, 0, 8, 0, catalog_eav_attribute, Magento\Catalog\Model\ResourceModel\Category\Attribute\Collection
4, catalog_product, Magento\Catalog\Model\ResourceModel\Product, Magento\Catalog\Model\ResourceModel\Eav\Attribute, catalog_product_entity, NULL, NULL, 1, default, 4, NULL, 0, 8, 0, catalog_eav_attribute, Magento\Catalog\Model\ResourceModel\Product\Attribute\Collection
5, order, Magento\Sales\Model\ResourceModel\Order, NULL, sales_order, NULL, NULL, 1, default, 5, Magento\Eav\Model\Entity\Increment\NumericValue, 1, 8, 0, NULL, NULL
--- Sample rows for table: customer_group ---
customer_group_id, customer_group_code, tax_class_id
0, NOT LOGGED IN, 3
1, General, 3
2, Wholesale, 3
3, Retailer, 3
--- Sample rows for table: catalog_product_entity_decimal ---
value_id, attribute_id, store_id, entity_id, value
1, 77, 0, 1, 34.000000
2, 77, 0, 2, 32.000000
3, 78, 0, 2, 32.000000
4, 77, 0, 3, 38.000000
5, 77, 0, 4, 45.000000
--- Sample rows for table: catalog_product_entity_int ---
value_id, attribute_id, store_id, entity_id, value
1, 97, 0, 1, 1
2, 99, 0, 1, 4
3, 97, 0, 2, 1
4, 99, 0, 2, 4
5, 136, 0, 2, 2
--- Sample rows for table: customer_entity ---
entity_id, website_id, email, group_id, increment_id, store_id, created_at, updated_at, is_active, disable_auto_group_change, created_in, prefix, firstname, middlename, lastname, suffix, dob, password_hash, rp_token, rp_token_created_at, default_billing, default_shipping, taxvat, confirmation, gender, failures_num, first_failure, lock_expires, session_cutoff
1, 1, roni_cost@example.com, 1, NULL, 1, 2023-04-19 16:15:35, 2023-04-19 16:15:36, 1, 0, Default Store View, NULL, Veronica, NULL, Costello, NULL, 1973-12-15, 48e901af81a098ea54ecb0b014805e7e47c68212c09e8f5e15bbc589bf7bd3a5:Q9WIXO5QZq4u8gZwjuFRbd4BhIjPPauQ:3_32_2_67108864, 0:3:+isFgVuaSN8keSmd9FhTpIXE/xH61xUg0JLYNVcXek/liRqi1rIXf3P0lvfgNGCxJRLCu1L0e9g75xwB, 2023-04-19 16:15:36, 1, 1, NULL, NULL, 2, 0, NULL, NULL, NULL
2, 1, john.smith.xyz@gmail.com, 1, NULL, 1, 2023-04-19 21:44:57, 2023-04-19 21:44:57, 1, 0, Default Store View, NULL, John, NULL, Smith, NULL, NULL, 33fe6d4fd6e7014839809617b8c2b6aa23e53ad98a34e24a950655829742cad1:cPQxgya3eXBYfqLXbNl3CQ5TgNvOInLA:3_32_2_67108864, 0:3:/mGGadZj8KkXjgeoFhwbXS/8IQ5yzvuFTrDYv3h/ZlJn3vHUBCz1jDOmFqNsqu4lBhrb1INIs1lKtfr3, 2023-04-19 21:44:57, 2, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL
3, 1, jane.doe@hotmail.com, 1, NULL, 1, 2023-04-19 21:45:01, 2023-04-19 21:45:01, 1, 0, Default Store View, NULL, Jane, NULL, Doe, NULL, NULL, 884b0e2aa55762cebecda73e15e1f85a90006644e1158a1d7de76e93ece21987:aVjGvRn6eeiBIukVfKte6voIjdagqQO7:3_32_2_67108864, 0:3:5X5LH8SQd/K3EZbVdtNtHFxcqI4hEE1+KTKjHeZYjJiLbWHjwH8LfiV2U5RjnvJzm/hzwGHbiR0265pG, 2023-04-19 21:45:01, 3, 3, NULL, NULL, NULL, 0, NULL, NULL, NULL
4, 1, bbjones@gmail.com, 1, NULL, 1, 2023-04-19 21:45:04, 2023-04-19 21:45:04, 1, 0, Default Store View, NULL, Bob, NULL, Jones, NULL, NULL, 7f16d0c52333dc1f969a349b235de3657e1b73ab6739df865a92c4d31f8b2ce4:BVjUGoW9jOrGyS27egyHNDyXOkY7rBWL:3_32_2_67108864, 0:3:S62cumQcL9vOv3m8xhTYxAWMokWO6b0EiuneijkrpbkU4ABJXg2iOqMSfeTpPm6yD2vS5QkmJ75NBhq8, 2023-04-19 21:45:04, 4, 4, NULL, NULL, NULL, 0, NULL, NULL, NULL
5, 1, helloworld@yahoo.com, 1, NULL, 1, 2023-04-19 21:45:07, 2023-04-19 21:45:07, 1, 0, Default Store View, NULL, Sarah, NULL, Miller, NULL, NULL, 4b24b99f36869873948cb6dcb502a520b06fe87a34492af1682c87880f94c9e5:hrDFhhNuSpBIOROn2TZwgZaV5GPyOgLQ:3_32_2_67108864, 0:3:8iKQHmfSso2/C+Xni572SJv6PNxsNZpftsH+PRf4zgdZczDKP8xD4sAtxgBSTCdP6agG875Bu78cntI2, 2023-04-19 21:45:07, 5, 5, NULL, NULL, NULL, 0, NULL, NULL, NULL
--- Sample rows for table: catalog_category_entity ---
entity_id, attribute_set_id, parent_id, created_at, updated_at, path, position, level, children_count
1, 3, 0, 2023-04-19 15:41:34, 2023-04-19 16:15:40, 1, 0, 0, 39
2, 3, 1, 2023-04-19 15:41:34, 2023-04-19 16:15:40, 1/2, 1, 1, 38
3, 3, 2, 2023-04-19 16:12:35, 2023-04-19 16:12:35, 1/2/3, 4, 2, 3
4, 3, 3, 2023-04-19 16:12:35, 2023-04-19 16:12:35, 1/2/3/4, 1, 3, 0
5, 3, 3, 2023-04-19 16:12:35, 2023-04-19 16:12:35, 1/2/3/5, 2, 3, 0
--- Sample rows for table: customer_address_entity ---
entity_id, increment_id, parent_id, created_at, updated_at, is_active, city, company, country_id, fax, firstname, lastname, middlename, postcode, prefix, region, region_id, street, suffix, telephone, vat_id, vat_is_valid, vat_request_date, vat_request_id, vat_request_success
1, NULL, 1, 2023-04-19 16:15:36, 2023-04-19 16:15:36, 1, Calder, NULL, US, NULL, Veronica, Costello, NULL, 49628-7978, NULL, Michigan, 33, 6146 Honey Bluff Parkway, NULL, (555) 229-3326, NULL, NULL, NULL, NULL, NULL
2, NULL, 2, 2023-04-19 21:44:57, 2023-04-19 23:36:29, 1, Birmingham, NULL, US, NULL, John, Smith, NULL, 35213, NULL, Alabama, 1, 123 Main Street, NULL, 2058812302, NULL, NULL, NULL, NULL, NULL
3, NULL, 3, 2023-04-19 21:45:01, 2023-04-19 23:41:21, 1, Miami, NULL, US, NULL, Jane, Doe, NULL, 33139, NULL, Florida, 18, 567 Ocean Drive, NULL, 4123671901, NULL, NULL, NULL, NULL, NULL
4, NULL, 4, 2023-04-19 21:45:04, 2023-04-19 23:38:55, 1, Dallas, NULL, US, NULL, Bob, Jones, NULL, 75202, NULL, Texas, 57, 890 Elm Street, NULL, 2141918677, NULL, NULL, NULL, NULL, NULL
5, NULL, 5, 2023-04-19 21:45:07, 2023-04-19 23:40:48, 1, Oakland, NULL, US, NULL, Sarah, Miller, NULL, 94602, NULL, California, 12, 321 Maple Avenue, NULL, 5107819902, NULL, NULL, NULL, NULL, NULL
--- Sample rows for table: sales_order_payment ---
entity_id, parent_id, base_shipping_captured, shipping_captured, amount_refunded, base_amount_paid, amount_canceled, base_amount_authorized, base_amount_paid_online, base_amount_refunded_online, base_shipping_amount, shipping_amount, amount_paid, amount_authorized, base_amount_ordered, base_shipping_refunded, shipping_refunded, base_amount_refunded, amount_ordered, base_amount_canceled, quote_payment_id, additional_data, cc_exp_month, cc_ss_start_year, echeck_bank_name, method, cc_debug_request_body, cc_secure_verify, protection_eligibility, cc_approval, cc_last_4, cc_status_description, echeck_type, cc_debug_response_serialized, cc_ss_start_month, echeck_account_type, last_trans_id, cc_cid_status, cc_owner, cc_type, po_number, cc_exp_year, cc_status, echeck_routing_number, account_status, anet_trans_method, cc_debug_response_body, cc_ss_issue, echeck_account_name, cc_avs_status, cc_number_enc, cc_trans_id, address_status, additional_information
1, 1, 5.0000, 5.0000, NULL, 36.3900, NULL, NULL, NULL, NULL, 5.0000, 5.0000, 36.3900, NULL, 36.3900, NULL, NULL, NULL, 36.3900, NULL, NULL, NULL, NULL, NULL, NULL, checkmo, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, {"method_title":"Check \/ Money order"}
2, 2, 5.0000, 5.0000, 39.6400, 39.6400, NULL, NULL, NULL, NULL, 5.0000, 5.0000, 39.6400, NULL, 39.6400, 5.0000, 5.0000, 39.6400, 39.6400, NULL, NULL, NULL, NULL, NULL, NULL, checkmo, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, {"method_title":"Check \/ Money order"}
3, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 160.2500, NULL, NULL, NULL, 160.2500, NULL, NULL, NULL, NULL, NULL, NULL, checkmo, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, {"method_title":"Check \/ Money order"}
4, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 106.0000, NULL, NULL, NULL, 106.0000, NULL, NULL, NULL, NULL, NULL, NULL, checkmo, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, {"method_title":"Check \/ Money order"}
5, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15.0000, 15.0000, NULL, NULL, 137.0000, NULL, NULL, NULL, 137.0000, NULL, NULL, NULL, NULL, NULL, NULL, checkmo, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, {"method_title":"Check \/ Money order"}
--- Sample rows for table: review ---
review_id, created_at, entity_id, entity_pk_value, status_id
1, 2023-04-19 16:15:10, 1, 1, 1
2, 2023-04-19 16:15:11, 1, 1, 1
3, 2023-04-19 16:15:11, 1, 6, 1
4, 2023-04-19 16:15:11, 1, 6, 1
5, 2023-04-19 16:15:11, 1, 6, 1
--- Sample rows for table: review_status ---
status_id, status_code
1, Approved
2, Pending
3, Not Approved
--- Sample rows for table: url_rewrite ---
url_rewrite_id, entity_type, entity_id, request_path, target_path, redirect_type, store_id, description, is_autogenerated, metadata
1, cms-page, 1, no-route, cms/page/view/page_id/1, 0, 1, NULL, 1, NULL
2, cms-page, 2, home, cms/page/view/page_id/2, 0, 1, NULL, 1, NULL
3, cms-page, 3, enable-cookies, cms/page/view/page_id/3, 0, 1, NULL, 1, NULL
4, cms-page, 4, privacy-policy-cookie-restriction-mode, cms/page/view/page_id/4, 0, 1, NULL, 1, NULL
5, category, 3, gear.html, catalog/category/view/id/3, 0, 1, NULL, 1, NULL
--- Sample rows for table: catalog_category_product ---
entity_id, category_id, product_id, position
1, 3, 1, 0
2, 4, 1, 0
3, 3, 2, 0
4, 7, 2, 0
5, 4, 2, 0
--- Sample rows for table: catalog_product_entity_varchar ---
value_id, attribute_id, store_id, entity_id, value
1, 73, 0, 1, Joust Duffle Bag
2, 121, 0, 1, joust-duffle-bag
3, 87, 0, 1, /c/o/computer-test.jpg
4, 88, 0, 1, /c/o/computer-test.jpg
5, 89, 0, 1, /c/o/computer-test.jpg
--- Sample rows for table: eav_attribute ---
attribute_id, entity_type_id, attribute_code, attribute_model, backend_model, backend_type, backend_table, frontend_model, frontend_input, frontend_label, frontend_class, source_model, is_required, is_user_defined, default_value, is_unique, note
1, 1, website_id, NULL, Magento\Customer\Model\Customer\Attribute\Backend\Website, static, NULL, NULL, select, Associate to Website, NULL, Magento\Customer\Model\Customer\Attribute\Source\Website, 1, 0, NULL, 0, NULL
2, 1, store_id, NULL, Magento\Customer\Model\Customer\Attribute\Backend\Store, static, NULL, NULL, select, Create In, NULL, Magento\Customer\Model\Customer\Attribute\Source\Store, 1, 0, NULL, 0, NULL
3, 1, created_in, NULL, NULL, static, NULL, NULL, text, Created From, NULL, NULL, 0, 0, NULL, 0, NULL
4, 1, prefix, NULL, NULL, static, NULL, NULL, text, Name Prefix, NULL, NULL, 0, 0, NULL, 0, NULL
5, 1, firstname, NULL, NULL, static, NULL, NULL, text, First Name, NULL, NULL, 1, 0, NULL, 0, NULL
--- Sample rows for table: store_website ---
website_id, code, name, sort_order, default_group_id, is_default
0, admin, Admin, 0, 0, 0
1, base, Main Website, 0, 1, 1
--- Sample rows for table: review_detail ---
detail_id, review_id, store_id, title, detail, nickname, customer_id
1, 1, 1, I prefer more compartments, I prefer more compartments. If you don't mind putting everything in one space, it's fine. Good for the gym., Chi, NULL
2, 2, 1, I use it a lot , It's a good size and I use it a lot. My only issue with it was I wanted the handles to be longer so I can wear it on my back., Filiberto, NULL
3, 3, 1, I've had this thing for really long, I've had this thing for a really long time and it barely shows any signs of wear and tear. It's really big, too! I've taken it on day trips as well as short vacations and usually have no trouble finding room for my stuff., Herb, NULL
4, 4, 1, Decent bag, Decent bag. I keep my stuff in it for work and the gym. It's nice and roomy. I wish it had a more sophisticated design, though. Kinda looks like it's for kids., Craig, NULL
5, 5, 1, Screwed up my back, I can't believe they're claiming these straps are "padded." Wearing this thing to class for a semester totally screwed up my back, and my shoulders would start to ache after a few minutes where the straps dug in., Orville, NULL
--- Sample rows for table: core_config_data ---
config_id, scope, scope_id, path, value, updated_at
1, default, 0, web/seo/use_rewrites, 1, 2023-04-19 15:41:22
2, default, 0, web/unsecure/base_url, http://localhost:28083/, 2025-06-03 03:27:41
3, default, 0, general/locale/code, en_US, 2023-04-19 15:41:23
4, default, 0, general/locale/timezone, America/New_York, 2023-04-19 15:41:23
5, default, 0, currency/options/base, USD, 2023-04-19 15:41:24
--- Sample rows for table: sales_order_grid ---
entity_id, status, store_id, store_name, customer_id, base_grand_total, base_total_paid, grand_total, total_paid, increment_id, base_currency_code, order_currency_code, shipping_name, billing_name, created_at, updated_at, billing_address, shipping_address, shipping_information, customer_email, customer_group, subtotal, shipping_and_handling, customer_name, payment_method, total_refunded, pickup_location_code
1, canceled, 1, Main Website
Main Website Store
Default Store View, 1, 36.3900, 36.3900, 36.3900, 36.3900, 000000001, USD, USD, Veronica Costello, Veronica Costello, 2022-03-30 01:36:37, 2023-04-23 23:35:55, 6146 Honey Bluff Parkway,Calder,Michigan,49628-7978, 6146 Honey Bluff Parkway,Calder,Michigan,49628-7978, Flat Rate - Fixed, roni_cost@example.com, 1, 29.0000, 5.0000, Veronica Costello, checkmo, NULL, NULL
2, closed, 1, Main Website
Main Website Store
Default Store View, 1, 39.6400, 39.6400, 39.6400, 39.6400, 000000002, USD, USD, Veronica Costello, Veronica Costello, 2022-04-24 20:36:28, 2023-04-23 23:35:55, 6146 Honey Bluff Parkway,Calder,Michigan,49628-7978, 6146 Honey Bluff Parkway,Calder,Michigan,49628-7978, Flat Rate - Fixed, roni_cost@example.com, 1, 32.0000, 5.0000, Veronica Costello, checkmo, 39.6400, NULL
3, canceled, 1, Main Website
Main Website Store
Default Store View, 34, 160.2500, NULL, 160.2500, NULL, 000000003, USD, USD, Brian Smith, Brian Smith, 2022-10-27 04:32:53, 2023-04-23 23:35:56, 456 Las Vegas Blvd S,Las Vegas,Nevada,89109, 456 Las Vegas Blvd S,Las Vegas,Nevada,89109, Flat Rate - Fixed, brian.smith@yahoo.com, 1, 145.2500, 15.0000, Brian Smith, checkmo, NULL, NULL
4, complete, 1, Main Website
Main Website Store
Default Store View, 15, 106.0000, NULL, 106.0000, NULL, 000000004, USD, USD, Jane Smith, Jane Smith, 2023-02-03 23:08:03, 2023-04-23 23:35:56, 456 Beverly Hills Blvd,Beverly Hills,California,90210, 456 Beverly Hills Blvd,Beverly Hills,California,90210, Flat Rate - Fixed, janesmith456@yahoo.com, 1, 91.0000, 15.0000, Jane Smith, checkmo, NULL, NULL
5, canceled, 1, Main Website
Main Website Store
Default Store View, 18, 137.0000, NULL, 137.0000, NULL, 000000005, USD, USD, Grace Nguyen, Grace Nguyen, 2022-08-24 05:11:45, 2023-04-23 23:35:57, 789 Harvard Square,Cambridge,Massachusetts,02138, 789 Harvard Square,Cambridge,Massachusetts,02138, Flat Rate - Fixed, avidreader99@yahoo.com, 1, 122.0000, 15.0000, Grace Nguyen, checkmo, NULL, NULL
--- Sample rows for table: cataloginventory_stock_status ---
product_id, website_id, stock_id, qty, stock_status
1, 0, 1, 100.0000, 0
2, 0, 1, 100.0000, 1
3, 0, 1, 100.0000, 1
4, 0, 1, 100.0000, 1
5, 0, 1, 100.0000, 1
--- Sample rows for table: inventory_source_item ---
source_item_id, source_code, sku, quantity, status
1, default, 24-MB01, 100.0000, 1
2, default, 24-MB04, 100.0000, 1
3, default, 24-MB03, 100.0000, 1
4, default, 24-MB05, 100.0000, 1
5, default, 24-MB06, 100.0000, 1
--- Sample rows for table: catalog_product_index_price ---
entity_id, customer_group_id, website_id, tax_class_id, price, final_price, min_price, max_price, tier_price
1, 0, 1, 0, 34.000000, 34.000000, 34.000000, 34.000000, NULL
1, 1, 1, 0, 34.000000, 27.200000, 27.200000, 34.000000, NULL
1, 2, 1, 0, 34.000000, 34.000000, 34.000000, 34.000000, NULL
1, 3, 1, 0, 34.000000, 34.000000, 34.000000, 34.000000, NULL
2, 0, 1, 2, 32.000000, 32.000000, 32.000000, 32.000000, NULL
--- Sample rows for table: store ---
store_id, code, website_id, group_id, name, sort_order, is_active
0, admin, 0, 0, Admin, 0, 1
1, default, 1, 1, Default Store View, 0, 1
--- Sample rows for table: catalog_product_entity ---
entity_id, attribute_set_id, type_id, sku, has_options, required_options, created_at, updated_at
1, 15, simple, 24-MB01, 0, 0, 2023-04-19 16:12:35, 2023-04-19 16:48:23
2, 15, simple, 24-MB04, 0, 0, 2023-04-19 16:12:37, 2023-04-19 16:12:37
3, 15, simple, 24-MB03, 0, 0, 2023-04-19 16:12:38, 2023-04-19 16:12:38
4, 15, simple, 24-MB05, 0, 0, 2023-04-19 16:12:38, 2023-04-19 16:12:38
5, 15, simple, 24-MB06, 0, 0, 2023-04-19 16:12:39, 2023-04-19 16:12:39
--- Sample rows for table: catalog_category_entity_varchar ---
value_id, attribute_id, store_id, entity_id, value
1, 45, 0, 1, Root Catalog
2, 45, 0, 2, Default Category
3, 52, 0, 2, PRODUCTS
4, 45, 0, 3, Gear
5, 52, 0, 3, PAGE
Reference in New Issue View Git Blame Copy Permalink