okayapi_tbl_sequence - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_tbl_sequence：/tablelist/okayapi_tbl_sequence.html


-- MySQL Table okayapi_tbl_sequence
-- From: OkayAPI.com
CREATE TABLE `okayapi_tbl_sequence` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `seq_name` varchar(50) NULL COMMENT '序列名称',
    `min_value` bigint(20) NULL COMMENT '最小值',
    `max_value` bigint(20) NULL COMMENT '最大值',
    `current_val` bigint(20) NULL COMMENT '当前值',
    `increment_val` int(11) NULL DEFAULT '1' COMMENT '增长步数',
    `remark` varchar(500) NULL COMMENT '备注',
    KEY `seq_name` (`seq_name`),
    KEY `min_value` (`min_value`),
    KEY `max_value` (`max_value`),
    KEY `current_val` (`current_val`),
    KEY `increment_val` (`increment_val`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-sequence表';

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

MySQL database table structure design

Displaying 1-6 of 6 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
seq_name	varchar(50)		否	序列名称
min_value	bigint(20)		否	最小值
max_value	bigint(20)		否	最大值
current_val	bigint(20)		否	当前值
increment_val	int(11)	1	否	增长步数	1
remark	varchar(500)		是	备注