mysql

type TSchemaTableColumn struct {
	TableSchema       string `db:"table_schema"`
	Table             string `db:"table_name"`
	ColumnName        string `db:"column_name"`
	RawDataType       string `db:"data_type"`
	DataType          string `db:"column_type"`
	VarcharLength     uint64 `db:"character_maximum_length"` // char,varchar
	BinaryLength      uint64 `db:"character_octet_length"`   // binary,varbinary
	NumericWidth      uint64 `db:"numeric_precision"`        // decimal,numeric,float,double
	NumericPrecision  uint64 `db:"numeric_scale"`            // decimal,numeric
	DatetimePrecision uint64 `db:"datetime_precision"`       // datetime/timestamp/time
	DefaultValue      string `db:"column_default"`
	IsNullable        string `db:"is_nullable"`
	Extra             string `db:"extra"`
	OrdinalPosition   string `db:"ordinal_position"`
}

type TSchemaTableIndex struct {
	TableSchema string `db:"table_schema"`
	IndexType   string `db:"index_type"`
	IndexName   string `db:"index_name"`
	NonUnique   int    `db:"non_unique"`
	Table       string `db:"table_name"`
	ColumnName  string `db:"column_name"`
	SeqInIndex  int    `db:"seq_in_index"`
}