/*
================================================================================
档案代号:sri_file
档案名称:报工资料 不良原因资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sri_file
(
sri01       varchar2(16) NOT NULL,   /*报工单号                               */
sri02       number(5) NOT NULL,      /*项次                                   */
sri03       number(5),               /*报工项次                               */
sri04       varchar2(4),             /*不良原因代号                           */
sri05       number(15,3),            /*不良数量                               */
sri06       varchar2(255),           /*备注                                   */
sri07       varchar2(1)              /*No Use                                 */
);

create unique index sri_pk on sri_file (sri01,sri02);
alter table sri_file add  constraint sri_pk primary key  (sri01,sri02) enable validate;
grant select on sri_file to public;
grant index on sri_file to public;
grant update on sri_file to public;
grant delete on sri_file to public;
grant insert on sri_file to public;