/*
================================================================================
档案代号:shq_file
档案名称:RUN CARD分割资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table shq_file
(
shq01       varchar2(16) NOT NULL,   /*分割单号                               */
shq011      number(5) NOT NULL,      /*分割序号                               */
shq02       varchar2(19),            /*新Run Card                             */
shq03       number(15,3),            /*拆批数量                               */
shq04       varchar2(255),           /*备注                                   */
shq05       varchar2(1),             /*No Use                                 */
shq06       varchar2(1),             /*No Use                                 */
shq07       varchar2(1),             /*No Use                                 */
shq08       varchar2(1),             /*No Use                                 */
shq09       varchar2(1),             /*No Use                                 */
shq10       varchar2(1)              /*No Use                                 */
);

create        index shq_02 on shq_file (shq03);
create unique index shq_pk on shq_file (shq01,shq011);
alter table shq_file add  constraint shq_pk primary key  (shq01,shq011) enable validate;
grant select on shq_file to public;
grant index on shq_file to public;
grant update on shq_file to public;
grant delete on shq_file to public;
grant insert on shq_file to public;