123

Tables (111)

allowance_template_rules

  • id — UUID — Primary key — NOT NULL
  • allowance_template_id — UUID — Foreign key → allowance_templates.id — NOT NULL
  • lesson_template_id — UUID — Foreign key — NOT NULL
  • therapy_type — VARCHAR(32) — NOT NULL
  • session_price — INTEGER — NOT NULL
  • calc_type — VARCHAR(16) — NOT NULL
  • calc_value — INTEGER — NOT NULL
  • night_allowance_amount — INTEGER

allowance_templates

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • therapy_types — VARCHAR(32) — NOT NULL
  • default_calc_type — VARCHAR(16) — NOT NULL
  • default_calc_value — INTEGER — NOT NULL
  • night_allowance_amount — INTEGER — NOT NULL
  • night_start_time — TIME
  • counsel_commission_rate — INTEGER — NOT NULL
  • exam_commission_rate — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

auth_accounts

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • provider — VARCHAR(32) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • created_at — TIMESTAMPTZ

calendar_event_instances

  • id — UUID — Primary key — NOT NULL
  • event_id — UUID — Foreign key → calendar_events.id — NOT NULL
  • start_date — DATE — NOT NULL
  • start_time — TIME
  • end_time — TIME
  • memo — TEXT
  • title — VARCHAR(255)
  • cancelled — BOOLEAN — NOT NULL
  • is_initial_consultation — BOOLEAN — NOT NULL
  • billable_when_cancelled — BOOLEAN — NOT NULL
  • is_makeup — BOOLEAN — NOT NULL
  • source_instance_id — UUID — Foreign key → calendar_event_instances.id
  • created_at — TIMESTAMPTZ

calendar_events

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id
  • event_type — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • start_time — TIME
  • end_time — TIME
  • is_all_day — BOOLEAN — NOT NULL
  • cancelled — BOOLEAN — NOT NULL
  • memo — TEXT
  • is_visit_lesson — BOOLEAN — NOT NULL
  • is_initial_consultation — BOOLEAN — NOT NULL
  • recurrence_rule_id — UUID — Foreign key
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • teacher_user_id — UUID — Foreign key
  • counsel_teacher_user_id — UUID — Foreign key
  • counsel_child_id — VARCHAR(32) — Foreign key → children.id

center_addresses

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • alias — VARCHAR(64)
  • address — VARCHAR(512) — NOT NULL
  • address_detail — VARCHAR(512)
  • is_primary — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_channel_quick_menu_items

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • menu_key — VARCHAR(64) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • is_visible — BOOLEAN — NOT NULL
  • config — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_channel_widgets

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • widget_type — VARCHAR(64) — NOT NULL
  • breakpoint — VARCHAR(8) — NOT NULL
  • x — SMALLINT — NOT NULL
  • y — INTEGER — NOT NULL
  • w — SMALLINT — NOT NULL
  • h — SMALLINT — NOT NULL
  • min_w — SMALLINT
  • min_h — SMALLINT
  • sort_order — INTEGER — NOT NULL
  • config — JSONB
  • is_visible — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_deputy_heads

  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

center_expense_entries

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • entry_date — DATE — NOT NULL
  • expense_category — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255)
  • display_title — VARCHAR(255)
  • payment_method — VARCHAR(32)
  • teacher_user_id — UUID — Foreign key
  • amount — INTEGER — NOT NULL
  • memo — TEXT
  • source_type — VARCHAR(32) — NOT NULL
  • recurring_template_id — UUID — Foreign key → center_expense_recurring_templates.id
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_expense_payment_lines

  • id — UUID — Primary key — NOT NULL
  • expense_entry_id — UUID — Foreign key → center_expense_entries.id — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

center_expense_recurring_template_payment_lines

  • id — UUID — Primary key — NOT NULL
  • recurring_template_id — UUID — Foreign key → center_expense_recurring_templates.id — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

