Function: createAllCollections()
function createAllCollections(db): { appointments: Collection<{ created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; end_date: ZodString; id: ZodString; is_all_day: ZodBoolean; reminder: ZodNullable<ZodString>; start_date: ZodString; status: ZodEnum<{ active: "active"; completed: "completed"; finished: "finished"; missed: "missed"; upcoming: "upcoming"; }>; title: ZodString; type: ZodEnum<{ blocked: "blocked"; meeting: "meeting"; private: "private"; work: "work"; }>; user_id: ZodString; work_project_id: ZodNullable<ZodString>; work_time_entry_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }> & NonSingleResult; bankAccounts: Collection<{ created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodNullable<ZodString>; id: ZodString; is_default: ZodBoolean; saldo: ZodNumber; saldo_set_at: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }> & NonSingleResult; contacts: Collection<{ address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ address: ZodNullable<ZodString>; created_at: ZodString; currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; description: ZodNullable<ZodString>; email: ZodNullable<ZodString>; id: ZodString; name: ZodString; phone: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }> & NonSingleResult; financeProjects: Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; due_date: ZodNullable<ZodString>; due_date_end: ZodNullable<ZodString>; id: ZodString; is_linked: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; start_amount: ZodNumber; title: ZodString; user_id: ZodString; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }> & NonSingleResult; financeProjectTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; financeProjectTags: Collection<{ created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; finance_project_id: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }> & NonSingleResult; notifications: Collection<{ body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }, string, UtilsRecord, ZodObject<{ body: ZodNullable<ZodString>; created_at: ZodString; dismissed_at: ZodNullable<ZodString>; id: ZodString; priority: ZodEnum<{ high: "high"; low: "low"; medium: "medium"; }>; read_at: ZodNullable<ZodString>; resource_id: ZodNullable<ZodString>; resource_type: ZodNullable<ZodEnum<{ appointment: "appointment"; }>>; scheduled_for: ZodNullable<ZodString>; title: ZodNullable<ZodString>; type: ZodEnum<{ appointment.reminder: "appointment.reminder"; appointment.start: "appointment.start"; system.version: "system.version"; }>; user_id: ZodString; }, $strip>, { body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }> & NonSingleResult; payouts: Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; id: ZodString; start_currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; start_value: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; value: ZodNumber; work_project_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }> & NonSingleResult; profiles: Collection<{ avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }, string, UtilsRecord, ZodObject<{ avatar_url: ZodNullable<ZodString>; created_at: ZodString; email: ZodString; full_name: ZodNullable<ZodString>; id: ZodString; initialized_index: ZodNullable<ZodNumber>; onboard_calendar_index: ZodNullable<ZodNumber>; onboard_dashboard_index: ZodNullable<ZodNumber>; onboard_finance_index: ZodNullable<ZodNumber>; onboard_work_index: ZodNullable<ZodNumber>; updated_at: ZodNullable<ZodString>; username: ZodString; website: ZodNullable<ZodString>; }, $strip>, { avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }> & NonSingleResult; projectAdjustments: Collection<{ amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodString; id: ZodString; is_already_included: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }> & NonSingleResult; projectTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; recurringCashflows: Collection<{ amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; anchor_day: ZodNullable<ZodNumber>; bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodString; end_date: ZodNullable<ZodString>; id: ZodString; interval: ZodEnum<{ 1/2 year: "1/2 year"; 1/4 year: "1/4 year"; day: "day"; month: "month"; week: "week"; year: "year"; }>; start_date: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }> & NonSingleResult; recurringCashflowTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; recurringCashflowTags: Collection<{ created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; recurring_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult; settings: Collection<{ automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }, string, UtilsRecord, ZodObject<{ automaticly_stop_other_timer: ZodBoolean; background_color_mode: ZodBoolean; color_mode: ZodBoolean; created_at: ZodString; default_project_bank_account_id: ZodNullable<ZodString>; default_project_type: ZodEnum<{ hobby: "hobby"; hourly: "hourly"; project: "project"; }>; default_salary_amount: ZodNumber; format_24h: ZodBoolean; id: ZodString; locale: ZodEnum<{ de-DE: "de-DE"; en-US: "en-US"; }>; round_in_time_sections: ZodBoolean; rounding_amount: ZodEnum<{ 1/2h: "1/2h"; 1/4h: "1/4h"; custom: "custom"; h: "h"; min: "min"; s: "s"; }>; rounding_direction: ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>; rounding_interval: ZodNumber; show_calendar_time: ZodBoolean; time_section_interval: ZodNumber; updated_at: ZodString; user_id: ZodString; }, $strip>, { automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }> & NonSingleResult; singleCashflows: Collection<{ amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; bank_account_id: ZodString; changed_date: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; finance_project_id: ZodNullable<ZodString>; id: ZodString; is_active: ZodBoolean; original_occurrence_date: ZodNullable<ZodString>; payout_id: ZodNullable<ZodString>; recurring_cashflow_id: ZodNullable<ZodString>; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }> & NonSingleResult; singleCashflowTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; singleCashflowTags: Collection<{ created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; single_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult; tags: Collection<{ created_at: string; description: string | null; id: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; description: string | null; id: string; title: string; user_id: string; }> & NonSingleResult; timeTrackers: Collection<{ appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ appointment_id: ZodNullable<ZodString>; created_at: ZodString; delta_end_time: ZodNumber; delta_start_time: ZodNumber; id: ZodString; memo: ZodNullable<ZodString>; order_index: ZodNumber; pomodoro_enabled: ZodBoolean; pomodoro_focus_duration: ZodNullable<ZodNumber>; pomodoro_long_break_duration: ZodNullable<ZodNumber>; pomodoro_phase: ZodEnum<{ focus: "focus"; long-break: "long-break"; short-break: "short-break"; }>; pomodoro_phase_overtime: ZodBoolean; pomodoro_phase_start_time: ZodNullable<ZodString>; pomodoro_sessions_completed: ZodNumber; pomodoro_sessions_until_long_break: ZodNullable<ZodNumber>; pomodoro_short_break_duration: ZodNullable<ZodNumber>; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; start_time: ZodNullable<ZodString>; state: ZodEnum<{ running: "running"; stopped: "stopped"; }>; time_fragment_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult; workFolders: Collection<{ created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; parent_folder: ZodNullable<ZodString>; title: ZodString; user_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }> & NonSingleResult; workProjects: Collection<{ bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodNullable<ZodString>; color: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; salary: ZodNullable<ZodNumber>; time_fragment_interval: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; work_folder_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }> & NonSingleResult; workProjectTags: Collection<{ created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; work_project_id: ZodString; }, $strip>, { created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }> & NonSingleResult; workTimeEntries: Collection<{ active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ active_seconds: ZodNumber; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; end_time: ZodString; hourly_payment: ZodBoolean; id: ZodString; memo: ZodNullable<ZodString>; paid: ZodBoolean; payout_id: ZodNullable<ZodString>; salary: ZodNumber; start_time: ZodString; time_fragments_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult;};Defined in: packages/db/src/collection-registry.ts:16
Parameters
Section titled “Parameters”| Parameter | Type |
|---|---|
db | AbstractPowerSyncDatabase |
Returns
Section titled “Returns”{ appointments: Collection<{ created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; end_date: ZodString; id: ZodString; is_all_day: ZodBoolean; reminder: ZodNullable<ZodString>; start_date: ZodString; status: ZodEnum<{ active: "active"; completed: "completed"; finished: "finished"; missed: "missed"; upcoming: "upcoming"; }>; title: ZodString; type: ZodEnum<{ blocked: "blocked"; meeting: "meeting"; private: "private"; work: "work"; }>; user_id: ZodString; work_project_id: ZodNullable<ZodString>; work_time_entry_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }> & NonSingleResult; bankAccounts: Collection<{ created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodNullable<ZodString>; id: ZodString; is_default: ZodBoolean; saldo: ZodNumber; saldo_set_at: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }> & NonSingleResult; contacts: Collection<{ address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ address: ZodNullable<ZodString>; created_at: ZodString; currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; description: ZodNullable<ZodString>; email: ZodNullable<ZodString>; id: ZodString; name: ZodString; phone: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }> & NonSingleResult; financeProjects: Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; due_date: ZodNullable<ZodString>; due_date_end: ZodNullable<ZodString>; id: ZodString; is_linked: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; start_amount: ZodNumber; title: ZodString; user_id: ZodString; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }> & NonSingleResult; financeProjectTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; financeProjectTags: Collection<{ created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; finance_project_id: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }> & NonSingleResult; notifications: Collection<{ body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }, string, UtilsRecord, ZodObject<{ body: ZodNullable<ZodString>; created_at: ZodString; dismissed_at: ZodNullable<ZodString>; id: ZodString; priority: ZodEnum<{ high: "high"; low: "low"; medium: "medium"; }>; read_at: ZodNullable<ZodString>; resource_id: ZodNullable<ZodString>; resource_type: ZodNullable<ZodEnum<{ appointment: "appointment"; }>>; scheduled_for: ZodNullable<ZodString>; title: ZodNullable<ZodString>; type: ZodEnum<{ appointment.reminder: "appointment.reminder"; appointment.start: "appointment.start"; system.version: "system.version"; }>; user_id: ZodString; }, $strip>, { body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }> & NonSingleResult; payouts: Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; id: ZodString; start_currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; start_value: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; value: ZodNumber; work_project_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }> & NonSingleResult; profiles: Collection<{ avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }, string, UtilsRecord, ZodObject<{ avatar_url: ZodNullable<ZodString>; created_at: ZodString; email: ZodString; full_name: ZodNullable<ZodString>; id: ZodString; initialized_index: ZodNullable<ZodNumber>; onboard_calendar_index: ZodNullable<ZodNumber>; onboard_dashboard_index: ZodNullable<ZodNumber>; onboard_finance_index: ZodNullable<ZodNumber>; onboard_work_index: ZodNullable<ZodNumber>; updated_at: ZodNullable<ZodString>; username: ZodString; website: ZodNullable<ZodString>; }, $strip>, { avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }> & NonSingleResult; projectAdjustments: Collection<{ amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodString; id: ZodString; is_already_included: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }> & NonSingleResult; projectTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; recurringCashflows: Collection<{ amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; anchor_day: ZodNullable<ZodNumber>; bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodString; end_date: ZodNullable<ZodString>; id: ZodString; interval: ZodEnum<{ 1/2 year: "1/2 year"; 1/4 year: "1/4 year"; day: "day"; month: "month"; week: "week"; year: "year"; }>; start_date: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }> & NonSingleResult; recurringCashflowTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; recurringCashflowTags: Collection<{ created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; recurring_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult; settings: Collection<{ automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }, string, UtilsRecord, ZodObject<{ automaticly_stop_other_timer: ZodBoolean; background_color_mode: ZodBoolean; color_mode: ZodBoolean; created_at: ZodString; default_project_bank_account_id: ZodNullable<ZodString>; default_project_type: ZodEnum<{ hobby: "hobby"; hourly: "hourly"; project: "project"; }>; default_salary_amount: ZodNumber; format_24h: ZodBoolean; id: ZodString; locale: ZodEnum<{ de-DE: "de-DE"; en-US: "en-US"; }>; round_in_time_sections: ZodBoolean; rounding_amount: ZodEnum<{ 1/2h: "1/2h"; 1/4h: "1/4h"; custom: "custom"; h: "h"; min: "min"; s: "s"; }>; rounding_direction: ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>; rounding_interval: ZodNumber; show_calendar_time: ZodBoolean; time_section_interval: ZodNumber; updated_at: ZodString; user_id: ZodString; }, $strip>, { automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }> & NonSingleResult; singleCashflows: Collection<{ amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; bank_account_id: ZodString; changed_date: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; finance_project_id: ZodNullable<ZodString>; id: ZodString; is_active: ZodBoolean; original_occurrence_date: ZodNullable<ZodString>; payout_id: ZodNullable<ZodString>; recurring_cashflow_id: ZodNullable<ZodString>; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }> & NonSingleResult; singleCashflowTagMapping: Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { }; singleCashflowTags: Collection<{ created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; single_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult; tags: Collection<{ created_at: string; description: string | null; id: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; description: string | null; id: string; title: string; user_id: string; }> & NonSingleResult; timeTrackers: Collection<{ appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ appointment_id: ZodNullable<ZodString>; created_at: ZodString; delta_end_time: ZodNumber; delta_start_time: ZodNumber; id: ZodString; memo: ZodNullable<ZodString>; order_index: ZodNumber; pomodoro_enabled: ZodBoolean; pomodoro_focus_duration: ZodNullable<ZodNumber>; pomodoro_long_break_duration: ZodNullable<ZodNumber>; pomodoro_phase: ZodEnum<{ focus: "focus"; long-break: "long-break"; short-break: "short-break"; }>; pomodoro_phase_overtime: ZodBoolean; pomodoro_phase_start_time: ZodNullable<ZodString>; pomodoro_sessions_completed: ZodNumber; pomodoro_sessions_until_long_break: ZodNullable<ZodNumber>; pomodoro_short_break_duration: ZodNullable<ZodNumber>; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; start_time: ZodNullable<ZodString>; state: ZodEnum<{ running: "running"; stopped: "stopped"; }>; time_fragment_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult; workFolders: Collection<{ created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; parent_folder: ZodNullable<ZodString>; title: ZodString; user_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }> & NonSingleResult; workProjects: Collection<{ bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodNullable<ZodString>; color: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; salary: ZodNullable<ZodNumber>; time_fragment_interval: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; work_folder_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }> & NonSingleResult; workProjectTags: Collection<{ created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; work_project_id: ZodString; }, $strip>, { created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }> & NonSingleResult; workTimeEntries: Collection<{ active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ active_seconds: ZodNumber; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; end_time: ZodString; hourly_payment: ZodBoolean; id: ZodString; memo: ZodNullable<ZodString>; paid: ZodBoolean; payout_id: ZodNullable<ZodString>; salary: ZodNumber; start_time: ZodString; time_fragments_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult;}| Name | Type | Defined in |
|---|---|---|
appointments | Collection<{ created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; end_date: ZodString; id: ZodString; is_all_day: ZodBoolean; reminder: ZodNullable<ZodString>; start_date: ZodString; status: ZodEnum<{ active: "active"; completed: "completed"; finished: "finished"; missed: "missed"; upcoming: "upcoming"; }>; title: ZodString; type: ZodEnum<{ blocked: "blocked"; meeting: "meeting"; private: "private"; work: "work"; }>; user_id: ZodString; work_project_id: ZodNullable<ZodString>; work_time_entry_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; end_date: string; id: string; is_all_day: boolean; reminder: string | null; start_date: string; status: "upcoming" | "active" | "finished" | "completed" | "missed"; title: string; type: "work" | "private" | "meeting" | "blocked"; user_id: string; work_project_id: string | null; work_time_entry_id: string | null; }> & NonSingleResult | packages/db/src/collection-registry.ts:284 |
bankAccounts | Collection<{ created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodNullable<ZodString>; id: ZodString; is_default: ZodBoolean; saldo: ZodNumber; saldo_set_at: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string | null; id: string; is_default: boolean; saldo: number; saldo_set_at: string; title: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:271 |
contacts | Collection<{ address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ address: ZodNullable<ZodString>; created_at: ZodString; currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; description: ZodNullable<ZodString>; email: ZodNullable<ZodString>; id: ZodString; name: ZodString; phone: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { address: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; description: string | null; email: string | null; id: string; name: string; phone: string | null; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:272 |
financeProjects | Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; due_date: ZodNullable<ZodString>; due_date_end: ZodNullable<ZodString>; id: ZodString; is_linked: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; start_amount: ZodNumber; title: ZodString; user_id: ZodString; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; description: string | null; due_date: string | null; due_date_end: string | null; id: string; is_linked: boolean; paid: boolean; single_cashflow_id: string | null; start_amount: number; title: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:274 |
financeProjectTagMapping | Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { } | packages/db/src/collection-registry.ts:298 |
financeProjectTags | Collection<{ created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; finance_project_id: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; finance_project_id: string; id: string; tag_id: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:275 |
notifications | Collection<{ body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }, string, UtilsRecord, ZodObject<{ body: ZodNullable<ZodString>; created_at: ZodString; dismissed_at: ZodNullable<ZodString>; id: ZodString; priority: ZodEnum<{ high: "high"; low: "low"; medium: "medium"; }>; read_at: ZodNullable<ZodString>; resource_id: ZodNullable<ZodString>; resource_type: ZodNullable<ZodEnum<{ appointment: "appointment"; }>>; scheduled_for: ZodNullable<ZodString>; title: ZodNullable<ZodString>; type: ZodEnum<{ appointment.reminder: "appointment.reminder"; appointment.start: "appointment.start"; system.version: "system.version"; }>; user_id: ZodString; }, $strip>, { body: string | null; created_at: string; dismissed_at: string | null; id: string; priority: "high" | "medium" | "low"; read_at: string | null; resource_id: string | null; resource_type: "appointment" | null; scheduled_for: string | null; title: string | null; type: "appointment.reminder" | "appointment.start" | "system.version"; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:294 |
payouts | Collection<{ bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; id: ZodString; start_currency: ZodNullable<ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>>; start_value: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; value: ZodNumber; work_project_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; id: string; start_currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF" | null; start_value: number | null; title: string; user_id: string; value: number; work_project_id: string | null; }> & NonSingleResult | packages/db/src/collection-registry.ts:276 |
profiles | Collection<{ avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }, string, UtilsRecord, ZodObject<{ avatar_url: ZodNullable<ZodString>; created_at: ZodString; email: ZodString; full_name: ZodNullable<ZodString>; id: ZodString; initialized_index: ZodNullable<ZodNumber>; onboard_calendar_index: ZodNullable<ZodNumber>; onboard_dashboard_index: ZodNullable<ZodNumber>; onboard_finance_index: ZodNullable<ZodNumber>; onboard_work_index: ZodNullable<ZodNumber>; updated_at: ZodNullable<ZodString>; username: ZodString; website: ZodNullable<ZodString>; }, $strip>, { avatar_url: string | null; created_at: string; email: string; full_name: string | null; id: string; initialized_index: number | null; onboard_calendar_index: number | null; onboard_dashboard_index: number | null; onboard_finance_index: number | null; onboard_work_index: number | null; updated_at: string | null; username: string; website: string | null; }> & NonSingleResult | packages/db/src/collection-registry.ts:292 |
projectAdjustments | Collection<{ amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodString; id: ZodString; is_already_included: ZodBoolean; paid: ZodBoolean; single_cashflow_id: ZodNullable<ZodString>; user_id: ZodString; }, $strip>, { amount: number; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string; id: string; is_already_included: boolean; paid: boolean; single_cashflow_id: string | null; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:277 |
projectTagMapping | Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { } | packages/db/src/collection-registry.ts:297 |
recurringCashflows | Collection<{ amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; anchor_day: ZodNullable<ZodNumber>; bank_account_id: ZodString; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; description: ZodString; end_date: ZodNullable<ZodString>; id: ZodString; interval: ZodEnum<{ 1/2 year: "1/2 year"; 1/4 year: "1/4 year"; day: "day"; month: "month"; week: "week"; year: "year"; }>; start_date: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; anchor_day: number | null; bank_account_id: string; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; description: string; end_date: string | null; id: string; interval: "day" | "week" | "month" | "1/4 year" | "1/2 year" | "year"; start_date: string; title: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:278 |
recurringCashflowTagMapping | Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { } | packages/db/src/collection-registry.ts:299 |
recurringCashflowTags | Collection<{ created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; recurring_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; recurring_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:279 |
settings | Collection<{ automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }, string, UtilsRecord, ZodObject<{ automaticly_stop_other_timer: ZodBoolean; background_color_mode: ZodBoolean; color_mode: ZodBoolean; created_at: ZodString; default_project_bank_account_id: ZodNullable<ZodString>; default_project_type: ZodEnum<{ hobby: "hobby"; hourly: "hourly"; project: "project"; }>; default_salary_amount: ZodNumber; format_24h: ZodBoolean; id: ZodString; locale: ZodEnum<{ de-DE: "de-DE"; en-US: "en-US"; }>; round_in_time_sections: ZodBoolean; rounding_amount: ZodEnum<{ 1/2h: "1/2h"; 1/4h: "1/4h"; custom: "custom"; h: "h"; min: "min"; s: "s"; }>; rounding_direction: ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>; rounding_interval: ZodNumber; show_calendar_time: ZodBoolean; time_section_interval: ZodNumber; updated_at: ZodString; user_id: ZodString; }, $strip>, { automaticly_stop_other_timer: boolean; background_color_mode: boolean; color_mode: boolean; created_at: string; default_project_bank_account_id: string | null; default_project_type: "hobby" | "hourly" | "project"; default_salary_amount: number; format_24h: boolean; id: string; locale: "en-US" | "de-DE"; round_in_time_sections: boolean; rounding_amount: "s" | "min" | "1/4h" | "1/2h" | "h" | "custom"; rounding_direction: "up" | "down" | "nearest"; rounding_interval: number; show_calendar_time: boolean; time_section_interval: number; updated_at: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:293 |
singleCashflows | Collection<{ amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ amount: ZodNumber; bank_account_id: ZodString; changed_date: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; date: ZodString; finance_project_id: ZodNullable<ZodString>; id: ZodString; is_active: ZodBoolean; original_occurrence_date: ZodNullable<ZodString>; payout_id: ZodNullable<ZodString>; recurring_cashflow_id: ZodNullable<ZodString>; title: ZodString; user_id: ZodString; }, $strip>, { amount: number; bank_account_id: string; changed_date: string | null; contact_id: string | null; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; date: string; finance_project_id: string | null; id: string; is_active: boolean; original_occurrence_date: string | null; payout_id: string | null; recurring_cashflow_id: string | null; title: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:280 |
singleCashflowTagMapping | Collection<{ parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }, string | number, { }, StandardSchemaV1<unknown, unknown>, { parent_id: string; tag: { created_at: string; description: string | null; id: string; title: string; user_id: string; }; }> & NonSingleResult & { } | packages/db/src/collection-registry.ts:300 |
singleCashflowTags | Collection<{ created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; single_cashflow_id: ZodString; tag_id: ZodString; user_id: ZodString; }, $strip>, { created_at: string; id: string; single_cashflow_id: string; tag_id: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:281 |
tags | Collection<{ created_at: string; description: string | null; id: string; title: string; user_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; title: ZodString; user_id: ZodString; }, $strip>, { created_at: string; description: string | null; id: string; title: string; user_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:273 |
timeTrackers | Collection<{ appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ appointment_id: ZodNullable<ZodString>; created_at: ZodString; delta_end_time: ZodNumber; delta_start_time: ZodNumber; id: ZodString; memo: ZodNullable<ZodString>; order_index: ZodNumber; pomodoro_enabled: ZodBoolean; pomodoro_focus_duration: ZodNullable<ZodNumber>; pomodoro_long_break_duration: ZodNullable<ZodNumber>; pomodoro_phase: ZodEnum<{ focus: "focus"; long-break: "long-break"; short-break: "short-break"; }>; pomodoro_phase_overtime: ZodBoolean; pomodoro_phase_start_time: ZodNullable<ZodString>; pomodoro_sessions_completed: ZodNumber; pomodoro_sessions_until_long_break: ZodNullable<ZodNumber>; pomodoro_short_break_duration: ZodNullable<ZodNumber>; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; start_time: ZodNullable<ZodString>; state: ZodEnum<{ running: "running"; stopped: "stopped"; }>; time_fragment_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { appointment_id: string | null; created_at: string; delta_end_time: number; delta_start_time: number; id: string; memo: string | null; order_index: number; pomodoro_enabled: boolean; pomodoro_focus_duration: number | null; pomodoro_long_break_duration: number | null; pomodoro_phase: "focus" | "short-break" | "long-break"; pomodoro_phase_overtime: boolean; pomodoro_phase_start_time: string | null; pomodoro_sessions_completed: number; pomodoro_sessions_until_long_break: number | null; pomodoro_short_break_duration: number | null; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; start_time: string | null; state: "running" | "stopped"; time_fragment_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:289 |
workFolders | Collection<{ created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; description: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; parent_folder: ZodNullable<ZodString>; title: ZodString; user_id: ZodNullable<ZodString>; }, $strip>, { created_at: string; description: string | null; id: string; order_index: number; parent_folder: string | null; title: string; user_id: string | null; }> & NonSingleResult | packages/db/src/collection-registry.ts:285 |
workProjects | Collection<{ bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }, string, UtilsRecord, ZodObject<{ bank_account_id: ZodNullable<ZodString>; color: ZodNullable<ZodString>; contact_id: ZodNullable<ZodString>; created_at: ZodString; description: ZodNullable<ZodString>; finance_project_id: ZodNullable<ZodString>; id: ZodString; order_index: ZodNumber; round_in_time_fragments: ZodNullable<ZodBoolean>; rounding_direction: ZodNullable<ZodEnum<{ down: "down"; nearest: "nearest"; up: "up"; }>>; rounding_interval: ZodNullable<ZodNumber>; salary: ZodNullable<ZodNumber>; time_fragment_interval: ZodNullable<ZodNumber>; title: ZodString; user_id: ZodString; work_folder_id: ZodNullable<ZodString>; }, $strip>, { bank_account_id: string | null; color: string | null; contact_id: string | null; created_at: string; description: string | null; finance_project_id: string | null; id: string; order_index: number; round_in_time_fragments: boolean | null; rounding_direction: "up" | "down" | "nearest" | null; rounding_interval: number | null; salary: number | null; time_fragment_interval: number | null; title: string; user_id: string; work_folder_id: string | null; }> & NonSingleResult | packages/db/src/collection-registry.ts:286 |
workProjectTags | Collection<{ created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ created_at: ZodString; id: ZodString; tag_id: ZodString; user_id: ZodString; work_project_id: ZodString; }, $strip>, { created_at: string; id: string; tag_id: string; user_id: string; work_project_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:287 |
workTimeEntries | Collection<{ active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }, string, UtilsRecord, ZodObject<{ active_seconds: ZodNumber; created_at: ZodString; currency: ZodEnum<{ AUD: "AUD"; BRL: "BRL"; CAD: "CAD"; CHF: "CHF"; CNY: "CNY"; EUR: "EUR"; GBP: "GBP"; INR: "INR"; JPY: "JPY"; USD: "USD"; VEF: "VEF"; }>; end_time: ZodString; hourly_payment: ZodBoolean; id: ZodString; memo: ZodNullable<ZodString>; paid: ZodBoolean; payout_id: ZodNullable<ZodString>; salary: ZodNumber; start_time: ZodString; time_fragments_interval: ZodNullable<ZodNumber>; user_id: ZodString; work_project_id: ZodString; }, $strip>, { active_seconds: number; created_at: string; currency: | "USD" | "EUR" | "GBP" | "CAD" | "AUD" | "JPY" | "CHF" | "CNY" | "INR" | "BRL" | "VEF"; end_time: string; hourly_payment: boolean; id: string; memo: string | null; paid: boolean; payout_id: string | null; salary: number; start_time: string; time_fragments_interval: number | null; user_id: string; work_project_id: string; }> & NonSingleResult | packages/db/src/collection-registry.ts:288 |