/* ================================================================================ 档案代号:msc_file 档案名称:MPS 计划变更单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msc_file ( msc01 varchar2(16) NOT NULL, /*MPS 计划变更单号 */ msc02 date, /*输入日期 */ msc03 varchar2(1), /*更新码 */ /*更新码(Y/N) */ msc04 date, /*变更日期 */ mscuser varchar2(10) /*资料所有者 */ ); create unique index msc_pk on msc_file (msc01); alter table msc_file add constraint msc_pk primary key (msc01) enable validate; grant select on msc_file to public; grant index on msc_file to public; grant update on msc_file to public; grant delete on msc_file to public; grant insert on msc_file to public; |