db

type ColumnInfo struct {
	Name         string
	DataType     string
	IsNullable   bool
	Default      string
	IsPrimaryKey bool
	Description  string
}

type Connection interface {
	// Schema operations
	ListTables(ctx context.Context) ([]TableInfo, error)
	DescribeTable(ctx context.Context, schema, tableName string) (*TableInfo, error)
	GetForeignKeys(ctx context.Context, schema, tableName string) ([]ForeignKeyInfo, error)
	SearchColumns(ctx context.Context, pattern string) ([]ColumnInfo, error)

	// Query operations
	Query(ctx context.Context, sql string, args ...interface{}) (pgx.Rows, error)
	EnsureConnection(ctx context.Context)
}

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

type DatabaseInfo struct {
	Host     string
	Port     int
	Database string
	User     string
	Version  string
}

type ForeignKeyInfo struct {
	TableSchema        string
	TableName          string
	ColumnName         string
	ForeignTableSchema string
	ForeignTableName   string
	ForeignColumnName  string
	ConstraintName     string
}

type IndexInfo struct {
	Name       string
	TableName  string
	Columns    []string
	IsUnique   bool
	IsPrimary  bool
	Definition string
}

type TableInfo struct {
	Schema        string
	Name          string
	Type          string // table, view, materialized view
	Description   string
	EstimatedRows int64 // Estimated row count from pg_class.reltuples
	Columns       []ColumnInfo
}