/*
================================================================================
档案代号:oqd_file
档案名称:其他费用资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oqd_file
(
oqd01       varchar2(16) NOT NULL,   /*估价单号                               */
oqd02       number(5) NOT NULL,      /*项次                                   */
oqd03       varchar2(255),           /*费用说明                               */
oqd04       number(20,6)             /*估价金额                               */
);

create unique index oqd_pk on oqd_file (oqd01,oqd02);
alter table oqd_file add  constraint oqd_pk primary key  (oqd01,oqd02) enable validate;
grant select on oqd_file to public;
grant index on oqd_file to public;
grant update on oqd_file to public;
grant delete on oqd_file to public;
grant insert on oqd_file to public;