Different data types in the database (Gsheet/Postgres) and in appsheet: best practice?

[Thulium]

A data type can be specified both in the Gsheet/Postgres database and in Appsheet itself.
There are fewer data types in Gsheet than in Appsheet.
There are more data types in Postgres than in Appsheet.

What is the correct understanding of the interaction of the database in relation to data types?

1. Does the data type in appsheet always "win"?
2. Is there a synchronization of data types between database and appsheet?
   If yes: in one direction or in both?
3. What happens if the data type is different? Does Appsheet then warn and suggest a change to the data type?
4. Is it best practice to specify no data type at all in the data base (in Gsheets "none") or the most universal one (in Postgres)?
5. Where can I find official information on this topic?
   
   

Thanks for your help : )