Field Duplicate Check Report

Date: 2026-03-06 Total user fields: 737 Collections scanned: 101 Shared field names: 84 Type mismatches: 9

Type Mismatches (same name, different type)

billing

• os_projects.billing: string —
• organizations.billing: alias —

buttons

• block_cta.buttons: json —
• block_button_groups.buttons: alias —
• block_button_group.buttons: alias —

cost

• os_expenses.cost: decimal —
• posts.cost: string — Use a range

due_date

• os_activities.due_date: timestamp — When does this activity need to be completed?
• os_invoices.due_date: date —
• os_projects.due_date: date —
• os_tasks.due_date: date —

headline

• block_columns.headline: string —
• block_columns_rows.headline: text —
• block_cta.headline: string —
• block_faqs.headline: string —
• block_form.headline: string —
• block_gallery.headline: string —
• block_hero.headline: string —
• block_logocloud.headline: string —
• block_richtext.headline: string —
• block_steps.headline: string —
• block_team.headline: text —
• block_testimonials.headline: string —
• block_video.headline: text —
• categories.headline: text —
• pages_blog.headline: string —
• pages_projects.headline: string —

image

• block_columns_rows.image: uuid —
• block_hero.image: string —
• block_step_items.image: uuid —
• posts.image: string —
• team.image: string —
• testimonials.image: string —

layer

• checkpoint_instances.layer: integer — Denormalized for fast query
• checkpoint_rules.layer: integer —
• checkpoint_types.layer: integer — Checkpoint layer
• meta_catalog.layer: integer — Architecture layer
• task_checkpoints.layer: string — Checkpoint layer: L0/L1/L2

parent_id

• feedbacks.parent_id: string —
• workflow_categories.parent_id: integer — FK self -> workflow_categories.id

tasks

• os_project_templates.tasks: json —
• os_projects.tasks: alias —

Semantic Duplicates (similar purpose)

Concept: assignee

• ai_tasks.assigned_agent (string)
• help_articles.owner (string)
• organizations.owner (string)
• os_deals.owner (string)
• os_projects.owner (string)
• os_activities.assigned_to (string)
• os_tasks.assigned_to (string)
• tasks.assigned_to (string)

Concept: code_id

• checkpoint_type_overrides.code (string)
• checkpoint_types.code (string)
• languages.code (string)
• meta_catalog.code (string)
• workflow_categories.code (string)
• table_registry.table_id (string)
• workflow_steps.step_key (string)
• workflows.process_code (string)

Concept: description

• agent_views.content (text)
• ai_discussion_comments.content (text)
• block_columns_rows.content (text)
• block_cta.content (text)
• block_hero.content (text)
• block_quote.content (text)
• block_richtext.content (text)
• block_step_items.content (text)
• block_team.content (text)
• feedbacks.content (text)
• help_articles.content (text)
• knowledge_documents.content (text)
• posts.content (text)
• task_comments.content (text)
• testimonials.content (text)
• agent_views.summary (text)
• help_articles.summary (text)
• knowledge_documents.summary (text)
• pages.summary (text)
• posts.summary (text)
• ai_discussions.description (text)
• block_library.description (text)
• checkpoint_type_overrides.description (text)
• checkpoint_types.description (text)
• globals.description (text)
• help_collections.description (text)
• meta_catalog.description (text)
• os_expenses.description (text)
• os_invoice_items.description (text)
• os_items.description (text)
• os_project_templates.description (text)
• os_projects.description (text)
• os_tasks.description (text)
• table_proposals.description (text)
• table_registry.description (text)
• tasks.description (text)
• workflow_categories.description (text)
• workflow_change_requests.description (text)
• workflow_steps.description (text)
• workflows.description (text)
• os_email_templates.body (text)
• redirects.note (text)
• workflows.narrative (text)

Concept: title_name