center_expense_recurring_templates

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • expense_category — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • display_title — VARCHAR(255)
  • amount — INTEGER — NOT NULL
  • memo — TEXT
  • payment_method — VARCHAR(32) — NOT NULL
  • teacher_user_id — UUID — Foreign key
  • recurrence_type — VARCHAR(16) — NOT NULL
  • weekly_by_weekdays — INTEGER
  • monthly_day — INTEGER
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_active — BOOLEAN — NOT NULL
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_group_members

  • group_id — UUID — Foreign key → center_groups.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL

center_groups

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • system_key — VARCHAR(32)
  • is_system — BOOLEAN — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_income_entries

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • entry_date — DATE — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id
  • title — VARCHAR(255)
  • display_title — VARCHAR(255)
  • income_category — VARCHAR(32) — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • teacher_user_id — UUID — Foreign key
  • amount — INTEGER — NOT NULL
  • refund_amount — INTEGER — NOT NULL
  • memo — TEXT
  • refund_memo — TEXT
  • status — VARCHAR(16) — NOT NULL
  • source_type — VARCHAR(32) — NOT NULL
  • recurring_template_id — UUID — Foreign key → center_income_recurring_templates.id
  • confirmed_at — TIMESTAMPTZ
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_income_payment_lines

  • id — UUID — Primary key — NOT NULL
  • income_entry_id — UUID — Foreign key → center_income_entries.id — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

center_income_recurring_template_payment_lines

  • id — UUID — Primary key — NOT NULL
  • recurring_template_id — UUID — Foreign key → center_income_recurring_templates.id — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

center_income_recurring_templates

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id
  • income_category — VARCHAR(32) — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • teacher_user_id — UUID — Foreign key
  • amount — INTEGER — NOT NULL
  • memo — TEXT
  • custom_title — VARCHAR(255)
  • display_title — VARCHAR(255)
  • recurrence_type — VARCHAR(16) — NOT NULL
  • weekly_by_weekdays — INTEGER
  • monthly_day — INTEGER
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • is_active — BOOLEAN — NOT NULL
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_income_refund_payment_lines

  • id — UUID — Primary key — NOT NULL
  • income_entry_id — UUID — Foreign key → center_income_entries.id — NOT NULL
  • payment_method — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

center_invitations

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • inviter_id — UUID — Foreign key — NOT NULL
  • invitee_email — VARCHAR(255)
  • invitee_phone — VARCHAR(32)
  • invitee_user_id — UUID — Foreign key
  • center_role_id — UUID — Foreign key → center_roles.id
  • positions — VARCHAR(64)
  • therapy_types — VARCHAR(64)
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ

center_join_requests

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ
  • resolved_by_user_id — UUID — Foreign key
  • reject_reason — TEXT

center_monthly_goals

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • sales_goal_amount — INTEGER — NOT NULL
  • lessons_completed_goal — INTEGER — NOT NULL
  • new_consultations_goal — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_notice_attachments

  • id — UUID — Primary key — NOT NULL
  • notice_id — UUID — Foreign key → center_notices.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • storage_key — VARCHAR(512) — NOT NULL
  • public_url — VARCHAR(512)
  • original_filename — VARCHAR(255)
  • mime_type — VARCHAR(128)
  • created_at — TIMESTAMPTZ

center_notice_reads

  • notice_id — UUID — Foreign key → center_notices.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • read_at — TIMESTAMPTZ — NOT NULL

center_notice_targets

  • id — UUID — Primary key — NOT NULL
  • notice_id — UUID — Foreign key → center_notices.id — NOT NULL
  • child_group_id — UUID — Foreign key → child_groups.id
  • center_group_id — UUID — Foreign key → center_groups.id

center_notices

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • author_id — UUID — Foreign key
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT — NOT NULL
  • audience_kind — VARCHAR(32) — NOT NULL
  • is_pinned — BOOLEAN — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • published_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_payment_accounts

  • id — UUID — Primary key — NOT NULL
  • group_id — UUID — Foreign key → center_groups.id — NOT NULL
  • bank_name — VARCHAR(64) — NOT NULL
  • account_number — VARCHAR(128) — NOT NULL
  • account_holder — VARCHAR(128)
  • label — VARCHAR(64)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_roles

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • description — TEXT
  • system_key — VARCHAR(32)
  • is_system — BOOLEAN — NOT NULL
  • is_default — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • permissions — JSONB
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_subscriptions

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • plan — VARCHAR(32) — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • status — VARCHAR(16) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

