/*
================================================================================
档案代号:idj_file
档案名称:ICD发票资料转入作业单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table idj_file
(
idj01       varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/
idj02       varchar2(10) DEFAULT '' NOT NULL, /*厂别*/
idj03       number(5) DEFAULT '0' NOT NULL, /*顺序*/
idj04       varchar2(20),            /*档案编号                               */
idj05       varchar2(20),            /*栏位编号                               */
idj06       varchar2(1),             /*no use                                 */
idj07       varchar2(1),             /*no use                                 */
idj08       varchar2(1),             /*no use                                 */
idj09       varchar2(1),             /*no use                                 */
idj10       varchar2(1)              /*no use                                 */
);

create unique index idj_pk on idj_file (idj01,idj02,idj03);
alter table idj_file add  constraint idj_pk primary key  (idj01,idj02,idj03) enable validate;
grant select on idj_file to public;
grant index on idj_file to public;
grant update on idj_file to public;
grant delete on idj_file to public;
grant insert on idj_file to public;