okayapi_jsh_serial_number - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_jsh_serial_number：/tablelist/okayapi_jsh_serial_number.html


-- MySQL Table okayapi_jsh_serial_number
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_serial_number` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `material_Id` bigint(20) NULL COMMENT '产品表id',
    `serial_Number` varchar(64) NULL COMMENT '序列号',
    `is_Sell` varchar(1) NULL DEFAULT '0' COMMENT '是否卖出，0未卖出，1卖出',
    `remark` varchar(1024) NULL COMMENT '备注',
    `delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
    `creator` bigint(20) NULL COMMENT '创建人',
    `updater` bigint(20) NULL COMMENT '更新人',
    `depothead_Id` bigint(20) NULL COMMENT '单据主表id，用于跟踪序列号流向',
    `tenant_id` bigint(20) NULL COMMENT '租户id',
    KEY `material_Id` (`material_Id`),
    KEY `serial_Number` (`serial_Number`),
    KEY `is_Sell` (`is_Sell`),
    KEY `remark` (`remark`),
    KEY `delete_Flag` (`delete_Flag`),
    KEY `creator` (`creator`),
    KEY `updater` (`updater`),
    KEY `depothead_Id` (`depothead_Id`),
    KEY `tenant_id` (`tenant_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-序列号表';

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

MySQL database table structure design

Displaying 1-9 of 9 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
material_Id	bigint(20)		是	产品表id
serial_Number	varchar(64)		是	序列号
is_Sell	varchar(1)	0	是	是否卖出，0未卖出，1卖出	0
remark	varchar(1024)		是	备注
delete_Flag	varchar(1)	0	是	删除标记，0未删除，1删除	0
creator	bigint(20)		是	创建人
updater	bigint(20)		是	更新人
depothead_Id	bigint(20)		是	单据主表id，用于跟踪序列号流向
tenant_id	bigint(20)		是	租户id