Schema Info
Schema Name: sfdl_stage_mongo.storedge_voyager_pagelayouts
- created: 2019-03-19 17:07:02
- disabled: False
- format: raw
- id: 793
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_mongo", "table": "storedge_voyager_pagelayouts" } - type: mongo
Schema Versions: 3
-
Version 380510
- created: 2022-02-02 22:18:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`", "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pagelayouts`\n(\n`metadata`struct<`locale`:STRING,`pageType`:STRING,`_id`:struct<`_oid`:STRING>>,`companyId`STRING,`localeCode`STRING,`_id`struct<`_oid`:STRING>,`siteId`struct<`_oid`:STRING>,`live`STRING,`versions`array>,`directionMap`:struct<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array ,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`nativelyRenderedContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array - hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-02-02/1643861836
- id: 380510
- processed: 1
- raw_data:
{ "__v": 5, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-06-22T22:29:45.968Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5ef14522a2e1130048e47e36" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "b9a49c3b-a5a1-476d-abdb-31e8218adf43", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef983" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc6d" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "e5tt6", "text": "Call Now: (505) 933-7288 ", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "db2mm", "text": "Call Now(270)776-9376", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "tel:+19252906185 ", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "(865) 635-4579
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2020-06-22T22:29:45.967Z" } }, "siteId": { "_oid": "581a3a647a58c597e2d57829" }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-06-22T22:29:45.968Z" }, "versions": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97b" }, "createdAt": { "_date": "2018-07-10T13:12:50.346Z" }, "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97c" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc68" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "otherImages": [ { "alt": "Hoosier Storage Office", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-28-am.png" }, { "alt": "Boxes & Supplies Available at Hoosier Storage in Noblesville, IN", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-40-am.png" }, {}, {} ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "Call Now: (505) 933-7288
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2018-07-10T13:12:50.346Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "siteId._oid": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 793
- schema_scan_id: 3678024
- updated: 2022-02-02 22:18:56
-
Version 380340
- created: 2022-02-01 22:17:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`", "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pagelayouts`\n(\n`metadata`struct<`locale`:STRING,`pageType`:STRING,`_id`:struct<`_oid`:STRING>>,`companyId`STRING,`localeCode`STRING,`_id`struct<`_oid`:STRING>,`siteId`struct<`_oid`:STRING>,`live`STRING,`boilerplate`STRING,`typeId`struct<`_oid`:STRING>,`createdAt`struct<`_date`:STRING>,`title`STRING,`publishedVersion`struct<`tag`:STRING,`createdAt`:STRING,`id`:STRING,`_id`:struct<`_oid`:STRING>,`updatedAt`:struct<`_date`:STRING>,`sections`:array,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`nativelyRenderedContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >,`directionMap`:struct<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array - hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-02-01/1643775406
- id: 380340
- processed: 1
- raw_data:
{ "__v": 5, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-06-22T22:29:45.968Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5ef14522a2e1130048e47e36" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "b9a49c3b-a5a1-476d-abdb-31e8218adf43", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef983" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc6d" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "e5tt6", "text": "Call Now: (505) 933-7288 ", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "db2mm", "text": "Call Now(270)776-9376", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "tel:+19252906185 ", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "(865) 635-4579
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2020-06-22T22:29:45.967Z" } }, "siteId": { "_oid": "581a3a647a58c597e2d57829" }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-06-22T22:29:45.968Z" }, "versions": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97b" }, "createdAt": { "_date": "2018-07-10T13:12:50.346Z" }, "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97c" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc68" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "otherImages": [ { "alt": "Hoosier Storage Office", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-28-am.png" }, { "alt": "Boxes & Supplies Available at Hoosier Storage in Noblesville, IN", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-40-am.png" }, {}, {} ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "Call Now: (505) 933-7288
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2018-07-10T13:12:50.346Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "siteId._oid": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 793
- schema_scan_id: 3676414
- updated: 2022-02-01 22:17:56
-
Version 380173
- created: 2022-01-31 22:19:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`", "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pagelayouts`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pagelayouts`\n(\n`metadata`struct<`locale`:STRING,`pageType`:STRING,`_id`:struct<`_oid`:STRING>>,`companyId`STRING,`localeCode`STRING,`_id`struct<`_oid`:STRING>,`siteId`struct<`_oid`:STRING>,`live`STRING,`versions`array>,`directionMap`:struct<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array ,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`nativelyRenderedContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array - hive_path: s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-01-31/1643689058
- id: 380173
- processed: 1
- raw_data:
{ "__v": 5, "_id": { "_oid": "592ecb7ba1dce915c661fafc" }, "boilerplate": false, "companyId": "8b27fc5d-ed61-493f-89f4-45b8f4bcdabc", "createdAt": { "_date": "2020-06-22T22:29:45.968Z" }, "live": false, "localeCode": "en-us", "metadata": { "_id": { "_oid": "5de668a7456a960046f9541a" }, "locale": "en-us", "pageType": "voyager/pages/types/SM_COUNTRY_PAGE" }, "publishedVersion": { "_id": { "_oid": "5ef14522a2e1130048e47e36" }, "createdAt": "2020-01-28T13:51:38.591Z", "id": "b9a49c3b-a5a1-476d-abdb-31e8218adf43", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef983" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc6d" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "e5tt6", "text": "Call Now: (505) 933-7288 ", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "db2mm", "text": "Call Now(270)776-9376", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "tel:+19252906185 ", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "(865) 635-4579
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2020-06-22T22:29:45.967Z" } }, "siteId": { "_oid": "581a3a647a58c597e2d57829" }, "title": "Global", "typeId": { "_oid": "5e39775169acaf00442dc854" }, "updatedAt": { "_date": "2020-06-22T22:29:45.968Z" }, "versions": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97b" }, "createdAt": { "_date": "2018-07-10T13:12:50.346Z" }, "id": "70027bab-60f9-40f2-9e8b-b1b2518ff83d", "sections": [ { "_id": { "_oid": "5ef130d9a2e11300486ef97c" }, "data": null, "id": "d2534ac4-bd1c-400b-aa3a-833398cface9", "payload": null, "type": "PreheaderTwoWidgets", "widgets": [ { "_id": { "_oid": "5ef130daa2e11300486efc68" }, "componentId": "850b43a8-06f2-46fb-a84b-b1a04a1a1303", "id": "8f61d56a-873f-4088-bafd-30203c4dfbb8", "payload": { "editorState": { "_immutable": { "allowUndo": true, "currentContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "decorator": { "_decorators": [ null, null, null ] }, "directionMap": { "80s8c": "LTR" }, "forceSelection": false, "inCompositionMode": false, "inlineStyleOverride": null, "lastChangeType": "insert-characters", "nativelyRenderedContent": { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "(865) 635-4579", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false } }, "redoStack": [], "selection": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 14, "hasFocus": true, "isBackward": false }, "treeMap": { "80s8c": [ { "decoratorKey": null, "end": 14, "leaves": [ { "end": 14, "start": 0 } ], "start": 0 } ] }, "undoStack": [ { "blockMap": { "80s8c": { "characterList": [], "depth": 0, "key": "80s8c", "text": "", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 2, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 14, "focusKey": "80s8c", "focusOffset": 2, "hasFocus": true, "isBackward": true } }, { "blockMap": { "80s8c": { "characterList": [ { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] }, { "entity": null, "style": [] } ], "depth": 0, "key": "80s8c", "text": "1-800-555-5555", "type": "header-two" } }, "selectionAfter": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false }, "selectionBefore": { "anchorKey": "80s8c", "anchorOffset": 0, "focusKey": "80s8c", "focusOffset": 0, "hasFocus": false, "isBackward": false } } ] } }, "href": "https://rental-center.storedge.com/?companyId=37daa893-f5e6-4298-80c1-8869ae33f6fd&facilityId=de3593e5-7081-44f0-8df8-feccc2a6deea#/login", "images": [ { "alt": "11E Storage", "file": "4a6e4eb5-d2c1-4d64-b899-14ba5478e8d8/11e-storage-web-logo-6.png", "link": "http://www.11estorage.com", "mediumId": "6176af31fa00d0064cb37b92", "target": "_self", "title": "Logo" } ], "otherImages": [ { "alt": "Hoosier Storage Office", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-28-am.png" }, { "alt": "Boxes & Supplies Available at Hoosier Storage in Noblesville, IN", "file": "9957ed71-1a0f-4a37-b0a5-cb18c89c333f/screen-shot-2017-08-16-at-11-38-40-am.png" }, {}, {} ], "rawContent": { "blocks": [ { "data": { "text-align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 8, "offset": 18 } ], "inlineStyleRanges": [], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "replacement": "phone", "target": "_self", "url": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418" }, "mutability": "MUTABLE", "type": "LINK" } } }, "rawContentState": { "blocks": [ { "data": { "align": "right" }, "depth": 0, "entityRanges": [ { "key": 0, "length": 14, "offset": 11 } ], "inlineStyleRanges": [ { "length": 21, "offset": 0, "style": "FONT_SIZE:24" } ], "key": "6i9h3", "text": "(864) 412-0876", "type": "header-two" } ], "entityMap": { "0": { "data": { "href": "https://www.meehanstorage.com/400-katy-boulevard-bonham-tx-75418", "key": "phone", "target": "_self", "url": "https://www.storagecourt.com/covid-19-info-current-clients" }, "mutability": "MUTABLE", "type": "LINK" }, "1": { "data": { "href": "https://valet.rightawaystorage.com", "target": "_blank", "url": "mailto:[email protected]" }, "mutability": "MUTABLE", "type": "LINK" } } }, "target": "_blank", "text": "Call Now: (505) 933-7288
\n" }, "type": "HeaderText" } ] } ], "styles": null, "updatedAt": { "_date": "2018-07-10T13:12:50.346Z" } } ] } - schema_attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "siteId._oid": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - schema_name_id: 793
- schema_scan_id: 3674826
- updated: 2022-01-31 22:19:57
Schema Scans: 3
Last at 2022-02-02 22:17:48
-
Scan 3678024
- duration: 0:01:10.997807
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3678024
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-stage", "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-02-02/1643861836", "key": "raw/voyager_pagelayouts/2022-02-02/1643861836/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_stage_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 8716942820440944740, "service_name": "preloading", "span_id": 9239084881812494029, "trace_id": 15473495614570736574 } } - running: False
- schema_name_id: 793
- start_time: 2022-02-02 22:17:48
- success: True
- trace_id: 15473495614570736574
-
Scan 3676414
- duration: 0:01:11.382396
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3676414
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-stage", "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-02-01/1643775406", "key": "raw/voyager_pagelayouts/2022-02-01/1643775406/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_stage_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 2746640426539185550, "service_name": "preloading", "span_id": 9073068043878974213, "trace_id": 10644481336303180200 } } - running: False
- schema_name_id: 793
- start_time: 2022-02-01 22:16:48
- success: True
- trace_id: 10644481336303180200
-
Scan 3674826
- duration: 0:01:09.351898
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 3674826
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-mongo-storedge-stage", "hive_path": "s3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-01-31/1643689058", "key": "raw/voyager_pagelayouts/2022-01-31/1643689058/pagelayouts_0.json.gz" }, "schema": { "name": "sfdl_stage_mongo.storedge_voyager_pagelayouts", "type": "mongo" }, "trace_context": { "parent_id": 6704591690746428743, "service_name": "preloading", "span_id": 3199253265939723000, "trace_id": 6206555519537656175 } } - running: False
- schema_name_id: 793
- start_time: 2022-01-31 22:18:50
- success: True
- trace_id: 6206555519537656175
- attributes:
{ "__v": "string", "_id._oid": "string", "boilerplate": "string", "companyId": "string", "createdAt._date": "string", "live": "string", "localeCode": "string", "metadata._id._oid": "string", "metadata.locale": "string", "metadata.pageType": "string", "publishedVersion._id._oid": "string", "publishedVersion.createdAt": "string", "publishedVersion.id": "string", "publishedVersion.sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "publishedVersion.styles": "string", "publishedVersion.tag": "string", "publishedVersion.updatedAt._date": "string", "siteId._oid": "string", "title": "string", "typeId._oid": "string", "updatedAt._date": "string", "versions": [ { "_id._oid": "string", "createdAt._date": "string", "id": "string", "sections": [ { "_id._oid": "string", "data": "string", "id": "string", "payload": "string", "type": "string", "widgets": [ { "_id._oid": "string", "componentId": "string", "id": "string", "payload.editorState._immutable.allowUndo": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.decorator._decorators": [ "string" ], "payload.editorState._immutable.directionMap.80s8c": "string", "payload.editorState._immutable.forceSelection": "string", "payload.editorState._immutable.inCompositionMode": "string", "payload.editorState._immutable.inlineStyleOverride": "string", "payload.editorState._immutable.lastChangeType": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string", "payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string", "payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string", "payload.editorState._immutable.redoStack": [ "string" ], "payload.editorState._immutable.selection.anchorKey": "string", "payload.editorState._immutable.selection.anchorOffset": "string", "payload.editorState._immutable.selection.focusKey": "string", "payload.editorState._immutable.selection.focusOffset": "string", "payload.editorState._immutable.selection.hasFocus": "string", "payload.editorState._immutable.selection.isBackward": "string", "payload.editorState._immutable.treeMap.80s8c": [ { "decoratorKey": "string", "end": "string", "leaves": [ { "end": "string", "start": "string" } ], "start": "string" } ], "payload.editorState._immutable.undoStack": [ { "blockMap.80s8c.characterList": [ { "entity": "string", "style": [ "string" ] } ], "blockMap.80s8c.depth": "string", "blockMap.80s8c.key": "string", "blockMap.80s8c.text": "string", "blockMap.80s8c.type": "string", "selectionAfter.anchorKey": "string", "selectionAfter.anchorOffset": "string", "selectionAfter.focusKey": "string", "selectionAfter.focusOffset": "string", "selectionAfter.hasFocus": "string", "selectionAfter.isBackward": "string", "selectionBefore.anchorKey": "string", "selectionBefore.anchorOffset": "string", "selectionBefore.focusKey": "string", "selectionBefore.focusOffset": "string", "selectionBefore.hasFocus": "string", "selectionBefore.isBackward": "string" } ], "payload.href": "string", "payload.images": [ { "alt": "string", "file": "string", "link": "string", "mediumId": "string", "target": "string", "title": "string" } ], "payload.otherImages": [ { "alt": "string", "file": "string" } ], "payload.rawContent.blocks": [ { "data.text_align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ "string" ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContent.entityMap.0.data.replacement": "string", "payload.rawContent.entityMap.0.data.target": "string", "payload.rawContent.entityMap.0.data.url": "string", "payload.rawContent.entityMap.0.mutability": "string", "payload.rawContent.entityMap.0.type": "string", "payload.rawContentState.blocks": [ { "data.align": "string", "depth": "string", "entityRanges": [ { "key": "string", "length": "string", "offset": "string" } ], "inlineStyleRanges": [ { "length": "string", "offset": "string", "style": "string" } ], "key": "string", "text": "string", "type": "string" } ], "payload.rawContentState.entityMap.0.data.href": "string", "payload.rawContentState.entityMap.0.data.key": "string", "payload.rawContentState.entityMap.0.data.target": "string", "payload.rawContentState.entityMap.0.data.url": "string", "payload.rawContentState.entityMap.0.mutability": "string", "payload.rawContentState.entityMap.0.type": "string", "payload.rawContentState.entityMap.1.data.href": "string", "payload.rawContentState.entityMap.1.data.target": "string", "payload.rawContentState.entityMap.1.data.url": "string", "payload.rawContentState.entityMap.1.mutability": "string", "payload.rawContentState.entityMap.1.type": "string", "payload.target": "string", "payload.text": "string", "type": "string" } ] } ], "styles": "string", "updatedAt._date": "string" } ] } - created: 2022-02-02 22:18:45
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pagelayouts`\n(\n`metadata`struct<`locale`:STRING,`pageType`:STRING,`_id`:struct<`_oid`:STRING>>,`companyId`STRING,`localeCode`STRING,`_id`struct<`_oid`:STRING>,`siteId`struct<`_oid`:STRING>,`live`STRING,`versions`array>,`directionMap`:struct<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array ,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array ,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array ,`nativelyRenderedContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array >,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-03-19 17:07:02",
"disabled": false,
"format": "raw",
"id": 793,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_mongo",
"table": "storedge_voyager_pagelayouts"
},
"type": "mongo"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"__v": "string",
"_id._oid": "string",
"boilerplate": "string",
"companyId": "string",
"createdAt._date": "string",
"live": "string",
"localeCode": "string",
"metadata._id._oid": "string",
"metadata.locale": "string",
"metadata.pageType": "string",
"publishedVersion._id._oid": "string",
"publishedVersion.createdAt": "string",
"publishedVersion.id": "string",
"publishedVersion.sections": [
{
"_id._oid": "string",
"data": "string",
"id": "string",
"payload": "string",
"type": "string",
"widgets": [
{
"_id._oid": "string",
"componentId": "string",
"id": "string",
"payload.editorState._immutable.allowUndo": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string",
"payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string",
"payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string",
"payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string",
"payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string",
"payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string",
"payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string",
"payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string",
"payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string",
"payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string",
"payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string",
"payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string",
"payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string",
"payload.editorState._immutable.decorator._decorators": [
"string"
],
"payload.editorState._immutable.directionMap.80s8c": "string",
"payload.editorState._immutable.forceSelection": "string",
"payload.editorState._immutable.inCompositionMode": "string",
"payload.editorState._immutable.inlineStyleOverride": "string",
"payload.editorState._immutable.lastChangeType": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string",
"payload.editorState._immutable.redoStack": [
"string"
],
"payload.editorState._immutable.selection.anchorKey": "string",
"payload.editorState._immutable.selection.anchorOffset": "string",
"payload.editorState._immutable.selection.focusKey": "string",
"payload.editorState._immutable.selection.focusOffset": "string",
"payload.editorState._immutable.selection.hasFocus": "string",
"payload.editorState._immutable.selection.isBackward": "string",
"payload.editorState._immutable.treeMap.80s8c": [
{
"decoratorKey": "string",
"end": "string",
"leaves": [
{
"end": "string",
"start": "string"
}
],
"start": "string"
}
],
"payload.editorState._immutable.undoStack": [
{
"blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"blockMap.80s8c.depth": "string",
"blockMap.80s8c.key": "string",
"blockMap.80s8c.text": "string",
"blockMap.80s8c.type": "string",
"selectionAfter.anchorKey": "string",
"selectionAfter.anchorOffset": "string",
"selectionAfter.focusKey": "string",
"selectionAfter.focusOffset": "string",
"selectionAfter.hasFocus": "string",
"selectionAfter.isBackward": "string",
"selectionBefore.anchorKey": "string",
"selectionBefore.anchorOffset": "string",
"selectionBefore.focusKey": "string",
"selectionBefore.focusOffset": "string",
"selectionBefore.hasFocus": "string",
"selectionBefore.isBackward": "string"
}
],
"payload.href": "string",
"payload.images": [
{
"alt": "string",
"file": "string",
"link": "string",
"mediumId": "string",
"target": "string",
"title": "string"
}
],
"payload.rawContent.blocks": [
{
"data.text_align": "string",
"depth": "string",
"entityRanges": [
{
"key": "string",
"length": "string",
"offset": "string"
}
],
"inlineStyleRanges": [
"string"
],
"key": "string",
"text": "string",
"type": "string"
}
],
"payload.rawContent.entityMap.0.data.replacement": "string",
"payload.rawContent.entityMap.0.data.target": "string",
"payload.rawContent.entityMap.0.data.url": "string",
"payload.rawContent.entityMap.0.mutability": "string",
"payload.rawContent.entityMap.0.type": "string",
"payload.rawContentState.blocks": [
{
"data.align": "string",
"depth": "string",
"entityRanges": [
{
"key": "string",
"length": "string",
"offset": "string"
}
],
"inlineStyleRanges": [
{
"length": "string",
"offset": "string",
"style": "string"
}
],
"key": "string",
"text": "string",
"type": "string"
}
],
"payload.rawContentState.entityMap.0.data.href": "string",
"payload.rawContentState.entityMap.0.data.key": "string",
"payload.rawContentState.entityMap.0.data.target": "string",
"payload.rawContentState.entityMap.0.data.url": "string",
"payload.rawContentState.entityMap.0.mutability": "string",
"payload.rawContentState.entityMap.0.type": "string",
"payload.rawContentState.entityMap.1.data.href": "string",
"payload.rawContentState.entityMap.1.data.target": "string",
"payload.rawContentState.entityMap.1.data.url": "string",
"payload.rawContentState.entityMap.1.mutability": "string",
"payload.rawContentState.entityMap.1.type": "string",
"payload.target": "string",
"payload.text": "string",
"type": "string"
}
]
}
],
"publishedVersion.styles": "string",
"publishedVersion.tag": "string",
"publishedVersion.updatedAt._date": "string",
"siteId._oid": "string",
"title": "string",
"typeId._oid": "string",
"updatedAt._date": "string",
"versions": [
{
"_id._oid": "string",
"createdAt._date": "string",
"id": "string",
"sections": [
{
"_id._oid": "string",
"data": "string",
"id": "string",
"payload": "string",
"type": "string",
"widgets": [
{
"_id._oid": "string",
"componentId": "string",
"id": "string",
"payload.editorState._immutable.allowUndo": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"payload.editorState._immutable.currentContent.blockMap.80s8c.depth": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.key": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.text": "string",
"payload.editorState._immutable.currentContent.blockMap.80s8c.type": "string",
"payload.editorState._immutable.currentContent.selectionAfter.anchorKey": "string",
"payload.editorState._immutable.currentContent.selectionAfter.anchorOffset": "string",
"payload.editorState._immutable.currentContent.selectionAfter.focusKey": "string",
"payload.editorState._immutable.currentContent.selectionAfter.focusOffset": "string",
"payload.editorState._immutable.currentContent.selectionAfter.hasFocus": "string",
"payload.editorState._immutable.currentContent.selectionAfter.isBackward": "string",
"payload.editorState._immutable.currentContent.selectionBefore.anchorKey": "string",
"payload.editorState._immutable.currentContent.selectionBefore.anchorOffset": "string",
"payload.editorState._immutable.currentContent.selectionBefore.focusKey": "string",
"payload.editorState._immutable.currentContent.selectionBefore.focusOffset": "string",
"payload.editorState._immutable.currentContent.selectionBefore.hasFocus": "string",
"payload.editorState._immutable.currentContent.selectionBefore.isBackward": "string",
"payload.editorState._immutable.decorator._decorators": [
"string"
],
"payload.editorState._immutable.directionMap.80s8c": "string",
"payload.editorState._immutable.forceSelection": "string",
"payload.editorState._immutable.inCompositionMode": "string",
"payload.editorState._immutable.inlineStyleOverride": "string",
"payload.editorState._immutable.lastChangeType": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.depth": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.key": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.text": "string",
"payload.editorState._immutable.nativelyRenderedContent.blockMap.80s8c.type": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.anchorOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.focusOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.hasFocus": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionAfter.isBackward": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.anchorOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusKey": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.focusOffset": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.hasFocus": "string",
"payload.editorState._immutable.nativelyRenderedContent.selectionBefore.isBackward": "string",
"payload.editorState._immutable.redoStack": [
"string"
],
"payload.editorState._immutable.selection.anchorKey": "string",
"payload.editorState._immutable.selection.anchorOffset": "string",
"payload.editorState._immutable.selection.focusKey": "string",
"payload.editorState._immutable.selection.focusOffset": "string",
"payload.editorState._immutable.selection.hasFocus": "string",
"payload.editorState._immutable.selection.isBackward": "string",
"payload.editorState._immutable.treeMap.80s8c": [
{
"decoratorKey": "string",
"end": "string",
"leaves": [
{
"end": "string",
"start": "string"
}
],
"start": "string"
}
],
"payload.editorState._immutable.undoStack": [
{
"blockMap.80s8c.characterList": [
{
"entity": "string",
"style": [
"string"
]
}
],
"blockMap.80s8c.depth": "string",
"blockMap.80s8c.key": "string",
"blockMap.80s8c.text": "string",
"blockMap.80s8c.type": "string",
"selectionAfter.anchorKey": "string",
"selectionAfter.anchorOffset": "string",
"selectionAfter.focusKey": "string",
"selectionAfter.focusOffset": "string",
"selectionAfter.hasFocus": "string",
"selectionAfter.isBackward": "string",
"selectionBefore.anchorKey": "string",
"selectionBefore.anchorOffset": "string",
"selectionBefore.focusKey": "string",
"selectionBefore.focusOffset": "string",
"selectionBefore.hasFocus": "string",
"selectionBefore.isBackward": "string"
}
],
"payload.href": "string",
"payload.images": [
{
"alt": "string",
"file": "string",
"link": "string",
"mediumId": "string",
"target": "string",
"title": "string"
}
],
"payload.otherImages": [
{
"alt": "string",
"file": "string"
}
],
"payload.rawContent.blocks": [
{
"data.text_align": "string",
"depth": "string",
"entityRanges": [
{
"key": "string",
"length": "string",
"offset": "string"
}
],
"inlineStyleRanges": [
"string"
],
"key": "string",
"text": "string",
"type": "string"
}
],
"payload.rawContent.entityMap.0.data.replacement": "string",
"payload.rawContent.entityMap.0.data.target": "string",
"payload.rawContent.entityMap.0.data.url": "string",
"payload.rawContent.entityMap.0.mutability": "string",
"payload.rawContent.entityMap.0.type": "string",
"payload.rawContentState.blocks": [
{
"data.align": "string",
"depth": "string",
"entityRanges": [
{
"key": "string",
"length": "string",
"offset": "string"
}
],
"inlineStyleRanges": [
{
"length": "string",
"offset": "string",
"style": "string"
}
],
"key": "string",
"text": "string",
"type": "string"
}
],
"payload.rawContentState.entityMap.0.data.href": "string",
"payload.rawContentState.entityMap.0.data.key": "string",
"payload.rawContentState.entityMap.0.data.target": "string",
"payload.rawContentState.entityMap.0.data.url": "string",
"payload.rawContentState.entityMap.0.mutability": "string",
"payload.rawContentState.entityMap.0.type": "string",
"payload.rawContentState.entityMap.1.data.href": "string",
"payload.rawContentState.entityMap.1.data.target": "string",
"payload.rawContentState.entityMap.1.data.url": "string",
"payload.rawContentState.entityMap.1.mutability": "string",
"payload.rawContentState.entityMap.1.type": "string",
"payload.target": "string",
"payload.text": "string",
"type": "string"
}
]
}
],
"styles": "string",
"updatedAt._date": "string"
}
]
},
"created": "2022-02-02 22:18:45",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mongo`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mongo.storedge_voyager_pagelayouts`\n(\n`metadata`struct<`locale`:STRING,`pageType`:STRING,`_id`:struct<`_oid`:STRING>>,`companyId`STRING,`localeCode`STRING,`_id`struct<`_oid`:STRING>,`siteId`struct<`_oid`:STRING>,`live`STRING,`versions`array,`id`:STRING,`sections`:array,`id`:STRING,`widgets`:array>,`entityRanges`:array>,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`target`:STRING,`key`:STRING,`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`target`:STRING,`url`:STRING>>>>,`text`:STRING,`rawContent`:struct<`blocks`:array,`entityRanges`:array>,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`url`:STRING,`target`:STRING,`replacement`:STRING>>>>,`editorState`:struct<`_immutable`:struct<`allowUndo`:STRING,`currentContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`decorator`:struct<`_decorators`:array>,`directionMap`:struct<`80s8c`:STRING>,`forceSelection`:STRING,`inCompositionMode`:STRING,`inlineStyleOverride`:STRING,`lastChangeType`:STRING,`nativelyRenderedContent`:struct<`blockMap`:struct<`80s8c`:struct<`key`:STRING,`type`:STRING,`text`:STRING,`characterList`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>,`redoStack`:array,`selection`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`treeMap`:struct<`80s8c`:array>>>>,`undoStack`:array,`entity`:STRING>>,`depth`:STRING>>,`selectionBefore`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>,`selectionAfter`:struct<`anchorKey`:STRING,`anchorOffset`:STRING,`focusKey`:STRING,`focusOffset`:STRING,`isBackward`:STRING,`hasFocus`:STRING>>>>>,`otherImages`:array>,`href`:STRING,`images`:array>,`target`:STRING>,`componentId`:STRING,`_id`:struct<`_oid`:STRING>>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`createdAt`:struct<`_date`:STRING>,`updatedAt`:struct<`_date`:STRING>,`styles`:STRING>>,`typeId`struct<`_oid`:STRING>,`createdAt`struct<`_date`:STRING>,`title`STRING,`publishedVersion`struct<`updatedAt`:struct<`_date`:STRING>,`createdAt`:STRING,`id`:STRING,`_id`:struct<`_oid`:STRING>,`sections`:array,`id`:STRING,`widgets`:array>,`entityRanges`:array>,`data`:struct<`align`:STRING>>>,`entityMap`:struct<`0`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`target`:STRING,`key`:STRING,`url`:STRING>>,`1`:struct<`type`:STRING,`mutability`:STRING,`data`:struct<`href`:STRING,`target`:STRING,`url`:STRING>>>>,`rawContent`:struct<`blocks`:array>,`inlineStyleRanges`:array,`depth`:STRING,`type`:STRING,`text`:STRING,`key`:STRING,`data`:struct<`text_align`:STRING>>>,`entityMap`:struct<`0`:struct<`data`:struct<`target`:STRING,`url`:STRING,`replacement`:STRING>,`mutability`:STRING,`type`:STRING>>>,`text`:STRING,`editorState`:struct<`_immutable`:struct<`undoStack`:array,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>>,`treeMap`:struct<`80s8c`:array>,`decoratorKey`:STRING,`end`:STRING,`start`:STRING>>>,`selection`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`redoStack`:array,`nativelyRenderedContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`lastChangeType`:STRING,`inlineStyleOverride`:STRING,`inCompositionMode`:STRING,`forceSelection`:STRING,`directionMap`:struct<`80s8c`:STRING>,`decorator`:struct<`_decorators`:array>,`currentContent`:struct<`selectionAfter`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`selectionBefore`:struct<`hasFocus`:STRING,`isBackward`:STRING,`focusOffset`:STRING,`focusKey`:STRING,`anchorOffset`:STRING,`anchorKey`:STRING>,`blockMap`:struct<`80s8c`:struct<`depth`:STRING,`characterList`:array>>,`text`:STRING,`type`:STRING,`key`:STRING>>>,`allowUndo`:STRING>>,`href`:STRING,`images`:array>,`target`:STRING>,`componentId`:STRING,`_id`:struct<`_oid`:STRING>>>,`type`:STRING,`data`:STRING,`payload`:STRING>>,`tag`:STRING,`styles`:STRING>,`updatedAt`struct<`_date`:STRING>,`boilerplate`STRING,`__v`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-mongo-storedge-stage/raw/voyager_pagelayouts/2022-02-02/1643861836'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mongo.storedge_voyager_pagelayouts`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_mongo.storedge_voyager_pagelayouts"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}