Following initial experiment, let me ask dummy question. Is it possible with airbyte to get result similar to native DB replication for set of tables. i.e. exact table definitions with datatypes for main fields, exact foreign keys, etc. Or should I look into native database replication instead ?

We dont have support for foreign keys currently. We try to create the same primary keys and the same data types although there are few data types which might end up as different. We are working on making the source definition of the table as close as possible in the destination as well.