/* ================================================================================ 档案代号:opm_file 档案名称:产品别预计产量单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table opm_file ( opm01 varchar2(10) NOT NULL, /*产品别 */ opm02 varchar2(10) NOT NULL, /*版本 */ opm03 number(5) NOT NULL, /*年度 */ opm04 varchar2(1), /*No Use */ opm05 varchar2(1), /*No Use */ opm06 varchar2(1), /*No Use */ opmacti varchar2(1), /*资料有效码 */ opmuser varchar2(10), /*资料所有者 */ opmgrup varchar2(10), /*资料所有群 */ opmmodu varchar2(10), /*资料更改者 */ opmdate date /*最近修改日 */ ); create unique index opm_pk on opm_file (opm01,opm02,opm03); alter table opm_file add constraint opm_pk primary key (opm01,opm02,opm03) enable validate; grant select on opm_file to public; grant index on opm_file to public; grant update on opm_file to public; grant delete on opm_file to public; grant insert on opm_file to public; |