例如新建表twf_processversion
1.新建表
create table TWF_PROCESSVERSION
(
FLDPROCESSID VARCHAR2(64),
FLDID VARCHAR2(32) not null,
FLDTAG VARCHAR2(64),
FLDNAME VARCHAR2(64),
FLDREMARK VARCHAR2(128),
FLDISNEW VARCHAR2(2),
FLDJSONSTRING CLOB,
FLDISPUBLISHED VARCHAR2(2)
)
2.给表的字段添加备注
comment on column TWF_PROCESSVERSION.FLDPROCESSID
is '所属流程定义ID';
comment on column TWF_PROCESSVERSION.FLDID
is 'ID';
comment on column TWF_PROCESSVERSION.FLDTAG
is '实体标识';
comment on column TWF_PROCESSVERSION.FLDNAME
is '流程版本名称';
comment on column TWF_PROCESSVERSION.FLDREMARK
is '功能说明';
comment on column TWF_PROCESSVERSION.FLDISNEW
is '是否最新版本';
comment on column TWF_PROCESSVERSION.FLDJSONSTRING
is 'json格式流程定义';
comment on column TWF_PROCESSVERSION.FLDISPUBLISHED
is '是否是已发布版本。0表示保存版本,1表示发布版本';
3.给表的fldid字段设置为主键
alter table twf_processversion
add constraint twf_processversion_id primary key (fldid)
4.给表的fldprocessid字段创建索引
create index idx_processversion_procid on twf_processversion (fldprocessid)