/*
================================================================================
档案代号: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;