/*
================================================================================
档案代号: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;