package com.example.wordbook.provider;

import java.util.HashMap;
import java.util.Map;

import android.provider.BaseColumns;

/**
 * DB定義クラス
 */
public final class WBData {

	/** DBバージョン */
	public static final int DATABASE_VERSION = 1;

	/** DBファイル名 */
	public static final String DATABASE_NAME = "wordbook.db";

	/** テーブル名 */
	public static final String TABLE_NAME_INFO = "info";

	/**
	 * テーブル列定義クラス
	 */
	public static final class InfoColumns implements BaseColumns {
		public static final String DEFAULT_SORT_ORDER = "_id ASC";

		public static final String INFO_FILE = "info_file";
		public static final String INFO_FILE_TYPE = "INTEGER";
		public static final String INFO_NUM = "info_num";
		public static final String INFO_NUM_TYPE = "INTEGER";
		public static final String INFO_STAT = "info_stat";
		public static final String INFO_STAT_TYPE = "INTEGER";
		public static final String INFO_LEVEL = "info_level";
		public static final String INFO_LEVEL_TYPE = "INTEGER";
		public static final String INFO_FLAG = "info_flag";
		public static final String INFO_FLAG_TYPE = "INTEGER";
		public static final String INFO_OK = "info_ok";
		public static final String INFO_OK_TYPE = "INTEGER";
		public static final String INFO_NG = "info_ng";
		public static final String INFO_NG_TYPE = "INTEGER";
		public static final String INFO_QUESTION = "info_question";
		public static final String INFO_QUESTION_TYPE = "TEXT";
		public static final String INFO_ANSWER = "info_answer";
		public static final String INFO_ANSWER_TYPE = "TEXT";
		public static final String INFO_DATA1 = "info_data1";
		public static final String INFO_DATA1_TYPE = "TEXT";
		public static final String INFO_DATA2 = "info_data2";
		public static final String INFO_DATA2_TYPE = "TEXT";
	}

	/** 射影マップ */
	public static final Map<String, String> PROJECTION_MAP_INFO;

	/** 射影マップ初期化 */
	static {
		PROJECTION_MAP_INFO = new HashMap<String, String>();

		PROJECTION_MAP_INFO.put(BaseColumns._ID, BaseColumns._ID);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_FILE, InfoColumns.INFO_FILE);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_NUM, InfoColumns.INFO_NUM);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_STAT, InfoColumns.INFO_STAT);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_LEVEL, InfoColumns.INFO_LEVEL);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_FLAG, InfoColumns.INFO_FLAG);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_OK, InfoColumns.INFO_OK);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_NG, InfoColumns.INFO_NG);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_QUESTION,
				InfoColumns.INFO_QUESTION);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_ANSWER,
				InfoColumns.INFO_ANSWER);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_DATA1, InfoColumns.INFO_DATA1);
		PROJECTION_MAP_INFO.put(InfoColumns.INFO_DATA2, InfoColumns.INFO_DATA2);
	}

	/**
	 * コンストラクタ（ユーティリティクラス）
	 */
	private WBData() {
	}

}