/*
================================================================================
档案代号:adj_file
档案名称:派车原因档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adj_file
(
adj01       varchar2(10) NOT NULL,   /*派车原因                               */
adj02       varchar2(80),            /*说明                                   */
adjacti     varchar2(1),             /*资料有效码                             */
adjuser     varchar2(10),            /*资料所有者                             */
adjgrup     varchar2(10),            /*资料所有部门                           */
adjmodu     varchar2(10),            /*资料更改者                             */
adjdate     date                     /*最近修改日                             */
);

create unique index adj_pk on adj_file (adj01);
alter table adj_file add  constraint adj_pk primary key  (adj01) enable validate;
grant select on adj_file to public;
grant index on adj_file to public;
grant update on adj_file to public;
grant delete on adj_file to public;
grant insert on adj_file to public;