1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
create table jx_notice_info( id number primary key, noticeid varchar2(14) not null, noticetype varchar2(50) not null, noticesubject varchar2(50) not null, noticecontent clob not null, noticestate varchar2(1) not null, sendjgbm varchar2(30) not null, cruser varchar2(30) not null, crtime timestamp not null ); comment on table jx_notice_info is '通知表'; comment on column jx_notice_info.id is '通知表ID'; comment on column jx_notice_info.noticeid is '通知编码'; comment on column jx_notice_info.noticetype is '通知类别'; comment on column jx_notice_info.noticesubject is '通知主题'; comment on column jx_notice_info.noticecontent is '文件内容'; comment on column jx_notice_info.noticestate is '状态(0-启动,1-删除)'; comment on column jx_notice_info.sendjgbm is '发件人机构编码'; comment on column jx_notice_info.cruser is '创建人'; comment on column jx_notice_info.crtime is '创建时间'; |