CREATE TABLE <database_name>.<schema_name>.ELEMENTS (
ID VARCHAR(36) PRIMARY KEY NOT NULL DEFAULT UUID_STRING(),
RECORD_ID VARCHAR,
ELEMENT_ID VARCHAR,
TEXT VARCHAR,
EMBEDDINGS VECTOR(FLOAT, <number-of-dimensions>),
TYPE VARCHAR,
SYSTEM VARCHAR,
LAYOUT_WIDTH DECIMAL,
LAYOUT_HEIGHT DECIMAL,
POINTS VARCHAR,
URL VARCHAR,
VERSION VARCHAR,
DATE_CREATED TIMESTAMP_TZ,
DATE_MODIFIED TIMESTAMP_TZ,
DATE_PROCESSED TIMESTAMP_TZ,
PERMISSIONS_DATA VARCHAR,
RECORD_LOCATOR VARCHAR,
CATEGORY_DEPTH INTEGER,
PARENT_ID VARCHAR,
ATTACHED_FILENAME VARCHAR,
FILETYPE VARCHAR,
LAST_MODIFIED TIMESTAMP_TZ,
FILE_DIRECTORY VARCHAR,
FILENAME VARCHAR,
LANGUAGES ARRAY,
PAGE_NUMBER VARCHAR,
LINKS VARCHAR,
PAGE_NAME VARCHAR,
LINK_URLS ARRAY,
LINK_TEXTS ARRAY,
SENT_FROM ARRAY,
SENT_TO ARRAY,
SUBJECT VARCHAR,
SECTION VARCHAR,
HEADER_FOOTER_TYPE VARCHAR,
EMPHASIZED_TEXT_CONTENTS ARRAY,
EMPHASIZED_TEXT_TAGS ARRAY,
TEXT_AS_HTML VARCHAR,
REGEX_METADATA VARCHAR,
DETECTION_CLASS_PROB DECIMAL,
IMAGE_BASE64 VARCHAR,
IMAGE_MIME_TYPE VARCHAR,
ORIG_ELEMENTS VARCHAR,
IS_CONTINUATION BOOLEAN
);
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4