Schema - Product (shared drive)

Filter ONLY on the fields listed here. Do NOT invent fields, entities, or enum values.

COMMENTS (4 rows, label field: ID)

• AUTHOR (string)
• CREATED (date)
• FILE_ID (string)
• ID (string)
• QUOTED_TEXT (string)
• RESOLVED (string)
• TEXT (string)
• relation: FILE_ID references FILES

DRIVES (1 rows, label field: NAME)

• CREATED (date)
• DRIVE_KIND (string)
• ID (string)
• NAME (string)

FILES (20 rows, label field: NAME)

• CONTENT_HASH (string)
• CREATED (date)
• DEPTH (integer)
• DRIVE_ID (string)
• EXTRACT_STATUS (string) - one of: exported_no_size, extracted, not_applicable, unsupported_type
• ID (string)
• IS_FOLDER (string) - one of: no, yes
• ITEM_KIND (string) - one of: document, folder, image, pdf, spreadsheet
• LINK_VISIBILITY (string) - one of: anyone_with_link, domain
• MIME_TYPE (string) - one of: application/pdf, application/vnd.google-apps.document, application/vnd.google-apps.folder, application/vnd.google-apps.spreadsheet, image/png
• MODIFIED (date)
• MODIFIED_BY (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com, dana@vendor.io
• NAME (string)
• NAME_IS_UNIQUE (string)
• OWNER_EMAIL (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com
• PARENT_ID (string)
• PATH (string)
• SECTION_COUNT (integer)
• SHARED_EXTERNALLY (string) - one of: no, yes
• SIZE_BYTES (integer)
• STARRED (string) - one of: no, yes
• TRASHED (string) - one of: no, yes
• WEB_VIEW_LINK (string)
• WORD_COUNT (integer)
• relation: DRIVE_ID references DRIVES
• SOURCE DEFAULT: TRASHED IS "no" is applied unless you filter TRASHED explicitly

LABELS (4 rows, label field: FILE_ID)

• FILE_ID (string)
• LABEL (string)
• VALUE (string)
• relation: FILE_ID references FILES

LINKS (4 rows, label field: SRC_FILE_ID)

• DST_FILE_ID (string)
• LINK_TYPE (string)
• SRC_FILE_ID (string)

PERMISSIONS (31 rows, label field: FILE_ID)

• FILE_ID (string)
• INHERITED (string) - one of: no, yes
• PRINCIPAL (string) - one of: acme.com, alice@acme.com, anyone, bob@acme.com, carol@acme.com, dana@vendor.io, eng@acme.com
• PRINCIPAL_TYPE (string) - one of: anyone, domain, group, user
• ROLE (string) - one of: commenter, organizer, owner, reader, writer
• relation: FILE_ID references FILES
• relation: PRINCIPAL references PRINCIPALS

PRINCIPALS (7 rows, label field: ID)

• DOMAIN (string) - one of: *, acme.com, vendor.io
• ID (string)
• PRINCIPAL_TYPE (string)

REVISIONS (8 rows, label field: ID)

• FILE_ID (string)
• ID (string)
• MODIFIED (date)
• MODIFIED_BY (string) - one of: alice@acme.com, bob@acme.com, carol@acme.com
• REVISION_ID (string)
• SIZE_BYTES (integer)
• relation: FILE_ID references FILES

SECTIONS (36 rows, label field: ID)

• CHAR_END (integer)
• CHAR_START (integer)
• FILE_ID (string)
• HEADING (string)
• ID (string)
• LEVEL (integer)
• SECTION_INDEX (integer)
• TEXT (string)
• WORD_COUNT (integer)
• relation: FILE_ID references FILES