/* ================================================================================ 档案代号:obh_file 档案名称:下阶营运中心销售预测单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table obh_file ( obh01 varchar2(40) NOT NULL, /*料件编号 */ obh02 varchar2(1) NOT NULL, /*计划期别格式 */ obh021 number(10) NOT NULL, /*起始期别 */ obh03 number(5) NOT NULL, /*序号 */ obh04 varchar2(10) NOT NULL, /*下阶营运中心 */ obh05 number(15,3), /*下阶需求量 */ obh06 number(15,3), /*下阶调整量 */ obh07 number(15,3), /*小计 */ obh08 varchar2(1), /*No */ obh09 varchar2(1) /*No */ ); create unique index obh_pk on obh_file (obh01,obh02,obh021,obh03,obh04); alter table obh_file add constraint obh_pk primary key (obh01,obh02,obh021,obh03,obh04) enable validate; grant select on obh_file to public; grant index on obh_file to public; grant update on obh_file to public; grant delete on obh_file to public; grant insert on obh_file to public; |