/* ================================================================================ 档案代号:smb_file 档案名称:行业别资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table smb_file ( smb01 varchar2(5) NOT NULL, /*收件者名称 */ smb02 varchar2(1) NOT NULL, /*E-MAIL ADDRESS */ smb03 varchar2(80), /*行业名称 */ smb04 varchar2(5), /*no use */ smb05 varchar2(1) /*no use */ ); create unique index smb_pk on smb_file (smb01,smb02); alter table smb_file add constraint smb_pk primary key (smb01,smb02) enable validate; grant select on smb_file to public; grant index on smb_file to public; grant update on smb_file to public; grant delete on smb_file to public; grant insert on smb_file to public; |