/* ================================================================================ 档案代号: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; |