/* ================================================================================ 档案代号:tab_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tab_file ( tab01 varchar2(10) DEFAULT '' NOT NULL, /*员工代号*/ tab02 number(5) DEFAULT '0' NOT NULL, /*所得税计算年月*/ tab03 number(5) DEFAULT '0' NOT NULL, /*所得税计算月份*/ tab04 number(5) DEFAULT '0' NOT NULL, /*所得税计算序号*/ tab05 varchar2(1) DEFAULT '' NOT NULL, /*课税所得来源*/ tab06 varchar2(5) DEFAULT '' NOT NULL, /*计薪指标*/ tab07 number(5) DEFAULT '0' NOT NULL, /*次数*/ tab08 number(20,6) DEFAULT '0',/*课税所得 */ tab09 number(20,6) DEFAULT '0',/*所得税 */ tab10 varchar2(1) DEFAULT 'n' NOT NULL, /*发放*/ tab11 varchar2(1) DEFAULT 'y' NOT NULL, /*合并计算*/ tab12 varchar2(10), /*no use */ tab13 number(20,6) DEFAULT '0 /*no use/<020' /*no use*/ ); create unique index tab_pk on tab_file (tab01,tab02,tab03,tab04); alter table tab_file add constraint tab_pk primary key (tab01,tab02,tab03,tab04) enable validate; grant select on tab_file to public; grant index on tab_file to public; grant update on tab_file to public; grant delete on tab_file to public; grant insert on tab_file to public; |