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