/* ================================================================================ 档案代号:cnc_file 档案名称:征免性质资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cnc_file ( cnc01 varchar2(10) NOT NULL, /*征免性质代码 */ cnc02 varchar2(80), /*征免性质名称 */ cnc03 varchar2(1), /*No Use */ cncacti varchar2(1), /*资料有效码 */ cncuser varchar2(10), /*资料所有者 */ cncgrup varchar2(10), /*资料所有部门 */ cncmodu varchar2(10), /*资料修改者 */ cncdate date /*最近修改日 */ ); create unique index cnc_pk on cnc_file (cnc01); alter table cnc_file add constraint cnc_pk primary key (cnc01) enable validate; grant select on cnc_file to public; grant index on cnc_file to public; grant update on cnc_file to public; grant delete on cnc_file to public; grant insert on cnc_file to public; |