schema

type ColumnInfo struct {
	Name       string  // Column name
	DataType   string  // Database type (e.g., INT, VARCHAR(255))
	IsNullable bool    // Whether the column is nullable
	IsPrimary  bool    // Whether this column is the primary key
	IsUnique   bool    // Whether this column has a unique constraint
	Default    *string // Default value (if any)
}

type ComparableFieldInfo struct {
	GoName       string                     // Go field name
	DBColumn     string                     // Database column name
	Index        []int                      // Index for fast field access via FieldByIndex
	IsZero       func(v reflect.Value) bool // Function to check if value is zero/empty
	Kind         reflect.Kind               // Field kind (string, int, struct, etc.)
	Type         reflect.Type               // Field type (for more detailed type checking)
	IsEmbedded   bool                       // Whether this is from an embedded struct
	IgnoreInDiff bool                       // Whether to ignore this field during diffing (e.g., tags like db:"-")
}

type IndexInfo struct {
	Name    string   // Index name
	Columns []string // Column names
	Unique  bool     // Is unique index
}

type ModelInfo struct {
	TableName        string                // Renamed: tableName -> TableName
	PkName           string                // Database name of the primary key field (Exported)
	Columns          []string              // Renamed: columns -> Columns
	Fields           []string              // Corresponding Go struct field names (Exported)
	FieldToColumnMap map[string]string     // Map Go field name to its corresponding DB column name (Exported)
	ColumnToFieldMap map[string]string     // Map DB column name to its corresponding Go field name (Exported)
	CompareFields    []ComparableFieldInfo // Fields to compare during diff operations (new)
	Indexes          []IndexInfo           // 普通索引
	UniqueIndexes    []IndexInfo           // 唯一索引
}

type TableInfo struct {
	Name       string       // Table name
	Columns    []ColumnInfo // All columns
	Indexes    []IndexInfo  // All indexes (including unique)
	PrimaryKey string       // Primary key column name (if any)
}