> For the complete documentation index, see [llms.txt](https://docs.cogram.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cogram.com/organization-administration/data-export-field-reference.md). # Data export field reference Every field of every JSON file in a Cogram Data Export, with the data it comes from, and the data that never leaves Cogram. This page lists, for every kind of record in a [Data Export](/organization-administration/data-exports.md), the fields its JSON carries and the stored data that is deliberately not exported. Where each file sits in the zip is on the [package layout](/organization-administration/data-export-package-layout.md) page. The page is generated from the export's own coverage registry, which Cogram's tests check against the database schema, so it is complete: a column that is not listed as a field here is listed as not exported, with the reason. Field types are JSON types: `string`, `number`, `boolean`, `object`, `null` where a value is missing, `datetime` and `date` for ISO-8601 strings, and the name of another record type where a field holds one of those records (or a list of them). ## Organization (`organizations`) | Field | Type | From | | ------------- | ------------------------ | -------------------- | | `id` | `string` | column `id` | | `name` | `string` or `null` | column `name` | | `domains` | `list[string]` or `null` | column `domains` | | `hq_address` | `string` or `null` | column `hq_address` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------------------------ | -------------------------------------------- | | `available_email_retention_rulesets` | templates, styling or settings; out of scope | | `creation_source` | internal worker, bot, upload or sync state | | `invited_by_org_id` | internal worker, bot, upload or sync state | | `is_self_serve` | billing or licensing, not customer data | | `mcp_rate_limit_rpm` | billing or licensing, not customer data | | `name_is_generated` | internal worker, bot, upload or sync state | | `org_settings` | templates, styling or settings; out of scope | | `organization_logo_public_height` | templates, styling or settings; out of scope | | `organization_logo_public_url` | templates, styling or settings; out of scope | | `organization_logo_public_width` | templates, styling or settings; out of scope | | `organization_logo_s3_key` | templates, styling or settings; out of scope | | `tenancy` | internal worker, bot, upload or sync state | ## User (`users`) | Field | Type | From | | ------- | ------------------ | --------------------------------- | | `id` | `string` | column `id` | | `name` | `string` | columns `first_name`, `last_name` | | `email` | `string` | column `email` | | `role` | `string` or `null` | derived | Not exported: | Column | Reason | | ---------------------- | --------------------------------------------------------- | | `banned_until` | access control or automation config; out of scope | | `bio` | users.json carries identity only: id, name, email, role | | `created_at` | users.json carries identity only: id, name, email, role | | `email_confirmed_at` | internal worker, bot, upload or sync state | | `invitation_sent_at` | internal worker, bot, upload or sync state | | `is_pending_since` | internal worker, bot, upload or sync state | | `is_sso_user` | access control or automation config; out of scope | | `job_title` | users.json carries identity only: id, name, email, role | | `last_activity_at` | internal worker, bot, upload or sync state | | `last_sign_in_at` | internal worker, bot, upload or sync state | | `location` | users.json carries identity only: id, name, email, role | | `modified_at` | users.json carries identity only: id, name, email, role | | `ms_user_id` | integration sync bookkeeping (Procore, Microsoft, Unanet) | | `organization_id` | organization\_id; implied by the export scope | | `phone_number` | users.json carries identity only: id, name, email, role | | `profile_photo_s3_key` | users.json carries identity only: id, name, email, role | | `raw_user_meta_data` | internal worker, bot, upload or sync state | | `sso_exempt` | access control or automation config; out of scope | | `tours_state` | templates, styling or settings; out of scope | | `user_settings` | templates, styling or settings; out of scope | ## UserRole (`user_roles`) Ships as the `.eml` file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts: * `role` Not exported: | Column | Reason | | ------------- | ------------------------------------------------------------------ | | `created_at` | join row; the recipient is identified and timestamped by its party | | `modified_at` | join row; the recipient is identified and timestamped by its party | | `user_id` | parent reference; implied by the file's place in the zip | ## Company (`companies`) | Field | Type | From | | --------------- | ------------------------ | ---------------------- | | `id` | `string` | column `id` | | `name` | `string` | column `name` | | `aliases` | `list[string]` or `null` | column `aliases` | | `email_domains` | `list[string]` or `null` | column `email_domains` | | `website` | `string` or `null` | column `website` | | `phone` | `string` or `null` | column `phone` | | `address` | `string` or `null` | column `address` | | `description` | `string` or `null` | column `description` | | `types` | `list[string]` or `null` | column `types` | | `disciplines` | `list[string]` or `null` | column `disciplines` | | `is_own_firm` | `boolean` | column `is_own_firm` | | `source` | `string` | column `source` | | `archived_at` | `datetime` or `null` | column `archived_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | ## Contact (`contacts`) | Field | Type | From | | ------------------- | ------------------------ | -------------------------- | | `id` | `string` | column `id` | | `primary_email` | `string` | column `primary_email` | | `additional_emails` | `list[string]` or `null` | column `additional_emails` | | `first_name` | `string` or `null` | column `first_name` | | `last_name` | `string` or `null` | column `last_name` | | `title` | `string` or `null` | column `title` | | `company_id` | `string` or `null` | column `company_id` | | `phone` | `string` or `null` | column `phone` | | `mobile_phone` | `string` or `null` | column `mobile_phone` | | `address` | `string` or `null` | column `address` | | `discipline` | `string` or `null` | column `discipline` | | `is_employee` | `boolean` or `null` | column `is_employee` | | `linked_user_id` | `string` or `null` | column `linked_user_id` | | `source` | `string` | column `source` | | `archived_at` | `datetime` or `null` | column `archived_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | ## ProjectCompany (`project_companies`) | Field | Type | From | | ------------------------- | -------------------- | -------------------------------- | | `id` | `string` | column `id` | | `company_id` | `string` | column `company_id` | | `project_function` | `string` or `null` | column `project_function` | | `is_primary_for_function` | `boolean` | column `is_primary_for_function` | | `joined_at` | `datetime` or `null` | column `joined_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | ## ProjectContact (`project_contacts`) | Field | Type | From | | -------------------- | -------------------- | --------------------------- | | `id` | `string` | column `id` | | `contact_id` | `string` | column `contact_id` | | `project_company_id` | `string` or `null` | column `project_company_id` | | `project_function` | `string` or `null` | column `project_function` | | `joined_at` | `datetime` or `null` | column `joined_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | -------------------------- | -------------------------------------------------------- | | `notification_preferences` | templates, styling or settings; out of scope | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | ## Project (`projects`) | Field | Type | From | | ------------------------ | ------------------------ | ------------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `creator_id` | `string` or `null` | column `creator_id` | | `name` | `string` | column `name` | | `description` | `string` or `null` | column `description` | | `archived_at` | `datetime` or `null` | column `archived_at` | | `source` | `string` | column `source` | | `asset_visibility` | `string` or `null` | column `asset_visibility` | | `is_public` | `boolean` | column `is_public` | | `is_dummy` | `boolean` | column `is_dummy` | | `is_personal` | `boolean` | column `is_personal` | | `email_filing_enabled` | `boolean` | column `email_filing_enabled` | | `board_auto_apply_mode` | `string` | column `board_auto_apply_mode` | | `customer_project_id` | `string` or `null` | column `customer_project_id` | | `client_name` | `string` or `null` | column `client_name` | | `project_address` | `string` or `null` | column `project_address` | | `project_type` | `_LookupRef` or `null` | columns `project_type_id` | | `unanet_project_id` | `string` or `null` | column `unanet_project_id` | | `unanet_lead_stage` | `string` or `null` | column `unanet_lead_stage` | | `unanet_custom_fields` | `object` or `null` | column `unanet_custom_fields` | | `unanet_market_sectors` | `list[object]` or `null` | column `unanet_market_sectors` | | `meta` | `object` or `null` | column `meta` | | `stage` | `_LookupRef` or `null` | columns `stage_id` | | `client_company_id` | `string` or `null` | column `client_company_id` | | `meeting_filing_enabled` | `boolean` | column `meeting_filing_enabled` | | `chat_enabled` | `boolean` | column `chat_enabled` | | `rfi_review_days` | `number` | column `rfi_review_days` | | `submittal_review_days` | `number` | column `submittal_review_days` | | `firm_role` | `string` or `null` | column `firm_role` | | `cover_image_filename` | `string` or `null` | columns `image_s3_key` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | --------------------- | --------------------------------------------------------- | | `default_auto_assign` | access control or automation config; out of scope | | `procore_company_id` | integration sync bookkeeping (Procore, Microsoft, Unanet) | | `procore_environment` | integration sync bookkeeping (Procore, Microsoft, Unanet) | | `procore_project_id` | integration sync bookkeeping (Procore, Microsoft, Unanet) | ## Meeting (`meetings`) | Field | Type | From | | ---------------------- | --------------------------------- | ----------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` or `null` | column `project_id` | | `user_id` | `string` | column `user_id` | | `name` | `string` or `null` | column `name` | | `source` | `string` or `null` | column `source` | | `meeting_time` | `datetime` | column `meeting_time` | | `meeting_url` | `string` or `null` | column `meeting_url` | | `started_timestamp` | `datetime` or `null` | column `started_timestamp` | | `ended_timestamp` | `datetime` or `null` | column `ended_timestamp` | | `status` | `string` | column `status` | | `language` | `string` | column `language` | | `is_dummy` | `boolean` | column `is_dummy` | | `word_count` | `number` or `null` | column `word_count` | | `condensed` | `boolean` | column `condensed` | | `user_is_organizer` | `boolean` or `null` | column `user_is_organizer` | | `calendar_description` | `string` or `null` | column `calendar_description` | | `participants` | `object` or `list[any]` or `null` | column `participants` | | `attendees` | `object` or `list[any]` or `null` | column `attendees` | | `speakers` | `object` or `list[any]` or `null` | column `speakers` | | `geo_coordinates` | `object` or `list[any]` or `null` | column `geo_coordinates` | | `geo_data` | `object` or `list[any]` or `null` | column `geo_data` | | `note` | `NoteExport` or `null` | derived | | `action_items` | `list[ActionItemExport]` | derived | | `attachments` | `list[MeetingAttachmentExport]` | derived | | `photos` | `list[MeetingPhotoExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------------------------- | ------------------------------------------------------------------------ | | `audio_url` | meeting audio never leaves Cogram (customer policy) | | `backfilled_to_my_workspace_at` | internal worker, bot, upload or sync state | | `bot_audio_analytics` | internal worker, bot, upload or sync state | | `bot_id` | internal worker, bot, upload or sync state | | `bot_launch_result` | internal worker, bot, upload or sync state | | `bot_left_on_silence_at` | internal worker, bot, upload or sync state | | `bot_restarted_count` | internal worker, bot, upload or sync state | | `bot_speaker_timeline` | internal worker, bot, upload or sync state | | `bot_speaker_timeline_v2` | internal worker, bot, upload or sync state | | `call_meeting_id` | internal worker, bot, upload or sync state | | `debug_info` | internal worker, bot, upload or sync state | | `deleted_at` | soft-delete or operational metadata | | `deletion_reason` | soft-delete or operational metadata | | `external_media_scrubbed_at` | soft-delete or operational metadata | | `failure_code` | soft-delete or operational metadata | | `fluester_audio_uri` | meeting audio never leaves Cogram (customer policy) | | `fluester_client_processing_status` | internal worker, bot, upload or sync state | | `fluester_debug_info` | internal worker, bot, upload or sync state | | `fluester_job_id` | internal worker, bot, upload or sync state | | `internal_share_token` | token or credential; never leaves Cogram | | `internal_share_token_expires_at` | token or credential; never leaves Cogram | | `multipart_object_key` | internal worker, bot, upload or sync state | | `multipart_part_count` | internal worker, bot, upload or sync state | | `multipart_part_size_bytes` | internal worker, bot, upload or sync state | | `multipart_photo_metadata` | internal worker, bot, upload or sync state | | `multipart_upload_id` | internal worker, bot, upload or sync state | | `notification_sent_at` | internal worker, bot, upload or sync state | | `origin` | internal worker, bot, upload or sync state | | `raw_analytics_data` | internal worker, bot, upload or sync state | | `raw_fluester_response` | internal worker, bot, upload or sync state | | `read_only_token` | token or credential; never leaves Cogram | | `recurrence_id` | internal worker, bot, upload or sync state | | `stopped_by_user_id` | who stopped the recording; shown on the meeting, not part of its content | | `uid` | internal worker, bot, upload or sync state | ## Transcript (`transcripts`) | Field | Type | From | | ------------- | --------------------------------- | -------------------- | | `id` | `string` | column `id` | | `meeting_id` | `string` | column `meeting_id` | | `data` | `object` or `list[any]` or `null` | column `data` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## ChainResult (`chain_results`) | Field | Type | From | | ---------------- | ----------------------------- | -------------------- | | `id` | `string` | column `id` | | `chain_id` | `string` or `null` | column `chain_id` | | `building_block` | `_BuildingBlockRef` or `null` | derived | | `user_id` | `string` or `null` | column `user_id` | | `output` | `string` or `null` | column `output` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `group_id` | access control or automation config; out of scope | | `input` | internal worker, bot, upload or sync state | | `meeting_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | ## Note (`notes`) | Field | Type | From | | ------------- | --------------------------------- | -------------------- | | `id` | `string` | column `id` | | `user_id` | `string` or `null` | column `user_id` | | `text` | `string` or `null` | column `text` | | `content` | `object` or `list[any]` or `null` | column `content` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------ | -------------------------------------------------------- | | `meeting_id` | parent reference; implied by the file's place in the zip | ## ActionItem (`action_items`) | Field | Type | From | | --------------------------- | -------------------- | ---------------------------------- | | `id` | `string` | column `id` | | `user_id` | `string` or `null` | column `user_id` | | `origin` | `string` or `null` | column `origin` | | `status` | `string` or `null` | column `status` | | `due_date_timestamp` | `datetime` or `null` | column `due_date_timestamp` | | `archived` | `boolean` | column `archived` | | `assignee` | `string` or `null` | column `assignee` | | `description` | `string` or `null` | column `description` | | `marked_done_timestamp` | `datetime` or `null` | column `marked_done_timestamp` | | `migrated_to_board_item_id` | `string` or `null` | column `migrated_to_board_item_id` | | `migrated_to_suggestion_id` | `string` or `null` | column `migrated_to_suggestion_id` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------ | -------------------------------------------------------- | | `meeting_id` | parent reference; implied by the file's place in the zip | ## MeetingAttachment (`meeting_attachments`) | Field | Type | From | | ------------------- | -------------------- | -------------------------- | | `id` | `string` | column `id` | | `uploader_id` | `string` | column `uploader_id` | | `filename` | `string` | column `filename` | | `mime_type` | `string` | column `mime_type` | | `size_bytes` | `number` | column `size_bytes` | | `extracted_content` | `string` or `null` | column `extracted_content` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `meeting_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## MeetingPhoto (`meeting_photos`) | Field | Type | From | | ----------------- | --------------------------------- | ------------------------ | | `id` | `string` | column `id` | | `note` | `string` or `null` | column `note` | | `taken_at` | `datetime` or `null` | column `taken_at` | | `geo_coordinates` | `object` or `list[any]` or `null` | column `geo_coordinates` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------ | ------------------------------------------------------------- | | `meeting_id` | parent reference; implied by the file's place in the zip | | `s3_photo_key` | S3 key; the binary itself ships as a sibling file | | `s3_thumbnail_key` | thumbnail or preview derived from the shipped binary; UI only | ## Email (`emails`) Ships as the `.eml` file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts: * `body` * `cc` * `conversation_id` * `created_at` * `html` * `id` * `internet_message_id` * `is_dummy` * `modified_at` * `recipients` * `sender` * `sent_at` * `subject` * `user_id` Not exported: | Column | Reason | | ------------------- | ------------------------------------------------------------------------------------------------------------------- | | `confidential_type` | not in the .eml; a Continuous Data Export carries it in each email's email.json | | `eml_s3_key` | S3 key; the binary itself ships as a sibling file | | `headers` | raw transport header text; an archived .eml carries the original headers and a rebuilt one the headers Cogram knows | | `message_id` | integration sync bookkeeping (Procore, Microsoft, Unanet) | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | | `retention_class` | not in the .eml; a Continuous Data Export carries it in each email's email.json | ## EmailAttachment (`email_attachments`) Ships as the `.eml` file itself, not as JSON. The columns below ride as RFC-822 headers or MIME parts: * `content_id` * `content_type` * `filename` * `is_inline` Not exported: | Column | Reason | | ----------------- | --------------------------------------------------------------------------------------------------------------------- | | `created_at` | emails have no JSON sidecar; the .eml is the whole record | | `email_id` | parent reference; implied by the file's place in the zip | | `extracted_text` | emails have no JSON sidecar; the .eml is the whole record | | `id` | an archived .eml is the original wire bytes, never rewritten below the header block, so no part can carry a Cogram id | | `modified_at` | emails have no JSON sidecar; the .eml is the whole record | | `organization_id` | organization\_id; implied by the export scope | | `s3_key` | embedded in the .eml as a MIME part | ## Document (`documents`) | Field | Type | From | | ------------------------------ | ----------------------------- | ------------------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `creator_id` | `string` | column `creator_id` | | `filename` | `string` | column `filename` | | `title` | `string` or `null` | column `title` | | `document_number` | `string` or `null` | column `document_number` | | `category` | `string` | column `category` | | `custom_category` | `string` or `null` | column `custom_category` | | `mime_type` | `string` | column `mime_type` | | `size_bytes` | `number` | column `size_bytes` | | `extracted_content` | `string` or `null` | column `extracted_content` | | `folder_id` | `string` or `null` | column `folder_id` | | `current_version_id` | `string` or `null` | column `current_version_id` | | `source_meeting_attachment_id` | `string` or `null` | column `source_meeting_attachment_id` | | `source_email_attachment_id` | `string` or `null` | column `source_email_attachment_id` | | `source_chat_attachment_id` | `string` or `null` | column `source_chat_attachment_id` | | `versions` | `list[DocumentVersionExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | -------- | ------------------------------------------------- | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## DocumentVersion (`document_versions`) | Field | Type | From | | -------------------------- | -------------------- | --------------------------------- | | `id` | `string` | column `id` | | `version_number` | `number` | column `version_number` | | `revision_code` | `string` or `null` | column `revision_code` | | `note` | `string` | column `note` | | `status` | `string` or `null` | column `status` | | `size_bytes` | `number` | column `size_bytes` | | `mime_type` | `string` | column `mime_type` | | `creator_id` | `string` | column `creator_id` | | `restored_from_version_id` | `string` or `null` | column `restored_from_version_id` | | `is_current` | `boolean` | derived | | `filename` | `string` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `document_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## Folder (`folders`) | Field | Type | From | | ------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `parent_id` | `string` or `null` | column `parent_id` | | `name` | `string` | column `name` | | `path` | `string` | derived | | `system_key` | `string` or `null` | column `system_key` | | `creator_id` | `string` | column `creator_id` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | | `restricted` | access control or automation config; out of scope | ## Drawing (`drawings`) | Field | Type | From | | ------------------- | ----------------------------- | -------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `creator_id` | `string` | column `creator_id` | | `drawing_set_id` | `string` or `null` | column `drawing_set_id` | | `drawing_no` | `string` | column `drawing_no` | | `title` | `string` | column `title` | | `category` | `string` or `null` | column `category` | | `drawing_date` | `date` or `null` | column `drawing_date` | | `discipline` | `_LookupRef` or `null` | columns `discipline_id` | | `extracted_content` | `string` or `null` | column `extracted_content` | | `is_dummy` | `boolean` | column `is_dummy` | | `revisions` | `list[DrawingRevisionExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## DrawingRevision (`drawing_revisions`) | Field | Type | From | | ---------------- | -------------------- | ----------------------- | | `id` | `string` | column `id` | | `creator_id` | `string` | column `creator_id` | | `version_number` | `number` | column `version_number` | | `file_name` | `string` | column `file_name` | | `file_size` | `number` | column `file_size` | | `page_number` | `number` or `null` | column `page_number` | | `is_active` | `boolean` | column `is_active` | | `revision_code` | `string` or `null` | column `revision_code` | | `status` | `string` or `null` | column `status` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------ | ------------------------------------------------------------- | | `drawing_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `s3_image_key` | S3 key; the binary itself ships as a sibling file | | `s3_pdf_key` | S3 key; the binary itself ships as a sibling file | | `s3_thumbnail_key` | thumbnail or preview derived from the shipped binary; UI only | | `upload_job_id` | internal worker, bot, upload or sync state | ## DrawingSet (`drawing_sets`) | Field | Type | From | | ----------------- | -------------------- | ------------------------ | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `name` | `string` | column `name` | | `drawing_ids` | `list[string]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## FieldReport (`field_reports`) | Field | Type | From | | -------------------------------- | --------------------------------------- | ----------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `user_id` | `string` | column `user_id` | | `name` | `string` | column `name` | | `summary` | `string` or `null` | column `summary` | | `location` | `string` or `null` | column `location` | | `language` | `string` or `null` | column `language` | | `status` | `string` or `null` | column `status` | | `start_time` | `datetime` or `null` | column `start_time` | | `end_time` | `datetime` or `null` | column `end_time` | | `source_meeting_id` | `string` or `null` | column `source_meeting_id` | | `meta_data` | `object` or `list[any]` or `null` | column `meta_data` | | `geo_data` | `object` or `list[any]` or `null` | column `geo_data` | | `observation_ids` | `list[string]` | derived | | `field_report_type_id` | `string` or `null` | column `field_report_type_id` | | `field_report_type_name` | `string` or `null` | derived | | `field_report_type_field_values` | `list[FieldReportTypeFieldValueExport]` | derived | | `field_report_type_table_cells` | `list[FieldReportTypeTableCellExport]` | derived | | `assignee` | `string` or `null` | column `assignee` | | `assignee_role` | `string` or `null` | column `assignee_role` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `assignee_contact_id` | `string` or `null` | column `assignee_contact_id` | | `assignee_company_id` | `string` or `null` | column `assignee_company_id` | | `is_dummy` | `boolean` | column `is_dummy` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## FieldReportTypeTableCell (`field_report_type_table_cells`) | Field | Type | From | | ----------------------------------- | -------------------- | ------------------------------------------ | | `id` | `string` | column `id` | | `field_report_type_field_id` | `string` | column `field_report_type_field_id` | | `field_name` | `string` | derived | | `field_report_type_table_column_id` | `string` or `null` | column `field_report_type_table_column_id` | | `column_name` | `string` | column `column_name` | | `row_index` | `number` | column `row_index` | | `value` | `string` | column `value` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `field_report_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | ## FieldReportTypeFieldValue (`field_report_type_field_values`) | Field | Type | From | | ------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `field_name` | `string` | column `field_name` | | `value` | `string` | column `value` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ---------------------------- | -------------------------------------------------------- | | `field_report_id` | parent reference; implied by the file's place in the zip | | `field_report_type_field_id` | reference to org-level definition; name is denormalized | | `organization_id` | organization\_id; implied by the export scope | ## Observation (`observations`) | Field | Type | From | | --------------------- | --------------------------------- | ---------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `user_id` | `string` | column `user_id` | | `field_report_id` | `string` or `null` | column `field_report_id` | | `title` | `string` | column `title` | | `note` | `string` | column `note` | | `status` | `_LookupRef` or `null` | columns `status_id` | | `type` | `_LookupRef` or `null` | columns `type_id` | | `drawing_id` | `string` or `null` | column `drawing_id` | | `drawing_coordinates` | `object` or `list[any]` or `null` | column `drawing_coordinates` | | `geo_coordinates` | `object` or `list[any]` or `null` | column `geo_coordinates` | | `meta_data` | `object` or `list[any]` or `null` | column `meta_data` | | `source_meeting_id` | `string` or `null` | column `source_meeting_id` | | `photos` | `list[ObservationPhotoExport]` | derived | | `assignee` | `string` or `null` | column `assignee` | | `assignee_role` | `string` or `null` | column `assignee_role` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `assignee_contact_id` | `string` or `null` | column `assignee_contact_id` | | `assignee_company_id` | `string` or `null` | column `assignee_company_id` | | `is_dummy` | `boolean` | column `is_dummy` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## ObservationPhoto (`observation_photos`) | Field | Type | From | | ------------------------- | --------------------------------- | -------------------------------- | | `id` | `string` | column `id` | | `source_meeting_photo_id` | `string` or `null` | column `source_meeting_photo_id` | | `note` | `string` or `null` | column `note` | | `taken_at` | `datetime` or `null` | column `taken_at` | | `geo_coordinates` | `object` or `list[any]` or `null` | column `geo_coordinates` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------ | ------------------------------------------------------------- | | `observation_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `s3_photo_key` | S3 key; the binary itself ships as a sibling file | | `s3_thumbnail_key` | thumbnail or preview derived from the shipped binary; UI only | ## ProjectBoardItem (`project_board_items`) | Field | Type | From | | --------------------- | ------------------------------ | ---------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `source_meeting_id` | `string` or `null` | column `source_meeting_id` | | `creator_user_id` | `string` or `null` | column `creator_user_id` | | `title` | `string` | column `title` | | `body` | `string` or `null` | column `body` | | `status` | `string` | column `status` | | `priority` | `string` or `null` | column `priority` | | `due_date` | `date` or `null` | column `due_date` | | `meeting_series_uid` | `string` or `null` | column `meeting_series_uid` | | `archived` | `boolean` | column `archived` | | `assignee` | `string` or `null` | column `assignee` | | `assignee_role` | `string` or `null` | column `assignee_role` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `assignee_contact_id` | `string` or `null` | column `assignee_contact_id` | | `assignee_company_id` | `string` or `null` | column `assignee_company_id` | | `history` | `list[TaskHistoryEntryExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## BoardItemHistoryEntry (`project_board_item_history`) | Field | Type | From | | ------------------------------ | -------------------- | ------------------------------------- | | `id` | `string` | column `id` | | `changed_by_user_id` | `string` or `null` | column `changed_by_user_id` | | `triggered_by_meeting_id` | `string` or `null` | column `triggered_by_meeting_id` | | `previous_status` | `string` or `null` | column `previous_status` | | `new_status` | `string` or `null` | column `new_status` | | `previous_assignee` | `string` or `null` | column `previous_assignee` | | `new_assignee` | `string` or `null` | column `new_assignee` | | `previous_assignee_user_id` | `string` or `null` | column `previous_assignee_user_id` | | `new_assignee_user_id` | `string` or `null` | column `new_assignee_user_id` | | `previous_assignee_contact_id` | `string` or `null` | column `previous_assignee_contact_id` | | `new_assignee_contact_id` | `string` or `null` | column `new_assignee_contact_id` | | `previous_assignee_company_id` | `string` or `null` | column `previous_assignee_company_id` | | `new_assignee_company_id` | `string` or `null` | column `new_assignee_company_id` | | `previous_assignee_role` | `string` or `null` | column `previous_assignee_role` | | `new_assignee_role` | `string` or `null` | column `new_assignee_role` | | `previous_priority` | `string` or `null` | column `previous_priority` | | `new_priority` | `string` or `null` | column `new_priority` | | `previous_due_date` | `date` or `null` | column `previous_due_date` | | `new_due_date` | `date` or `null` | column `new_due_date` | | `previous_project_id` | `string` or `null` | column `previous_project_id` | | `new_project_id` | `string` or `null` | column `new_project_id` | | `reason` | `string` or `null` | column `reason` | | `comment` | `string` or `null` | column `comment` | | `changed_at` | `datetime` | column `changed_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `board_item_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | ## Transmittal (`transmittals`) | Field | Type | From | | -------------------------------- | ---------------------------------- | --------------------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `creator_id` | `string` | column `creator_id` | | `sender_org_id` | `string` | column `sender_org_id` | | `transmittal_number` | `string` | column `transmittal_number` | | `subject` | `string` | column `subject` | | `purpose` | `string` | column `purpose` | | `status` | `string` | column `status` | | `remarks` | `string` or `null` | column `remarks` | | `due_date` | `datetime` or `null` | column `due_date` | | `sent_at` | `datetime` or `null` | column `sent_at` | | `revoked_at` | `datetime` or `null` | column `revoked_at` | | `revoked_by_id` | `string` or `null` | column `revoked_by_id` | | `revoke_reason` | `string` or `null` | column `revoke_reason` | | `thread_id` | `string` or `null` | column `thread_id` | | `require_recipient_verification` | `boolean` or `null` | column `require_recipient_verification` | | `assignee` | `string` or `null` | column `assignee` | | `assignee_role` | `string` or `null` | column `assignee_role` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `assignee_contact_id` | `string` or `null` | column `assignee_contact_id` | | `assignee_company_id` | `string` or `null` | column `assignee_company_id` | | `recipients` | `list[TransmittalRecipientExport]` | derived | | `documents` | `list[TransmittalDocumentExport]` | derived | | `events` | `list[TransmittalEventExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## CorrespondenceThread (`correspondence_threads`) | Field | Type | From | | ------------------- | ------------------------------------ | -------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `project_id` | `string` | column `project_id` | | `registration_type` | `string` | column `registration_type` | | `direction` | `string` | column `direction` | | `subject` | `string` or `null` | column `subject` | | `registered_as` | `ThreadRegistrationExport` or `null` | derived | | `parties` | `list[ThreadPartyExport]` | derived | | `messages` | `list[ThreadMessageExport]` | derived | | `comments` | `list[ThreadCommentExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## CorrespondenceComment (`correspondence_comments`) | Field | Type | From | | ---------------------------- | -------------------- | ----------------------------------- | | `id` | `string` | column `id` | | `author_kind` | `string` | column `author_kind` | | `author_user_id` | `UUID` or `null` | column `author_user_id` | | `author_name` | `string` or `null` | derived | | `agent_status` | `string` or `null` | column `agent_status` | | `agent_trigger_comment_id` | `string` or `null` | column `agent_trigger_comment_id` | | `agent_requested_by_user_id` | `UUID` or `null` | column `agent_requested_by_user_id` | | `audience` | `string` | column `audience` | | `body` | `string` | column `body` | | `mentioned_user_ids` | `list[UUID]` | column `mentioned_user_ids` | | `edited_at` | `datetime` or `null` | column `edited_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | --------------------- | -------------------------------------------------------- | | `agent_attempt_times` | internal worker, bot, upload or sync state | | `agent_started_at` | internal worker, bot, upload or sync state | | `agent_thread_id` | internal worker, bot, upload or sync state | | `deleted_at` | soft-delete or operational metadata | | `organization_id` | organization\_id; implied by the export scope | | `related_message_id` | internal worker, bot, upload or sync state | | `thread_id` | parent reference; implied by the file's place in the zip | ## CorrespondenceParty (`correspondence_parties`) | Field | Type | From | | --------------------------- | -------------------- | ---------------------------------- | | `id` | `string` | column `id` | | `contact_id` | `string` or `null` | column `contact_id` | | `external_ref` | `string` or `null` | column `external_ref` | | `display_name` | `string` or `null` | column `display_name` | | `email` | `string` or `null` | column `email` | | `standing_role` | `string` | column `standing_role` | | `first_viewed_at` | `datetime` or `null` | column `first_viewed_at` | | `first_viewed_verified` | `boolean` or `null` | column `first_viewed_verified` | | `first_downloaded_at` | `datetime` or `null` | column `first_downloaded_at` | | `first_downloaded_verified` | `boolean` or `null` | column `first_downloaded_verified` | | `acknowledged_at` | `datetime` or `null` | column `acknowledged_at` | | `acknowledged_verified` | `boolean` or `null` | column `acknowledged_verified` | | `responded_at` | `datetime` or `null` | column `responded_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------------- | -------------------------------------------------------- | | `access_token` | token or credential; never leaves Cogram | | `notification_message_id` | internal worker, bot, upload or sync state | | `organization_id` | organization\_id; implied by the export scope | | `thread_id` | parent reference; implied by the file's place in the zip | ## CorrespondenceMessage (`correspondence_messages`) | Field | Type | From | | ----------------- | ------------------------------ | ------------------------ | | `id` | `string` | column `id` | | `message_uid` | `string` | column `message_uid` | | `in_reply_to` | `string` or `null` | column `in_reply_to` | | `reference_uids` | `list[string]` or `null` | column `reference_uids` | | `from_party_id` | `string` or `null` | column `from_party_id` | | `sender_party_id` | `string` or `null` | column `sender_party_id` | | `direction` | `string` | column `direction` | | `body` | `string` or `null` | column `body` | | `disposition` | `string` or `null` | column `disposition` | | `revision` | `string` or `null` | column `revision` | | `source` | `string` | column `source` | | `source_email_id` | `string` or `null` | column `source_email_id` | | `sent_at` | `datetime` or `null` | column `sent_at` | | `eml_filename` | `string` or `null` | columns `eml_s3_key` | | `addressees` | `list[MessageAddresseeExport]` | derived | | `documents` | `list[MessageDocumentExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `thread_id` | parent reference; implied by the file's place in the zip | ## MessageAddressee (`message_addressees`) | Field | Type | From | | ---------- | -------- | ----------------- | | `party_id` | `string` | column `party_id` | | `role` | `string` | column `role` | Not exported: | Column | Reason | | ----------------- | ------------------------------------------------------------------ | | `created_at` | join row; the recipient is identified and timestamped by its party | | `id` | join row; the recipient is identified and timestamped by its party | | `message_id` | parent reference; implied by the file's place in the zip | | `modified_at` | join row; the recipient is identified and timestamped by its party | | `organization_id` | organization\_id; implied by the export scope | ## MessageDocument (`message_documents`) | Field | Type | From | | --------------------- | -------------------- | ---------------------------- | | `id` | `string` | column `id` | | `document_id` | `string` or `null` | column `document_id` | | `document_version_id` | `string` or `null` | column `document_version_id` | | `drawing_revision_id` | `string` or `null` | column `drawing_revision_id` | | `kind` | `string` or `null` | column `kind` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `message_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | ## TransmittalDocument (`transmittal_documents`) | Field | Type | From | | --------------------- | -------------------- | ---------------------------- | | `id` | `string` | column `id` | | `document_id` | `string` or `null` | column `document_id` | | `document_version_id` | `string` or `null` | column `document_version_id` | | `drawing_id` | `string` or `null` | column `drawing_id` | | `drawing_revision_id` | `string` or `null` | column `drawing_revision_id` | | `dated` | `datetime` or `null` | column `dated` | | `remarks` | `string` or `null` | column `remarks` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `transmittal_id` | parent reference; implied by the file's place in the zip | ## TransmittalEvent (`transmittal_events`) | Field | Type | From | | ------------ | --------------------------------- | ------------------- | | `id` | `string` | column `id` | | `event_type` | `string` | column `event_type` | | `actor_id` | `string` or `null` | column `actor_id` | | `details` | `object` or `list[any]` or `null` | column `details` | | `created_at` | `datetime` or `null` | column `created_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `transmittal_id` | parent reference; implied by the file's place in the zip | ## Submittal (`submittals`) | Field | Type | From | | -------------------------- | -------------------------------------- | --------------------------------- | | `id` | `string` | column `id` | | `project_id` | `string` | column `project_id` | | `creator_id` | `string` or `null` | column `creator_id` | | `procore_submittal_id` | `number` or `null` | column `procore_submittal_id` | | `procore_company_id` | `string` or `null` | column `procore_company_id` | | `procore_project_id` | `string` or `null` | column `procore_project_id` | | `procore_data` | `object` or `list[any]` or `null` | columns `procore_raw_obj` | | `procore_last_sync_at` | `datetime` or `null` | column `procore_last_sync_at` | | `cogram_status` | `string` | column `cogram_status` | | `procore_response` | `string` or `null` | column `procore_response` | | `response_comment` | `string` or `null` | column `response_comment` | | `responded_at` | `datetime` or `null` | column `responded_at` | | `ai_checks_result` | `object` or `list[any]` or `null` | column `ai_checks_result` | | `ai_checks_run_at` | `datetime` or `null` | column `ai_checks_run_at` | | `spec_compliance_result` | `object` or `list[any]` or `null` | column `spec_compliance_result` | | `spec_compliance_run_at` | `datetime` or `null` | column `spec_compliance_run_at` | | `title` | `string` or `null` | column `title` | | `subject` | `string` or `null` | column `subject` | | `number` | `string` or `null` | column `number` | | `revision` | `string` or `null` | column `revision` | | `previous_revision_id` | `string` or `null` | column `previous_revision_id` | | `package_label` | `string` or `null` | column `package_label` | | `spec_csi_division` | `string` or `null` | column `spec_csi_division` | | `spec_csi_section` | `string` or `null` | column `spec_csi_section` | | `drawing_number` | `string` or `null` | column `drawing_number` | | `disciplines` | `list[string]` | column `disciplines` | | `due_date` | `datetime` or `null` | column `due_date` | | `date_received` | `date` or `null` | column `date_received` | | `due_date_source` | `string` or `null` | column `due_date_source` | | `counterparty_reference` | `string` or `null` | column `counterparty_reference` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `source_email_id` | `string` or `null` | column `source_email_id` | | `created_manually` | `boolean` | column `created_manually` | | `thread_id` | `string` or `null` | column `thread_id` | | `ai_draft_response` | `string` or `null` | column `ai_draft_response` | | `ai_draft_response_run_at` | `datetime` or `null` | column `ai_draft_response_run_at` | | `ai_draft_status` | `string` or `null` | column `ai_draft_status` | | `approvers` | `list[SubmittalApproverExport]` | derived | | `attachments` | `list[SubmittalAttachmentMetaExport]` | derived | | `external_reviews` | `list[ExternalReviewInvitationExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## SubmittalApprover (`submittal_approvers`) | Field | Type | From | | --------------------- | --------------------------------- | ---------------------------- | | `id` | `string` | column `id` | | `procore_approver_id` | `number` or `null` | column `procore_approver_id` | | `procore_data` | `object` or `list[any]` or `null` | columns `procore_raw_obj` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | -------------- | -------------------------------------------------------- | | `submittal_id` | parent reference; implied by the file's place in the zip | ## SubmittalAttachment (`submittal_attachments`) | Field | Type | From | | ----------------------- | -------------------- | ------------------------------------- | | `id` | `string` | column `id` | | `parent_type` | `string` | derived | | `parent_id` | `string` | columns `approver_id`, `submittal_id` | | `filename` | `string` | column `filename` | | `file_size_bytes` | `number` or `null` | column `file_size_bytes` | | `mime_type` | `string` or `null` | column `mime_type` | | `procore_attachment_id` | `number` or `null` | column `procore_attachment_id` | | `procore_url` | `string` or `null` | column `procore_url` | | `creator_id` | `string` or `null` | column `creator_id` | | `extracted_text` | `string` or `null` | column `extracted_text` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------------------- | | `procore_raw_obj` | duplicate of data already in the zip | | `s3_key` | S3 key; the binary itself ships as a sibling file | | `s3_uploaded_at` | integration sync bookkeeping (Procore, Microsoft, Unanet) | ## RFI (`rfis`) | Field | Type | From | | -------------------------- | -------------------------------------- | --------------------------------- | | `id` | `string` | column `id` | | `project_id` | `string` | column `project_id` | | `creator_id` | `string` or `null` | column `creator_id` | | `procore_rfi_id` | `number` or `null` | column `procore_rfi_id` | | `procore_company_id` | `string` or `null` | column `procore_company_id` | | `procore_project_id` | `string` or `null` | column `procore_project_id` | | `procore_data` | `object` or `list[any]` or `null` | columns `procore_raw_obj` | | `procore_last_sync_at` | `datetime` or `null` | column `procore_last_sync_at` | | `cogram_status` | `string` or `null` | column `cogram_status` | | `response_comment` | `string` or `null` | column `response_comment` | | `responded_at` | `datetime` or `null` | column `responded_at` | | `ai_checks_result` | `object` or `list[any]` or `null` | column `ai_checks_result` | | `ai_checks_run_at` | `datetime` or `null` | column `ai_checks_run_at` | | `question_extraction` | `ExtractedQuestion` or `null` | column `question_extraction` | | `title` | `string` or `null` | column `title` | | `subject` | `string` or `null` | column `subject` | | `number` | `string` or `null` | column `number` | | `spec_csi_division` | `string` or `null` | column `spec_csi_division` | | `spec_csi_section` | `string` or `null` | column `spec_csi_section` | | `due_date` | `datetime` or `null` | column `due_date` | | `date_received` | `date` or `null` | column `date_received` | | `due_date_source` | `string` or `null` | column `due_date_source` | | `counterparty_reference` | `string` or `null` | column `counterparty_reference` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `source_email_id` | `string` or `null` | column `source_email_id` | | `drawing_number` | `string` or `null` | column `drawing_number` | | `disciplines` | `list[string]` | column `disciplines` | | `created_manually` | `boolean` | column `created_manually` | | `thread_id` | `string` or `null` | column `thread_id` | | `ai_draft_response` | `string` or `null` | column `ai_draft_response` | | `ai_draft_response_run_at` | `datetime` or `null` | column `ai_draft_response_run_at` | | `ai_draft_status` | `string` or `null` | column `ai_draft_status` | | `questions` | `list[RFIQuestionExport]` | derived | | `attachments` | `list[RFIAttachmentMetaExport]` | derived | | `external_reviews` | `list[ExternalReviewInvitationExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## RFIQuestion (`rfi_questions`) | Field | Type | From | | --------------------- | --------------------------------- | ---------------------------- | | `id` | `string` | column `id` | | `procore_question_id` | `number` or `null` | column `procore_question_id` | | `procore_data` | `object` or `list[any]` or `null` | columns `procore_raw_obj` | | `answers` | `list[RFIAnswerExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | -------- | -------------------------------------------------------- | | `rfi_id` | parent reference; implied by the file's place in the zip | ## RFIAnswer (`rfi_answers`) | Field | Type | From | | ------------------- | --------------------------------- | -------------------------- | | `id` | `string` | column `id` | | `question_id` | `string` | column `question_id` | | `procore_answer_id` | `number` or `null` | column `procore_answer_id` | | `procore_data` | `object` or `list[any]` or `null` | columns `procore_raw_obj` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | ## RFIAttachment (`rfi_attachments`) | Field | Type | From | | ----------------------- | -------------------- | ---------------------------------- | | `id` | `string` | column `id` | | `parent_type` | `string` | derived | | `parent_id` | `string` | columns `answer_id`, `question_id` | | `filename` | `string` | column `filename` | | `file_size_bytes` | `number` or `null` | column `file_size_bytes` | | `mime_type` | `string` or `null` | column `mime_type` | | `procore_attachment_id` | `number` or `null` | column `procore_attachment_id` | | `procore_url` | `string` or `null` | column `procore_url` | | `creator_id` | `string` or `null` | column `creator_id` | | `extracted_text` | `string` or `null` | column `extracted_text` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------------------- | | `procore_raw_obj` | duplicate of data already in the zip | | `s3_key` | S3 key; the binary itself ships as a sibling file | | `s3_uploaded_at` | integration sync bookkeeping (Procore, Microsoft, Unanet) | ## ChangeOrder (`change_orders`) | Field | Type | From | | ----------------------------- | -------------------------------------- | ------------------------------------ | | `id` | `string` | column `id` | | `project_id` | `string` | column `project_id` | | `type` | `string` | column `type` | | `number` | `string` or `null` | column `number` | | `subject` | `string` | column `subject` | | `contractor` | `string` or `null` | column `contractor` | | `disciplines` | `list[string]` | column `disciplines` | | `amount` | `string` or `null` | column `amount` | | `currency` | `string` or `null` | column `currency` | | `schedule_impact_days` | `number` or `null` | column `schedule_impact_days` | | `date_received` | `date` or `null` | column `date_received` | | `due_date` | `date` or `null` | column `due_date` | | `ball_in_court` | `string` or `null` | column `ball_in_court` | | `review_status` | `string` | column `review_status` | | `outcome` | `string` or `null` | column `outcome` | | `review_status_changed_at` | `datetime` or `null` | column `review_status_changed_at` | | `review_status_changed_by_id` | `string` or `null` | column `review_status_changed_by_id` | | `commercial_status` | `string` | column `commercial_status` | | `owner_decision` | `string` or `null` | column `owner_decision` | | `assignee_user_id` | `string` or `null` | column `assignee_user_id` | | `creator_id` | `string` or `null` | column `creator_id` | | `source_email_id` | `string` or `null` | column `source_email_id` | | `thread_id` | `string` or `null` | column `thread_id` | | `execution_date` | `date` or `null` | column `execution_date` | | `signed_document_id` | `string` or `null` | column `signed_document_id` | | `outside_cogram_attestation` | `string` or `null` | column `outside_cogram_attestation` | | `revisions` | `list[ChangeOrderRevisionExport]` | derived | | `external_reviews` | `list[ExternalReviewInvitationExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | ## ChangeOrderRevision (`change_order_revisions`) | Field | Type | From | | ----------------- | -------------------- | ------------------------ | | `id` | `string` | column `id` | | `revision_number` | `number` | column `revision_number` | | `issued_at` | `date` | column `issued_at` | | `note` | `string` or `null` | column `note` | | `document_id` | `string` or `null` | column `document_id` | | `issued_by_id` | `string` or `null` | column `issued_by_id` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `change_order_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | ## ExternalReviewInvitation (`external_review_invitations`) | Field | Type | From | | --------------------------- | ------------------------------------------ | ---------------------------------- | | `id` | `string` | column `id` | | `rfi_id` | `string` or `null` | column `rfi_id` | | `submittal_id` | `string` or `null` | column `submittal_id` | | `email` | `string` | column `email` | | `name` | `string` or `null` | column `name` | | `company` | `string` or `null` | column `company` | | `is_required` | `boolean` | column `is_required` | | `deadline` | `datetime` or `null` | column `deadline` | | `invited_by_user_id` | `string` or `null` | column `invited_by_user_id` | | `reviewer_user_id` | `string` or `null` | columns `recipient_user_id` | | `message` | `string` or `null` | column `message` | | `audience` | `string` or `null` | column `audience` | | `response_status` | `string` or `null` | column `response_status` | | `response_comment` | `string` or `null` | column `response_comment` | | `response_custom_stamp` | `string` or `null` | column `response_custom_stamp` | | `responded_at` | `datetime` or `null` | column `responded_at` | | `expires_at` | `datetime` or `null` | columns `preview_token_expires_at` | | `email_sent_at` | `datetime` or `null` | column `email_sent_at` | | `revoked_at` | `datetime` or `null` | column `revoked_at` | | `asset_type` | `string` | column `asset_type` | | `asset_id` | `string` or `null` | column `asset_id` | | `status` | `string` | column `status` | | `sender_organization_id` | `string` | column `sender_organization_id` | | `sender_user_id` | `string` or `null` | column `sender_user_id` | | `recipient_contact_id` | `string` or `null` | column `recipient_contact_id` | | `recipient_organization_id` | `string` or `null` | column `recipient_organization_id` | | `accepted_copy_asset_id` | `string` or `null` | column `accepted_copy_asset_id` | | `accepted_copy_project_id` | `string` or `null` | column `accepted_copy_project_id` | | `party_id` | `string` or `null` | column `party_id` | | `preview_first_viewed_at` | `datetime` or `null` | column `preview_first_viewed_at` | | `attachments` | `list[ExternalReviewAttachmentMetaExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------------- | ------------------------------------------------- | | `preview_token` | token or credential; never leaves Cogram | | `recipient_email` | duplicate of data already in the zip | | `require_sign_in_to_view` | access control or automation config; out of scope | ## ExternalReviewAttachment (`external_review_attachments`) | Field | Type | From | | ----------------- | -------------------- | ------------------------ | | `id` | `string` | column `id` | | `invitation_id` | `string` or `null` | column `invitation_id` | | `filename` | `string` | column `filename` | | `file_size_bytes` | `number` or `null` | column `file_size_bytes` | | `mime_type` | `string` or `null` | column `mime_type` | | `uploaded_by` | `string` | column `uploaded_by` | | `creator_user_id` | `string` or `null` | column `creator_user_id` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | -------- | ------------------------------------------------- | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## KnowledgeEntry (`knowledge_entries`) | Field | Type | From | | --------------------- | -------------------- | -------------------------- | | `id` | `string` | column `id` | | `creator_id` | `string` | column `creator_id` | | `project_id` | `string` or `null` | column `project_id` | | `scope` | `string` | column `scope` | | `kind` | `string` | column `kind` | | `title` | `string` | column `title` | | `description` | `string` | column `description` | | `body_text` | `string` or `null` | column `body_text` | | `filename` | `string` or `null` | derived | | `attachment_filename` | `string` or `null` | derived | | `mime_type` | `string` or `null` | column `mime_type` | | `size_bytes` | `number` or `null` | column `size_bytes` | | `extracted_content` | `string` or `null` | column `extracted_content` | | `content_sha256` | `string` or `null` | column `content_sha256` | | `source_thread_id` | `string` or `null` | column `source_thread_id` | | `source` | `string` or `null` | column `source` | | `source_ref` | `string` or `null` | column `source_ref` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | ------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## Prompt (`prompts`) | Field | Type | From | | ------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `user_id` | `string` | column `user_id` | | `title` | `string` or `null` | column `title` | | `content` | `string` | column `content` | | `tags` | `list[string]` | column `tags` | | `scope` | `string` | column `scope` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `last_used_at` | usage or sync telemetry, not customer data | | `organization_id` | organization\_id; implied by the export scope | | `search_vector` | internal worker, bot, upload or sync state | | `used_count` | usage or sync telemetry, not customer data | ## Agent (`agents`) | Field | Type | From | | ------------------------- | -------------------- | -------------------------------- | | `id` | `string` | column `id` | | `created_by_id` | `string` | column `created_by_id` | | `owner_id` | `string` | column `owner_id` | | `name` | `string` | column `name` | | `description` | `string` or `null` | column `description` | | `instructions` | `string` | column `instructions` | | `skill_ids` | `list[string]` | column `skill_ids` | | `knowledge_entry_ids` | `list[string]` | column `knowledge_entry_ids` | | `shared_with_org` | `boolean` | column `shared_with_org` | | `managed_by_organization` | `boolean` | column `managed_by_organization` | | `model` | `string` | column `model` | | `reasoning_effort` | `string` | column `reasoning_effort` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `deleted_at` | soft-delete or operational metadata | | `glyph_icon` | templates, styling or settings; out of scope | | `glyph_seed` | templates, styling or settings; out of scope | | `glyph_text` | templates, styling or settings; out of scope | | `organization_id` | organization\_id; implied by the export scope | | `provided_key` | internal worker, bot, upload or sync state | ## ProjectChatChannel (`project_chat_channel`) | Field | Type | From | | ------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `project_id` | `string` | column `project_id` | | `name` | `string` | column `name` | | `archived_at` | `datetime` or `null` | column `archived_at` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | ## ProjectChatMessage (`project_chat_message`) | Field | Type | From | | -------------------- | ---------------------------- | --------------------------- | | `id` | `string` | column `id` | | `author_user_id` | `string` | column `author_user_id` | | `body` | `string` | column `body` | | `rich_body` | `string` or `null` | column `rich_body` | | `mentioned_user_ids` | `list[string]` | column `mentioned_user_ids` | | `edited_at` | `datetime` or `null` | column `edited_at` | | `attachments` | `list[ChatAttachmentExport]` | derived | | `reactions` | `list[ChatReactionExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ------------------- | -------------------------------------------------------- | | `channel_id` | parent reference; implied by the file's place in the zip | | `client_message_id` | internal worker, bot, upload or sync state | | `deleted_at` | soft-delete or operational metadata | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | ## ProjectChatAttachment (`project_chat_attachment`) | Field | Type | From | | --------------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `filename` | `string` | column `filename` | | `attachment_filename` | `string` | derived | | `size_bytes` | `number` | column `size_bytes` | | `mime_type` | `string` | column `mime_type` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `deleted_at` | soft-delete or operational metadata | | `message_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | | `s3_key` | S3 key; the binary itself ships as a sibling file | ## ProjectChatReaction (`project_chat_reaction`) | Field | Type | From | | ------------- | -------------------- | -------------------- | | `id` | `string` | column `id` | | `user_id` | `string` | column `user_id` | | `reaction` | `string` | column `reaction` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `message_id` | parent reference; implied by the file's place in the zip | | `organization_id` | organization\_id; implied by the export scope | | `project_id` | parent reference; implied by the file's place in the zip | ## Schedule (`schedules`) | Field | Type | From | | -------------- | -------------------------------- | -------------------- | | `id` | `string` | column `id` | | `project_id` | `string` | column `project_id` | | `items` | `list[ScheduleItemExport]` | derived | | `dependencies` | `list[ScheduleDependencyExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | ## ScheduleItem (`schedule_items`) | Field | Type | From | | ------------------ | -------------------- | ------------------------- | | `id` | `string` | column `id` | | `kind` | `string` | column `kind` | | `wbs_key` | `string` or `null` | column `wbs_key` | | `name` | `string` | column `name` | | `owner` | `string` or `null` | column `owner` | | `owner_contact_id` | `string` or `null` | column `owner_contact_id` | | `start_date` | `date` or `null` | column `start_date` | | `finish_date` | `date` or `null` | column `finish_date` | | `duration_days` | `number` or `null` | column `duration_days` | | `status` | `string` | column `status` | | `parent_item_id` | `string` or `null` | column `parent_item_id` | | `position` | `number` | column `position` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `schedule_id` | parent reference; implied by the file's place in the zip | ## ScheduleDependency (`schedule_dependencies`) | Field | Type | From | | --------------------- | -------------------- | ---------------------------- | | `id` | `string` | column `id` | | `predecessor_item_id` | `string` | column `predecessor_item_id` | | `successor_item_id` | `string` | column `successor_item_id` | | `dependency_type` | `string` | column `dependency_type` | | `lag_days` | `number` or `null` | column `lag_days` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | -------------------------------------------------------- | | `organization_id` | organization\_id; implied by the export scope | | `schedule_id` | parent reference; implied by the file's place in the zip | ## Workflow (`workflows`) | Field | Type | From | | ------------------------- | --------------------------------- | -------------------------------- | | `id` | `string` | column `id` | | `organization_id` | `string` | column `organization_id` | | `name` | `string` | column `name` | | `description` | `string` or `null` | column `description` | | `status` | `string` | column `status` | | `project_ids` | `list[string]` | column `project_ids` | | `trigger_config` | `object` or `list[any]` or `null` | column `trigger_config` | | `data_config` | `object` or `list[any]` or `null` | column `data_config` | | `prompt_config` | `object` or `list[any]` or `null` | column `prompt_config` | | `output_config` | `object` or `list[any]` or `null` | column `output_config` | | `email_config` | `object` or `list[any]` or `null` | column `email_config` | | `last_run_at` | `datetime` or `null` | column `last_run_at` | | `next_run_at` | `datetime` or `null` | column `next_run_at` | | `kind` | `string` | column `kind` | | `trigger_type` | `string` | column `trigger_type` | | `project_selection_mode` | `string` | column `project_selection_mode` | | `owner_project_id` | `string` or `null` | column `owner_project_id` | | `author_id` | `string` | column `author_id` | | `agent_id` | `string` or `null` | column `agent_id` | | `model` | `string` or `null` | column `model` | | `reasoning_effort` | `string` or `null` | column `reasoning_effort` | | `managed_by_organization` | `boolean` | column `managed_by_organization` | | `runs` | `list[WorkflowRunExport]` | derived | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ---------------------- | ------------------------------------------ | | `builder_thread_id` | internal worker, bot, upload or sync state | | `deleted_at` | soft-delete or operational metadata | | `legacy_intake_exempt` | internal worker, bot, upload or sync state | | `provided_key` | internal worker, bot, upload or sync state | ## WorkflowRun (`workflow_runs`) | Field | Type | From | | --------------------- | --------------------------------- | ---------------------------- | | `id` | `string` | column `id` | | `workflow_id` | `string` | column `workflow_id` | | `project_id` | `string` or `null` | column `project_id` | | `status` | `string` | column `status` | | `started_at` | `datetime` | column `started_at` | | `completed_at` | `datetime` or `null` | column `completed_at` | | `documents_processed` | `number` | column `documents_processed` | | `report_content` | `string` or `null` | column `report_content` | | `error_message` | `string` or `null` | column `error_message` | | `outcome` | `string` or `null` | column `outcome` | | `trigger_event` | `object` or `list[any]` or `null` | column `trigger_event` | | `email_sent_at` | `datetime` or `null` | column `email_sent_at` | | `email_recipients` | `list[string]` or `null` | column `email_recipients` | | `result_record_type` | `string` or `null` | column `result_record_type` | | `result_record_id` | `string` or `null` | column `result_record_id` | | `agent_thread_id` | `string` or `null` | column `agent_thread_id` | | `model` | `string` or `null` | column `model` | | `run_config_snapshot` | `object` or `list[any]` or `null` | column `run_config_snapshot` | | `created_at` | `datetime` or `null` | column `created_at` | | `modified_at` | `datetime` or `null` | column `modified_at` | Not exported: | Column | Reason | | ----------------- | --------------------------------------------- | | `cost_usd` | LLM usage accounting, not customer data | | `deleted_at` | soft-delete or operational metadata | | `idempotency_key` | internal worker, bot, upload or sync state | | `input_tokens` | LLM usage accounting, not customer data | | `organization_id` | organization\_id; implied by the export scope | | `output_tokens` | LLM usage accounting, not customer data | | `total_tokens` | LLM usage accounting, not customer data | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.cogram.com/organization-administration/data-export-field-reference.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.