/*
================================================================================
档案代号:adm_file
档案名称:派车单其它托运物品档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adm_file
(
adm01       varchar2(16) NOT NULL,   /*派车单单号                             */
adm02       number(5) NOT NULL,      /*项次                                   */
adm03       varchar2(1),             /*类别                                   */
adm04       number(5),               /*件数                                   */
adm05       varchar2(80),            /*说明                                   */
adm06       varchar2(10),            /*委托人                                 */
adm07       varchar2(40),            /*收件单位                               */
adm08       varchar2(40)             /*收件人                                 */
);

create unique index adm_pk on adm_file (adm01,adm02);
alter table adm_file add  constraint adm_pk primary key  (adm01,adm02) enable validate;
grant select on adm_file to public;
grant index on adm_file to public;
grant update on adm_file to public;
grant delete on adm_file to public;
grant insert on adm_file to public;