DPriceRangeSheet.Class.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. namespace JinDouYun\Dao\Price;
  3. use JinDouYun\Dao\BaseDao;
  4. /**
  5. * 商品价格范围表
  6. * Class DPriceRangeSheet
  7. * @package JinDouYun\Dao\Price
  8. */
  9. class DPriceRangeSheet extends BaseDao
  10. {
  11. public function __construct($serviceDB = 'price')
  12. {
  13. $this->_table = 'priceRangeSheet';
  14. $this->_primary = 'id';
  15. $this->_fields = [
  16. "id",//int(10) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  17. "goodsCode",//varchar(50) COMMENT '商品code',
  18. "goodsName",//varchar(100) NOT NULL COMMENT '商品名称',
  19. "goodsId",//int(10) NOT NULL COMMENT '商品id',
  20. "shopId",//int(10) NOT NULL COMMENT '店铺id',
  21. "createTime",//int(10) NOT NULL COMMENT '创建时间',
  22. "updateTime",//int(10) NOT NULL COMMENT '修改时间',
  23. "deleteStatus",//tinyint(3) NOT NULL DEFAULT '1' COMMENT '删除状态 4删除 5正常',
  24. "salePrice",//json NOT NULL COMMENT '最低/高价',
  25. "shopName",//varchar(50) DEFAULT NULL COMMENT '店铺名称',
  26. "extends",//json COMMENT '最低/高价',
  27. ];
  28. $this->_readonly = ['id'];
  29. $this->_create_autofill = [
  30. 'createTime' => time()
  31. ];
  32. $this->_update_autofill = [
  33. 'updateTime' => time()
  34. ];
  35. parent::__construct($serviceDB);
  36. }
  37. }