/* ================================================================================ 档案代号:zc_file 档案名称:工作代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zc_file ( zc01 varchar2(3) NOT NULL, /*异动代号 */ zc02 varchar2(10) /*工作说明 */ ); create unique index zc_pk on zc_file (zc01); alter table zc_file add constraint zc_pk primary key (zc01) enable validate; grant select on zc_file to public; grant index on zc_file to public; grant update on zc_file to public; grant delete on zc_file to public; grant insert on zc_file to public; |