/*
================================================================================
档案代号:idn_file
档案名称:ICD厂商WIP资料设定单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table idn_file
(
idn01       varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/
idn02       varchar2(10) DEFAULT '' NOT NULL, /*厂别*/
idn03       number(5) DEFAULT '0' NOT NULL, /*顺序*/
idn04       varchar2(20),            /*档案编号                               */
idn05       varchar2(20),            /*栏位编号                               */
idn06       varchar2(1),             /*no use                                 */
idn07       varchar2(1),             /*no use                                 */
idn08       varchar2(1),             /*no use                                 */
idn09       varchar2(1),             /*no use                                 */
idn10       varchar2(1)              /*no use                                 */
);

create unique index idn_pk on idn_file (idn01,idn02,idn03);
alter table idn_file add  constraint idn_pk primary key  (idn01,idn02,idn03) enable validate;
grant select on idn_file to public;
grant index on idn_file to public;
grant update on idn_file to public;
grant delete on idn_file to public;
grant insert on idn_file to public;