/* ================================================================================ 档案代号:ind_file 档案名称:料件/单据相关之文件路径档名资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ind_file ( ind01 varchar2(40) NOT NULL, /*料件编号/单据编号 */ /*料件编号/单据编号 Key Value - 1 */ ind02 number(5) NOT NULL, /*项次 */ /* Key Value - 2 */ ind03 varchar2(80), /*档名 */ /* Key Value - 3 */ ind04 varchar2(255) /*备注 */ /* Key Value - 4 */ ); create unique index ind_pk on ind_file (ind01,ind02); alter table ind_file add constraint ind_pk primary key (ind01,ind02) enable validate; grant select on ind_file to public; grant index on ind_file to public; grant update on ind_file to public; grant delete on ind_file to public; grant insert on ind_file to public; |