Opened 11 years ago

Closed 10 years ago

#718 closed defect (fixed)

ps_service_provider table is missing a contact_fascimile column

Reported by: James Passmore Owned by: Piero Campalani
Priority: minor Milestone:
Component: petascope Version: 9.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 by abeccati, 11 years ago

Complexity: Medium → Easy
Component: undecided → petascope
Owner: changed from Dimitar Misev to Piero Campalani

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 by Piero Campalani, 11 years ago

Status: new → accepted

comment:3 by Piero Campalani, 10 years ago

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 by Dimitar Misev, 10 years ago

Resolution: → fixed
Status: accepted → closed
Note: See TracTickets for help on using tickets.