xin.xihc.jba.db.bean.MysqlColumnInfo Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of spring-jba Show documentation
java对象访问
There is a newer version: 1.8.12
/**
 *
 */
package xin.xihc.jba.db.bean;

/**
 * Mysql数据库列信息
 *
 * @author Leo.Xi
 * @date 2018年1月26日
 * @since
 */
public class MysqlColumnInfo {

	private String table_catalog;
	/**
	 * 库名
	 */
	private String table_schema;
	/**
	 * 表名
	 */
	private String table_name;
	/**
	 * 字段名
	 */
	private String column_name;
	/**
	 * 字段位置的排序
	 */
	private String ordinal_position;
	/**
	 * 字段默认值
	 */
	private String column_default;
	/**
	 * 是否可以为null
	 */
	private String is_nullable;
	/**
	 * 字段类型
	 */
	private String data_type;
	/**
	 * 最大长度
	 */
	private Integer character_maximum_length;
	private Integer character_octet_length;
	/**
	 * 数字长度
	 */
	private Integer numeric_precision;
	/**
	 * 小数点数
	 */
	private Integer numeric_scale;
	/**
	 * 日期时间格式
	 */
	private Integer datetime_precision;
	private String character_set_name;
	private String collation_name;
	/**
	 * 类型加长度拼接的字符串，例如varchar(100)
	 */
	private String column_type;
	/**
	 * 是否是主键，是的话为PRI
	 */
	private String column_key;
	/**
	 * 是否为自动增长，是的话为auto_increment
	 */
	private String extra;
	private String privileges;
	private String column_comment;

	public String getTable_catalog() {
		return table_catalog;
	}

	public void setTable_catalog(String table_catalog) {
		this.table_catalog = table_catalog;
	}

	public String getTable_schema() {
		return table_schema;
	}

	public void setTable_schema(String table_schema) {
		this.table_schema = table_schema;
	}

	public String getTable_name() {
		return table_name;
	}

	public void setTable_name(String table_name) {
		this.table_name = table_name;
	}

	public String getColumn_name() {
		return column_name;
	}

	public void setColumn_name(String column_name) {
		this.column_name = column_name;
	}

	public String getOrdinal_position() {
		return ordinal_position;
	}

	public void setOrdinal_position(String ordinal_position) {
		this.ordinal_position = ordinal_position;
	}

	public String getColumn_default() {
		return column_default;
	}

	public void setColumn_default(String column_default) {
		this.column_default = column_default;
	}

	public String getIs_nullable() {
		return is_nullable;
	}

	public void setIs_nullable(String is_nullable) {
		this.is_nullable = is_nullable;
	}

	public String getData_type() {
		return data_type;
	}

	public void setData_type(String data_type) {
		this.data_type = data_type;
	}

	public Integer getCharacter_maximum_length() {
		return character_maximum_length;
	}

	public void setCharacter_maximum_length(Integer character_maximum_length) {
		this.character_maximum_length = character_maximum_length;
	}

	public Integer getCharacter_octet_length() {
		return character_octet_length;
	}

	public void setCharacter_octet_length(Integer character_octet_length) {
		this.character_octet_length = character_octet_length;
	}

	public Integer getNumeric_precision() {
		return numeric_precision;
	}

	public void setNumeric_precision(Integer numeric_precision) {
		this.numeric_precision = numeric_precision;
	}

	public Integer getNumeric_scale() {
		return numeric_scale;
	}

	public void setNumeric_scale(Integer numeric_scale) {
		this.numeric_scale = numeric_scale;
	}

	public Integer getDatetime_precision() {
		return datetime_precision;
	}

	public void setDatetime_precision(Integer datetime_precision) {
		this.datetime_precision = datetime_precision;
	}

	public String getCharacter_set_name() {
		return character_set_name;
	}

	public void setCharacter_set_name(String character_set_name) {
		this.character_set_name = character_set_name;
	}

	public String getCollation_name() {
		return collation_name;
	}

	public void setCollation_name(String collation_name) {
		this.collation_name = collation_name;
	}

	public String getColumn_type() {
		return column_type;
	}

	public void setColumn_type(String column_type) {
		this.column_type = column_type;
	}

	public String getColumn_key() {
		return column_key;
	}

	public void setColumn_key(String column_key) {
		this.column_key = column_key;
	}

	public String getExtra() {
		return extra;
	}

	public void setExtra(String extra) {
		this.extra = extra;
	}

	public String getPrivileges() {
		return privileges;
	}

	public void setPrivileges(String privileges) {
		this.privileges = privileges;
	}

	public String getColumn_comment() {
		return column_comment;
	}

	public void setColumn_comment(String column_comment) {
		this.column_comment = column_comment;
	}

}