/* ================================================================================ 档案代号:cpc_file 档案名称:课税级别资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpc_file ( cpc01 number(5) NOT NULL, /*课税级别 */ cpc02 number(20,6), /*所得净额/应纳税所得额以下( */ /*所得净额/应纳税所得额以下(含) for 大陆版*/ cpc03 number(9,4), /*级别税率 */ cpc04 number(20,6), /*速算扣除数 */ /*速算扣除数 for 大陆版*/ cpcuser varchar2(10), /*资料所有者 */ cpcgrup varchar2(10), /*资料所有群 */ cpcmodu varchar2(10), /*资料更改者 */ cpcdate date /*最近修改日 */ ); create unique index cpc_pk on cpc_file (cpc01); alter table cpc_file add constraint cpc_pk primary key (cpc01) enable validate; grant select on cpc_file to public; grant index on cpc_file to public; grant update on cpc_file to public; grant delete on cpc_file to public; grant insert on cpc_file to public; |