[Feature]: Store additional resource type information in the database

### Contact Details

_No response_

### What should we build?

Store additional resource type information in the database:
- type of resource type (int, str, UUID, …)
- Resource type constraints (min, max, …)
- resource type default values
- ...

### Relevant pseudo code

```shell

```