Tables in Ubercart 2
This is a list of the Ubercart tables found in my version 2.0 as of Dec. 26, 2009 (there might be some additional tables listed here from optional ubercart modules).
| Table Name | Brief Description |
|---|---|
| uc_attributes | Holds the major source for the attribute ID (aid) and the base descriptions for the product attributes |
| uc_attribute_options | Holds the major source for the option ID (oid) and the base prices for these options |
| uc_cart_products | |
| uc_catalog_images | |
| uc_class_attributes | |
| uc_class_attribute_options | |
| uc_countries | |
| uc_files | |
| uc_file_products | |
| uc_file_users | |
| uc_orders | |
| uc_order_admin_comments | |
| uc_order_comments | |
| uc_order_line_items | |
| uc_order_log | |
| uc_order_products | |
| uc_order_statuses | |
| uc_payment_paypal_ipn | |
| uc_payment_receipts | |
| uc_products | |
| uc_product_adjustments | |
| uc_product_attributes | This matches the node id (nid) to the attributes that are to be displayed to the user, as designated by the aid that links back to the uc_attributes table. |
| uc_product_classes | These are the different classes that can be created for the products. Each of these product classes then essentially become like a CCK item, with possible attributes and options set up for this class, analogous to the 'managed fields' for a CCK. The product classes can be seen from /admin/store/products/classes. |
| uc_product_features | |
| uc_product_options | This matches the node id (nid) to the options that are to be displayed, as designated by the oid that links back to the uc_attribute_options table. |
| uc_store_footers | |
| uc_zones |