• agent_views.title (string)
• block_columns.title (string)
• block_columns_rows.title (string)
• block_cta.title (string)
• block_divider.title (string)
• block_faqs.title (string)
• block_form.title (string)
• block_gallery.title (string)
• block_hero.title (string)
• block_library.title (string)
• block_logocloud.title (string)
• block_quote.title (string)
• block_richtext.title (string)
• block_step_items.title (string)
• block_steps.title (string)
• block_team.title (string)
• block_testimonials.title (string)
• block_video.title (string)
• categories.title (string)
• content_requests.title (string)
• conversations.title (string)
• forms.title (string)
• globals.title (string)
• help_articles.title (string)
• help_collections.title (string)
• help_feedback.title (string)
• knowledge_documents.title (string)
• navigation.title (string)
• navigation_items.title (string)
• pages.title (string)
• pages_blog.title (string)
• pages_projects.title (string)
• posts.title (string)
• seo.title (string)
• testimonials.title (string)
• workflow_change_requests.title (string)
• workflow_steps.title (string)
• workflows.title (string)
• ai_tasks.name (string)
• checkpoint_type_overrides.name (string)
• checkpoint_types.name (string)
• languages.name (string)
• meta_catalog.name (string)
• organization_addresses.name (string)
• organizations.name (string)
• os_activities.name (string)
• os_deal_stages.name (string)
• os_deals.name (string)
• os_email_templates.name (string)
• os_expenses.name (string)
• os_items.name (string)
• os_payment_terms.name (string)
• os_project_templates.name (string)
• os_projects.name (string)
• os_proposals.name (string)
• os_tasks.name (string)
• os_tax_rates.name (string)
• table_registry.name (string)
• tasks.name (string)
• team.name (string)
• workflow_categories.name (string)
• block_button.label (string)
• navigation_items.label (string)
• workflow_step_relations.label (string)

Shared Field Names (2+ collections)

Field	Collections	Types
activities	contacts, os_deals	alias
activity	contacts, os_deals, os_proposals	alias
address_country	globals, organization_addresses	string
address_locality	globals, organization_addresses	string
address_region	globals, organization_addresses	string
alignment	block_button_group, block_faqs, block_richtext	string
approved_at	feedbacks, knowledge_documents	timestamp
approved_by	knowledge_documents, workflow_change_requests	string
approver_id	ai_discussions, feedbacks	string
assigned_to	os_activities, os_tasks, tasks	string
billing	organizations, os_projects	alias, string
blocks	os_proposals, pages	alias
button_group	block_button, block_buttons, block_columns_rows, block_cta, block_hero, block_st	string
buttons	block_button_group, block_button_groups, block_cta	alias, json
category	block_library, checkpoint_types, knowledge_documents, os_expenses, posts	string
children	knowledge_documents, navigation_items	alias
code	checkpoint_type_overrides, checkpoint_types, languages, meta_catalog, workflow_c	string
collection	conversations, os_proposal_blocks, page_blocks, pages_blocks, table_registry	string
color	block_button, categories, os_deal_stages	string
contact	globals, os_invoices, os_payments, os_proposal_approvals	string
contacts	organizations, os_activities, os_deals, os_projects, os_proposals	alias
contacts_id	organizations_contacts, os_activity_contacts, os_deal_contacts, os_project_conta	string
content	agent_views, ai_discussion_comments, block_columns_rows, block_cta, block_hero,	text
cost	os_expenses, posts	decimal, string
created_by	content_requests, doc_reviews	string
deal	os_activities, os_proposals	string
description	ai_discussions, block_library, checkpoint_type_overrides, checkpoint_types, glob	text
directus_files_id	block_gallery_files, block_logocloud_logos, os_task_files, post_gallery_items	string
domain	checkpoint_rules, checkpoint_types	string
due_date	os_activities, os_invoices, os_projects, os_tasks	date, timestamp
email	contacts, globals, organizations, os_proposal_approvals	string
entity_type	feedbacks, meta_catalog	string
first_name	contacts, os_proposal_approvals	string
form	block_form, inbox, os_tasks	string
headline	block_columns, block_columns_rows, block_cta, block_faqs, block_form, block_gall	string, text
hide_block	page_blocks, pages_blocks	boolean
icon	help_collections, navigation_items, os_items	string
image	block_columns_rows, block_hero, block_step_items, posts, team, testimonials	string, uuid
image_position	block_columns_rows, block_hero	string
invoice	os_invoice_items, os_payments	string
is_blocking	checkpoint_rules, checkpoint_type_overrides	boolean
item	conversations, os_invoice_items, os_proposal_blocks, page_blocks, pages_blocks	string
job_title	contacts, team	string
label	block_button, navigation_items, workflow_step_relations	string
last_name	contacts, os_proposal_approvals	string
layer	checkpoint_instances, checkpoint_rules, checkpoint_types, meta_catalog, task_che	integer, string
level	workflow_categories, workflows	integer
metadata	feedbacks, os_payments, os_proposal_approvals	json
name	ai_tasks, checkpoint_type_overrides, checkpoint_types, languages, meta_catalog,	string
organization	conversations, organization_addresses, os_activities, os_deals, os_invoices, os_	string