/* ================================================================================ 档案代号:tri_file 档案名称:职务评鉴委员单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table tri_file ( tri01 varchar2(8) NOT NULL, /*考试科目 */ tri02 date NOT NULL, /*委任起始日期 */ tri03 date NOT NULL, /*委任截止日期 */ tri04 number(5) NOT NULL, /*行序 */ tri05 varchar2(1), /*外聘否 */ tri06 varchar2(10), /*委员代号 */ tri07 varchar2(1) /*主委否 */ ); create unique index tri_pk on tri_file (tri01,tri02,tri03,tri04); alter table tri_file add constraint tri_pk primary key (tri01,tri02,tri03,tri04) enable validate; grant select on tri_file to public; grant index on tri_file to public; grant update on tri_file to public; grant delete on tri_file to public; grant insert on tri_file to public; |