/* ================================================================================ 档案代号:tsa_file 档案名称:提案明细资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tsa_file ( tsa01 varchar2(16) NOT NULL, /*提案单号 */ tsa02 number(5) NOT NULL, /*客户项次 */ tsa03 number(5) NOT NULL, /*产品项次 */ tsa04 number(15,3), /*目标数量 */ tsa05 number(20,6), /*目标未税金额 */ tsa06 number(15,3), /*No Use */ tsa07 number(20,6), /*No Use */ tsa08 number(20,6), /*目标含税金额 */ tsa09 number(20,6) /*No Use */ ); create unique index tsa_pk on tsa_file (tsa01,tsa02,tsa03); alter table tsa_file add constraint tsa_pk primary key (tsa01,tsa02,tsa03) enable validate; grant select on tsa_file to public; grant index on tsa_file to public; grant update on tsa_file to public; grant delete on tsa_file to public; grant insert on tsa_file to public; |