/* ================================================================================ 档案代号:wsm_file 档案名称:ERP 服务与他系统间栏位对应关系单头档 档案目的:提供建立呼叫 erp 服务建立资料时, 他系统与 erp 栏位的对应关系 上游档案: 下游档案: ============.========================.========================================== */ create table wsm_file ( wsm01 varchar2(80) NOT NULL, /*服务代码 */ wsm02 varchar2(15) NOT NULL, /*table 名称 */ wsmacti varchar2(1), /*资料有效码 */ wsmdate date, /*最后异动日期 */ wsmgrup varchar2(10), /*资料建立人员群组 */ wsmmodu varchar2(10), /*最后异动人员 */ wsmuser varchar2(10) /*资料建立人员 */ ); create unique index wsm_pk on wsm_file (wsm01,wsm02); alter table wsm_file add constraint wsm_pk primary key (wsm01,wsm02) enable validate; grant select on wsm_file to public; grant index on wsm_file to public; grant update on wsm_file to public; grant delete on wsm_file to public; grant insert on wsm_file to public; |