/* ================================================================================ 档案代号:osb_file 档案名称:销售目标单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table osb_file ( osb01 varchar2(16) NOT NULL, /*目标单号 */ osb02 number(5) NOT NULL, /*年度 */ osb03 number(5) NOT NULL, /*期别 */ osb04 number(20,6), /*原币目标 */ osb05 number(20,6) /*本币目标 */ ); create unique index osb_pk on osb_file (osb01,osb02,osb03); alter table osb_file add constraint osb_pk primary key (osb01,osb02,osb03) enable validate; grant select on osb_file to public; grant index on osb_file to public; grant update on osb_file to public; grant delete on osb_file to public; grant insert on osb_file to public; |