/*
================================================================================
档案代号:vmo_file
档案名称:aps 物料清单、料表维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table vmo_file
(
vmo01       varchar2(40) DEFAULT '' NOT NULL, /*主件品号*/
vmo02       varchar2(40) DEFAULT '' NOT NULL, /*元件品号*/
vmo03       number(5) DEFAULT '0' NOT NULL, /*元件序号*/
vmo08       number(1),               /*元件替代码                             */
vmo09       number(1),               /*元件替代优先顺序                       */
vmo10       number(1),               /*元件群组替代码                         */
vmo11       number(1),               /*耗尽料                                 */
vmo13       number(1),               /*替代方式                               */
vmo14       number(1),               /*展元件需求                             */
vmo15       number(1),               /*客供料                                 */
vmo16       number(1),               /*替代料供给                             */
vmo17       number(1),               /*新单开立方式                           */
vmo18       number(18,8)             /*替代比率                               */
);

create unique index vmo_pk on vmo_file (vmo01,vmo02,vmo03);
alter table vmo_file add  constraint vmo_pk primary key  (vmo01,vmo02,vmo03) enable validate;
grant select on vmo_file to public;
grant index on vmo_file to public;
grant update on vmo_file to public;
grant delete on vmo_file to public;
grant insert on vmo_file to public;