/* ================================================================================ 档案代号:cpe_file 档案名称:班别资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpe_file ( cpe01 varchar2(10) NOT NULL, /*班别代码 */ cpe02 varchar2(40), /*班别简称 */ cpe03 number(8,4), /*班别之基础日总时数 */ cpe04 number(15,3), /*班别之基础月总天数 */ cpe05 number(5,3), /*No Use */ cpe06 varchar2(10), /*津贴代号 */ cpe07 varchar2(1), /*No Use */ cpe08 number(5), /*No Use */ cpe09 number(5), /*No Use */ cpe10 number(5), /*No Use */ cpeacti varchar2(1), /*资料有效否 */ cpeuser varchar2(10), /*资料所有者 */ cpegrup varchar2(10), /*资料所有群 */ cpemodu varchar2(10), /*资料更改者 */ cpedate date /*最近修改日 */ ); create unique index cpe_pk on cpe_file (cpe01); alter table cpe_file add constraint cpe_pk primary key (cpe01) enable validate; grant select on cpe_file to public; grant index on cpe_file to public; grant update on cpe_file to public; grant delete on cpe_file to public; grant insert on cpe_file to public; |