center_user_channel_settings

  • user_id — UUID — Foreign key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • quick_menu_layout — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

center_user_document_mandates

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • mandate_started_at — TIMESTAMPTZ — NOT NULL
  • deadline_at — TIMESTAMPTZ
  • document_access_unlocked_at — TIMESTAMPTZ
  • completed_at — TIMESTAMPTZ
  • status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

center_voucher_programs

  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • voucher_program_id — UUID — Foreign key — NOT NULL
  • display_order — INTEGER
  • created_at — TIMESTAMPTZ

centers

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • voucher_available — VARCHAR(32) — NOT NULL
  • plan — VARCHAR(32) — NOT NULL
  • certification_status — VARCHAR(32) — NOT NULL
  • certification_pending_at — TIMESTAMPTZ
  • owner_id — UUID — Foreign key
  • photo — VARCHAR(512)
  • address — VARCHAR(512)
  • address_detail — VARCHAR(512)
  • contact — VARCHAR(128)
  • email — VARCHAR(255)
  • business_registration_number — VARCHAR(32)
  • business_hours — JSONB
  • homepage_sns — JSONB
  • therapy_areas — VARCHAR(32)
  • introduction — TEXT
  • color — VARCHAR(32)
  • established_at — DATE
  • business_license — VARCHAR(512)
  • seal_image — VARCHAR(512)
  • payment_bank_name — VARCHAR(64)
  • payment_account_number — VARCHAR(128)
  • payment_account_holder — VARCHAR(128)
  • monthly_personal_wallet_enabled — BOOLEAN — NOT NULL
  • monthly_wallet_effective_from — DATE
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ
  • deletion_pending_at — TIMESTAMPTZ
  • deletion_purge_at — TIMESTAMPTZ
  • deletion_reason — TEXT

child_centers

  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • created_at — TIMESTAMPTZ
  • inflow_memo — TEXT
  • inflow_route — VARCHAR(255)
  • payment_memo — TEXT
  • removed_at — TIMESTAMPTZ
  • removed_by_user_id — UUID — Foreign key
  • removal_reason — TEXT

child_education_institutions

  • id — UUID — Primary key — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • education_institution — VARCHAR(32) — NOT NULL
  • education_institution_name — VARCHAR(255)
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ

child_government_payment_policies

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • mode — VARCHAR(16) — NOT NULL
  • effective_from — DATE — NOT NULL
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

child_groups

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id
  • name — VARCHAR(255)

child_guardians

  • id — UUID — Primary key — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • user_id — UUID — Foreign key
  • relation_type — VARCHAR(32) — NOT NULL
  • relation_type_note — VARCHAR(32)
  • contact — VARCHAR(128)
  • name — VARCHAR(255)
  • is_primary — BOOLEAN — NOT NULL
  • parent_app_active — BOOLEAN — NOT NULL

child_mandatory_document_ai_job_items

  • id — UUID — Primary key — NOT NULL
  • job_id — UUID — Foreign key → child_mandatory_document_ai_jobs.id — NOT NULL
  • source_document_id — UUID — Foreign key → child_mandatory_source_documents.id — NOT NULL
  • sort_order — INTEGER — NOT NULL

child_mandatory_document_ai_jobs

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • triggered_by_user_id — UUID — Foreign key
  • status — VARCHAR(32) — NOT NULL
  • progress_percent — SMALLINT
  • started_at — TIMESTAMPTZ
  • estimated_ready_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • error_message — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

child_mandatory_source_documents

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id
  • therapy_type — VARCHAR(64) — NOT NULL
  • document_slot — VARCHAR(64) — NOT NULL
  • storage_bucket — VARCHAR(255) — NOT NULL
  • object_key — VARCHAR(1024) — NOT NULL
  • original_filename — VARCHAR(512)
  • content_type — VARCHAR(128)
  • size_bytes — BIGINT
  • uploaded_by_user_id — UUID — Foreign key
  • uploaded_at — TIMESTAMPTZ — NOT NULL

