structure

type Bound struct {
	ColumnNameS string `json:"columnNameS"`
	ColumnNameT string `json:"columnNameT"`
	CollationS  string `json:"collationS"`
	CollationT  string `json:"collationT"`
	LowerS      string `json:"lowerS"`
	UpperS      string `json:"upperS"`
	LowerT      string `json:"lowerT"`
	UpperT      string `json:"upperT"`

	HasLower bool `json:"hasLower"`
	HasUpper bool `json:"hasUpper"`
}

type Column struct {
	NewColumns map[string]NewColumn            `json:"newColumn"`
	OldColumns map[string]map[string]OldColumn `json:"oldColumn"`
}

type ConstraintCheck struct {
	ConstraintExpression string
}

type ConstraintForeign struct {
	ConstraintColumn      string
	ReferencedTableSchema string
	ReferencedTableName   string
	ReferencedColumnName  string
	DeleteRule            string
	UpdateRule            string
}

type ConstraintPrimary struct {
	ConstraintColumn string
}

type ConstraintUnique struct {
	ConstraintColumn string
}

type Index struct {
	IndexType        string
	Uniqueness       string
	IndexColumn      string
	DomainIndexOwner string
	DomainIndexName  string
	DomainParameters string
}

type NewColumn struct {
	Datatype    string // custom column datatype
	NULLABLE    string
	DataDefault string
	Charset     string
	Collation   string
	Comment     string
}

type OldColumn struct {
	DatatypeName      string
	DataLength        string
	DataPrecision     string
	DatetimePrecision string // only mysql compatible database
	DataScale         string
	NULLABLE          string
	DataDefault       string
	Charset           string
	Collation         string
	Comment           string
}

type Partition struct {
	PartitionKey     string
	PartitionType    string
	SubPartitionKey  string
	SubPartitionType string
}

type Range struct {
	DBTypeS     string         `json:"dbTypeS"`
	DBTypeT     string         `json:"dbTypeT"`
	Bounds      []*Bound       `json:"bounds"`
	BoundOffset map[string]int `json:"boundOffset"`
}

type Table struct {
	SchemaName         string
	TableName          string
	TableComment       string
	TableCharset       string
	TableCollation     string
	NewColumns         map[string]NewColumn            // columnNameNew -> NewColumn
	OldColumns         map[string]map[string]OldColumn // originColumnName -> columnNameNew -> OldColumn
	Indexes            map[string]Index                // indexName -> Index
	PrimaryConstraints map[string]ConstraintPrimary    // constraintName -> ConstraintPrimary
	UniqueConstraints  map[string]ConstraintUnique     // constraintName -> ConstraintUnique
	ForeignConstraints map[string]ConstraintForeign    // constraintName -> ConstraintForeign
	CheckConstraints   map[string]ConstraintCheck      // constraintName -> ConstraintCheck
	Partitions         []Partition
}

type TableObjects struct {
	PartitionTables   []string
	TemporaryTables   []string
	ClusteredTables   []string
	MaterializedViews []string
	ExternalTables    []string
	NormalViews       []string
	CompositeTables   []string
	TaskTables        []string // the database support migrate task table list
}