erer
Tables (38)
advisory_requests
- advisory_request_id — UUID — Primary key — NOT NULL
- public_code — VARCHAR(50) — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- requester_user_id — UUID — Foreign key → users.user_id — NOT NULL
- request_title — VARCHAR(200) — NOT NULL
- request_category — VARCHAR(100) — NOT NULL
- request_body — TEXT — NOT NULL
- assigned_operator_user_id — UUID
- assigned_at — TIMESTAMPTZ
- request_status — VARCHAR(30) — NOT NULL
- credit_charge_status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- replied_at — TIMESTAMPTZ
ai_jobs
- ai_job_id — UUID — Primary key — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- advisory_request_id — UUID — Foreign key → advisory_requests.advisory_request_id
- requested_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- model_provider — VARCHAR(100) — NOT NULL
- model_name — VARCHAR(100) — NOT NULL
- prompt_reference — VARCHAR(500) — NOT NULL
- output_reference — VARCHAR(500)
- job_status — VARCHAR(30) — NOT NULL
- input_token_count — INTEGER
- output_token_count — INTEGER
- estimated_cost_krw — BIGINT
- error_code — VARCHAR(100)
- error_message — TEXT
- retention_policy_code — VARCHAR(50) — NOT NULL
- started_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
audit_logs
- audit_log_id — UUID — Primary key — NOT NULL
- actor_operator_user_id — UUID
- actor_scope — VARCHAR(30) — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- action_name — VARCHAR(100) — NOT NULL
- resource_type — VARCHAR(100) — NOT NULL
- resource_id — UUID
- change_reason — TEXT
- previous_values — JSONB
- new_values — JSONB
- ip_address — INET
- user_agent — VARCHAR(500)
- trace_identifier — VARCHAR(100)
- occurred_at — TIMESTAMPTZ — NOT NULL
auth_identities
- auth_identity_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- identity_provider — VARCHAR(30) — NOT NULL
- provider_account_identifier — VARCHAR(200) — NOT NULL
- provider_email — VARCHAR(320)
- identity_status — VARCHAR(30) — NOT NULL
- linked_at — TIMESTAMPTZ — NOT NULL
coach_availability_exceptions
- availability_exception_id — UUID — Primary key — NOT NULL
- coach_id — UUID — Foreign key → coaches.coach_id — NOT NULL
- exception_type — VARCHAR(30) — NOT NULL
- exception_start_at — TIMESTAMPTZ — NOT NULL
- exception_end_at — TIMESTAMPTZ — NOT NULL
- full_day — BOOLEAN — NOT NULL
- reason — TEXT
- created_by_actor_user_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
coach_availability_rules
- availability_rule_id — UUID — Primary key — NOT NULL
- coach_id — UUID — Foreign key → coaches.coach_id — NOT NULL
- weekday_number — SMALLINT — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- session_duration_minutes — INTEGER — NOT NULL
- buffer_minutes — INTEGER — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- valid_from — DATE — NOT NULL
- valid_until — DATE
- rule_status — VARCHAR(30) — NOT NULL
- created_by_actor_user_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
coaches
- coach_id — UUID — Primary key — NOT NULL
- operator_user_id — UUID — NOT NULL
- coach_name — VARCHAR(100) — NOT NULL
- coach_email — VARCHAR(320) — NOT NULL
- specialty — VARCHAR(200) — NOT NULL
- biography — TEXT
- timezone — VARCHAR(50) — NOT NULL
- profile_visibility — VARCHAR(30) — NOT NULL
- coach_status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
coaching_booking_events
- coaching_booking_event_id — UUID — Primary key — NOT NULL
- coaching_booking_id — UUID — Foreign key → coaching_bookings.coaching_booking_id — NOT NULL
- actor_reference_id — UUID
- actor_scope — VARCHAR(30) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- previous_status — VARCHAR(30)
- new_status — VARCHAR(30)
- reason — TEXT
- message — TEXT
- previous_values — JSONB
- new_values — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
coaching_bookings
- coaching_booking_id — UUID — Primary key — NOT NULL
- public_code — VARCHAR(50) — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- coach_id — UUID — Foreign key → coaches.coach_id — NOT NULL
- topic — VARCHAR(200) — NOT NULL
- agenda — TEXT
- booking_status — VARCHAR(30) — NOT NULL
- starts_at — TIMESTAMPTZ — NOT NULL
- ends_at — TIMESTAMPTZ — NOT NULL
- confirmation_due_at — TIMESTAMPTZ
- cancellation_reason — TEXT
- requested_at — TIMESTAMPTZ — NOT NULL
- confirmed_at — TIMESTAMPTZ
- cancelled_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ — NOT NULL
companies
- company_id — UUID — Primary key — NOT NULL
- legal_name — VARCHAR(200) — NOT NULL
- display_name — VARCHAR(200) — NOT NULL
- business_registration_number_encrypted — BYTEA
- business_registration_number_hash — CHAR(64)
- representative_name — VARCHAR(100)
- billing_email — VARCHAR(320) — NOT NULL
- ownership_status — VARCHAR(30) — NOT NULL
- company_status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
company_memberships
- company_membership_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- primary_organization_unit_id — UUID — Foreign key → organization_units.organization_unit_id
- company_role — VARCHAR(30) — NOT NULL
- membership_origin — VARCHAR(30) — NOT NULL
- membership_status — VARCHAR(30) — NOT NULL
- invited_by_user_id — UUID — Foreign key → users.user_id
- joined_at — TIMESTAMPTZ
- suspended_at — TIMESTAMPTZ
- revoked_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
company_owner_invitations
- company_owner_invitation_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- invitee_email — VARCHAR(320) — NOT NULL
- invitee_user_id — UUID — Foreign key → users.user_id
- nominated_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- invitation_token_hash — CHAR(64) — NOT NULL
- invitation_status — VARCHAR(30) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- accepted_by_user_id — UUID — Foreign key → users.user_id
- accepted_at — TIMESTAMPTZ
- cancelled_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
company_permission_grants
- company_permission_grant_id — UUID — Primary key — NOT NULL
- company_membership_id — UUID — Foreign key → company_memberships.company_membership_id — NOT NULL
- company_permission_id — UUID — Foreign key → company_permissions.company_permission_id — NOT NULL
- data_scope — VARCHAR(30) — NOT NULL
- granted_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- grant_reason — VARCHAR(500)
- granted_at — TIMESTAMPTZ — NOT NULL
- revoked_by_user_id — UUID — Foreign key → users.user_id
- revoked_at — TIMESTAMPTZ
company_permissions
- company_permission_id — UUID — Primary key — NOT NULL
- permission_code — VARCHAR(100) — NOT NULL
- permission_name — VARCHAR(100) — NOT NULL
- permission_description — VARCHAR(500) — NOT NULL
- permission_category — VARCHAR(30) — NOT NULL
- available_data_scopes — JSONB — NOT NULL
- permission_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
credit_ledger
- credit_ledger_entry_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- event_type — VARCHAR(30) — NOT NULL
- credit_amount — INTEGER — NOT NULL
- source_type — VARCHAR(30) — NOT NULL
- source_identifier — UUID
- advisory_request_id — UUID — Foreign key → advisory_requests.advisory_request_id
- coaching_booking_id — UUID — Foreign key → coaching_bookings.coaching_booking_id
- change_reason — TEXT — NOT NULL
- idempotency_key — VARCHAR(200) — NOT NULL
- expires_at — TIMESTAMPTZ
- performed_by_user_id — UUID — Foreign key → users.user_id
- created_at — TIMESTAMPTZ — NOT NULL
data_deletion_jobs
- data_deletion_job_id — UUID — Primary key — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- subject_user_id — UUID — Foreign key → users.user_id
- request_source — VARCHAR(30) — NOT NULL
- deletion_scope — JSONB — NOT NULL
- requested_by_user_id — UUID — Foreign key → users.user_id
- requested_at — TIMESTAMPTZ — NOT NULL
- execute_after — TIMESTAMPTZ — NOT NULL
- deletion_status — VARCHAR(30) — NOT NULL
- legal_hold_reason — TEXT
- result — JSONB
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
inquiries
- inquiry_id — UUID — Primary key — NOT NULL
- public_code — VARCHAR(50) — NOT NULL
- company_name — VARCHAR(200) — NOT NULL
- contact_name — VARCHAR(100) — NOT NULL
- contact_email — VARCHAR(320) — NOT NULL
- contact_phone — VARCHAR(50)
- inquiry_category — VARCHAR(30) — NOT NULL
- message — TEXT — NOT NULL
- diagnosis — JSONB
- inquiry_status — VARCHAR(30) — NOT NULL
- assigned_operator_user_id — UUID
- converted_workspace_id — UUID — Foreign key → workspaces.workspace_id
- submitted_at — TIMESTAMPTZ — NOT NULL
- reviewed_at — TIMESTAMPTZ
- closed_at — TIMESTAMPTZ
inquiry_events
- inquiry_event_id — UUID — Primary key — NOT NULL
- inquiry_id — UUID — Foreign key → inquiries.inquiry_id — NOT NULL
- actor_reference_id — UUID
- actor_scope — VARCHAR(30) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- previous_status — VARCHAR(30)
- new_status — VARCHAR(30)
- note — TEXT
- previous_values — JSONB
- new_values — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
invoices
- invoice_id — UUID — Primary key — NOT NULL
- subscription_id — UUID — Foreign key → subscriptions.subscription_id — NOT NULL
- public_code — VARCHAR(50) — NOT NULL
- invoice_period_start — DATE — NOT NULL
- invoice_period_end — DATE — NOT NULL
- subtotal_krw — BIGINT — NOT NULL
- discount_krw — BIGINT — NOT NULL
- tax_krw — BIGINT — NOT NULL
- total_krw — BIGINT — NOT NULL
- invoice_status — VARCHAR(30) — NOT NULL
- due_at — TIMESTAMPTZ
- issued_at — TIMESTAMPTZ
- paid_at — TIMESTAMPTZ
- receipt_reference — VARCHAR(500)
- created_at — TIMESTAMPTZ — NOT NULL
membership_invitations
- membership_invitation_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- invitation_scope — VARCHAR(30) — NOT NULL
- invitee_email — VARCHAR(320) — NOT NULL
- requested_role — VARCHAR(30) — NOT NULL
- invited_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- invitation_token_hash — CHAR(64) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- invitation_status — VARCHAR(30) — NOT NULL
- accepted_by_user_id — UUID — Foreign key → users.user_id
- accepted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
notification_logs
- notification_log_id — UUID — Primary key — NOT NULL
- notification_template_id — UUID
- related_entity_type — VARCHAR(50) — NOT NULL
- related_entity_id — UUID — NOT NULL
- recipient — VARCHAR(320) — NOT NULL
- notification_channel — VARCHAR(30) — NOT NULL
- message_subject — VARCHAR(200)
- message_reference — VARCHAR(500)
- notification_status — VARCHAR(30) — NOT NULL
- scheduled_at — TIMESTAMPTZ
- sent_at — TIMESTAMPTZ
- provider_message_identifier — VARCHAR(200)
- retry_count — INTEGER — NOT NULL
- failure_reason — TEXT
- idempotency_key — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
notification_preferences
- notification_preference_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- notification_channel — VARCHAR(30) — NOT NULL
- notification_category — VARCHAR(30) — NOT NULL
- notification_event_type — VARCHAR(50)
- receiving_enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
organization_units
- organization_unit_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- parent_organization_unit_id — UUID — Foreign key → organization_units.organization_unit_id
- organization_unit_type — VARCHAR(30) — NOT NULL
- organization_unit_name — VARCHAR(200) — NOT NULL
- organization_unit_code — VARCHAR(50)
- hierarchy_depth — SMALLINT — NOT NULL
- organization_unit_status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- archived_at — TIMESTAMPTZ
payments
- payment_id — UUID — Primary key — NOT NULL
- invoice_id — UUID — Foreign key → invoices.invoice_id — NOT NULL
- payment_provider — VARCHAR(50) — NOT NULL
- provider_event_identifier — VARCHAR(200) — NOT NULL
- idempotency_key — VARCHAR(200) — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
- initiated_by_user_id — UUID — Foreign key → users.user_id
- amount_krw — BIGINT — NOT NULL
- payment_status — VARCHAR(30) — NOT NULL
- failure_code — VARCHAR(100)
- failure_message — TEXT
- approved_at — TIMESTAMPTZ
- cancelled_at — TIMESTAMPTZ
- provider_payload — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
plans
- plan_id — UUID — Primary key — NOT NULL
- plan_code — VARCHAR(50) — NOT NULL
- plan_name — VARCHAR(100) — NOT NULL
- billing_cycle — VARCHAR(30) — NOT NULL
- price_krw — BIGINT — NOT NULL
- included_request_count — INTEGER — NOT NULL
- coaching_session_quota — INTEGER — NOT NULL
- company_seat_limit — INTEGER
- default_workspace_seat_limit — INTEGER
- plan_version — INTEGER — NOT NULL
- plan_active — BOOLEAN — NOT NULL
- effective_from — DATE — NOT NULL
- effective_until — DATE
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
policy_versions
- policy_version_id — UUID — Primary key — NOT NULL
- policy_type — VARCHAR(30) — NOT NULL
- version_label — VARCHAR(50) — NOT NULL
- content_hash — CHAR(64) — NOT NULL
- change_summary — TEXT — NOT NULL
- document_storage_key — VARCHAR(500) — NOT NULL
- published_at — TIMESTAMPTZ — NOT NULL
- effective_at — TIMESTAMPTZ — NOT NULL
- created_by_operator_user_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
report_versions
- report_version_id — UUID — Primary key — NOT NULL
- report_id — UUID — Foreign key → reports.report_id — NOT NULL
- version_number — INTEGER — NOT NULL
- schema_version — INTEGER — NOT NULL
- headline — VARCHAR(200) — NOT NULL
- content — JSONB — NOT NULL
- version_status — VARCHAR(30) — NOT NULL
- created_by_operator_user_id — UUID — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
reports
- report_id — UUID — Primary key — NOT NULL
- public_code — VARCHAR(50) — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- report_type — VARCHAR(30) — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- subject_user_id — UUID — Foreign key → users.user_id
- report_status — VARCHAR(30) — NOT NULL
- published_version_id — UUID — Foreign key → report_versions.report_version_id
- published_by_operator_user_id — UUID
- published_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
request_attachments
- request_attachment_id — UUID — Primary key — NOT NULL
- advisory_request_id — UUID — Foreign key → advisory_requests.advisory_request_id — NOT NULL
- uploaded_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- original_filename — VARCHAR(500) — NOT NULL
- object_storage_key — VARCHAR(500) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- file_size_bytes — BIGINT — NOT NULL
- malware_scan_status — VARCHAR(30) — NOT NULL
- uploaded_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
request_events
- request_event_id — UUID — Primary key — NOT NULL
- advisory_request_id — UUID — Foreign key → advisory_requests.advisory_request_id — NOT NULL
- actor_reference_id — UUID
- actor_scope — VARCHAR(30) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- previous_status — VARCHAR(30)
- new_status — VARCHAR(30)
- change_reason — TEXT
- previous_values — JSONB
- new_values — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
request_replies
- request_reply_id — UUID — Primary key — NOT NULL
- advisory_request_id — UUID — Foreign key → advisory_requests.advisory_request_id — NOT NULL
- version_number — INTEGER — NOT NULL
- reply_body — TEXT — NOT NULL
- reply_status — VARCHAR(30) — NOT NULL
- created_by_operator_user_id — UUID — NOT NULL
- failure_message — TEXT
- idempotency_key — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
subscriptions
- subscription_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- plan_id — UUID — Foreign key → plans.plan_id — NOT NULL
- purchased_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- billing_contact_user_id — UUID — Foreign key → users.user_id
- subscription_status — VARCHAR(30) — NOT NULL
- payment_method_type — VARCHAR(30) — NOT NULL
- payment_method_reference — VARCHAR(500)
- current_period_start — TIMESTAMPTZ — NOT NULL
- current_period_end — TIMESTAMPTZ — NOT NULL
- next_billing_at — TIMESTAMPTZ
- cancellation_requested_at — TIMESTAMPTZ
- cancellation_effective_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
usage_events
- usage_event_id — UUID — Primary key — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id
- event_type — VARCHAR(30) — NOT NULL
- quantity — INTEGER — NOT NULL
- source_entity_type — VARCHAR(50) — NOT NULL
- source_entity_id — UUID — NOT NULL
- metadata — JSONB
- occurred_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
user_consents
- user_consent_id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id
- policy_version_id — UUID — Foreign key → policy_versions.policy_version_id — NOT NULL
- consent_channel — VARCHAR(30) — NOT NULL
- consent_decision — VARCHAR(30) — NOT NULL
- decided_at — TIMESTAMPTZ — NOT NULL
- withdrawn_at — TIMESTAMPTZ
- ip_address — INET
- user_agent — VARCHAR(500)
- evidence — JSONB
users
- user_id — UUID — Primary key — NOT NULL
- email — VARCHAR(320) — NOT NULL
- full_name — VARCHAR(100) — NOT NULL
- profile_image_storage_key — VARCHAR(500)
- account_status — VARCHAR(30) — NOT NULL
- email_verified — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
workspace_memberships
- workspace_membership_id — UUID — Primary key — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- workspace_role — VARCHAR(30) — NOT NULL
- membership_status — VARCHAR(30) — NOT NULL
- invited_by_user_id — UUID — Foreign key → users.user_id
- joined_at — TIMESTAMPTZ
- suspended_at — TIMESTAMPTZ
- revoked_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
workspace_resource_budgets
- workspace_resource_budget_id — UUID — Primary key — NOT NULL
- subscription_id — UUID — Foreign key → subscriptions.subscription_id — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.workspace_id — NOT NULL
- resource_type — VARCHAR(30) — NOT NULL
- period_start — DATE — NOT NULL
- period_end — DATE — NOT NULL
- allocated_quantity — INTEGER — NOT NULL
- hard_limit_enabled — BOOLEAN — NOT NULL
- allocation_status — VARCHAR(30) — NOT NULL
- allocated_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
workspaces
- workspace_id — UUID — Primary key — NOT NULL
- company_id — UUID — Foreign key → companies.company_id — NOT NULL
- organization_unit_id — UUID — Foreign key → organization_units.organization_unit_id
- workspace_name — VARCHAR(200) — NOT NULL
- workspace_slug — VARCHAR(100) — NOT NULL
- workspace_type — VARCHAR(30) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- default_language — VARCHAR(30) — NOT NULL
- workspace_status — VARCHAR(30) — NOT NULL
- created_by_user_id — UUID — Foreign key → users.user_id — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- archived_at — TIMESTAMPTZ