人大金仓自增建表语句

-- 如果序列存在，则删除它
DROP SEQUENCE IF EXISTS TableHeaderManagement_id_seq;

-- 创建序列
CREATE SEQUENCE TableHeaderManagement_id_seq;

-- 创建表
CREATE TABLE TableHeaderManagement (
    revision INT,
    id INT NOT NULL DEFAULT nextval('TableHeaderManagement_id_seq'),
    logical_id VARCHAR(32) NOT NULL,
    belong_airport_three VARCHAR(32),
    menu_id VARCHAR(32),
    menu_name VARCHAR(32),
    menu_key VARCHAR(32),
    columns_json TEXT,
    remark VARCHAR(32),
    is_delete INT NOT NULL DEFAULT 2,
    created_id VARCHAR(32),
    created_name VARCHAR(32),
    created_time DATETIME NOT NULL,
    updated_id VARCHAR(32),
    updated_name VARCHAR(32),
    updated_time DATETIME,
    PRIMARY KEY (id)
);

-- 添加字段注释
COMMENT ON TABLE TableHeaderManagement IS '表头管理';
COMMENT ON COLUMN TableHeaderManagement.revision IS '乐观锁';
COMMENT ON COLUMN TableHeaderManagement.id IS 'id';
COMMENT ON COLUMN TableHeaderManagement.logical_id IS '逻辑id';
COMMENT ON COLUMN TableHeaderManagement.belong_airport_three IS '所属机场三字码';
COMMENT ON COLUMN TableHeaderManagement.menu_id IS '菜单id';
COMMENT ON COLUMN TableHeaderManagement.menu_name IS '菜单名称';
COMMENT ON COLUMN TableHeaderManagement.menu_key IS '菜单key';
COMMENT ON COLUMN TableHeaderManagement.columns_json IS '列名json';
COMMENT ON COLUMN TableHeaderManagement.remark IS '备注';
COMMENT ON COLUMN TableHeaderManagement.is_delete IS '逻辑删除 2未删除，1已删除';
COMMENT ON COLUMN TableHeaderManagement.created_id IS '创建人id';
COMMENT ON COLUMN TableHeaderManagement.created_name IS '创建人姓名';
COMMENT ON COLUMN TableHeaderManagement.created_time IS '创建时间';
COMMENT ON COLUMN TableHeaderManagement.updated_id IS '更新人id';
COMMENT ON COLUMN TableHeaderManagement.updated_name IS '更新人姓名';
COMMENT ON COLUMN TableHeaderManagement.updated_time IS '更新时间';