/*
================================================================================
档案代号:ksg_file
档案名称:制造通知单单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ksg_file
(
ksg01       varchar2(16) NOT NULL,   /*制造通知单号                           */
ksg02       number(5) NOT NULL,      /*项次                                   */
ksg03       varchar2(40),            /*生产料号                               */
ksg04       date,                    /*预计生产完工日期                       */
ksg05       number(15,3),            /*计划数量                               */
ksg06       varchar2(1),             /*No Use                                 */
ksg07       date,                    /*有效日期                               */
ksg08       varchar2(1),             /*No Use                                 */
ksg09       varchar2(1),             /*结案否                                 */
ksg10       number(10),              /*No Use                                 */
ksg11       varchar2(255),           /*备注                                   */
ksg12       date,                    /*No Use                                 */
ksg13       varchar2(1),             /*No Use                                 */
ksg14       varchar2(1),             /*No Use                                 */
ksg15       varchar2(1),             /*No Use                                 */
ksg930      varchar2(10)             /*成本中心                               */
);

create        index ksg_02 on ksg_file (ksg03);
create unique index ksg_pk on ksg_file (ksg01,ksg02);
alter table ksg_file add  constraint ksg_pk primary key  (ksg01,ksg02) enable validate;
grant select on ksg_file to public;
grant index on ksg_file to public;
grant update on ksg_file to public;
grant delete on ksg_file to public;
grant insert on ksg_file to public;