/*
================================================================================
档案代号:icu_file
档案名称:ICD料件制程资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table icu_file
(
icu01       varchar2(40) NOT NULL,   /*母体料号                               */
icu02       varchar2(10) NOT NULL,   /*制程编号                               */
icu03       varchar2(1),             /*Ccode否                                */
icu04       varchar2(5),             /*固定值(总Code)                         */
icu05       varchar2(5),             /*前置 / 后置(总Code)                    */
                                     /*1.前置 , 2.后置                        */
icu06       varchar2(5),             /*起始流水码(总Code)                     */
icu07       varchar2(5),             /*截止流水码(总Code)                     */
icu08       varchar2(5),             /*目前已用流水码(总Code)                 */
icu09       varchar2(5),             /*固定值(子Code)                         */
icu10       varchar2(1),             /*前置 / 后置(子Code)                    */
                                     /*1.前置 , 2.后置                        */
icu11       varchar2(5),             /*起始流水码(子Code)                     */
icu12       varchar2(5),             /*截止流水码(子Code)                     */
icu13       varchar2(5)              /*目前已用流水码(子Code)                 */
);

create unique index icu_pk on icu_file (icu01,icu02);
alter table icu_file add  constraint icu_pk primary key  (icu01,icu02) enable validate;
grant select on icu_file to public;
grant index on icu_file to public;
grant update on icu_file to public;
grant delete on icu_file to public;
grant insert on icu_file to public;