/*
================================================================================
档案代号:smj_file
档案名称:制造管理系统－系统[关闭/开启]历史记
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table smj_file
(
smj01       varchar2(10),            /*操作人员－系统关闭记录                 */
smj02       varchar2(20),            /*程式编号                               */
smj03       date,                    /*系统日期                               */
smj04       varchar2(8),             /*系统时间                               */
smj05       varchar2(16),            /*终端机编号                             */
smj06       varchar2(255),           /*备注(一)                               */
smj07       varchar2(255),           /*备注(二)                               */
                                     /*no use                            genero*/
smj08       varchar2(255),           /*备注(三)                               */
                                     /*no use                            genero*/
smj09       varchar2(10),            /*操作人员－系统开启记录                 */
smj10       varchar2(20),            /*程式编号                               */
smj11       date,                    /*系统日期                               */
smj12       varchar2(8),             /*系统时间                               */
smj13       varchar2(16),            /*终端机编号                             */
smj14       varchar2(255),           /*备注(一)                               */
smj15       varchar2(255),           /*备注(二)                               */
                                     /*no use                            genero*/
smj16       varchar2(255)            /*备注(三)                               */
                                     /*no use                            genero*/
);

grant select on smj_file to public;
grant index on smj_file to public;
grant update on smj_file to public;
grant delete on smj_file to public;
grant insert on smj_file to public;