X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FContribute%2FProduct.xml;h=8c18004c2cd1082e9ec91c9872a1f9e2d8b4ee61;hb=d5fd88834139d3bd5be9a170e5689c50c42783e3;hp=93c401305cc30485ca3a39cc7f0573fe5f9c8297;hpb=51daafaadd025703b2f8d6e3d27898e3768908f9;p=civicrm-core.git diff --git a/xml/schema/Contribute/Product.xml b/xml/schema/Contribute/Product.xml index 93c401305c..8c18004c2c 100644 --- a/xml/schema/Contribute/Product.xml +++ b/xml/schema/Contribute/Product.xml @@ -8,200 +8,202 @@ 1.4 true - id - int unsigned - true - 1.4 + id + Product ID + int unsigned + true + 1.4 - id - true + id + true - name - product_name - Product Name - varchar - 255 - true - true - true - Required product/premium name - 1.4 - - - description - Description - text - true - Optional description of the product/premium. - 1.4 - - - sku - SKU - varchar - 50 - true - Optional product sku or code. - 1.4 - - - options - Options - text - true - Store comma-delimited list of color, size, etc. options for the product. - 1.4 - - - image - Image - varchar - 255 - Full or relative URL to uploaded image - fullsize. - 1.4 - - - thumbnail - Thumbnail - varchar - 255 - Full or relative URL to image thumbnail. - 1.4 - - - price - Price - decimal - Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record. - 1.4 - - - currency - varchar - 3 - NULL - 3 character string, value from config setting or input via user. - 3.2 - - civicrm_currency
- name - full_name - numeric_code - - - Select - - - - financial_type_id - Financial Type - int unsigned - NULL - - civicrm_financial_type
- id - name - - FK to Financial Type. - 4.3 + name + product_name + Product Name + varchar + 255 + true + true + true + Required product/premium name + 1.4 + + + description + Description + text + true + Optional description of the product/premium. + 1.4 + + + sku + SKU + varchar + 50 + true + Optional product sku or code. + 1.4 + + + options + Options + text + true + Store comma-delimited list of color, size, etc. options for the product. + 1.4 + + + image + Image + varchar + 255 + Full or relative URL to uploaded image - fullsize. + 1.4 + + + thumbnail + Thumbnail + varchar + 255 + Full or relative URL to image thumbnail. + 1.4 + + + price + Price + decimal + Sell price or market value for premiums. For tax-deductible contributions, this will be stored as non_deductible_amount in the contribution record. + 1.4 + + + currency + varchar + 3 + NULL + 3 character string, value from config setting or input via user. + 3.2 + + civicrm_currency
+ name + full_name + name + symbol + + + Select + + + + financial_type_id + Financial Type + int unsigned + NULL + + civicrm_financial_type
+ id + name + + FK to Financial Type. + 4.3 - financial_type_id - civicrm_financial_type
- id - SET NULL - 4.3 + financial_type_id + civicrm_financial_type
+ id + SET NULL + 4.3 - min_contribution - Minimum Contribution - decimal - Minimum contribution required to be eligible to select this premium. - 1.4 - - - cost - Cost - decimal - Actual cost of this product. Useful to determine net return from sale or using this as an incentive. - 1.4 - - - is_active - Is Active - boolean - true - Disabling premium removes it from the premiums_premium join table below. - 1.4 - - - period_type - Period Type - varchar - 8 - 'rolling' - Rolling means we set start/end based on current day, fixed means we set start/end for current year or month -(e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) - - CRM_Core_SelectValues::periodType - - 1.4 - - Select - - - - fixed_period_start_day - Fixed Period Start Day - int - 0101 - Month and day (MMDD) that fixed period type subscription or membership starts. - 1.4 - - - duration_unit - Duration Unit - varchar - 8 - 'year' - - CRM_Core_SelectValues::getPremiumUnits - - 1.4 - - Select - - - - duration_interval - Duration Interval - int - Number of units for total duration of subscription, service, membership (e.g. 12 Months). - 1.4 - - - frequency_unit - Frequency Unit - varchar - 8 - 'month' - Frequency unit and interval allow option to store actual delivery frequency for a subscription or service. - - CRM_Core_SelectValues::getPremiumUnits - - 1.4 - - Select - - - - frequency_interval - Frequency Interval - int - Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months). - 1.4 + min_contribution + Minimum Contribution + decimal + Minimum contribution required to be eligible to select this premium. + 1.4 + + + cost + Cost + decimal + Actual cost of this product. Useful to determine net return from sale or using this as an incentive. + 1.4 + + + is_active + Is Active + boolean + true + Disabling premium removes it from the premiums_premium join table below. + 1.4 + + + period_type + Period Type + varchar + 8 + 'rolling' + Rolling means we set start/end based on current day, fixed means we set start/end for current year or month + (e.g. 1 year + fixed -> we would set start/end for 1/1/06 thru 12/31/06 for any premium chosen in 2006) + + CRM_Core_SelectValues::periodType + + 1.4 + + Select + + + + fixed_period_start_day + Fixed Period Start Day + int + 0101 + Month and day (MMDD) that fixed period type subscription or membership starts. + 1.4 + + + duration_unit + Duration Unit + varchar + 8 + 'year' + + CRM_Core_SelectValues::getPremiumUnits + + 1.4 + + Select + + + + duration_interval + Duration Interval + int + Number of units for total duration of subscription, service, membership (e.g. 12 Months). + 1.4 + + + frequency_unit + Frequency Unit + varchar + 8 + 'month' + Frequency unit and interval allow option to store actual delivery frequency for a subscription or service. + + CRM_Core_SelectValues::getPremiumUnits + + 1.4 + + Select + + + + frequency_interval + Frequency Interval + int + Number of units for delivery frequency of subscription, service, membership (e.g. every 3 Months). + 1.4