model

type Column struct {
	*DbColumn
	Index *DbIndex
}

type ColumnData struct {
	Db      string
	Table   string
	Columns []*Column
}

type DbColumn struct {
	Name            string `db:"COLUMN_NAME"`
	DataType        string `db:"DATA_TYPE"`
	ColumnType      string `db:"COLUMN_TYPE"`
	Extra           string `db:"EXTRA"`
	Comment         string `db:"COLUMN_COMMENT"`
	ColumnDefault   any    `db:"COLUMN_DEFAULT"`
	IsNullAble      string `db:"IS_NULLABLE"`
	OrdinalPosition int    `db:"ORDINAL_POSITION"`
}

type DbIndex struct {
	IndexName  string `db:"INDEX_NAME"`
	NonUnique  int    `db:"NON_UNIQUE"`
	SeqInIndex int    `db:"SEQ_IN_INDEX"`
}

type Index struct {
	IndexType IndexType
	Columns   []*Column
}

type IndexType string

type InformationSchemaModel struct {
	// contains filtered or unexported fields
}

type PostgreColumn struct {
	Num               sql.NullInt32  `db:"num"`
	Field             sql.NullString `db:"field"`
	Type              sql.NullString `db:"type"`
	NotNull           sql.NullBool   `db:"not_null"`
	Comment           sql.NullString `db:"comment"`
	ColumnDefault     sql.NullString `db:"column_default"`
	IdentityIncrement sql.NullInt32  `db:"identity_increment"`
}

type PostgreIndex struct {
	IndexName  sql.NullString `db:"index_name"`
	IndexId    sql.NullInt32  `db:"index_id"`
	IsUnique   sql.NullBool   `db:"is_unique"`
	IsPrimary  sql.NullBool   `db:"is_primary"`
	ColumnName sql.NullString `db:"column_name"`
	IndexSort  sql.NullInt32  `db:"index_sort"`
}

type PostgreSqlModel struct {
	// contains filtered or unexported fields
}

type Table struct {
	Db      string
	Table   string
	Columns []*Column
	// Primary key not included
	UniqueIndex map[string][]*Column
	PrimaryKey  *Column
	NormalIndex map[string][]*Column
}