product_bundles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
product_bundle_product.bundle_id Defined in XMLR
quotes.id Defined in XMLR
product_bundle_note.bundle_id Defined in XMLR
deleted BIT 1 0
date_entered DATETIME 26 null
date_modified DATETIME 26 null
modified_user_id CHAR 36 null
created_by CHAR 36 null
name VARCHAR 255 null
bundle_stage VARCHAR 255 null
description TEXT 65535 null
taxrate_id CHAR 36 null
taxrates.id Defined in XMLR
tax DECIMAL 26,6 null
tax_usdollar DECIMAL 26,6 null
total DECIMAL 26,6 null
total_usdollar DECIMAL 26,6 null
subtotal_usdollar DECIMAL 26,6 null
shipping_usdollar DECIMAL 26,6 null
deal_tot DECIMAL 26,6 null
deal_tot_usdollar DECIMAL 26,6 null
new_sub DECIMAL 26,6 null
new_sub_usdollar DECIMAL 26,6 null
subtotal DECIMAL 26,6 null
taxable_subtotal DECIMAL 26,6 null
shipping DECIMAL 26,6 null
default_group BIT 1 0
sync_key VARCHAR 100 null
team_id CHAR 36 null
teams.id Defined in XMLR
team_set_id CHAR 36 null
team_sets.id Defined in XMLR
team_sets_teams.team_set_id Defined in XMLR
acl_team_set_id CHAR 36 null
currency_id CHAR 36 -99
currencies.id Defined in XMLR
base_rate DECIMAL 26,6 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_product_bundles_acl_tmst_id Performance Asc/Asc acl_team_set_id + deleted
idx_product_bundles_skey Must be unique Asc sync_key
idx_product_bundles_tmst_id Performance Asc/Asc team_set_id + deleted
idx_products_bundles Performance Asc/Asc name + deleted

Relationships