/*
 * Created on 2005.06.01.
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.etixpert.evolution;

/**
 * @author aintitfun
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class TableConstant {
	
	static java.util.Map tableInfos = new java.util.Hashtable();;
	
	static {
		
		tableInfos.put("distributor", new TableInfo(
				"", 
				new String[] {},
				new String[] {},
				new String[] {}));
		
		tableInfos.put("address", new TableInfo(
				"address", 
				new String[] {},
				new String[] {},
				new String[] {"id", "distr_id"}));
		
		tableInfos.put("creditcard", new TableInfo(
				"", 
				new String[] {},
				new String[] {},
				new String[] {}));
		
		tableInfos.put("bank_account", new TableInfo(
				"", 
				new String[] {},
				new String[] {},
				new String[] {}));
		
		tableInfos.put("individual_bonus", new TableInfo(
				"individual_bonus", 
				new String[] {"id","descr","q_metric","q_type","q_value","calc_metric","calc_value","calc_value_type","calc_type","valid_from","valid_to","distr_id"},
				new String[] {"integer","string","string","integer","numeric","string","numeric","integer","integer","bonusdate","bonusdate","integer"},
				new String[] {"id"}));
		
		tableInfos.put("individual_bonus_2", new TableInfo(
				"individual_bonus", 
				new String[] {"id","descr","valid_from","valid_to","distr_id", "db0", "db1", "db2", "db3", "db4", "t1b1", "t1b2", "t1b3"
						, "t2b1", "t2b2", "t2b3", "t3b1", "t3b2", "t3b3", "tbq", "t2_level1_criteria", "t3_level1_criteria", "t3_level2_criteria"},
				new String[] {"integer","string","bonusdate","bonusdate","integer", "numeric", "numeric", "numeric", "numeric", "numeric"
						, "numeric", "numeric", "numeric", "numeric", "numeric", "numeric", "numeric", "numeric", "numeric", 
						"integer", "integer", "integer", "integer"},
				new String[] {"id"}));
		
		
		tableInfos.put("article", new TableInfo(
				"article", 
				new String[] {"id","descr","art_group_id","trade_name_id","comment","combi", "inventory", "minimum_inventory", "ordered", "order_price"},
				new String[] {"string","string","integer","integer","string","boolean", "integer", "integer", "integer", "double"},
				new String[] {"id"}));
		
		tableInfos.put("supplier_order", new TableInfo(
				"supplier_order",
				new String[] {"id", "article_id", "quantity", "supplier_name", "order_id", "order_date"},
				new String[] {"integer", "string", "integer", "string", "string", "date"},
				new String[] {"id"}));
		
		tableInfos.put("accept_protocol", new TableInfo(
				"accept_protocol",
				new String[] {"id", "accept_date", "accepted_by", "distr_id", "similar_users"},
				new String[] {"integer", "date", "integer", "integer", "string"},
				new String[] {"id"}));
		
		tableInfos.put("article_history", new TableInfo(
				"article_history", 
				new String[] {"art_id","valid_from","valid_to","netto","netto_customer", "netto_silver_customer", "netto_gold_customer", "netto_vip_customer", "netto_handler", "netto_grosshandler", "points", "bonus", "vat_id", "order_price", "supplier", "supplier_alt", "supplier_container", "supplier_labels", "supplier_over_carton", "supplier_other", "user_changed"},
				new String[] {"string","date","date","double","double","double", "double", "double", "double", "double","double","double", "integer", "double", "string", "string", "string", "string", "string", "string", "integer"},
				new String[] {"art_id", "valid_from"}));

		tableInfos.put("discount_history", new TableInfo(
				"discount_history",
				new String[] {"distr_id", "discount_rate", "begin_time", "end_time"},
				new String[] {"integer", "float", "date", "date"},
				new String[] {"distr_id", "begin_time"}
				));
		
		tableInfos.put("combi_article_content", new TableInfo(
				"combi_article_content", 
				new String[] {"combi_art_id","art_id","quantity"},
				new String[] {"string","string","integer"},
				new String[] {"combi_art_id"}));

		tableInfos.put("order_detail", new TableInfo(
				"order_detail", 
				new String[] {"order_id","comment","art_name",
				"art_position", "quantity", "bonus", "brutto", 
				"netto", "points", "vat_value",
				"campaign_id", "promotion_id", "art_id", "trade_margin", "order_price", "netto_trader", "brutto_trader"},
				new String[] {"long","string","string",
				"integer", "integer", "double", "numeric", 
				"double", "double", "double",
				"integer", "integer", "string", "double", "double", "numeric", "numeric"},
				new String[] {"order_id", "art_position"}));
		
		tableInfos.put("protocol", new TableInfo(
				"protocol", 
				new String[] {"id","prot_date","table_name",
				"field_name", "before", "after", "changed_by", 
				"datatype", "identifier"},
				new String[] {"long","date","string",
				"string", "string", "string", "integer", 
				"string", "string"},
				new String[] {"id"}));		
		
		tableInfos.put("subscription_detail", new TableInfo(
				"subscription_detail", 
				new String[] {"id", "subscr_id","comment","art_name",
				"art_position", "quantity", "bonus", "brutto", 
				"netto", "points", "vat_value",
				"art_id", "trade_margin",
				"modification_comment", "subscription", "order_price", "netto_trader", "brutto_trader"},
				new String[] {"integer", "long","string","string",
				"integer", "integer", "double", "numeric", 
				"double", "double", "double",
				"string", "double",
				"string", "boolean", "double", "numeric", "numeric"},
				new String[] {"subscr_id","art_id"}));
				
		tableInfos.put("order_header", new TableInfo(
						"order_header", 
						new String[] {"id","bill_id","order_status_id", "bonus_date",
						"order_date", "ordered_by", "comment", "payment_status",
						"pay_method_id", "pay_method_descr", "account_id", 
						"store_descr", "shipping_descr", "order_type", 
						"delivery_postcode", "delivery_city", "delivery_street",
						"delivery_name", "delivery_country_id", "delivery_title",
						"billing_postcode", "billing_city", "billing_street",
						"billing_name", "billing_country_id", "billing_title",
						"total_netto", "total_brutto", "total_points",
						"total_bonus", "total_trade_margin", "order_created_by", "billing_date", 
						"total_netto_trader", "total_brutto_trader", "orderer_level_id", "orderer_level_subtype_id", "first_order", "discount_rate", "sconto", "sconto_days", "webshop_order"},
						new String[] {"long","long","integer", "date",
						"date", "integer", "string", "boolean",
						"integer", "string", "integer", 
						"string", "string", "integer",
						"string", "string", "string",
						"string", "string", "string",
						"string", "string", "string",
						"string", "string", "string",
						"numeric", "numeric", "numeric",
						"numeric", "numeric", "integer", "date", "numeric", "numeric", "integer", "integer", "boolean", "numeric", "numeric", "integer", "boolean"},
						new String[] {"id"}));		

		tableInfos.put("subscription_header", new TableInfo(
				"subscription_header", 
				new String[] {"id",
				"creation_date", "start_date", "distr_id", "comment",
				"pay_method_id", "pay_method_descr", "account_id", 
				"store_descr", "shipping_descr", 
				"delivery_postcode", "delivery_city", "delivery_street",
				"delivery_name", "delivery_country_id", "delivery_title",
			
				"total_netto", "total_brutto", "total_points",
				"total_bonus", "total_trade_margin", "created_by",
				"max_delivery","delivered", "next_delivery", "duration",
				"auto_extension","operating_time","delivery_intervall",
				"modified_by","modification_comment", "descr", "total_netto_trader", "total_brutto_trader", "orderer_level_id"},
				new String[] {"long",
				"date", "date", "integer", "string",
				"integer", "string", "integer", 
				"string", "string",
				"string", "string", "string",
				"string", "string", "string",
				
				"numeric", "numeric", "numeric",
				"numeric", "numeric", "integer",
				"integer","integer", "date", "integer",
				"boolean","integer","integer",
				"int", "string", "string", "numeric", "numeric", "integer"},
				new String[] {"id"}));		

		
		
	}
}
