序号发生器表：id_codeid

说明

序号发生器表

结构

源码

Mysql建表SQL语句

CREATE TABLE id_codeid (
  ID int(11) NOT NULL AUTO_INCREMENT,
  ID_NAME varchar(50) NOT NULL,
  ID_VALUE int(11) NOT NULL,
  ID_PRE varchar(50) DEFAULT NULL,
  ID_DATE_FLAG smallint(6) DEFAULT NULL,
  ID_LENGTH int(11) DEFAULT NULL,
  PRIMARY KEY (ID),
  UNIQUE KEY ID_CODEID_ID_NAME (ID_NAME) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1;

华为GaussDB建表SQL语句

CREATE TABLE id_codeid (
  ID INTEGER AUTO_INCREMENT,
  ID_NAME varchar(50) NOT NULL,
  ID_VALUE INTEGER NOT NULL,
  ID_PRE varchar(50) DEFAULT NULL,
  ID_DATE_FLAG smallint DEFAULT NULL,
  ID_LENGTH INTEGER DEFAULT NULL,
  PRIMARY KEY (ID)
);