schema

type Column struct {
	Table           string
	Name            string // ColumnName
	OrdinalPosition int
	Default         string // ColumnDefault
	Nullable        string
	DataType        string
	ColumnType      string
	Key             string // ColumnKey
	Extra           string
	Comment         string // ColumnComment
	ForeignKey      *ForeignKey
	IndexName       string
	NonUnique       int
	IsMultiKey      bool
}

type Driver interface {
	// Open creates a new Scheme for the given configuration.
	Open(cfg *config.DB) (Scheme, error)
}

type ForeignKey struct {
	ConstraintName string // FK constraint name
	Table          string // Source table (e.g., "posts")
	ColumnName     string // Column in source table (e.g., "user_id")
	RefTable       string // Referenced table (e.g., "users")
	RefColumn      string // Referenced column (e.g., "id")
}

type Index struct {
	Table      string
	NonUnique  int
	ColumnName string
	IndexName  string
}

type Scheme interface {
	io.Closer
	Load(ctx context.Context) ([]*Table, error)
}

type Table struct {
	Name               string
	Comment            string
	Columns            []*Column
	ForeignKeys        []ForeignKey
	ReverseForeignKeys []ForeignKey // Foreign keys from other tables referencing this table
}