baoshi-was/app/OracleBasSKU.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
/**
 * DB:      FLUX/WMS_USER
 * TABLE:   BAS_SKU
 * EXPLAIN: 商品
 */
use App\Traits\ModelTimeFormat;
use App\Traits\ModelLogChanging;
class OracleBasSKU extends Model
{
    use \Awobaz\Compoships\Compoships;
    use ModelLogChanging;

    use ModelTimeFormat;
    protected $connection="oracle";
    protected $table="BAS_SKU";

    /*
     * column: SKU 产品编码
     *         ALTERNATE_SKU1 产品条码
     *         Descr_C 商品名称
     *
     * */
    public function lotId()
    {
        return $this->hasOne(OracleBasLotId::class,'lotid','lotid')
            ->select('lotid','lotkey01','lotkey02','lotkey03','lotkey04','lotkey05','lotkey08');
    }
}