Update constraints of Behaviour, Distance & GroupID fields

ices-tools-dev / esas

European Seabirds at Sea (ESAS) data model

https://esas-docs.ices.dk

Creative Commons Zero v1.0 Universal

3 stars 1 forks source link

Update constraints of Behaviour, Distance & GroupID fields #102

Closed peterdesmet closed 2 years ago

peterdesmet commented 2 years ago

The file specification currently has char(5) for Behaviour. Since behaviour codes can be combined with ~ that might be too limiting. I would set this to char(30) cf. Association.

nicolasvanermen commented 2 years ago

I would also set Distance to float(6) and groupID to char(5)

Sample > Distance: float(4) -> float(6)

[x] Update in database
[x] Update in Specification of format
[x] Update in Table schema

Observation > GroupID: char(3) -> char(5)

[x] Update in database
[x] Update in Specification of format
[x] Update in Table schema

Observation > Behaviour: char(5) -> char(30)

[x] Update in database
[x] Update in Specification of format
[x] Update in Table schema

peterdesmet commented 2 years ago

@cmspinto can these field length changes be implemented in the database?

@Osanna123 can these field length changes be updated in the specification of the format

neil-ices-dk commented 2 years ago

Anna has tested an import file and it was ok, so fully implemented