/* ================================================================================ 档案代号:mlb_file 档案名称:报表转发人员单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mlb_file ( mlb01 varchar2(10) NOT NULL, /*报表代号 */ mlb02 number(5) NOT NULL, /*顺序 */ mlb03 varchar2(10) NOT NULL, /*查阅人员 */ mlb04 varchar2(255) /*备注 */ ); create unique index mlb_pk on mlb_file (mlb01,mlb02,mlb03); alter table mlb_file add constraint mlb_pk primary key (mlb01,mlb02,mlb03) enable validate; grant select on mlb_file to public; grant index on mlb_file to public; grant update on mlb_file to public; grant delete on mlb_file to public; grant insert on mlb_file to public; |