{"metadata":{"type":"database"},"title":"🗂️ CFP+ Master Source Registry v1.0","url":"https://app.notion.com/p/69c0a9bcd430442d8d9ef3f1eadadc92?pvs=204","text":"<database url=\"{{https://app.notion.com/p/69c0a9bcd430442d8d9ef3f1eadadc92}}\" inline=\"false\" icon=\"🗂️\">
The title of this Database is: 🗂️ CFP+ Master Source Registry v1.0
<ancestor-path></ancestor-path>
Here are the Database's Data Sources:
You can use the \"view\" tool on the URL of any Data Source to see its full schema configuration.
<data-sources>
<data-source url=\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\">
The title of this Data Source is: 🗂️ CFP+ Master Source Registry v1.0
Here is the database's configurable state:
Properties with `readOnly: true` are synced or system-managed. Do not try to update their values with page update tools.
<data-source-state>
{\"icon\":\"🗂️\",\"name\":\"CFP+ Master Source Registry v1.0\",\"schema\":{\"Current Status\":{\"description\":\"\",\"name\":\"Current Status\",\"options\":[{\"color\":\"brown\",\"description\":\"\",\"name\":\"Locked\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VVthPA/bl50ag\"},{\"color\":\"default\",\"description\":\"\",\"name\":\"Pending\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VVthPA/P0d2WQ\"},{\"color\":\"orange\",\"description\":\"\",\"name\":\"Missing\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VVthPA/RXhEeg\"},{\"color\":\"purple\",\"description\":\"\",\"name\":\"Draft\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VVthPA/PEtVSA\"},{\"color\":\"blue\",\"description\":\"\",\"name\":\"Active\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VVthPA/fGZAZg\"}],\"type\":\"select\"},\"Current Version\":{\"description\":\"\",\"name\":\"Current Version\",\"type\":\"text\"},\"Last Significant Update\":{\"description\":\"\",\"name\":\"Last Significant Update\",\"querySqlColumns\":{\"columns\":[{\"name\":\"date:Last Significant Update:start\",\"sqlType\":\"TEXT\"},{\"name\":\"date:Last Significant Update:end\",\"sqlType\":\"TEXT\"},{\"name\":\"date:Last Significant Update:is_datetime\",\"sqlType\":\"INTEGER\"}],\"usage\":\"For connections.notion.querySql. Main schema name not queryable.\"},\"type\":\"date\"},\"Layer\":{\"description\":\"\",\"name\":\"Layer\",\"options\":[{\"color\":\"blue\",\"description\":\"\",\"name\":\"Layer 1 — Constitutional\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/bl50ag\"},{\"color\":\"orange\",\"description\":\"\",\"name\":\"Layer 2 — Charter\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/P0d2WQ\"},{\"color\":\"pink\",\"description\":\"\",\"name\":\"Layer 3 — Governance\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/RXhEeg\"},{\"color\":\"red\",\"description\":\"\",\"name\":\"Layer 4 — Identity\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/PEtVSA\"},{\"color\":\"default\",\"description\":\"\",\"name\":\"Layer 5 — Brand\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/fGZAZg\"},{\"color\":\"yellow\",\"description\":\"\",\"name\":\"Layer 6 — Reference\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/ZWdVQQ\"},{\"color\":\"purple\",\"description\":\"\",\"name\":\"Layer 7 — Website\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/cnRWew\"},{\"color\":\"gray\",\"description\":\"\",\"name\":\"Layer 8 — Knowledge\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/WztGPg\"},{\"color\":\"brown\",\"description\":\"\",\"name\":\"Layer 9 — Translation\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/ZltARw\"},{\"color\":\"green\",\"description\":\"\",\"name\":\"Layer 10 — Media\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/dVdCZQ\"},{\"color\":\"yellow\",\"description\":\"\",\"name\":\"Locked Articles Registry\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/bmU-bQ\"},{\"color\":\"yellow\",\"description\":\"\",\"name\":\"Missing Content Registry\",\"url\":\"collectionPropertyOption://222880e9-4ec5-448c-a5e3-7522761de535/VnxZdA/YWJdWQ\"}],\"type\":\"select\"},\"Locked Status\":{\"description\":\"\",\"name\":\"Locked Status\",\"type\":\"checkbox\"},\"Notes\":{\"description\":\"\",\"name\":\"Notes\",\"type\":\"text\"},\"Official Link\":{\"description\":\"\",\"name\":\"Official Link\",\"type\":\"url\"},\"Official Title\":{\"description\":\"\",\"name\":\"Official Title\",\"type\":\"title\"},\"Publication Ready\":{\"description\":\"\",\"name\":\"Publication Ready\",\"type\":\"checkbox\"},\"Related Historical Documents\":{\"description\":\"\",\"name\":\"Related Historical Documents\",\"type\":\"text\"},\"Source Of Truth\":{\"description\":\"\",\"name\":\"Source Of Truth\",\"type\":\"checkbox\"},\"Superseded Documents\":{\"description\":\"\",\"name\":\"Superseded Documents\",\"type\":\"text\"},\"Translation Ready\":{\"description\":\"\",\"name\":\"Translation Ready\",\"type\":\"checkbox\"},\"Website Ready\":{\"description\":\"\",\"name\":\"Website Ready\",\"type\":\"checkbox\"},\"userDefined:ID\":{\"description\":\"\",\"name\":\"ID\",\"type\":\"text\"}},\"url\":\"collection://222880e9-4ec5-448c-a5e3-7522761de535\"}
</data-source-state>
Here is the SQLite table definition for this data source.
<sqlite-table>
CREATE TABLE IF NOT EXISTS \"collection://222880e9-4ec5-448c-a5e3-7522761de535\" (
\turl TEXT UNIQUE,
\tcreatedTime TEXT, -- ISO-8601 datetime string, automatically set. This is the canonical time for when the page was created.
\t\"Related Historical Documents\" TEXT,
\t\"Notes\" TEXT,
\t\"date:Last Significant Update:start\" TEXT, -- ISO-8601 date or datetime string. Use the expanded property (date:<column_name>:start) to set this value.
\t\"date:Last Significant Update:end\" TEXT, -- ISO-8601 date or datetime string, can be empty. Must be NULL if the date is a single date, and must be present if the date is a range. Use the expanded property (date:<column_name>:end) to set this value.
\t\"date:Last Significant Update:is_datetime\" INTEGER, -- 1 if the date is a datetime, 0 if it is a date, NULL defaults to 0. Use the expanded property (date:<column_name>:is_datetime) to set this value.
\t\"Locked Status\" TEXT, -- \"__YES__\" = true, \"__NO__\" = false, NULL defaults to false
\t\"Website Ready\" TEXT, -- \"__YES__\" = true, \"__NO__\" = false, NULL defaults to false
\t\"Current Status\" TEXT, -- one of [\"Locked\", \"Pending\", \"Missing\", \"Draft\", \"Active\"]
\t\"Source Of Truth\" TEXT, -- \"__YES__\" = true, \"__NO__\" = false, NULL defaults to false
\t\"Layer\" TEXT, -- one of [\"Layer 1 — Constitutional\", \"Layer 2 — Charter\", \"Layer 3 — Governance\", \"Layer 4 — Identity\", \"Layer 5 — Brand\", \"Layer 6 — Reference\", \"Layer 7 — Website\", \"Layer 8 — Knowledge\", \"Layer 9 — Translation\", \"Layer 10 — Media\", \"Locked Articles Registry\", \"Missing Content Registry\"]
\t\"Translation Ready\" TEXT, -- \"__YES__\" = true, \"__NO__\" = false, NULL defaults to false
\t\"Official Link\" TEXT,
\t\"Superseded Documents\" TEXT,
\t\"userDefined:ID\" TEXT,
\t\"Current Version\" TEXT,
\t\"Publication Ready\" TEXT, -- \"__YES__\" = true, \"__NO__\" = false, NULL defaults to false
\t\"Official Title\" TEXT
)
</sqlite-table>
</data-source>
</data-sources>
Here are the Database's Views:
You can use the \"view\" tool on the URL of any View to see its full configuration.
<views>
<view url=\"{{view://5a939533-6db8-4123-8649-5afcb24d09ae}}\">
{\"dataSourceUrl\":\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\",\"displayProperties\":[\"Official Title\",\"userDefined:ID\",\"Layer\",\"Current Version\",\"Current Status\",\"Locked Status\",\"Source Of Truth\",\"Website Ready\",\"Translation Ready\",\"Publication Ready\",\"Official Link\",\"Last Significant Update\",\"Notes\",\"Related Historical Documents\",\"Superseded Documents\"],\"name\":\"All Sources\",\"type\":\"table\"}
</view>
<view url=\"{{view://464931b6-6ce2-44da-9d01-b46e959aa736}}\">
{\"cardLayoutMode\":\"default\",\"dataSourceUrl\":\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\",\"displayProperties\":[\"Official Title\",\"userDefined:ID\",\"Current Version\",\"Current Status\",\"Locked Status\",\"Source Of Truth\"],\"fullWidthProperties\":[],\"groupBy\":{\"property\":\"Layer\",\"propertyType\":\"select\",\"sort\":{\"type\":\"manual\"}},\"name\":\"By Layer\",\"type\":\"board\"}
</view>
<view url=\"{{view://91e36c59-8e0a-4973-8804-4dec3458ed48}}\">
{\"advancedFilter\":{\"filters\":[{\"operator\":\"checkbox_is\",\"property\":\"Source Of Truth\",\"propertyType\":\"checkbox\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":true}},{\"operator\":\"checkbox_is\",\"property\":\"Website Ready\",\"propertyType\":\"checkbox\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":true}}],\"operator\":\"and\",\"type\":\"group\"},\"dataSourceUrl\":\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\",\"displayProperties\":[\"Official Title\",\"userDefined:ID\",\"Layer\",\"Current Version\",\"Current Status\",\"Locked Status\",\"Source Of Truth\",\"Website Ready\",\"Official Link\",\"Last Significant Update\",\"Notes\",\"Publication Ready\",\"Related Historical Documents\",\"Superseded Documents\",\"Translation Ready\"],\"name\":\"Website Approved Source Registry v1.0\",\"type\":\"table\"}
</view>
<view url=\"{{view://363af5c6-7aa3-4d78-bdbb-fdf409b22e10}}\">
{\"advancedFilter\":{\"filters\":[{\"operator\":\"checkbox_is\",\"property\":\"Source Of Truth\",\"propertyType\":\"checkbox\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":true}},{\"operator\":\"checkbox_is\",\"property\":\"Translation Ready\",\"propertyType\":\"checkbox\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":true}}],\"operator\":\"and\",\"type\":\"group\"},\"dataSourceUrl\":\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\",\"displayProperties\":[\"Official Title\",\"userDefined:ID\",\"Layer\",\"Current Version\",\"Current Status\",\"Locked Status\",\"Source Of Truth\",\"Translation Ready\",\"Official Link\",\"Last Significant Update\",\"Notes\",\"Publication Ready\",\"Related Historical Documents\",\"Superseded Documents\",\"Website Ready\"],\"name\":\"Translation Approved Source Registry v1.0\",\"type\":\"table\"}
</view>
<view url=\"{{view://22498266-f98f-48e5-acf0-53ffbb1a3784}}\">
{\"advancedFilter\":{\"filters\":[{\"operator\":\"enum_is\",\"property\":\"Current Status\",\"propertyType\":\"select\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":\"Missing\"}},{\"operator\":\"enum_is\",\"property\":\"Current Status\",\"propertyType\":\"select\",\"type\":\"property\",\"value\":{\"type\":\"exact\",\"value\":\"Pending\"}}],\"operator\":\"or\",\"type\":\"group\"},\"dataSourceUrl\":\"{{collection://222880e9-4ec5-448c-a5e3-7522761de535}}\",\"displayProperties\":[\"Official Title\",\"userDefined:ID\",\"Layer\",\"Current Version\",\"Current Status\",\"Locked Status\",\"Source Of Truth\",\"Official Link\",\"Notes\",\"Last Significant Update\",\"Publication Ready\",\"Related Historical Documents\",\"Superseded Documents\",\"Translation Ready\",\"Website Ready\"],\"name\":\"Missing Content Registry v1.0\",\"type\":\"table\"}
</view>
</views>
</database>"}