/*
================================================================================
档案代号:smx_file
档案名称:异动记录报表内容单身
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table smx_file
(
smx01       varchar2(8) NOT NULL,    /*报表代号                               */
smx02       number(5) NOT NULL,      /*项次                                   */
smx03       number(5),               /*排列行序                               */
                                     /*允许值1/2/3                            */
smx04       number(5),               /*排列栏序                               */
                                     /*行序加上栏序不可重复                   */
smx05       varchar2(10),            /*栏位来源                               */
smx06       number(15,3),            /*栏位长度                               */
smx07       number(5),               /*栏位性质                               */
                                     /*0.char 在报表中左靠                    */
                                     /*>0.numeric 在报表中右靠                */
smxdmy1     varchar2(1),             /*No Use                                 */
smxdmy2     varchar2(1)              /*No Use                                 */
);

create unique index smx_pk on smx_file (smx01,smx02);
alter table smx_file add  constraint smx_pk primary key  (smx01,smx02) enable validate;
grant select on smx_file to public;
grant index on smx_file to public;
grant update on smx_file to public;
grant delete on smx_file to public;
grant insert on smx_file to public;