/*
================================================================================
档案代号:sfw_file
档案名称:工单重要备注资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sfw_file
(
sfw01       varchar2(16) NOT NULL,   /*工单编号                               */
sfw02       number(5) NOT NULL,      /*行序号                                 */
sfw03       varchar2(255)            /*重要备注                               */
);

create unique index sfw_pk on sfw_file (sfw01,sfw02);
alter table sfw_file add  constraint sfw_pk primary key  (sfw01,sfw02) enable validate;
grant select on sfw_file to public;
grant index on sfw_file to public;
grant update on sfw_file to public;
grant delete on sfw_file to public;
grant insert on sfw_file to public;