I have a potential feature enhancement for the database-based Metadata Loaders. This has been tested with the PostgresSQL loaders, however I suspect this is something that is reflected across all database loaders.
This suggestion is simply for constraints of the fields to be brought into connect, with the names of the fields. So for instance the following:
is visible in Connect as:
What would be nice is two additional columns, 'Not Null' and 'Primary Key'. Or alternatively, a 'constraints' column, that contains these constraints, so that it does not have to be documented manually following an import.