product_bundles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
quotes.id Defined in XMLR
product_bundle_product.bundle_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

Close relationships within degrees of separation