DActivityGoods.Class.php 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: XiaoMing
  5. * Date: 2019/12/18
  6. * Time: 12:01
  7. */
  8. namespace JinDouYun\Dao\Market;
  9. use JinDouYun\Dao\BaseDao;
  10. class DActivityGoods extends BaseDao
  11. {
  12. public function __construct($serviceDB = 'default')
  13. {
  14. $this->_table = 'activity_goods';
  15. $this->_primary = 'id';
  16. $this->_fields = [
  17. "id",//int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  18. "activityId",//int(11) unsigned NOT NULL COMMENT '促销活动id',
  19. "goodsId",//int(11) unsigned NOT NULL COMMENT '促销活动商品id',
  20. "shopId",
  21. "basicGoodsId",// int(11) unsigned NOT NULL COMMENT '促销活动基础商品id',
  22. "skuId",//int(11) unsigned NOT NULL COMMENT '规格id',
  23. "price",//decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '订货价格',
  24. "deleteStatus",//tinyint(3) unsigned NOT NULL DEFAULT '5' COMMENT '软删除(5未删除 4已删除)',
  25. "activityNum",//int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活动数量',
  26. "limitNum",//int(11) unsigned NOT NULL DEFAULT '0' COMMENT '限购数量',
  27. "createTime",//int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  28. "updateTime",//int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  29. "extends",//json DEFAULT NULL COMMENT '拓展字段',
  30. "haveBuyNum",//int(10) unsigned NOT NULL DEFAULT '0' COMMENT '活动已购数量',
  31. ];
  32. $this->_readonly = ['id'];
  33. $this->_create_autofill = [
  34. 'createTime' => time()
  35. ];
  36. $this->_update_autofill = [
  37. 'updateTime' => time()
  38. ];
  39. parent::__construct($serviceDB);
  40. }
  41. }