/*
================================================================================
档案代号:idm_file
档案名称:ICD厂商WIP资料设定单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table idm_file
(
idm01       varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/
idm02       varchar2(10) DEFAULT '' NOT NULL, /*厂别 预设为 00*/
idm03       varchar2(255),           /*档案存放位置                           */
idm04       varchar2(1),             /*no use                                 */
idm05       varchar2(1),             /*栏位分隔符号                           */
                                     /*0.TAB 1.分号                           */
idm07       varchar2(1),             /*no use                                 */
idm08       number(5),               /*序号                                   */
idm09       varchar2(1),             /*no use                                 */
idm10       varchar2(1),             /*no use                                 */
idm11       varchar2(1),             /*no use                                 */
idm12       varchar2(1),             /*no use                                 */
idm13       varchar2(1),             /*no use                                 */
idm14       varchar2(1),             /*no use                                 */
idm15       varchar2(1)              /*no use                                 */
);

create unique index idm_pk on idm_file (idm01,idm02);
alter table idm_file add  constraint idm_pk primary key  (idm01,idm02) enable validate;
grant select on idm_file to public;
grant index on idm_file to public;
grant update on idm_file to public;
grant delete on idm_file to public;
grant insert on idm_file to public;