/* ================================================================================ 档案代号:gii_file 档案名称:采购料明细档 (单身) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gii_file ( gii01 varchar2(6) NOT NULL, /*预测编号 */ gii02 varchar2(1) NOT NULL, /*类别 */ gii03 varchar2(10) NOT NULL, /*部门编号 */ gii04 number(5) NOT NULL, /*预测年度 */ gii05 number(5) NOT NULL, /*预测期别 */ gii06 number(20,6), /*预测金额 */ gii07 number(9,4) /*机率 */ ); create unique index gii_pk on gii_file (gii01,gii02,gii03,gii04,gii05); alter table gii_file add constraint gii_pk primary key (gii01,gii02,gii03,gii04,gii05) enable validate; grant select on gii_file to public; grant index on gii_file to public; grant update on gii_file to public; grant delete on gii_file to public; grant insert on gii_file to public; |