fohow_admin/db/migrate/20171110030458_create_products.rb

# encoding:utf-8
# 产品相关表
class CreateProducts < ActiveRecord::Migration
  def up
    #平台栏目类别
    create_table :platform_cats do |t|
        t.string  :name,  :default => '', :null => false, :limit => 10
      	#排序
      	t.integer :position, :default => 1, :null => false
      	t.string  :ancestry,  :limit => 20, :default => '', :null => false
      	#配置不同的平台，录入产品时init，微信端首页wx_home
      	t.column :platform, :string, :limit => 20, :default => '', :null => false
      	t.column :url, :string, :limit => 4096, :default => '',:null => false
      	t.column :state, :boolean, :default => true,  :null => false
      	#打标签hot、new等
      	t.column :mark, :string, :limit => 10, :default => '', :null => false
      	#
      	t.column :cover_click, :string, :limit => 4096, :default => '',:null => false
      	#icon 样式配置
      	t.column :icon, :string, :limit => 10, :default => '', :null => false
      	#控制字体颜色
      	t.column :font_color, :string, :limit => 10, :default => '', :null => false
      	t.column :remark, :string, :limit => 225, :default => '', :null => false
      	#预留字段
      	t.column :remark1, :string, :limit => 225, :default => '', :null => false
      	t.column :remark2, :string, :limit => 225, :default => '', :null => false
      	#如果是推单品的，则记录产品ID
      	t.column :product_id, :integer, :default => 0, :null => false
    end

    add_index :platform_cats, :position
    add_index :platform_cats, :ancestry
    add_index :platform_cats, :platform

  	#商品表
    create_table :products do |t|
        #商家用户
        t.column :merchant_id, :integer
    	  #商品名称    	
      	t.column :name,         :string, :limit => 100, :null => false
      	#类别id
      	t.column :category_id,  :integer
      	#商品详情
        #modify string->text
      	t.text :detail,  :null => false

      	#外部现金价格(分)
      	t.column :price, :integer, :null=>false
        #内部提货券价格(分)
        t.column :robo_balance_price, :integer, :null => false
        #外部提货券价格(分)
        t.column :mall_balance_price, :integer, :null => false

      	#采购价格(分)
      	t.column :buy_price, :integer, :null=>false

        #商品类型 直营:direct_sale, 代销: user_sale
        t.column :ptype, :string, :limit=>32, :default=>"direct_sale"
        #用户挂单结算价(分)
        t.column :user_sale_price, :integer, :null=>false, :default=>0

        #库存(份)
        t.column :count, :integer, :null=>false, :default=>1
      	#零表示不推荐，大于零的推荐，越大越靠前
      	t.column :recommend, :integer, :limit => 11, :default => 0      	
      	#是否上架
      	t.column :status, :boolean, :default => false
        #是否是精准扶贫
        t.column :is_support_poor, :boolean, :default => false
        #虚拟销售量
        t.column :virtual_sold_count, :integer, :limit => 11, :default =>0 
        #限购数量
        t.column :purchase_limit_count, :integer, :null=> false, :default => 0

        #特殊时段告知用户订单处理发货时段
        #停止发货时间
        t.column :deliver_stop_at, :datetime
        #开始发货时间
        t.column :deliver_start_at, :datetime

        #分享文案
        t.string   :share_content, :limit => 50
        #分享图片  
        t.string   :share_img

        #仅限新人
        t.column :is_only_new, :boolean, :default=>0
        t.column :seckill_start, :datetime
        t.column :seckill_end, :datetime
        t.column :seckill_price, :integer

        t.column :specification, :string
        t.column :no_delivery_area, :string, :default => "西藏、新疆、内蒙、宁夏、青海、甘肃"
      	t.timestamps
    end

    add_index :products, :category_id

    #商品图片
    create_table :product_pictures do |t|
      #产品ID
      t.column :product_id, :string, :limit => 20, :null => false
      #图片路径
      t.column :img, :string, :null => false
      #图片类型 0：轮播图，1：详情图
      t.column :pic_type, :tinyint, :null=>false, :default=>0
      #排序
      t.column :sort, :integer, :null=> false, :default=>0      
      t.timestamps
    end

    add_index :product_pictures, :product_id

    #商品类别  
    create_table :product_cats do |t|
      t.string  :name,      :null => false, :limit => 20
      t.integer :position
      t.string  :ancestry,  :limit => 20
      t.boolean :status, default: true
    end
    add_index :product_cats, :position
    add_index :product_cats, :ancestry
    add_index :product_cats, :name

    #商品订单表
    create_table :orders do |t|
    	#订单号
    	t.column :order_id, :string, :null=>false
      #订单类型 0:普通订单, 1:代销订单, 2:自用订单
      t.column :order_type, :tinyint, :default=>0
      # #关联代销订单号
      # t.column :sale_order_id, :string
      #粮仓ID, 自用和代销时记录关联粮仓ID
      t.column :granary_id, :integer, :default=>0
      #商品id
      t.column :product_id, :integer, :null=>false
    	#用户id
    	t.column :user_id, :integer, :null=>false
      #微信用户id
      t.column :wx_user_id, :integer, :null=>false
      #份数
      t.column :count, :integer, :null=>false
      # 支付时商品的提货券单价
      t.column :unit_robo_balance_price, :integer, :null=>false
      # 支付时商品的现金单价
      t.column :unit_price, :integer, :null=>false
    	#订单总价(单位) 根据支付方式来显示金钱分还是提货券还是提货券
    	t.column :total_price, :integer, :null=>false
    	#支付总价(单位) 根据支付方式来显示金钱分还是提货券还是提货券
    	t.column :paied_price, :integer, :default=>0
      #进货总价(分)除以100就是元
      t.column :buy_price, :integer, :default=>0
    	#支付时间
    	t.column :paied_at, :integer, :default=>0
    	#流水号
    	t.column :trade_no, :string
    	#状态
    	t.column :status, :string
    	#支付方式：微信、提货券、提货券;  weixinpay, balance, integral
    	t.column :pay_way, :string
      #支付来源: 公众号 gzh、小程序 xcx、第五创系统d5c_sys
      t.column :source, :string

    	#电话
    	t.column :tel, :string
    	#地址
    	t.column :address, :string
    	#联系人
    	t.column :contact, :string
    	#快递公司
    	t.column :express_company, :string
    	#快递单号
    	t.column :express_order_no, :string
    	#备注
      
      # 7天自动收货功能=====================
    	t.column :remark, :string
      # 发货时间
      t.column :dispatch_time, :datetime
      # 收货时间
      t.column :receive_time, :datetime

      #抽奖或者筹中筹的下单标识
      t.column :order_remark, :string

      # 退款功能============================
      # 平台退款
      t.column :platform_refund_amount, :integer, :default => 0
      # 商家退款
      t.column :merchant_refund_amount, :integer, :default => 0
      # 是否部分退款
      t.column :is_part_refund, :boolean, :default => false

      # 销售专题添加抽奖功能================
      # 是否参与销售专题抽奖
      t.boolean  :is_join_subject_prize, :null => false, :default => false
      # 销售专题id
      t.column   :product_sale_subject_id, :integer, :null => false, :default => 0

    	t.timestamps
    end   

    add_index :orders, :order_id
    add_index :orders, :user_id    
    add_index :orders, :granary_id
  end
end