/* ================================================================================ 档案代号:isf_file 档案名称:GIS系统参数档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table isf_file ( isf00 varchar2(1) NOT NULL, /*key value = '0' */ isf01 varchar2(1), /*发票汇出时,单价是含税/未税 */ isf02 varchar2(8), /*商品类型 */ isf03 varchar2(1), /*No Use */ isf04 varchar2(1), /*No Use */ isf05 varchar2(1), /*No Use */ isf06 varchar2(1), /*No Use */ isf07 varchar2(10), /*No Use */ isf08 varchar2(10), /*No Use */ isf09 varchar2(10), /*No Use */ isf10 varchar2(10), /*No Use */ isf11 number(10), /*No Use */ isf12 number(10), /*No Use */ isf13 number(10), /*No Use */ isf14 number(10), /*No Use */ isf15 number(10), /*No Use */ isf16 date, /*No Use */ isf17 date /*No Use */ ); create unique index isf_pk on isf_file (isf00); alter table isf_file add constraint isf_pk primary key (isf00) enable validate; grant select on isf_file to public; grant index on isf_file to public; grant update on isf_file to public; grant delete on isf_file to public; grant insert on isf_file to public; |