Encore OS — Documentation

Generated by npm run db:docs:generate — DO NOT EDIT BY HAND. Change the schema via a migration, then regenerate.

Core: lo_ · Tables: 29 · Source generated: 2026-06-10T02:55:32.169Z

Entity relationships

Tables

`lo_accountability_chart`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`name`	text	no	’Accountability Chart’::text
`description`	text	yes
`version`	integer	no	1
`is_active`	boolean	no	true
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_accountability_chart_delete (DELETE)
lo_accountability_chart_insert (INSERT)
lo_accountability_chart_org_access (SELECT)
lo_accountability_chart_select (SELECT)
lo_accountability_chart_update (UPDATE)

`lo_assessment_recipients`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`schedule_id`	uuid	no
`organization_id`	uuid	no
`recipient_id`	uuid	no
`notified_at`	timestamp with time zone	yes
`reminder_sent_at`	timestamp with time zone	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()

Foreign keys:

organization_id → pf_organizations(id)
recipient_id → pf_profiles(id)
schedule_id → lo_assessment_schedules(id)

Policies:

lo_assessment_recipients_delete (DELETE)
lo_assessment_recipients_insert (INSERT)
lo_assessment_recipients_select (SELECT)
lo_assessment_recipients_update (UPDATE)

`lo_assessment_responses`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`schedule_id`	uuid	no
`organization_id`	uuid	no
`respondent_id`	uuid	no
`submission_id`	uuid	yes
`status`	text	no	’pending’::text
`started_at`	timestamp with time zone	yes
`submitted_at`	timestamp with time zone	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

organization_id → pf_organizations(id)
respondent_id → pf_profiles(id)
schedule_id → lo_assessment_schedules(id)

Policies:

lo_assessment_responses_delete (DELETE)
lo_assessment_responses_insert (INSERT)
lo_assessment_responses_select (SELECT)
lo_assessment_responses_update (UPDATE)

`lo_assessment_schedules`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`assessment_id`	uuid	no
`organization_id`	uuid	no
`scheduled_date`	date	no
`due_date`	date	no
`distribution_scope`	text	no	’all’::text
`scope_ids`	uuid[]	yes
`status`	text	no	’scheduled’::text
`distributed_at`	timestamp with time zone	yes
`closed_at`	timestamp with time zone	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

assessment_id → lo_assessments(id)
created_by → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_assessment_schedules_delete (DELETE)
lo_assessment_schedules_insert (INSERT)
lo_assessment_schedules_select (SELECT)
lo_assessment_schedules_update (UPDATE)

