注册

建表语句

卖萌小少侠 2022/05/17 1814 2

大佬们帮忙看看啊,我这个建表语句有问题吗,为什么一直14行附近出现错误,无效的数据类型
create table CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG
(
id bigint(19)
constraint T_DATA_TRANS_RULE_CONFIG_pk
primary key,
parent_id bigint(19),
rule_name varchar(50),
rule_description VARCHAR(512),
fetch_type varchar(200),
status varchar(10),
description1 text,
custom_flag TINYINT(3),
rule_type TINYINT(3)
);

comment on table CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG is ‘数据分发信息表’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.parent_id is ‘父类id’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_name is ‘规则名称’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_description is ‘规则说明’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.fetch_type is ‘提取类型’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.status is ‘状态(0停用,1启用,2注销)’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.description1 is ‘描述1’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.custom_flag is ‘是否自定义菜单,1为是,0为否’;

comment on column CITYOS_DATAPROCESS.T_DATA_TRANS_RULE_CONFIG.rule_type is ‘1-正则规则, 2-关键词规则’;

回答 0
暂无回答
扫一扫
联系客服