Skip to content

JSONB Subtypes

Eric Hanson edited this page Nov 4, 2024 · 1 revision

rowlist

  • Array of row_ids represented as text strings, meta.row_id::text
  • Order matters - used for checkout sequence, etc.
[
    "(pt,periodic_table,{AtomicNumber},{4})",
    "(pt,periodic_table,{AtomicNumber},{5})",
    "(pt,periodic_table,{AtomicNumber},{6})"
]

fieldset

  • Object
  • keys are row_id::text
  • values are sub-object of column_name: value_hash
{
    "(pt,periodic_table,{AtomicNumber},{4})": {
        "Discoverer": "Dick Clark",
        "Element": "Instantfamium"
    },
    "(pt,periodic_table,{AtomicNumber},{6})": {
        "Discoverer": "John Lennon 907"
    }
}

Clone this wiki locally