/* ================================================================================ 档案代号:ocb_file 档案名称:关系人可冲销之厂商编号 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ocb_file ( ocb01 varchar2(10) NOT NULL, /*客户编号 */ ocb02 varchar2(10) NOT NULL, /*营运中心编号 */ ocb03 varchar2(10) NOT NULL, /*厂商编号 */ ocb04 varchar2(1), /*No Use */ ocb05 varchar2(1), /*No Use */ ocbacti varchar2(1), /*资料有效码 */ ocbuser varchar2(10), /*资料所有者 */ ocbgrup varchar2(10), /*资料所有部门 */ ocbmodu varchar2(10), /*资料修改者 */ ocbdate date /*最近修改日 */ ); create unique index ocb_pk on ocb_file (ocb01,ocb02,ocb03); alter table ocb_file add constraint ocb_pk primary key (ocb01,ocb02,ocb03) enable validate; grant select on ocb_file to public; grant index on ocb_file to public; grant update on ocb_file to public; grant delete on ocb_file to public; grant insert on ocb_file to public; |