Opened 11 years ago
Last modified 10 years ago
#720 closed enhancement
ps_service_provider has column contact_role that should be constrained against a dictionary of values — at Version 1
Reported by: | James Passmore | Owned by: | Dimitar Misev |
---|---|---|---|
Priority: | minor | Milestone: | 9.0.x |
Component: | petascope | Version: | development |
Keywords: | petascopedb | Cc: | |
Complexity: | Easy |
Description (last modified by )
The value of contact_role in the table ps_service_provider is used to populate the ows:Role of the WCS GetCapabilities response. This role has a restriction in the XML schema to a code list defined by section B5.5 (CI_RoleCode) of ISO 19115:2003.
It would be nice if petascopedb could have some dictionary of the allowed values, that could be used to constrain the values in ps_service_provider
Incidentally, the default value supplied in the table currently ('Project leader') is not a valid value, a more appropriate default would be 'pointOfContact'
The value of 'Project leader' would better be applied to the 'contact_position_name' column in the same table.