okayapi_jsh_material

-- MySQL Table okayapi_jsh_material
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_material` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `Id` bigint(20) NULL COMMENT '主键',
    `CategoryId` bigint(20) NULL COMMENT '产品类型',
    `Name` varchar(50) NULL COMMENT '名称',
    `Mfrs` varchar(50) NULL COMMENT '制造商',
    `Packing` decimal(24,6) NULL COMMENT '包装（KG/包）',
    `SafetyStock` decimal(24,6) NULL COMMENT '安全存量（KG）',
    `Model` varchar(50) NULL COMMENT '型号',
    `Standard` varchar(50) NULL COMMENT '规格',
    `Color` varchar(50) NULL COMMENT '颜色',
    `Unit` varchar(50) NULL COMMENT '单位-单个',
    `Remark` varchar(100) NULL COMMENT '备注',
    `RetailPrice` decimal(24,6) NULL COMMENT '零售价',
    `LowPrice` decimal(24,6) NULL COMMENT '最低售价',
    `PresetPriceOne` decimal(24,6) NULL COMMENT '预设售价一',
    `PresetPriceTwo` decimal(24,6) NULL COMMENT '预设售价二',
    `UnitId` bigint(20) NULL COMMENT '计量单位Id',
    `FirstOutUnit` varchar(50) NULL COMMENT '首选出库单位',
    `FirstInUnit` varchar(50) NULL COMMENT '首选入库单位',
    `PriceStrategy` varchar(500) NULL COMMENT '价格策略',
    `Enabled` bit(1) NULL COMMENT '启用 0-禁用  1-启用',
    `OtherField1` varchar(50) NULL COMMENT '自定义1',
    `OtherField2` varchar(50) NULL COMMENT '自定义2',
    `OtherField3` varchar(50) NULL COMMENT '自定义3',
    `enableSerialNumber` varchar(1) NULL DEFAULT '0' COMMENT '是否开启序列号，0否，1是',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
    KEY `Id` (`Id`),
    KEY `CategoryId` (`CategoryId`),
    KEY `Name` (`Name`),
    KEY `Mfrs` (`Mfrs`),
    KEY `Packing` (`Packing`),
    KEY `SafetyStock` (`SafetyStock`),
    KEY `Model` (`Model`),
    KEY `Standard` (`Standard`),
    KEY `Color` (`Color`),
    KEY `Unit` (`Unit`),
    KEY `Remark` (`Remark`),
    KEY `RetailPrice` (`RetailPrice`),
    KEY `LowPrice` (`LowPrice`),
    KEY `PresetPriceOne` (`PresetPriceOne`),
    KEY `PresetPriceTwo` (`PresetPriceTwo`),
    KEY `UnitId` (`UnitId`),
    KEY `FirstOutUnit` (`FirstOutUnit`),
    KEY `FirstInUnit` (`FirstInUnit`),
    KEY `PriceStrategy` (`PriceStrategy`),
    KEY `Enabled` (`Enabled`),
    KEY `OtherField1` (`OtherField1`),
    KEY `OtherField2` (`OtherField2`),
    KEY `OtherField3` (`OtherField3`),
    KEY `enableSerialNumber` (`enableSerialNumber`),
    KEY `tenant_id` (`tenant_id`),
    KEY `delete_Flag` (`delete_Flag`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-产品表';

After replication, you can go to the database to create the database table.