/* ================================================================================ 档案代号:cof_file 档案名称:商品编号币别单价资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cof_file ( cof01 varchar2(40) NOT NULL, /*商品编号 */ cof02 varchar2(4) NOT NULL, /*币别 */ cof03 number(20,6), /*单价 */ cof04 varchar2(4), /*No Use */ cof05 varchar2(4), /*No Use */ cof06 number(16,8), /*No Use */ cof07 varchar2(1), /*No Use */ cof08 varchar2(1), /*No Use */ cof09 varchar2(1), /*No Use */ cofud01 varchar2(255), /*自订栏位-Textedit */ cofud02 varchar2(40), /*自订栏位-文字 */ cofud03 varchar2(40), /*自订栏位-文字 */ cofud04 varchar2(40), /*自订栏位-文字 */ cofud05 varchar2(40), /*自订栏位-文字 */ cofud06 varchar2(40), /*自订栏位-文字 */ cofud07 number(15,3), /*自订栏位-数值 */ cofud08 number(15,3), /*自订栏位-数值 */ cofud09 number(15,3), /*自订栏位-数值 */ cofud10 number(10), /*自订栏位-整数 */ cofud11 number(10), /*自订栏位-整数 */ cofud12 number(10), /*自订栏位-整数 */ cofud13 date, /*自订栏位-日期 */ cofud14 date, /*自订栏位-日期 */ cofud15 date /*自订栏位-日期 */ ); create unique index cof_pk on cof_file (cof01,cof02); alter table cof_file add constraint cof_pk primary key (cof01,cof02) enable validate; grant select on cof_file to public; grant index on cof_file to public; grant update on cof_file to public; grant delete on cof_file to public; grant insert on cof_file to public; |