There are following below set of Database Tables store Sales Order Data.
sales_order
sales_order_item
sales_order_grid
sales_order_address
sales_order_payment
sales_order_status
[1] sales_order :: store [payement, discount, tax, Customer ID(customer_id), Email, Billing-Shipping payment etc.]
[2] sales_order_item :: Store [Product Details, Order ID(order_id)]
[3] sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]
[4] sales_order_address :: Store [Shipping & Billing Address, , Customer ID(customer_id)], each time store two row one for Billing address and another For shipping address while ordering any product
[5] sales_order_payment :: Store [payment details on the bases of Order ID]
[6] sales_order_status :: Store [Sales Order Status like canceled, closed, complete, fraud, holded, payment_review, Paypal Canceled Reversal, Paypal Reversed, Pending, Pending Payment, Pending Paypal, Processing]
sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]
order_id of sales_order_item Become increment_id of sales_order_grid increment_id display in
Stores -> Configuration–>Sales -> Order
Magento 2 All Database Tables [500 and more Tables]
Which Magento 2 Database Tables Store Sales Order Data
Which Magento 2 Database Tables Store Sales Invoice Order Data
Which Magento 2 Database Tables Store Sales Tax and Its related Data
Which Magento 2 Database Tables Store Catalog Price Rules
Which Magento 2 Database Tables Store Cart Price Rules
Which Magento 2 Database Table Store Patches
Which Magento 2 Database Tables Store Customer Review
Awesome, Magento 2 Sales Orders Tables info, really very beneficial info.
Thank you very much.
Please follow YouTube Video where things are summarized very easy way as well as other Blog content
https://bit.ly/3oaqHVm