/* ================================================================================ 档案代号:ahi_file 档案名称:利润中心内部定价档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ahi_file ( ahi01 number(5) NOT NULL, /*年度 */ ahi02 number(5) NOT NULL, /*期别 */ ahi03 varchar2(40) NOT NULL, /*料号 */ ahi04 number(20,6), /*成本单价 by ima25 */ ahi05 number(20,6) /*内部单价 by ima25 */ ); create unique index ahi_pk on ahi_file (ahi01,ahi02,ahi03); alter table ahi_file add constraint ahi_pk primary key (ahi01,ahi02,ahi03) enable validate; grant select on ahi_file to public; grant index on ahi_file to public; grant update on ahi_file to public; grant delete on ahi_file to public; grant insert on ahi_file to public; |