The classification_scheme table
The registry of classification systems a factor's activity can be expressed in.
Fields#
| field | type | required | example | meaning |
|---|---|---|---|---|
code |
text | yes | The stable short identifier used to reference this row. | |
name |
text | yes | The full name, as the organisation writes it. | |
authority |
text | yes | publishing body | |
is_standard |
boolean | yes | True for an externally published standard, which means the same thing across publishers and can be joined on. False for a publisher's own tree. | |
description |
text | yes | Free prose describing this row. | |
publisher_code |
text | Set for a publisher's own tree; NULL for an external standard. | ||
version |
text | The version label the publisher itself uses. | ||
url |
text | Where to find it at the source. |
Referenced by#
activity_classification.scheme.
Notes#
is_standard is the join rule: a published standard (NACE, NAICS) means the same thing across publishers and is a legitimate cross-library key. A publisher's own tree is meaningful inside that library only, however similar two trees look.