child_month_personal_accounts

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • voucher_tier_id — UUID
  • service_enrollment_id — UUID
  • teacher_user_id — UUID
  • voucher_tier_key — VARCHAR(36) — NOT NULL
  • service_enrollment_key — VARCHAR(36) — NOT NULL
  • teacher_user_key — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

child_month_personal_group_settlements

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • voucher_tier_id — UUID
  • service_enrollment_id — UUID
  • voucher_tier_key — VARCHAR(36) — NOT NULL
  • service_enrollment_key — VARCHAR(36) — NOT NULL
  • personal_fully_paid_at — TIMESTAMPTZ — NOT NULL
  • completed_by_user_id — UUID — Foreign key
  • last_payment_group_id — UUID
  • cleared_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

child_prepaid_ledgers

  • id — UUID — Primary key — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • lot_id — UUID — Foreign key → child_prepaid_lots.id
  • lesson_payment_target_id — UUID — Foreign key → lesson_payment_targets.id
  • child_month_personal_account_id — UUID — Foreign key → child_month_personal_accounts.id
  • entry_type — VARCHAR(32) — NOT NULL
  • delta_amount — INTEGER — NOT NULL
  • charge_group_id — UUID
  • idempotency_key — VARCHAR(128)
  • created_by_user_id — UUID — Foreign key
  • memo — TEXT
  • created_at — TIMESTAMPTZ

child_prepaid_lots

  • id — UUID — Primary key — NOT NULL
  • fifo_seq — BIGINT — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • payment_channel — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • remaining_amount — INTEGER — NOT NULL
  • charged_at — TIMESTAMPTZ — NOT NULL
  • charge_group_id — UUID
  • idempotency_key — VARCHAR(128)
  • created_by_user_id — UUID — Foreign key
  • memo — TEXT
  • created_at — TIMESTAMPTZ

children

  • id — VARCHAR(32) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(16) — NOT NULL
  • birth_date — DATE — NOT NULL
  • contact — VARCHAR(128) — NOT NULL
  • disability_type — VARCHAR(64) — NOT NULL
  • education_institution — VARCHAR(32)
  • education_institution_name — VARCHAR(255)
  • group_id — UUID — Foreign key → child_groups.id
  • memo — TEXT
  • address — VARCHAR(512)
  • address_detail — VARCHAR(512)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

counseling_form_advanced_pages

  • id — UUID — Primary key — NOT NULL
  • form_id — UUID — Foreign key → counseling_forms_advanced.id — NOT NULL
  • category — VARCHAR(64) — NOT NULL
  • page_key — VARCHAR(64) — NOT NULL
  • answers — JSONB — NOT NULL
  • is_complete — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

counseling_form_basic_complaint_rows

  • id — UUID — Primary key — NOT NULL
  • form_id — UUID — Foreign key → counseling_forms_basic.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • content — TEXT
  • onset — TEXT
  • coping — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

counseling_form_basic_family_rows

  • id — UUID — Primary key — NOT NULL
  • form_id — UUID — Foreign key → counseling_forms_basic.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • name — VARCHAR(255)
  • relation_to_child — VARCHAR(32)
  • relation_other — VARCHAR(255)
  • age — VARCHAR(64)
  • education — VARCHAR(255)
  • occupation — VARCHAR(255)
  • cohabitation — VARCHAR(255)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

counseling_forms_advanced

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → documents.id — NOT NULL
  • receipt_number — VARCHAR(128)
  • registrant_name — VARCHAR(255)
  • registrant_user_id — UUID — Foreign key
  • received_on — DATE
  • schema_version — INTEGER — NOT NULL
  • current_category — VARCHAR(64) — NOT NULL
  • current_page_key — VARCHAR(64)
  • category_progress — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

