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