<?php
/**
 * Created by PhpStorm.
 * User: Gss
 * Date: 2021/6/10 0010
 * Time: 16:48
 */

namespace JinDouYun\Dao\Stock;


use JinDouYun\Dao\BaseDao;

class DInventoryArea extends BaseDao
{
    public function __construct($serviceDB = 'stock')
    {
        $this->_table = 'inventory_area';
        $this->_primary = 'id';
        $this->_fields = [
            'id',//int(10) NOT NULL COMMENT '自增id',
            'warehouseId',//int(10) NOT NULL DEFAULT '0' COMMENT '仓库id',
            'merchantId',// int(10) DEFAULT '0' COMMENT '商户id',
            'areaId',//int(10) NOT NULL DEFAULT '0' COMMENT '库区id',
            'areaName',//varchar(255) NOT NULL COMMENT '库区名称',
            'areaCode',//varchar(255) DEFAULT NULL COMMENT '库区编码',
            'storageLocationId',//int(10) NOT NULL COMMENT '库位id',
            'storageLocationName',//varchar(255) DEFAULT NULL COMMENT '库位名称',
            'storageLocationCode',//varchar(255) DEFAULT NULL COMMENT '库位编码',
            'skuId',//int(10) DEFAULT '0',
            'unitName',//varchar(255) DEFAULT NULL COMMENT '单位名称',
            'skuName',//varchar(255) DEFAULT NULL COMMENT '属性名称',
            'num',//decimal(10,2) DEFAULT '0.00' COMMENT '数量',
            'updateTime',//int(11) DEFAULT NULL COMMENT '更新时间',
            'createTime',//int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
            'materielId',
        ];
        $this->_readonly = ['id'];
        $this->_create_autofill = [
            'createTime' => time(),
            'updateTime' => time()
        ];
        $this->_update_autofill = [
            'updateTime' => time()
        ];

        parent::__construct($serviceDB);
    }
}