The release table
A publisher's versioned dataset, labelled the way the publisher labels it. A factor spans releases; its values attach to one.
Fields#
| field | type | required | example | meaning |
|---|---|---|---|---|
id |
uuid | yes | The row's own identifier. Consumers address a factor by its slug, not by this. | |
publisher_id |
uuid | yes | The publisher this belongs to. | |
version |
text | yes | 23.6 | The version label the publisher itself uses. |
system_model |
text | ecoinvent 'cutoff' / 'APOS' / ...; NULL for single-model publishers. | ||
released_on |
date | When the publisher released it. | ||
stream |
text | The publisher's document line, when it ships more than one co-valid document: efdb beside ar6, a spreadsheet beside a report annex, an energy set beside a transport set. Empty for the usual case of one document. Editions supersede each other within a stream; two streams are complementary and both are served. |
||
is_latest |
boolean | yes | Which release serves, among the releases of one publisher, one system_model and one stream. A newer edition supersedes an older one where their factor coverage overlaps. Reading false means the release is not served at all, so a publisher's second, co-valid document must declare its own stream rather than compete for one flag. |
|
source_url |
text | Where the source document can be retrieved. | ||
license_code |
text | yes | License provenance is per-release: it varies by version (EXIOBASE 3.8.2 open vs 3.10 NC) and by artifact within a publisher (Agribalyse CSV vs LCI). The open-source split is a filter on license_tier, not a fork. 'etalab-2.0','cc-by-sa-4.0',... | |
license_tier |
text | yes | open / copyleft / restricted / prohibited | |
license_url |
text | The full licence text. | ||
attribution_text |
text | The credit line reuse requires, and nothing else: no licence terms, no note of ours. Copy it whole. | ||
license_notice |
text | The publisher's own terms-of-use prose, verbatim, where the licence is not a named public one (a copyright notice, an EULA clause, an Impressum sentence). Empty when the licence name says it all. |
Referenced by#
emission_factor_value.release_id, ingest_run.release_id, source_artifact.release_id, source_row.release_id.
Notes#
is_latest picks the winner among releases whose factor coverage overlaps, within one stream. It IS the serving filter (factors_flat joins it) so a release reading false serves nothing. A publisher that ships two co-valid documents (an EFDB export and an AR6 table; a spreadsheet and a report annex) gives each one a stream, and each stream then carries its own current release. Four columns say how a factor may be used: license_tier is the distribution filter (open, copyleft, restricted, prohibited), license_code names the specific licence, attribution_text is the credit line a consumer reproduces, whole and with nothing else in it, and license_notice carries the publisher's own terms-of-use prose where the licence is not a named public one, or is empty. All four (and license_url) are served on factors_flat, so filtering by licence no longer means joining back to this table.