/*
================================================================================
档案代号:oqe_file
档案名称:估价单资料备注说明档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oqe_file
(
oqe01       varchar2(16) NOT NULL,   /*估价单代号                             */
oqe02       number(5) NOT NULL,      /*估价单代号项次                         */
                                     /*单头的编号为:0                         */
oqe03       number(5) NOT NULL,      /*行序                                   */
oqe04       varchar2(255)            /*说明                                   */
);

create unique index oqe_pk on oqe_file (oqe01,oqe02,oqe03);
alter table oqe_file add  constraint oqe_pk primary key  (oqe01,oqe02,oqe03) enable validate;
grant select on oqe_file to public;
grant index on oqe_file to public;
grant update on oqe_file to public;
grant delete on oqe_file to public;
grant insert on oqe_file to public;