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