/* ================================================================================ 档案代号:mlk_file 档案名称:javamail预设收件人 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table mlk_file ( mlk01 varchar2(20) NOT NULL, /*程式代号 */ /*程式代号(program code) */ mlk02 number(5) NOT NULL, /*序号 */ mlk03 varchar2(1), /*1:收件者 2: 副本 3: 密件副本 */ mlk04 varchar2(80), /*MAIL address */ mlk05 varchar2(40), /*姓名 */ mlk06 varchar2(255) /*备注 */ ); create unique index mlk_pk on mlk_file (mlk01,mlk02); alter table mlk_file add constraint mlk_pk primary key (mlk01,mlk02) enable validate; grant select on mlk_file to public; grant index on mlk_file to public; grant update on mlk_file to public; grant delete on mlk_file to public; grant insert on mlk_file to public; |