/* ================================================================================ 档案代号:fie_file 档案名称:作业资料单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fie_file ( fie01 varchar2(10) NOT NULL, /*作业编号 */ fie02 number(5) NOT NULL, /*步骤 */ fie03 varchar2(80) /*内容 */ ); create unique index fie_pk on fie_file (fie01,fie02); alter table fie_file add constraint fie_pk primary key (fie01,fie02) enable validate; grant select on fie_file to public; grant index on fie_file to public; grant update on fie_file to public; grant delete on fie_file to public; grant insert on fie_file to public; |