/* ================================================================================ 档案代号:zm_file 档案名称:目录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table zm_file ( zm01 varchar2(10) NOT NULL, /*目录代号 */ zm03 number(5) NOT NULL, /*序号 */ zm04 varchar2(20) /*程式代号 */ /*程式代号(Program code) */ ); create unique index zm_pk on zm_file (zm01,zm03); alter table zm_file add constraint zm_pk primary key (zm01,zm03) enable validate; grant select on zm_file to public; grant index on zm_file to public; grant update on zm_file to public; grant delete on zm_file to public; grant insert on zm_file to public; |