NotionDatabaseProperties
This page supports schema for Notion Datatype NotionDatabaseProperties.
{
"additionalProperties": {
"properties": {
"checkbox": {
"properties": {},
"type": "object",
"x-label": {
"en": "checkbox",
"ko": "checkbox"
}
},
"created_by": {
"properties": {},
"type": "object",
"x-label": {
"en": "created_by",
"ko": "created_by"
}
},
"created_time": {
"properties": {},
"type": "object",
"x-label": {
"en": "created_time",
"ko": "created_time"
}
},
"date": {
"properties": {},
"type": "object",
"x-label": {
"en": "date",
"ko": "date"
}
},
"description": {
"type": "string",
"x-label": {
"en": "description",
"ko": "description"
}
},
"email": {
"properties": {},
"type": "object",
"x-label": {
"en": "email",
"ko": "email"
}
},
"files": {
"properties": {},
"type": "object",
"x-label": {
"en": "files",
"ko": "files"
}
},
"formula": {
"properties": {
"expression": {
"type": "string",
"x-label": {
"en": "expression",
"ko": "expression"
}
}
},
"required": [
"expression"
],
"type": "object",
"x-label": {
"en": "formula",
"ko": "formula"
}
},
"id": {
"type": "string",
"x-label": {
"en": "id",
"ko": "id"
}
},
"last_edited_by": {
"properties": {},
"type": "object",
"x-label": {
"en": "last_edited_by",
"ko": "last_edited_by"
}
},
"last_edited_time": {
"properties": {},
"type": "object",
"x-label": {
"en": "last_edited_time",
"ko": "last_edited_time"
}
},
"multi_select": {
"properties": {
"options": {
"items": {
"properties": {
"color": {
"x-dataType": "NotionTextColor",
"x-dataTypeVersion": "1.0.0",
"x-label": {
"en": "color",
"ko": "color"
}
},
"id": {
"type": "string",
"x-label": {
"en": "id",
"ko": "id"
}
},
"name": {
"type": "string",
"x-label": {
"en": "name",
"ko": "name"
}
}
},
"required": [
"name"
],
"type": "object",
"x-label": {
"en": "option",
"ko": "option"
}
},
"type": "array",
"x-label": {
"en": "options",
"ko": "options"
}
}
},
"required": [
"options"
],
"type": "object",
"x-label": {
"en": "multi_select",
"ko": "multi_select"
}
},
"name": {
"type": "string",
"x-label": {
"en": "name",
"ko": "name"
}
},
"number": {
"properties": {
"format": {
"enum": [
"argentine_peso",
"baht",
"australian_dollar",
"canadian_dollar",
"chilean_peso",
"colombian_peso",
"danish_krone",
"dirham",
"dollar",
"euro",
"forint",
"franc",
"hong_kong_dollar",
"koruna",
"krona",
"leu",
"lira",
"mexican_peso",
"new_taiwan_dollar",
"new_zealand_dollar",
"norwegian_krone",
"number",
"number_with_commas",
"percent",
"philippine_peso",
"pound",
"peruvian_sol",
"rand",
"real",
"ringgit",
"riyal",
"ruble",
"rupee",
"rupiah",
"shekel",
"singapore_dollar",
"uruguayan_peso",
"yen,",
"yuan",
"won",
"zloty"
],
"type": "string",
"x-label": {
"en": "format",
"ko": "format"
}
}
},
"required": [
"format"
],
"type": "object",
"x-label": {
"en": "number",
"ko": "number"
}
},
"people": {
"properties": {},
"type": "object",
"x-label": {
"en": "people",
"ko": "people"
}
},
"phone_number": {
"properties": {},
"type": "object",
"x-label": {
"en": "phone_number",
"ko": "phone_number"
}
},
"relation": {
"properties": {
"database_id": {
"format": "uuid",
"type": "string",
"x-label": {
"en": "relation",
"ko": "relation"
}
},
"synced_property_id": {
"type": "string",
"x-label": {
"en": "synced_property_id",
"ko": "synced_property_id"
}
},
"synced_property_name": {
"type": "string",
"x-label": {
"en": "synced_property_name",
"ko": "synced_property_name"
}
}
},
"required": [],
"type": "object",
"x-label": {
"en": "relation",
"ko": "relation"
}
},
"rich_text": {
"properties": {},
"type": "object",
"x-label": {
"en": "rich_text",
"ko": "rich_text"
}
},
"rollup": {
"properties": {
"function": {
"enum": [
"average",
"checked",
"count_per_group",
"count",
"count_values",
"date_range",
"earliest_date",
"empty",
"latest_date",
"max",
"median",
"min",
"not_empty",
"percent_checked",
"percent_empty",
"percent_not_empty",
"percent_per_group",
"percent_unchecked",
"range",
"unchecked",
"unique",
"show_original",
"show_unique",
"sum"
],
"type": "string",
"x-label": {
"en": "function",
"ko": "function"
}
},
"relation_property_id": {
"type": "string",
"x-label": {
"en": "relation_property_id",
"ko": "relation_property_id"
}
},
"relation_property_name": {
"type": "string",
"x-label": {
"en": "relation_property_name",
"ko": "relation_property_name"
}
},
"rollup_property_id": {
"type": "string",
"x-label": {
"en": "rollup_property_id",
"ko": "rollup_property_id"
}
},
"rollup_property_name": {
"type": "string",
"x-label": {
"en": "rollup_property_name",
"ko": "rollup_property_name"
}
}
},
"required": [],
"type": "object",
"x-label": {
"en": "rollup",
"ko": "rollup"
}
},
"select": {
"properties": {
"options": {
"items": {
"properties": {
"color": {
"x-dataType": "NotionTextColor",
"x-dataTypeVersion": "1.0.0",
"x-label": {
"en": "color",
"ko": "color"
}
},
"id": {
"type": "string",
"x-label": {
"en": "id",
"ko": "id"
}
},
"name": {
"type": "string",
"x-label": {
"en": "name",
"ko": "name"
}
}
},
"required": [],
"type": "object",
"x-label": {
"en": "option",
"ko": "option"
}
},
"type": "array",
"x-label": {
"en": "options",
"ko": "options"
}
}
},
"required": [
"options"
],
"type": "object",
"x-label": {
"en": "select",
"ko": "select"
}
},
"status": {
"properties": {
"groups": {
"items": {
"properties": {
"color": {
"x-dataType": "NotionTextColor",
"x-dataTypeVersion": "1.0.0",
"x-label": {
"en": "color",
"ko": "color"
}
},
"id": {
"type": "string",
"x-label": {
"en": "id",
"ko": "id"
}
},
"name": {
"type": "string",
"x-label": {
"en": "name",
"ko": "name"
}
},
"option_ids": {
"items": {
"type": "string"
},
"type": "array",
"x-label": {
"en": "option_ids",
"ko": "option_ids"
}
}
},
"required": [],
"type": "object",
"x-label": {
"en": "option",
"ko": "option"
}
},
"type": "array",
"x-label": {
"en": "options",
"ko": "options"
}
},
"options": {
"items": {
"properties": {
"color": {
"x-dataType": "NotionTextColor",
"x-dataTypeVersion": "1.0.0",
"x-label": {
"en": "color",
"ko": "color"
}
},
"id": {
"type": "string",
"x-label": {
"en": "id",
"ko": "id"
}
},
"name": {
"type": "string",
"x-label": {
"en": "name",
"ko": "name"
}
}
},
"required": [],
"type": "object",
"x-label": {
"en": "option",
"ko": "option"
}
},
"type": "array",
"x-label": {
"en": "options",
"ko": "options"
}
}
},
"required": [
"options",
"groups"
],
"type": "object",
"x-label": {
"en": "status",
"ko": "status"
}
},
"title": {
"properties": {},
"type": "object",
"x-label": {
"en": "title",
"ko": "title"
}
},
"type": {
"enum": [
"checkbox",
"created_by",
"created_time",
"date",
"email",
"files",
"formula",
"last_edited_by",
"last_edited_time",
"multi_select",
"number",
"people",
"phone_number",
"relation",
"rich_text",
"rollup",
"select",
"status",
"title",
"url"
],
"type": "string",
"x-label": {
"en": "type",
"ko": "type"
}
},
"url": {
"properties": {},
"type": "object",
"x-label": {
"en": "url",
"ko": "url"
}
}
},
"required": [],
"type": "object"
},
"type": "object"
}
Helpful?