/* ================================================================================ 档案代号:cpt_file 档案名称:临时卡号资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cpt_file ( cpt01 date NOT NULL, /*使用日期 */ cpt02 varchar2(10) NOT NULL, /*临时卡号 */ cpt03 varchar2(10), /*员工代号 */ cptacti varchar2(1), /*资料有效否 */ cptuser varchar2(10), /*资料所有者 */ cptgrup varchar2(10), /*资料所有群 */ cptmodu varchar2(10), /*资料更改者 */ cptdate date /*最近修改日 */ ); create unique index cpt_pk on cpt_file (cpt01,cpt02); alter table cpt_file add constraint cpt_pk primary key (cpt01,cpt02) enable validate; grant select on cpt_file to public; grant index on cpt_file to public; grant update on cpt_file to public; grant delete on cpt_file to public; grant insert on cpt_file to public; |