/*
================================================================================
档案代号:tmn_file
档案名称:传票缺号档
档案目的:存放已被占用的传票缺号
上游档案:
下游档案:
============.========================.==========================================
*/
create table tmn_file
(
tmn01       varchar2(10) NOT NULL,   /*营运中心编号                           */
tmn02       varchar2(16) NOT NULL,   /*传票号码                               */
tmn03       varchar2(1),             /*No Use                                 */
tmn04       varchar2(1),             /*No Use                                 */
tmn05       number(5),               /*No Use                                 */
tmn06       varchar2(5) NOT NULL     /*帐别                                   */
);

create unique index tmn_pk on tmn_file (tmn01,tmn02,tmn06);
alter table tmn_file add  constraint tmn_pk primary key  (tmn01,tmn02,tmn06) enable validate;
grant select on tmn_file to public;
grant index on tmn_file to public;
grant update on tmn_file to public;
grant delete on tmn_file to public;
grant insert on tmn_file to public;