Clarify the differences between database properties and configs

### Contributions

- [ ] I have read the contribution docs, and understand what's expected of me.

### Link to the page on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/resource-configs/database

Here are [the reference docs ](https://docs.getdbt.com/reference/resource-properties/database)on a database source property. We outline the difference between [source properties](https://docs.getdbt.com/reference/source-properties) and configs in [Configs, properties, what are they?](https://docs.getdbt.com/reference/configs-and-properties) Here's more about [using Sources](https://docs.getdbt.com/docs/build/sources) and [defining a database source property](https://docs.getdbt.com/reference/resource-properties/database).

### What part(s) of the page would you like to see updated?

We had a great clarification question[ from the community](https://getdbt.slack.com/archives/C0441GSRU04/p1689195583896909). They asked about the database configs and properties.

@joellabes capture this so succinctly!
>when setting the database property for sources, you're telling dbt where to look for the tables that another tool is creating.
when setting the database config for seeds, models, etc, you're setting where dbt should write those tables/views to.
these are two different things that happen to have the same name. the configs for seeds, models, etc can be set in dbt_project.yml, whatever.yml or in the model file itself, and their inheritance follows the same rules as all other configs (see the what are they doc above).
for sources, database has to be defined in a whatever.yml file and theres no inheritance

### Additional information

_No response_