counseling_forms_basic

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → documents.id — NOT NULL
  • receipt_number — VARCHAR(128)
  • child_name — VARCHAR(255)
  • child_gender — VARCHAR(16)
  • child_birth_date — DATE
  • registrant_name — VARCHAR(255)
  • registrant_user_id — UUID — Foreign key
  • received_on — DATE
  • reasons_and_expectations — TEXT
  • registrant_opinion — TEXT
  • family_special_notes — TEXT
  • guardian_address — VARCHAR(512)
  • guardian_address_detail — VARCHAR(255)
  • guardian_contact — VARCHAR(128)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

document_search_recents

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • query_normalized — VARCHAR(200) — NOT NULL
  • query_display — VARCHAR(200) — NOT NULL
  • searched_at — TIMESTAMPTZ — NOT NULL

document_types

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • ai_enabled — BOOLEAN — NOT NULL
  • applicable_scope — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

documents

  • id — UUID — Primary key — NOT NULL
  • service_enrollment_id — UUID — Foreign key
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • document_type_id — UUID — Foreign key → document_types.id — NOT NULL
  • document_number — INTEGER — NOT NULL
  • title — VARCHAR(255)
  • status — VARCHAR(32)
  • memo — TEXT
  • ai_free_edit_remaining — INTEGER — NOT NULL
  • ai_free_edit_initialized — BOOLEAN — NOT NULL
  • ai_auto_generated_at — TIMESTAMPTZ
  • ai_auto_generated_by_user_id — UUID — Foreign key
  • ai_auto_generate_source_document_id — UUID — Foreign key → documents.id
  • center_id — UUID — Foreign key → centers.id
  • parent_requested_at — TIMESTAMPTZ
  • parent_requested_by_user_id — UUID — Foreign key
  • parent_fill_step — INTEGER — NOT NULL
  • parent_request_count — INTEGER — NOT NULL
  • created_by_user_id — UUID — Foreign key
  • updated_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

evaluation_report_attachments

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → evaluation_reports.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • attachment_type — VARCHAR(64)
  • storage_key — VARCHAR(512) — NOT NULL
  • public_url — VARCHAR(512)
  • original_filename — VARCHAR(255)
  • mime_type — VARCHAR(128)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

evaluation_report_test_result_metrics

  • id — UUID — Primary key — NOT NULL
  • summary_id — UUID — Foreign key → evaluation_report_test_result_summaries.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • metric_major — VARCHAR(64)
  • metric_key — VARCHAR(255)
  • metric_label — VARCHAR(255)
  • metric_value — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

evaluation_report_test_result_summaries

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → evaluation_report_test_runs.id — NOT NULL
  • test_tool_name — VARCHAR(255)
  • peer_level — VARCHAR(255)
  • result_difference — TEXT
  • result — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

evaluation_report_test_runs

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → evaluation_reports.id — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • executed_at — DATE
  • test_tool_name — VARCHAR(255)
  • tool_major_category — VARCHAR(255)
  • tool_minor_category — VARCHAR(255)
  • age — VARCHAR(64)
  • examiner_user_id — UUID — Foreign key
  • examiner_name — VARCHAR(255)
  • purpose — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

evaluation_reports

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → documents.id — NOT NULL
  • address — TEXT
  • guardian_contact — VARCHAR(32)
  • evaluation_name — VARCHAR(255)
  • evaluation_date — DATE
  • written_at — TIMESTAMPTZ
  • evaluator_user_id — UUID — Foreign key
  • evaluator_name — VARCHAR(255)
  • background_info — TEXT
  • behavior_characteristics — TEXT
  • result_analysis — TEXT
  • overall_opinion — TEXT
  • signature_user_id — UUID — Foreign key
  • signature_key — VARCHAR(512)
  • signature_public_url — VARCHAR(512)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

event_lesson_participants

  • id — UUID — Primary key — NOT NULL
  • event_id — UUID — Foreign key → calendar_events.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • template_id — UUID — Foreign key — NOT NULL
  • voucher_tier_id — UUID — Foreign key
  • session_price — INTEGER — NOT NULL
  • therapy_type — VARCHAR(32)
  • service_enrollment_id — UUID — Foreign key

