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