(1) In the collections table, rename extent to spatial or extent_spatial to make it more similar to the STAC specification, because there is both the extent spatial andextent temporal.
(2) In the collections anditems tables, rename the created andupdated fields to created_at andupdated_at to make the type of fields more explicit, because leaving only created and updated , it sounds they are flags (i.e. boolean fields), while the suffix _at makes them explicit that they are dates.
I would like to suggest renaming some fields:
(1) In the
collections
table, renameextent
tospatial
orextent_spatial
to make it more similar to the STAC specification, because there is both theextent spatial
andextent temporal
.(2) In the
collections
anditems
tables, rename thecreated
andupdated
fields tocreated_at
andupdated_at
to make the type of fields more explicit, because leaving onlycreated
andupdated
, it sounds they are flags (i.e. boolean fields), while the suffix_at
makes them explicit that they are dates.