OpenCart Community

All these or am I missing others?

• order
  order_history
  order_option
  order_product
  order_recurring
  order_recurring_transaction
  order_shipment
  order_status
  order_total
  order_voucher

• customer
  customer_activity
  customer_affiliate
  customer_approval
  customer_group
  customer_group_description
  customer_history
  customer_ip
  customer_login
  customer_online
  customer_reward
  customer_search
  customer_transaction
  customer_wishlist
  custom_field
  custom_field_customer_group
  custom_field_description
  custom_field_value
  custom_field_value_description

On GitHub, you could search for the: system/helper/db_schema.php file and lookup for each: order_id database fields. This will also show you the table source name that each orders are associated into despite if a customer has been logged with the order or without.

However, take note that this methodology may exclude the aside extensions you may had installed on your store which may also contain other order_id database fields. Otherwise, you may need to pull in a schema query from PHPMyAdmin (direct) to pull all the order_id database fields which will include all database tables.

Just take a look at the schema of all the table in your database, if it contains order_id or customer_id then include that file also. In this way, third-party extension tables that use order_id or customer_id will also get included.

I KNOW this is years old post but since I just did this on a test store this is what I got:
TABLE_NAME  1 | COLUMN_NAME
address | customer_id
cart | customer_id
coupon_history | customer_id
customer | customer_id
customer_activity | customer_id
customer_field | customer_id
customer_history | customer_id
customer_ip | customer_id
customer_online | customer_id
customer_reward | customer_id
customer_search | customer_id
customer_transaction | customer_id
customer_wishlist | customer_id
order | customer_id
order_fraud | customer_id
return | customer_id
review | customer_id
affiliate_transaction | order_id
apri | order_id
coupon_history | order_id
customer_reward | order_id
customer_transaction | order_id
order | order_id
order_custom_field | order_id
order_download | order_id
order_fraud | order_id
order_history | order_id
order_option | order_id
order_product | order_id
order_recurring | order_id
order_total | order_id
order_voucher | order_id
return | order_id
voucher | order_id
voucher_history | order_id

Sorry about the formatting but it should be understandable.
Also this doesn't include payment tables so if you use paypal it will also have those tables that use customer_id and/or order_id.

Mike