/*
================================================================================
档案代号:sme_file
档案名称:工作行事历资料档    MANUFACTURE DATE
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table sme_file
(
sme01       date NOT NULL,           /*工作日                                 */
                                     /*manufacture date                       */
sme02       varchar2(1)              /*工作日否                               */
                                     /*只能输入 Y / N                         */
);

create unique index sme_pk on sme_file (sme01);
alter table sme_file add  constraint sme_pk primary key  (sme01) enable validate;
grant select on sme_file to public;
grant index on sme_file to public;
grant update on sme_file to public;
grant delete on sme_file to public;
grant insert on sme_file to public;