/*
================================================================================
档案代号:ado_file
档案名称:车辆加油记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ado_file
(
ado01       varchar2(10) NOT NULL,   /*车辆编号                               */
ado02       date NOT NULL,           /*加油日期                               */
ado03       number(5) NOT NULL,      /*序号                                   */
ado04       number(15,6),            /*加油数量                               */
ado05       number(20,6),            /*加油金额                               */
ado06       varchar2(10),            /*驾驶员                                 */
ado07       varchar2(20),            /*加油地点                               */
adoacti     varchar2(1),             /*资料有效码                             */
adouser     varchar2(10),            /*资料所有者                             */
adogrup     varchar2(10),            /*资料所有部门                           */
adomodu     varchar2(10),            /*资料修改者                             */
adodate     date                     /*最近修改日                             */
);

create unique index ado_pk on ado_file (ado01,ado02,ado03);
alter table ado_file add  constraint ado_pk primary key  (ado01,ado02,ado03) enable validate;
grant select on ado_file to public;
grant index on ado_file to public;
grant update on ado_file to public;
grant delete on ado_file to public;
grant insert on ado_file to public;