/* ================================================================================ 档案代号:von_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table von_file ( von00 varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/ von01 varchar2(10) DEFAULT '' NOT NULL, /*限定版本*/ von02 varchar2(10) DEFAULT '' NOT NULL, /*储存版本*/ von03 varchar2(16) DEFAULT '' NOT NULL, /*制令编号*/ von04 varchar2(10) DEFAULT '' NOT NULL, /*途程编号*/ von05 varchar2(60) DEFAULT '' NOT NULL, /*加工序号*/ von06 varchar2(6) DEFAULT '' NOT NULL, /*作业编号*/ von07 varchar2(10) DEFAULT '' NOT NULL, /*资源编号*/ von08 number(15,3), /*未完成量 */ von09 number(1) /*排程 */ ); create unique index von_pk on von_file (von00,von01,von02,von03,von04,von05,von06,von07); alter table von_file add constraint von_pk primary key (von00,von01,von02,von03,von04,von05,von06,von07) enable validate; grant select on von_file to public; grant index on von_file to public; grant update on von_file to public; grant delete on von_file to public; grant insert on von_file to public; |