interim_reports

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → documents.id — NOT NULL
  • therapy_plan_id — UUID — Foreign key
  • service_name — VARCHAR(512)
  • service_period_start — DATE
  • service_period_end — DATE
  • provider_name — VARCHAR(255)
  • service_area — VARCHAR(255)
  • mid_evaluation_date — DATE
  • initial_situation_text — TEXT
  • initial_situation_attachment_object_key — VARCHAR(1024)
  • final_situation_text — TEXT
  • counseling_content — TEXT
  • manager_opinion_text — TEXT
  • future_goals_plans_text — TEXT
  • report_date — DATE
  • organization_name — VARCHAR(512)
  • author_name — VARCHAR(255)
  • author_signature_data_url — TEXT
  • goals_snapshot — JSONB
  • goals_snapshot_at — TIMESTAMPTZ
  • goals_snapshot_source_therapy_plan_id — VARCHAR(64)
  • goals_snapshot_source_document_id — VARCHAR(64)
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

learning_content_categories

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

learning_content_likes

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • target_type — VARCHAR(16) — NOT NULL
  • target_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ

learning_featured_items

  • id — UUID — Primary key — NOT NULL
  • section — VARCHAR(64) — NOT NULL
  • target_type — VARCHAR(16) — NOT NULL
  • target_id — UUID — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

learning_lectures

  • id — UUID — Primary key — NOT NULL
  • category_id — UUID — Foreign key → learning_content_categories.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • subtitle — VARCHAR(1000)
  • thumbnail_storage_key — VARCHAR(512)
  • thumbnail_public_url — VARCHAR(512)
  • external_url — TEXT — NOT NULL
  • external_provider — VARCHAR(128)
  • chapter_count — INTEGER
  • duration_minutes — INTEGER
  • content_provider — VARCHAR(16)
  • status — VARCHAR(16) — NOT NULL
  • published_at — TIMESTAMPTZ
  • sort_order — INTEGER — NOT NULL
  • view_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

learning_materials

  • id — UUID — Primary key — NOT NULL
  • category_id — UUID — Foreign key → learning_content_categories.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • description — TEXT
  • thumbnail_storage_key — VARCHAR(512)
  • thumbnail_public_url — VARCHAR(512)
  • delivery_type — VARCHAR(32) — NOT NULL
  • file_storage_key — VARCHAR(512)
  • file_public_url — VARCHAR(512)
  • external_url — TEXT
  • content_provider — VARCHAR(16)
  • download_count — INTEGER — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • published_at — TIMESTAMPTZ
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

legal_documents

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • version — VARCHAR(32) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • effective_at — TIMESTAMPTZ — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

lesson_completion_confirmations

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • event_lesson_participant_id — UUID — Foreign key → event_lesson_participants.id — NOT NULL
  • calendar_event_instance_id — UUID — Foreign key → calendar_event_instances.id
  • calendar_event_id — UUID — Foreign key → calendar_events.id
  • status — VARCHAR(16) — NOT NULL
  • confirmed_at — TIMESTAMPTZ
  • confirmed_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

lesson_makeup_allocations

  • id — UUID — Primary key — NOT NULL
  • source_instance_id — UUID — Foreign key → calendar_event_instances.id — NOT NULL
  • target_instance_id — UUID — Foreign key → calendar_event_instances.id — NOT NULL
  • added_minutes — INTEGER — NOT NULL
  • memo — TEXT
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ

lesson_parent_signatures

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • service_enrollment_id — UUID — Foreign key — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • event_lesson_participant_id — UUID — Foreign key → event_lesson_participants.id — NOT NULL
  • calendar_event_instance_id — UUID — Foreign key → calendar_event_instances.id
  • calendar_event_id — UUID — Foreign key → calendar_events.id
  • signed_by_user_id — UUID — Foreign key
  • signature_data_url — TEXT — NOT NULL
  • signed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

