crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/tools/xml/schema/Auction/Item.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Auction</base>
   5   <class>Item</class>
   6   <comment>stores item information for an auction</comment>
   7   <name>civicrm_auction_item</name>
   8   <add>3.0</add>
   9   <field>
  10       <name>id</name>
  11       <type>int unsigned</type>
  12       <required>true</required>
  13       <add>3.0</add>
  14   </field>
  15   <primaryKey>
  16        <name>id</name>
  17        <autoincrement>true</autoincrement>
  18   </primaryKey>
  19   <field>
  20       <name>auction_id</name>
  21       <type>int unsigned</type>
  22       <required>true</required>
  23       <comment>FK to civicrm_auction for this item</comment>
  24        <add>3.0</add>
  25   </field>
  26   <foreignKey>
  27        <name>auction_id</name>
  28        <table>civicrm_auction</table>
  29        <key>id</key>
  30        <add>3.0</add>
  31        <onDelete>CASCADE</onDelete>
  32   </foreignKey>
  33   <field>
  34       <name>donor_id</name>
  35       <type>int unsigned</type>
  36       <required>true</required>
  37       <comment>FK to civicrm_contact, who donated this item</comment>
  38        <add>3.0</add>
  39   </field>
  40   <foreignKey>
  41        <name>donor_id</name>
  42        <table>civicrm_contact</table>
  43        <key>id</key>
  44        <add>3.0</add>
  45        <onDelete>CASCADE</onDelete>
  46   </foreignKey>
  47   <field>
  48       <name>auction_item_type_id</name>
  49       <type>int unsigned</type>
  50       <title>Auction Item Type ID</title>
  51       <default>0</default>
  52       <comment>Auction Type ID.Implicit FK to civicrm_option_value where option_group = auction_item_type.</comment>
  53       <add>3.0</add>
  54   </field>
  55   <index>
  56     <name>index_auction_item_type_id</name>
  57     <fieldName>auction_item_type_id</fieldName>
  58     <add>3.0</add>
  59   </index>
  60   <field>
  61       <name>auction_item_category_id</name>
  62       <type>int unsigned</type>
  63       <title>Auction Item Category ID</title>
  64       <default>0</default>
  65       <comment>Auction Category ID.Implicit FK to civicrm_option_value where option_group = auction_item_.</comment>
  66       <add>3.0</add>
  67   </field>
  68   <index>
  69     <name>index_auction_item_category_id</name>
  70     <fieldName>auction_item_category_id</fieldName>
  71     <add>3.0</add>
  72   </index>
  73   <field>
  74        <name>title</name>
  75        <title>Item Name</title>
  76        <type>varchar</type>
  77        <length>255</length>
  78        <required>true</required>
  79        <export>true</export>
  80        <localizable>true</localizable>
  81        <comment>Required item title</comment>
  82        <add>3.0</add>
  83   </field>
  84   <field>
  85       <name>description</name>
  86       <title>Description</title>
  87       <type>text</type>
  88       <localizable>true</localizable>
  89       <comment>Optional description of the product/premium.</comment>
  90       <add>3.0</add>
  91   </field>
  92   <field>
  93       <name>note</name>
  94       <title>Special Note</title>
  95       <type>text</type>
  96       <localizable>true</localizable>
  97       <comment>Optional specific instructions / restrictions regarding this item.</comment>
  98       <add>3.0</add>
  99   </field>
 100   <field>
 101       <name>lot_number</name>
 102       <title>Lot Number</title>
 103       <type>varchar</type>
 104       <length>50</length>
 105       <export>true</export>
 106       <comment>lot numbers associated with this item. could be a range. automatically computed.</comment>
 107       <add>3.0</add>
 108   </field>
 109   <field>
 110        <name>url</name>
 111        <type>varchar</type>
 112        <length>128</length>
 113        <import>true</import>
 114        <comment>optional URL of website to associate with item.</comment>
 115        <add>1.1</add>
 116   </field>
 117   <field>
 118       <name>sku</name>
 119       <title>SKU</title>
 120       <type>varchar</type>
 121       <length>50</length>
 122       <export>true</export>
 123       <comment>Optional product sku or code.</comment>
 124       <add>3.0</add>
 125   </field>
 126   <field>
 127       <name>options</name>
 128       <title>Options</title>
 129       <type>text</type>
 130       <localizable>true</localizable>
 131       <comment>Store comma-delimited list of color, size, etc. options for the product.</comment>
 132       <add>3.0</add>
 133   </field>
 134   <field>
 135       <name>image</name>
 136       <title>Image</title>
 137       <type>varchar</type>
 138       <length>255</length>
 139       <comment>Full or relative URL to uploaded image - fullsize.</comment>
 140       <add>3.0</add>
 141   </field>
 142   <field>
 143       <name>quantity</name>
 144       <title>Quantity</title>
 145       <type>int unsigned</type>
 146       <comment>Number of Units availaible.</comment>
 147       <add>3.0</add>
 148   </field>
 149   <field>
 150       <name>retail_value</name>
 151       <title>Price</title>
 152       <type>decimal</type>
 153       <comment>Retail value of item.</comment>
 154       <add>3.0</add>
 155   </field>
 156   <field>
 157       <name>min_bid_value</name>
 158       <title>Minimum Bid</title>
 159       <type>decimal</type>
 160       <comment>Minimum bid allowed for this item.</comment>
 161       <add>3.0</add>
 162   </field>
 163   <field>
 164       <name>min_bid_increment</name>
 165       <title>Minimum Bid Increment</title>
 166       <type>decimal</type>
 167       <comment>Minimum bid increment allowed for this item.</comment>
 168       <add>3.0</add>
 169   </field>
 170   <field>
 171       <name>buy_now_value</name>
 172       <title>Buy Now Value</title>
 173       <type>decimal</type>
 174       <comment>The amount that the item can be bought for immediately</comment>
 175       <add>3.0</add>
 176   </field>
 177   <field>
 178        <name>bid_start_date</name>
 179        <type>datetime</type>
 180        <title>Bid Start Date</title>
 181        <comment>Date and time bidding starts.</comment>
 182        <add>3.0</add>
 183   </field>
 184   <field>
 185        <name>bid_end_date</name>
 186        <type>datetime</type>
 187        <title>Bid End Date</title>
 188        <comment>Date and time bidding ends.</comment>
 189        <add>3.0</add>
 190   </field>
 191   <field>
 192       <name>is_active</name>
 193       <type>boolean</type>
 194       <default>0</default>
 195       <required>true</required>
 196       <comment>Is this item active/approved and available</comment>
 197       <add>3.0</add>
 198   </field>
 199   <field>
 200       <name>is_group</name>
 201       <type>boolean</type>
 202       <default>0</default>
 203       <comment>Does this item group other items?</comment>
 204       <add>3.0</add>
 205   </field>
 206   <field>
 207       <name>parent_id</name>
 208       <type>int unsigned</type>
 209       <comment>FK to civicrm_auction_item, if this item is part of an item group</comment>
 210        <add>3.0</add>
 211   </field>
 212   <foreignKey>
 213        <name>parent_id</name>
 214        <table>civicrm_auction_item</table>
 215        <key>id</key>
 216        <add>3.0</add>
 217        <onDelete>SET NULL</onDelete>
 218   </foreignKey>
 219  <field>
 220       <name>creator_id</name>
 221       <type>int unsigned</type>
 222       <comment>FK to civicrm_contact, who created this item</comment>
 223        <add>3.0</add>
 224   </field>
 225   <foreignKey>
 226        <name>creator_id</name>
 227        <table>civicrm_contact</table>
 228        <key>id</key>
 229        <add>3.0</add>
 230        <onDelete>SET NULL</onDelete>
 231   </foreignKey>
 232   <field>
 233        <name>created_date</name>
 234        <type>datetime</type>
 235        <comment>Date and time when item was created.</comment>
 236        <add>3.0</add>
 237   </field>
 238   <field>
 239       <name>approver_id</name>
 240       <type>int unsigned</type>
 241       <comment>FK to civicrm_contact, who approvedthis item</comment>
 242        <add>3.0</add>
 243   </field>
 244   <foreignKey>
 245        <name>approver_id</name>
 246        <table>civicrm_contact</table>
 247        <key>id</key>
 248        <add>3.0</add>
 249        <onDelete>SET NULL</onDelete>
 250   </foreignKey>
 251   <field>
 252        <name>approval_date</name>
 253        <type>datetime</type>
 254        <uniqueName>approval_date</uniqueName>
 255        <comment>Date and time the item was approved.</comment>
 256        <add>3.0</add>
 257   </field>
 258 </table>