Post by sfbh » Wed Apr 22, 2020 3:51 am

I searched for this and didn't find it. So I figured out how to create it and I thought someone else may find it useful. This is the database structure from a clean install of version 3.0.3.2. Table names include the default "oc_" prefix.

Please let me know if you find any errors or have any suggestions to improve it.

Tables

Code: Select all

oc_address
oc_api
oc_api_ip
oc_api_session
oc_attribute
oc_attribute_description
oc_attribute_group
oc_attribute_group_description
oc_banner
oc_banner_image
oc_cart
oc_category
oc_category_description
oc_category_filter
oc_category_path
oc_category_to_layout
oc_category_to_store
oc_coupon
oc_coupon_category
oc_coupon_history
oc_coupon_product
oc_country
oc_currency
oc_custom_field
oc_custom_field_customer_group
oc_custom_field_description
oc_custom_field_value
oc_custom_field_value_description
oc_customer
oc_customer_activity
oc_customer_affiliate
oc_customer_approval
oc_customer_group
oc_customer_group_description
oc_customer_history
oc_customer_login
oc_customer_ip
oc_customer_online
oc_customer_reward
oc_customer_search
oc_customer_transaction
oc_customer_wishlist
oc_download
oc_download_description
oc_event
oc_extension
oc_extension_install
oc_extension_path
oc_filter
oc_filter_description
oc_filter_group
oc_filter_group_description
oc_geo_zone
oc_googleshopping_category
oc_googleshopping_product
oc_googleshopping_product_status
oc_googleshopping_product_target
oc_googleshopping_target
oc_information
oc_information_description
oc_information_to_layout
oc_information_to_store
oc_language
oc_layout
oc_layout_module
oc_layout_route
oc_length_class
oc_length_class_description
oc_location
oc_manufacturer
oc_manufacturer_to_store
oc_marketing
oc_modification
oc_module
oc_option
oc_option_description
oc_option_value
oc_option_value_description
oc_order
oc_order_history
oc_order_option
oc_order_product
oc_order_recurring
oc_order_recurring_transaction
oc_order_shipment
oc_order_status
oc_order_total
oc_order_voucher
oc_product
oc_product_attribute
oc_product_description
oc_product_discount
oc_product_filter
oc_product_image
oc_product_option
oc_product_option_value
oc_product_recurring
oc_product_related
oc_product_reward
oc_product_special
oc_product_to_category
oc_product_to_download
oc_product_to_layout
oc_product_to_store
oc_recurring
oc_recurring_description
oc_return
oc_return_action
oc_return_history
oc_return_reason
oc_return_status
oc_review
oc_seo_url
oc_session
oc_setting
oc_shipping_courier
oc_statistics
oc_stock_status
oc_store
oc_tax_class
oc_tax_rate
oc_tax_rate_to_customer_group
oc_tax_rule
oc_theme
oc_translation
oc_upload
oc_user
oc_user_group
oc_voucher
oc_voucher_history
oc_voucher_theme
oc_voucher_theme_description
oc_weight_class
oc_weight_class_description
oc_zone
oc_zone_to_geo_zone
Edit: reordered some of the table names that weren't in alphabetical order.

Attachments

oc_3.0.3.2_diagram.png

oc_3.0.3.2_diagram.png (1.22 MiB) Viewed 17472 times


Newbie

Posts

Joined
Sun Apr 16, 2017 4:51 am

Post by straightlight » Wed Apr 22, 2020 4:01 am

This topic has now been moved to the Development > Concepts section of the forum.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by straightlight » Wed Apr 22, 2020 4:03 am

If you're specifically asking if the schema structure is correct, as a feedback, based on the concept of the relationship of the database you're presenting; one big issue in the presentation can already be discovered with the oc_country table where the database relationship are not being shown with other tables such as the zones, orders, addresses and the geographic zones, for instance.

If you're looking to present the database graphically, I would suggest to use the information schema query in your PHPMyAdmin which could save you a lot of time.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by rein.hochstenbach » Wed Feb 10, 2021 6:55 pm

Trying to find the database schema for setting up some automated tests.
Unfortunately, phpmyadmin of mysql workbench reverse engineering of the schema does only give me unconnected tables.
I would like to have the functional full ERD.
Can somebody help me wit that?
I am on 3.0.3.6. version

Regards.
Rein


Posts

Joined
Mon Jan 21, 2019 5:58 pm

Post by straightlight » Wed Feb 10, 2021 8:15 pm

rein.hochstenbach wrote:
Wed Feb 10, 2021 6:55 pm
Trying to find the database schema for setting up some automated tests.
Unfortunately, phpmyadmin of mysql workbench reverse engineering of the schema does only give me unconnected tables.
I would like to have the functional full ERD.
Can somebody help me wit that?
I am on 3.0.3.6. version

Regards.
Rein
Rely on the model folders.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by Muhammad Ali Ali » Fri Dec 24, 2021 3:14 pm

your database structure is like a tree or graph? when ever i was create it I confuse on that stage.


Posts

Joined
Wed Dec 08, 2021 7:09 pm
Who is online

Users browsing this forum: No registered users and 15 guests