`lo_assessments`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`assessment_name`	text	no
`assessment_type`	text	no	’custom’::text
`description`	text	yes
`form_id`	uuid	yes
`is_active`	boolean	no	true
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
form_id → fw_forms(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_assessments_delete (DELETE)
lo_assessments_insert (INSERT)
lo_assessments_select (SELECT)
lo_assessments_update (UPDATE)

`lo_feedback`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`one_on_one_id`	uuid	yes
`feedback_type`	text	no
`feedback_text`	text	no
`role_id`	uuid	yes
`gwc_category`	text	yes
`recipient_id`	uuid	no
`provider_id`	uuid	no
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
one_on_one_id → lo_one_on_ones(id)
organization_id → pf_organizations(id)
provider_id → pf_profiles(id)
recipient_id → pf_profiles(id)
role_id → lo_role_definitions(id)
updated_by → pf_profiles(id)

Policies:

lo_feedback_delete (DELETE)
lo_feedback_insert (INSERT)
lo_feedback_select (SELECT)
lo_feedback_update (UPDATE)

`lo_gwc_assessments`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`seat_assignment_id`	uuid	no
`assessed_by`	uuid	no
`assessment_date`	date	no	CURRENT_DATE
`get_it_score`	integer	no
`want_it_score`	integer	no
`capacity_score`	integer	no
`get_it_notes`	text	yes
`want_it_notes`	text	yes
`capacity_notes`	text	yes
`overall_notes`	text	yes
`recommendation`	text	yes
`recommendation_notes`	text	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes

Foreign keys:

assessed_by → pf_profiles(id)
created_by → pf_profiles(id)
organization_id → pf_organizations(id)
seat_assignment_id → lo_seat_assignments(id)
updated_by → pf_profiles(id)

Policies:

lo_gwc_assessments_delete (DELETE)
lo_gwc_assessments_insert (INSERT)
lo_gwc_assessments_org_access (SELECT)
lo_gwc_assessments_select (SELECT)
lo_gwc_assessments_update (UPDATE)

`lo_issue_discussions`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`issue_id`	uuid	no
`organization_id`	uuid	no
`discussion_text`	text	no
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
issue_id → lo_issues(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_issue_discussions_delete (DELETE)
lo_issue_discussions_insert (INSERT)
lo_issue_discussions_select (SELECT)
lo_issue_discussions_update (UPDATE)

`lo_issues`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`title`	text	no
`description`	text	yes
`priority`	text	no	’medium’::text
`status`	text	no	’open’::text
`assigned_to`	uuid	yes
`assigned_by`	uuid	yes
`root_cause`	text	yes
`resolution`	text	yes
`resolved_date`	date	yes
`resolved_by`	uuid	yes
`meeting_id`	uuid	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

assigned_by → pf_profiles(id)
assigned_to → pf_profiles(id)
created_by → pf_profiles(id)
meeting_id → lo_meetings(id)
organization_id → pf_organizations(id)
resolved_by → pf_profiles(id)
updated_by → pf_profiles(id)

Policies:

lo_issues_delete (DELETE)
lo_issues_insert (INSERT)
lo_issues_select (SELECT)
lo_issues_update (UPDATE)

`lo_knowledge_article_versions`

RLS: ✅ enabled (2 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`article_id`	uuid	no
`version_number`	integer	no
`title`	text	no
`content`	text	no
`summary`	text	yes
`created_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes		User who last updated this record
`updated_at`	timestamp with time zone	yes	now()

Foreign keys:

article_id → lo_knowledge_articles(id)
created_by → pf_profiles(id)
updated_by → users(id)

Policies:

lo_knowledge_article_versions_insert (INSERT)
lo_knowledge_article_versions_select (SELECT)

`lo_knowledge_articles`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`category_id`	uuid	yes
`title`	text	no
`slug`	text	no
`summary`	text	yes
`content`	text	no
`article_type`	text	no	’general’::text
`status`	text	no	’draft’::text
`tags`	text[]	yes	’{}‘::text[]
`is_featured`	boolean	yes	false
`view_count`	integer	yes	0
`published_at`	timestamp with time zone	yes
`archived_at`	timestamp with time zone	yes
`custom_fields`	jsonb	yes	’{}‘::jsonb
`created_at`	timestamp with time zone	no	now()
`created_by`	uuid	no
`updated_at`	timestamp with time zone	no	now()
`updated_by`	uuid	yes

Foreign keys:

category_id → lo_knowledge_categories(id)
created_by → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_knowledge_articles_delete (DELETE)
lo_knowledge_articles_insert (INSERT)
lo_knowledge_articles_select (SELECT)
lo_knowledge_articles_update (UPDATE)

`lo_knowledge_categories`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`parent_id`	uuid	yes
`name`	text	no
`slug`	text	no
`description`	text	yes
`icon`	text	yes
`display_order`	integer	yes	0
`is_active`	boolean	yes	true
`created_at`	timestamp with time zone	no	now()
`created_by`	uuid	no
`updated_at`	timestamp with time zone	no	now()
`updated_by`	uuid	yes

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
parent_id → lo_knowledge_categories(id)
updated_by → pf_profiles(id)

Policies:

lo_knowledge_categories_delete (DELETE)
lo_knowledge_categories_insert (INSERT)
lo_knowledge_categories_select (SELECT)
lo_knowledge_categories_update (UPDATE)

`lo_meeting_action_items`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`meeting_id`	uuid	no
`todo_id`	uuid	yes
`organization_id`	uuid	no
`description`	text	no
`assigned_to`	uuid	yes
`due_date`	date	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

assigned_to → pf_profiles(id)
created_by → pf_profiles(id)
meeting_id → lo_meetings(id)
organization_id → pf_organizations(id)
todo_id → lo_todos(id)
updated_by → pf_profiles(id)

Policies:

lo_meeting_action_items_delete (DELETE)
lo_meeting_action_items_insert (INSERT)
lo_meeting_action_items_select (SELECT)
lo_meeting_action_items_update (UPDATE)

`lo_meeting_attendees`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`meeting_id`	uuid	no
`attendee_id`	uuid	no
`organization_id`	uuid	no
`status`	text	no	’invited’::text
`attended_at`	timestamp with time zone	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes

Foreign keys:

attendee_id → pf_profiles(id)
created_by → pf_profiles(id)
meeting_id → lo_meetings(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_meeting_attendees_delete (DELETE)
lo_meeting_attendees_insert (INSERT)
lo_meeting_attendees_select (SELECT)
lo_meeting_attendees_update (UPDATE)

`lo_meetings`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`meeting_type`	text	no	’level_10’::text
`title`	text	no
`scheduled_date`	timestamp with time zone	no
`duration_minutes`	integer	yes
`status`	text	no	’scheduled’::text
`agenda_template_id`	uuid	yes
`agenda_items`	jsonb	yes	’[]‘::jsonb
`meeting_notes`	text	yes
`decisions_made`	jsonb	yes	’[]‘::jsonb
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_meetings_delete (DELETE)
lo_meetings_insert (INSERT)
lo_meetings_select (SELECT)
lo_meetings_update (UPDATE)

`lo_module_settings`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`enable_vision_sharing`	boolean	no	true
`enable_rock_notifications`	boolean	no	true
`default_rock_duration_days`	integer	no	90
`max_rocks_per_quarter`	integer	no	7
`enable_gwc_assessments`	boolean	no	true
`gwc_assessment_frequency_days`	integer	no	90
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb
`default_meeting_duration_minutes`	integer	no	60
`meeting_reminder_minutes`	integer	no	15
`enable_meeting_notes`	boolean	no	true
`week_start_day`	integer	no	1	0=Sunday, 1=Monday, etc.
`scorecard_threshold_green`	numeric(5,2)	no	90.00
`scorecard_threshold_yellow`	numeric(5,2)	no	70.00
`default_issue_priority`	text	no	’medium’::text	low, medium, high
`issue_auto_archive_days`	integer	no	30
`enable_issue_voting`	boolean	no	true
`default_article_visibility`	text	no	’team’::text	private, team, organization
`version_retention_days`	integer	no	90
`enable_article_ratings`	boolean	no	true
`ai_enabled`	boolean	yes	true	Enable AI features for Leadership OS module
`require_smart_validation`	boolean	yes	false
`smart_minimum_score`	integer	yes	70
`smart_wizard_enabled`	boolean	yes	true
`meeting_number_prefix`	text	yes	’MTG’::text	Prefix for meeting IDs (e.g., MTG)
`meeting_number_sequence`	integer	yes	1	Next sequence number for meeting generation
`rock_number_prefix`	text	yes	’ROCK’::text	Prefix for quarterly rock IDs (e.g., ROCK)
`rock_number_sequence`	integer	yes	1	Next sequence number for rock generation
`issue_number_prefix`	text	yes	’ISSUE’::text	Prefix for issue IDs (e.g., ISSUE)
`issue_number_sequence`	integer	yes	1	Next sequence number for issue generation
`use_configurable_wizards`	boolean	yes	false	PF-41: Use configurable wizard templates when true; otherwise use hardcoded wizards.

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_module_settings_delete (DELETE)
lo_module_settings_insert (INSERT)
lo_module_settings_org_access (SELECT)
lo_module_settings_select (SELECT)
lo_module_settings_update (UPDATE)

`lo_one_on_ones`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`manager_id`	uuid	no
`employee_id`	uuid	no
`scheduled_date`	timestamp with time zone	no
`duration_minutes`	integer	yes	30
`status`	text	no	’scheduled’::text
`role_clarity_discussed`	boolean	yes	false
`gwc_discussed`	boolean	yes	false
`feedback_provided`	boolean	yes	false
`meeting_notes`	text	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
employee_id → pf_profiles(id)
manager_id → pf_profiles(id)
organization_id → pf_organizations(id)
updated_by → pf_profiles(id)

Policies:

lo_one_on_ones_delete (DELETE)
lo_one_on_ones_insert (INSERT)
lo_one_on_ones_select (SELECT)
lo_one_on_ones_update (UPDATE)

`lo_quarterly_rocks`

RLS: ✅ enabled (6 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`strategic_goal_id`	uuid	yes
`quarter`	text	no
`fiscal_year`	integer	no
`title`	text	no
`description`	text	yes
`status`	text	no	’not_started’::text
`progress_percentage`	integer	no	0
`owner_id`	uuid	yes
`start_date`	date	no
`end_date`	date	no
`completed_date`	date	yes
`display_order`	integer	no	0
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb
`review_score`	integer	yes
`review_notes`	text	yes
`reviewed_by`	uuid	yes
`reviewed_at`	timestamp with time zone	yes
`executive_sponsor_id`	uuid	yes		LO-11: Executive accountable for goal success
`smart_score`	integer	yes		SMART goal validation score (0-100). 80+ = Excellent, 70-79 = Good, 50-69 = Fair, 0-49 = Poor
`smart_validation`	jsonb	yes		SMART validation results: {specific: {score, valid, feedback}, measurable: {…}, …}
`smart_validated_at`	timestamp with time zone	yes		Timestamp when SMART validation was performed

Foreign keys:

created_by → pf_profiles(id)
executive_sponsor_id → pf_profiles(id)
organization_id → pf_organizations(id)
owner_id → pf_profiles(id)
reviewed_by → pf_profiles(id)
strategic_goal_id → lo_strategic_goals(id)
updated_by → pf_profiles(id)

Policies:

lo_quarterly_rocks_delete (DELETE)
lo_quarterly_rocks_insert (INSERT)
lo_quarterly_rocks_org_view (SELECT)
lo_quarterly_rocks_select (SELECT)
lo_quarterly_rocks_update (UPDATE)
lo_rocks_org_access (SELECT)

`lo_rock_assignments`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`rock_id`	uuid	no
`profile_id`	uuid	no
`organization_id`	uuid	no
`assignment_type`	text	no	’team_member’::text
`is_primary_owner`	boolean	no	false
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes		User who last updated this record

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
profile_id → pf_profiles(id)
rock_id → lo_quarterly_rocks(id)
updated_by → users(id)

Policies:

lo_rock_assignments_delete (DELETE)
lo_rock_assignments_insert (INSERT)
lo_rock_assignments_select (SELECT)
lo_rock_assignments_update (UPDATE)

`lo_rock_milestones`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`rock_id`	uuid	no
`organization_id`	uuid	no
`title`	text	no
`description`	text	yes
`status`	text	no	’not_started’::text
`target_date`	date	yes
`completed_date`	date	yes
`display_order`	integer	no	0
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`assignee_id`	uuid	yes		LO-11: Person assigned to complete this action
`priority`	text	yes	’medium’::text	LO-11: Priority level (high, medium, low)
`estimated_hours`	numeric(6,2)	yes
`actual_hours`	numeric(6,2)	yes
`tags`	text[]	yes	’{}‘::text[]	LO-11: Labels for filtering and categorization
`depends_on_action_id`	uuid	yes		LO-14: Action that must be completed before this action can complete. Self-referential FK.
`custom_fields`	jsonb	no	’{}‘::jsonb	Organization-specific metadata per constitution.md §5.2.1

Foreign keys:

assignee_id → pf_profiles(id)
created_by → pf_profiles(id)
depends_on_action_id → lo_rock_milestones(id)
organization_id → pf_organizations(id)
rock_id → lo_quarterly_rocks(id)
updated_by → pf_profiles(id)

Policies:

lo_rock_milestones_access (SELECT)
lo_rock_milestones_delete (DELETE)
lo_rock_milestones_insert (INSERT)
lo_rock_milestones_select (SELECT)
lo_rock_milestones_update (UPDATE)

`lo_role_definitions`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`accountability_chart_id`	uuid	no
`role_name`	text	no
`role_description`	text	yes
`department`	text	yes
`key_functions`	jsonb	no	’[]‘::jsonb	Array of 5-7 key functions: [{“function”: “Name”, “description”: ”…”, “order”: 1}]
`parent_role_id`	uuid	yes
`display_order`	integer	no	0
`vision_alignment`	text	yes
`strategic_goal_ids`	uuid[]	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

accountability_chart_id → lo_accountability_chart(id)
created_by → pf_profiles(id)
organization_id → pf_organizations(id)
parent_role_id → lo_role_definitions(id)
updated_by → pf_profiles(id)

Policies:

lo_role_definitions_delete (DELETE)
lo_role_definitions_insert (INSERT)
lo_role_definitions_org_access (SELECT)
lo_role_definitions_select (SELECT)
lo_role_definitions_update (UPDATE)

`lo_scorecard_metrics`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`role_id`	uuid	yes
`metric_name`	text	no
`metric_description`	text	yes
`metric_type`	text	no
`unit`	text	yes
`target_value`	numeric	yes
`warning_threshold`	numeric	yes
`critical_threshold`	numeric	yes
`higher_is_better`	boolean	no	true
`display_order`	integer	no	0
`is_active`	boolean	no	true
`strategic_goal_id`	uuid	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
role_id → lo_role_definitions(id)
strategic_goal_id → lo_strategic_goals(id)
updated_by → pf_profiles(id)

Policies:

lo_scorecard_metrics_delete (DELETE)
lo_scorecard_metrics_insert (INSERT)
lo_scorecard_metrics_select (SELECT)
lo_scorecard_metrics_update (UPDATE)

`lo_scorecard_values`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`scorecard_id`	uuid	no
`metric_id`	uuid	no
`organization_id`	uuid	no
`actual_value`	numeric	no
`trend`	text	no	’same’::text
`notes`	text	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes

Foreign keys:

created_by → pf_profiles(id)
metric_id → lo_scorecard_metrics(id)
organization_id → pf_organizations(id)
scorecard_id → lo_scorecards(id)
updated_by → pf_profiles(id)

Policies:

lo_scorecard_values_delete (DELETE)
lo_scorecard_values_insert (INSERT)
lo_scorecard_values_select (SELECT)
lo_scorecard_values_update (UPDATE)

`lo_scorecards`

RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`role_id`	uuid	yes
`week_start_date`	date	no
`week_end_date`	date	no
`status`	text	no	’draft’::text
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
role_id → lo_role_definitions(id)
updated_by → pf_profiles(id)

Policies:

lo_scorecards_delete (DELETE)
lo_scorecards_insert (INSERT)
lo_scorecards_select (SELECT)
lo_scorecards_update (UPDATE)

`lo_seat_assignments`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`role_id`	uuid	no
`profile_id`	uuid	no
`assignment_type`	text	no	’primary’::text
`start_date`	date	no	CURRENT_DATE
`end_date`	date	yes
`is_active`	boolean	no	true
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
profile_id → pf_profiles(id)
role_id → lo_role_definitions(id)
updated_by → pf_profiles(id)

Policies:

lo_seat_assignments_delete (DELETE)
lo_seat_assignments_insert (INSERT)
lo_seat_assignments_org_access (SELECT)
lo_seat_assignments_select (SELECT)
lo_seat_assignments_update (UPDATE)

`lo_strategic_goals`

RLS: ✅ enabled (5 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`vision_document_id`	uuid	yes
`goal_type`	text	no
`title`	text	no
`description`	text	yes
`category`	text	no
`status`	text	no	’not_started’::text
`target_date`	date	yes
`completion_date`	date	yes
`owner_id`	uuid	yes
`display_order`	integer	no	0
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb
`executive_sponsor_id`	uuid	yes		LO-11: Executive accountable for goal success
`smart_score`	integer	yes		SMART goal validation score (0-100). 80+ = Excellent, 70-79 = Good, 50-69 = Fair, 0-49 = Poor
`smart_validation`	jsonb	yes		JSON containing detailed SMART validation breakdown by criterion
`smart_validated_at`	timestamp with time zone	yes		Timestamp when SMART validation was last performed

Foreign keys:

created_by → pf_profiles(id)
executive_sponsor_id → pf_profiles(id)
organization_id → pf_organizations(id)
owner_id → pf_profiles(id)
updated_by → pf_profiles(id)
vision_document_id → lo_vision_documents(id)

Policies:

lo_strategic_goals_delete (DELETE)
lo_strategic_goals_insert (INSERT)
lo_strategic_goals_org_access (SELECT)
lo_strategic_goals_select (SELECT)
lo_strategic_goals_update (UPDATE)

`lo_todo_comments`

@deprecated Use pf_task_comments instead. This table is read-only and retained for backward compatibility. See PF-29. RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`todo_id`	uuid	no
`organization_id`	uuid	no
`comment_text`	text	no
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
todo_id → lo_todos(id)

Policies:

lo_todo_comments_delete (DELETE)
lo_todo_comments_insert (INSERT)
lo_todo_comments_select (SELECT)
lo_todo_comments_update (UPDATE)

`lo_todos`

@deprecated Use pf_tasks instead. This table is read-only and retained for backward compatibility. See PF-29. RLS: ✅ enabled (4 policies)

Column	Type	Nullable	Default
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`title`	text	no
`description`	text	yes
`status`	text	no	’open’::text
`priority`	text	no	’medium’::text
`assigned_to`	uuid	yes
`assigned_by`	uuid	yes
`due_date`	date	yes
`completed_date`	date	yes
`rock_id`	uuid	yes
`issue_id`	uuid	yes
`meeting_id`	uuid	yes
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

assigned_by → pf_profiles(id)
assigned_to → pf_profiles(id)
created_by → pf_profiles(id)
organization_id → pf_organizations(id)
rock_id → lo_quarterly_rocks(id)
updated_by → pf_profiles(id)

Policies:

lo_todos_delete (DELETE)
lo_todos_insert (INSERT)
lo_todos_select (SELECT)
lo_todos_update (UPDATE)

`lo_vision_documents`

RLS: ✅ enabled (6 policies)

Column	Type	Nullable	Default	Comment
`id`	uuid	no	gen_random_uuid()
`organization_id`	uuid	no
`site_id`	uuid	yes
`core_values`	jsonb	no	’[]‘::jsonb	Array of core values: [{“name”: “Value Name”, “description”: ”…”, “order”: 1}]
`mission_statement`	text	yes
`ten_year_target`	text	yes
`is_active`	boolean	no	true
`version`	integer	no	1
`created_at`	timestamp with time zone	no	now()
`updated_at`	timestamp with time zone	no	now()
`created_by`	uuid	yes
`updated_by`	uuid	yes
`custom_fields`	jsonb	no	’{}‘::jsonb

Foreign keys:

created_by → pf_profiles(id)
organization_id → pf_organizations(id)
site_id → pf_sites(id)
updated_by → pf_profiles(id)

Policies:

lo_vision_docs_org_access (SELECT)
lo_vision_documents_delete (DELETE)
lo_vision_documents_insert (INSERT)
lo_vision_documents_org_view (SELECT)
lo_vision_documents_select (SELECT)
lo_vision_documents_update (UPDATE)

​Entity relationships

​Tables

​lo_accountability_chart

​lo_assessment_recipients

​lo_assessment_responses

​lo_assessment_schedules

​lo_assessments

​lo_feedback

​lo_gwc_assessments

​lo_issue_discussions

​lo_issues

​lo_knowledge_article_versions

​lo_knowledge_articles

​lo_knowledge_categories

​lo_meeting_action_items

​lo_meeting_attendees

​lo_meetings

​lo_module_settings

​lo_one_on_ones

​lo_quarterly_rocks

​lo_rock_assignments

​lo_rock_milestones

​lo_role_definitions

​lo_scorecard_metrics

​lo_scorecard_values

​lo_scorecards

​lo_seat_assignments

​lo_strategic_goals

​lo_todo_comments

​lo_todos

​lo_vision_documents

Entity relationships

Tables

`lo_accountability_chart`

`lo_assessment_recipients`

`lo_assessment_responses`

`lo_assessment_schedules`

`lo_assessments`

`lo_feedback`

`lo_gwc_assessments`

`lo_issue_discussions`

`lo_issues`

`lo_knowledge_article_versions`

`lo_knowledge_articles`

`lo_knowledge_categories`

`lo_meeting_action_items`

`lo_meeting_attendees`

`lo_meetings`

`lo_module_settings`

`lo_one_on_ones`

`lo_quarterly_rocks`

`lo_rock_assignments`

`lo_rock_milestones`

`lo_role_definitions`

`lo_scorecard_metrics`

`lo_scorecard_values`

`lo_scorecards`

`lo_seat_assignments`

`lo_strategic_goals`

`lo_todo_comments`

`lo_todos`

`lo_vision_documents`