[RndTbl] Opencart database tables
Sean Walberg
sean at ertw.com
Thu Apr 10 08:18:55 CDT 2014
There's a Magento community edition that's free. I have no first hand
experience running it but I've been following a couple of eCommerce
podcasts for the last year or so and that's what almost all the
interviewees are running. So perhaps this is one of those "it may not win
any technical awards but it makes business sense" type of things.
FWIW I've been working on some stuff with SpreeCommerce (spreecommerce.com),
it's a shopping cart system written in Ruby on Rails.
mydb=> \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------------------+-------+---------
public | schema_migrations | table | mydb
public | spree_activators | table | mydb
public | spree_addresses | table | mydb
public | spree_adjustments | table | mydb
public | spree_assets | table | mydb
public | spree_calculators | table | mydb
public | spree_configurations | table | mydb
public | spree_countries | table | mydb
public | spree_credit_cards | table | mydb
public | spree_gateways | table | mydb
public | spree_inventory_units | table | mydb
public | spree_line_items | table | mydb
public | spree_log_entries | table | mydb
public | spree_option_types | table | mydb
public | spree_option_types_prototypes | table | mydb
public | spree_option_values | table | mydb
public | spree_option_values_variants | table | mydb
public | spree_orders | table | mydb
public | spree_pages | table | mydb
public | spree_payment_methods | table | mydb
public | spree_payments | table | mydb
public | spree_preferences | table | mydb
public | spree_prices | table | mydb
public | spree_product_option_types | table | mydb
public | spree_product_properties | table | mydb
public | spree_products | table | mydb
public | spree_products_promotion_rules | table | mydb
public | spree_products_taxons | table | mydb
public | spree_promotion_action_line_items | table | mydb
public | spree_promotion_actions | table | mydb
public | spree_promotion_rules | table | mydb
public | spree_promotion_rules_users | table | mydb
public | spree_properties | table | mydb
public | spree_properties_prototypes | table | mydb
public | spree_prototypes | table | mydb
public | spree_return_authorizations | table | mydb
public | spree_roles | table | mydb
public | spree_roles_users | table | mydb
public | spree_shipments | table | mydb
public | spree_shipping_categories | table | mydb
public | spree_shipping_method_categories | table | mydb
public | spree_shipping_methods | table | mydb
public | spree_shipping_methods_zones | table | mydb
public | spree_shipping_rates | table | mydb
public | spree_skrill_transactions | table | mydb
public | spree_state_changes | table | mydb
public | spree_states | table | mydb
public | spree_stock_items | table | mydb
public | spree_stock_locations | table | mydb
public | spree_stock_movements | table | mydb
public | spree_stock_transfers | table | mydb
public | spree_tax_categories | table | mydb
public | spree_tax_rates | table | mydb
public | spree_taxonomies | table | mydb
public | spree_taxons | table | mydb
public | spree_tokenized_permissions | table | mydb
public | spree_trackers | table | mydb
public | spree_users | table | mydb
public | spree_variants | table | mydb
public | spree_zone_members | table | mydb
public | spree_zones | table | mydb
(61 rows)
On Thu, Apr 10, 2014 at 12:31 AM, Hartmut W Sager <hwsager at marityme.net>wrote:
> This looks just as messy (tons of tables, fields, and duplicated data) as
> I saw in the (in)famous osCommerce shopping cart software a few years ago.
> Furthermore, the tables and fields here (in OpenCart) look remarkably
> similar to those in osCommerce.
>
> As a bit of an aside, I wouldn't trust or use anything derived from
> osCommerce, including the very pricey Magento cart.
>
> Hartmut Sager
>
>
> On 9 April 2014 16:40, Bradford C. Vokey <brad at fsi.ca> wrote:
>
>> Further to the number of database tables Opencart creates with its
>> default modules:
>>
>> The answer is...
>> MariaDB [spiritoos]> show tables;
>>
>> +-----------------------------------+
>> | Tables_in_spiritoos |
>> +-----------------------------------+
>> | oc_address |
>> | oc_affiliate |
>> | oc_affiliate_transaction |
>> | oc_attribute |
>> | oc_attribute_description |
>> | oc_attribute_group |
>> | oc_attribute_group_description |
>> | oc_banner |
>> | oc_banner_image |
>> | oc_banner_image_description |
>> | oc_category |
>> | oc_category_description |
>> | oc_category_filter |
>> | oc_category_path |
>> | oc_category_to_layout |
>> | oc_category_to_store |
>> | oc_country |
>> | oc_coupon |
>> | oc_coupon_category |
>> | oc_coupon_history |
>> | oc_coupon_product |
>> | oc_currency |
>> | oc_custom_field |
>> | oc_custom_field_description |
>> | oc_custom_field_to_customer_group |
>> | oc_custom_field_value |
>> | oc_custom_field_value_description |
>> | oc_customer |
>> | oc_customer_ban_ip |
>> | oc_customer_field |
>> | oc_customer_group |
>> | oc_customer_group_description |
>> | oc_customer_history |
>> | oc_customer_ip |
>> | oc_customer_online |
>> | oc_customer_reward |
>> | oc_customer_transaction |
>> | oc_download |
>> | oc_download_description |
>> | oc_extension |
>> | oc_filter |
>> | oc_filter_description |
>> | oc_filter_group |
>> | oc_filter_group_description |
>> | oc_geo_zone |
>> | oc_information |
>> | oc_information_description |
>> | oc_information_to_layout |
>> | oc_information_to_store |
>> | oc_language |
>> | oc_layout |
>> | oc_layout_route |
>> | oc_length_class |
>> | oc_length_class_description |
>> | oc_manufacturer |
>> | oc_manufacturer_to_store |
>> | oc_option |
>> | oc_option_description |
>> | oc_option_value |
>> | oc_option_value_description |
>> | oc_order |
>> | oc_order_download |
>> | oc_order_field |
>> | oc_order_fraud |
>> | oc_order_history |
>> | oc_order_option |
>> | oc_order_product |
>> | 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_related |
>> | oc_product_reward |
>> | oc_product_special |
>> | oc_product_to_category |
>> | oc_product_to_download |
>> | oc_product_to_layout |
>> | oc_product_to_store |
>> | oc_return |
>> | oc_return_action |
>> | oc_return_history |
>> | oc_return_reason |
>> | oc_return_status |
>> | oc_review |
>> | oc_setting |
>> | oc_stock_status |
>> | oc_store |
>> | oc_tax_class |
>> | oc_tax_rate |
>> | oc_tax_rate_to_customer_group |
>> | oc_tax_rule |
>> | oc_url_alias |
>> | 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 |
>> +-----------------------------------+
>> 109 rows in set (0.00 sec)
>>
>> ... with LOTS of duplication of data... sigh...
>>
>> Brad.
>> _______________________________________________
>> Roundtable mailing list
>> Roundtable at muug.mb.ca
>> http://www.muug.mb.ca/mailman/listinfo/roundtable
>>
>
>
> _______________________________________________
> Roundtable mailing list
> Roundtable at muug.mb.ca
> http://www.muug.mb.ca/mailman/listinfo/roundtable
>
>
--
Sean Walberg <sean at ertw.com> http://ertw.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.muug.mb.ca/pipermail/roundtable/attachments/20140410/9ae2ce55/attachment-0001.html>
More information about the Roundtable
mailing list