lesson_payment_targets

  • id — UUID — Primary key — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • calendar_event_instance_id — UUID — Foreign key → calendar_event_instances.id
  • calendar_event_id — UUID — Foreign key → calendar_events.id
  • event_lesson_participant_id — UUID — Foreign key → event_lesson_participants.id — NOT NULL
  • government_due — INTEGER
  • personal_due — INTEGER
  • due_locked_at — TIMESTAMPTZ
  • due_rate_source — VARCHAR(255)
  • government_paid — INTEGER — NOT NULL
  • personal_paid — INTEGER — NOT NULL
  • personal_refunded — INTEGER — NOT NULL
  • refunded_at — TIMESTAMPTZ
  • is_refunded — BOOLEAN — NOT NULL
  • personal_completion_status — VARCHAR(16) — NOT NULL
  • personal_confirmed_at — TIMESTAMPTZ
  • personal_confirmed_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

lesson_personal_payment_lines

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • lesson_payment_target_id — UUID — Foreign key → lesson_payment_targets.id — NOT NULL
  • payment_channel — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • payment_group_id — UUID — NOT NULL
  • idempotency_key — VARCHAR(128)
  • created_by_user_id — UUID — Foreign key
  • memo — TEXT
  • created_at — TIMESTAMPTZ

month_personal_payment_confirmations

  • id — UUID — Primary key — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • payment_group_id — UUID — NOT NULL
  • confirmed_at — TIMESTAMPTZ — NOT NULL
  • confirmed_by_user_id — UUID — Foreign key
  • auto_confirmed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ

month_personal_payment_lines

  • id — UUID — Primary key — NOT NULL
  • account_id — UUID — Foreign key → child_month_personal_accounts.id — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • child_id — VARCHAR(32) — Foreign key → children.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL
  • entry_type — VARCHAR(16) — NOT NULL
  • payment_group_id — UUID — NOT NULL
  • source_payment_group_id — UUID
  • payment_channel — VARCHAR(32) — NOT NULL
  • amount — INTEGER — NOT NULL
  • payment_source — VARCHAR(16)
  • idempotency_key — VARCHAR(128)
  • memo — TEXT
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ

notification_recipients

  • notification_id — UUID — Foreign key → notifications.id — NOT NULL
  • user_id — UUID — Foreign key — NOT NULL
  • read_at — TIMESTAMPTZ
  • dismissed_at — TIMESTAMPTZ

notifications

  • id — UUID — Primary key — NOT NULL
  • scope — VARCHAR(32) — NOT NULL
  • category_code — VARCHAR(64) — NOT NULL
  • center_id — UUID — Foreign key → centers.id
  • child_id — VARCHAR(32) — Foreign key → children.id
  • title — TEXT
  • body — TEXT
  • payload — JSONB
  • source_type — VARCHAR(64)
  • source_id — VARCHAR(255)
  • dedupe_key — VARCHAR(255)
  • created_by_user_id — UUID — Foreign key
  • created_at — TIMESTAMPTZ — NOT NULL

parent_document_shares

  • id — UUID — Primary key — NOT NULL
  • document_id — UUID — Foreign key → documents.id — NOT NULL
  • child_guardian_id — UUID — Foreign key → child_guardians.id — NOT NULL
  • center_id — UUID — Foreign key → centers.id — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • shared_by_user_id — UUID — Foreign key
  • shared_at — TIMESTAMPTZ
  • stopped_at — TIMESTAMPTZ
  • stopped_by_user_id — UUID — Foreign key
  • last_error — TEXT
  • pdf_storage_key — VARCHAR(512)
  • pdf_storage_bucket — VARCHAR(128)
  • pdf_page_count — INTEGER
  • pdf_mime_type — VARCHAR(128)
  • read_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

parent_notification_settings

  • user_id — UUID — Foreign key — NOT NULL
  • lesson_notifications_enabled — BOOLEAN — NOT NULL
  • before_lesson_enabled — BOOLEAN — NOT NULL
  • before_lesson_30m — BOOLEAN — NOT NULL
  • before_lesson_1h — BOOLEAN — NOT NULL
  • before_lesson_24h — BOOLEAN — NOT NULL
  • lesson_completed_enabled — BOOLEAN — NOT NULL
  • lesson_cancelled_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

phone_verification_challenges

  • id — UUID — Primary key — NOT NULL
  • phone_normalized — VARCHAR(32) — NOT NULL
  • code_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • consumed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

and 31 more tables