/*
================================================================================
档案代号:icf_file
档案名称:ICD料件BIN资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icf_file
(
icf01       varchar2(80) NOT NULL,   /*Item                                   */
icf02       varchar2(5) NOT NULL,    /*Bin                                    */
icf03       varchar2(255),           /*Bin Desc                               */
icf04       varchar2(1),             /*Pass Bin                               */
icf05       varchar2(1),             /*Code                                   */
                                     /*0:Good  1:D/G(Down Grade)  2:Fail      */
icf06       varchar2(255),           /*Remark                                 */
icf07       varchar2(1),             /*no use                                 */
icf08       varchar2(1),             /*no use                                 */
icf09       varchar2(1)              /*no use                                 */
);

create unique index icf_pk on icf_file (icf01,icf02);
alter table icf_file add  constraint icf_pk primary key  (icf01,icf02) enable validate;
grant select on icf_file to public;
grant index on icf_file to public;
grant update on icf_file to public;
grant delete on icf_file to public;
grant insert on icf_file to public;