/*
================================================================================
档案代号:ske_file
档案名称:制单说明资料档
档案目的:制单说明资料档 单档多栏
上游档案:
下游档案:
============.========================.==========================================
*/
create table ske_file
(
ske01       varchar2(16) DEFAULT '' NOT NULL, /*制单编号*/
ske02       varchar2(1) DEFAULT '' NOT NULL, /*说明类型*/
ske03       number(10) DEFAULT '0' NOT NULL, /*说明项次*/
ske04       varchar2(80) DEFAULT '' NOT NULL, /*说明内容*/
ske05       varchar2(1) DEFAULT '' NOT NULL /*列印方式   1-列印于前 2-列印  */
);

create unique index ske_pk on ske_file (ske01,ske02,ske03);
alter table ske_file add  constraint ske_pk primary key  (ske01,ske02,ske03) enable validate;
grant select on ske_file to public;
grant index on ske_file to public;
grant update on ske_file to public;
grant delete on ske_file to public;
grant insert on ske_file to public;