数据表:ims_yz_producer(厂家-厂家数据表)。
| 字段 | 类型 | 默认值 | 约束 | 说明 |
|---|---|---|---|---|
id | integer unsigned | - | 非空、自增 | |
uniacid | integer | 0 | - | |
producer_name | string(100) | - | - | 厂家名称 |
province_id | integer | 0 | - | 省 |
province_name | string(100) | - | - | |
city_id | integer | 0 | - | 市 |
city_name | string(100) | - | - | |
district_id | integer | 0 | - | 区/县 |
district_name | string(100) | - | - | |
address | string(500) | - | - | 详细地址 |
mobile | string(100) | - | - | 厂家电话 |
logo | string(500) | - | - | 厂家logo |
business_license | string(500) | - | - | 营业执照 |
producer_notice | text(65535) | - | - | 店铺通告 |
refund_explain | text(65535) | - | - | 退货说明 |
created_at | integer | - | - | |
updated_at | integer | - | - | |
deleted_at | integer | - | - | |
supplier_id | integer | 0 | 非空 | 创建者供应商ID |
store_id | integer | 0 | 非空 | 创建者门店ID |
