compare

type ColumnData struct {
	TableName        string
	ColumnName       string
	DataType         types.NullString
	ColumnDefault    types.NullString
	IsNullable       string
	CharMaxLen       types.NullInt
	NumericPrecision types.NullInt
}

type ColumnDiff struct {
	DB1 []ColumnData
	DB2 []ColumnData
}

type DBComparisonResult struct {
	MissingTablesInDB1 []string
	MissingTablesInDB2 []string
	ColumnDiff         ColumnDiff
	ViewDiff           ViewDiff
}

type ViewData struct {
	ViewName       string
	ViewDefinition string
}

type ViewDiff struct {
	MissingViewsInDB1 []string
	MissingViewsInDB2 []string
	DifferentViews    []ViewDifference
}

type ViewDifference struct {
	ViewName      string
	DB1Definition string
	DB2Definition string
}