Opened 3 years ago

Closed 3 years ago

#718 closed defect (fixed)

ps_service_provider table is missing a contact_fascimile column

Reported by: jpass Owned by: pcampalani
Priority: minor Milestone:
Component: petascope Version: 9.0.0
Keywords: WCS metadata petascopedb Cc:
Complexity: Easy

Description

WCS contact info metadata permits a Facsimile phone number, but there is no way to add such a number using the ps_service_provider table.

E.g. it should be possible to have the following information in the WCS GetCapabilities? response:

<ows:Phone>
 <ows:Voice>+44 (0)131 667 1000</ows:Voice>
 <ows:Facsimile>+44 (0)131 668 2683</ows:Facsimile>
</ows:Phone>

Currently only a single phone number is permitted, though this also has an error see: http://rasdaman.eecs.jacobs-university.de/ticket/717

Change History (4)

comment:1 Changed 3 years ago by abeccati

  • Complexity changed from Medium to Easy
  • Component changed from undecided to petascope
  • Owner changed from dmisev to pcampalani

The faximile has multiplicity greater than one so either an array column or a property table to enable multiplicity with single valued types.

comment:2 Changed 3 years ago by pcampalani

  • Status changed from new to accepted

comment:3 Changed 3 years ago by pcampalani

Db schema and Petascope fixed in changeset:f6c9996 (requires update_petascopedb.sh).
James, please let me know if I can close the ticket, thanks.

comment:4 Changed 3 years ago by dmisev

  • Resolution set to fixed
  • Status changed from accepted to closed
Note: See TracTickets for help on using tickets.