公用的数据库表和一些业务表_数据库 基准表 业务表

-- 字典 --

select * from code_library where codeno="PartnerType";
select * from code_library where codeno="Tickettype";
 
-- getitemname('BailUseType',status)
 
-- getitemname('BailUseType',usetype)

-- 自动生成id存储表--

select * from object_maxsn
-- UPDATE tb_name SET score=189 WHERE id=2;

-- 错误表--

select * from webservice_error;

-- 配置服务表--

-- com.amarsoft.trade.partner.orgmanager.bail.BailAdvancesHandler
select * from webservice_uddi where methodid like 'partner.set%';
select * from webservice_uddi where methodid="partner.ticketcheck";
-- partner.ticketcheck
 
-- com.amarsoft.trade.partner.merchantmanager.ticket.TicketCheckHandler
-- {"inpu