/* ================================================================================ 档案代号:opn_file 档案名称:产品别预计产量单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table opn_file ( opn01 varchar2(10) NOT NULL, /*产品别 */ opn02 varchar2(10) NOT NULL, /*版本 */ opn03 number(5) NOT NULL, /*年度 */ opn04 number(5) NOT NULL, /*月份 */ opn05 number(15,3), /*计划数量 */ opn06 varchar2(1), /*No Use */ opn07 varchar2(1), /*No Use */ opn08 varchar2(1) /*No Use */ ); create unique index opn_pk on opn_file (opn01,opn02,opn03,opn04); alter table opn_file add constraint opn_pk primary key (opn01,opn02,opn03,opn04) enable validate; grant select on opn_file to public; grant index on opn_file to public; grant update on opn_file to public; grant delete on opn_file to public; grant insert on opn_file to public; |