db_dict.h

在SCO UNIX制定界面程序 可根据文件配制菜单,而不必修改源程序,非常方便

/*************************************************************************
 * 有关库表主键等的定义
 *
 * 周国祥	2001/05/15 move from dbprg/audit.ec
 *		除dbprg/audit.ec中用于产生文件上下传信息外，
 *		upload/*.ec 中也会用到，为避免不一致性，故移至此处
 ************************************************************************/

#ifndef _DB_DICT_H_
#define _DB_DICT_H_

static struct db_dict {
	char *tablename;
	char *key_field[6];
	char downloadflag;
	char uploadflag;
} dict[] = {
	{ "bank_info",		{ "bank_id", "host_id", NULL },1,1 },
	{ "bank_base",		{ "bank_id", "host_id", NULL },0,1 },
	{ "bank_acct",		{ "bank_id", "host_id", NULL },0,0 },
	{ "merchant_base",	{ "merchant_id", NULL },0,1 },
	{ "vip_card",		{ "card_no", NULL },0,1 },
	{ "bank_limit_amt",	{ "bank_id", "host_id", "tran_type", "card_type", NULL },0,1 },
	{ "edc_terminal",	{ "merchant_id", "terminal_id", NULL },0,1 },
	{ "edc_dl_ctl",		{ "terminal_id", "merchant_id" },0,1 },
	{ "edc_trans",		{ "terminal_id", "merchant_id" },0,1 },
	{ "edc_card",		{ "terminal_id", "merchant_id" },0,1 },
	{ "edc_dl_param",	{ "mode_type", NULL },0,1 },
	{ "adm_bank_ctrl",	{ "bank_id", "host_id", NULL },1,0 },
	{ "wb_list",		{ "card_no", NULL },0,0 },
	{ "card_acct",		{ "card_no", NULL },0,0 },
	{ "cur_tran_ls",	{ "merchant_id","terminal_id","card_no",NULL },0,0 },
	{ "err_tran_ls",	{ "merchant_id", "terminal_id", "card_no",NULL },0,0 },
	//{ "hjd",		{ "merchant_id", "batch_no", NULL },0,0 },
	//{ "rmb_rate",		{ "currency", "date", NULL },0,0 },
	{ "center_oper",	{ "oper_no", NULL },0,0 },
	{ "merchant_oper",	{ "merchant_id", "oper_no", NULL },0,0 },
	{ "sys_param",		{ "bank_id", NULL },0,0 },
	{ "card_type",		{ "card_no", NULL },0,0 },
	{ "sys_module",		{ "module_id", NULL },0,0 },
	//{ "pos_param",	{ "mode_type", NULL },0,0 },
	{ "card_route",		{"first_card_no", "last_card_no", "rcv_bank_id", "rcv_host_id", "module_id", NULL },0,0 },
	{ "default_route",	{ "rcv_bank_id", "rcv_host_id", "module_id", NULL },0,0 },
	{ "control_card",	{ "card_no", NULL },0,1 },
	{ NULL, }};


#endif	//_DB_DICT_H_