models

type AcknowledgmentStatus string

type AcknowledgmentVia string

type ActionItem struct {
	ID           uuid.UUID        `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	PostMortemID uuid.UUID        `gorm:"type:uuid;not null;index" json:"post_mortem_id"`
	Title        string           `gorm:"type:varchar(500);not null" json:"title"`
	Owner        *string          `gorm:"type:varchar(255)" json:"owner,omitempty"`
	DueDate      *time.Time       `json:"due_date,omitempty"`
	Status       ActionItemStatus `gorm:"type:varchar(20);not null;default:'open'" json:"status"`
	CreatedAt    time.Time        `gorm:"not null;default:now()" json:"created_at"`
	UpdatedAt    time.Time        `gorm:"not null;default:now()" json:"updated_at"`
}

type ActionItemStatus string

type Alert struct {
	ID          uuid.UUID     `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	ExternalID  string        `gorm:"type:varchar(255);not null" json:"external_id"`
	Source      string        `gorm:"type:varchar(100);not null" json:"source"`
	Fingerprint string        `gorm:"type:varchar(255);index" json:"fingerprint"`
	Status      AlertStatus   `gorm:"type:varchar(50);not null;default:'firing'" json:"status"`
	Severity    AlertSeverity `gorm:"type:varchar(50);not null;default:'info'" json:"severity"`
	Title       string        `gorm:"type:varchar(500);not null" json:"title"`
	Description string        `gorm:"type:text" json:"description"`
	Labels      JSONB         `gorm:"type:jsonb;default:'{}'" json:"labels"`
	Annotations JSONB         `gorm:"type:jsonb;default:'{}'" json:"annotations"`
	RawPayload  JSONB         `gorm:"type:jsonb" json:"raw_payload"`
	StartedAt   time.Time     `gorm:"type:timestamptz;not null" json:"started_at"`
	EndedAt     *time.Time    `gorm:"type:timestamptz" json:"ended_at"`
	ReceivedAt  time.Time     `gorm:"type:timestamptz;not null;default:now()" json:"received_at"`
	CreatedAt   time.Time     `gorm:"type:timestamptz;not null;default:now()" json:"created_at"`

	// EscalationPolicyID links this alert to the escalation policy assigned by
	// the routing engine.  Nil means no escalation is configured for this alert.
	EscalationPolicyID *uuid.UUID `gorm:"type:uuid;index" json:"escalation_policy_id,omitempty"`

	// AcknowledgmentStatus is the alert-level ack state driven by the escalation
	// engine. Denormalized from escalation_states for fast querying without a join.
	AcknowledgmentStatus AcknowledgmentStatus `gorm:"type:varchar(50);not null;default:'pending'" json:"acknowledgment_status"`
}

type AlertSeverity string

type AlertStatus string

type EscalationPolicy struct {
	// ID is the unique identifier for this policy.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// Name is a human-readable label.
	// Example: "Platform Team Default"
	Name string `gorm:"type:varchar(255);not null" json:"name"`

	// Description explains when and why this policy is used.
	Description string `gorm:"type:text;default:''" json:"description"`

	// Enabled controls whether this policy is evaluated by the engine.
	// Disabled policies are never triggered even if a routing rule references them.
	Enabled bool `gorm:"not null;default:true" json:"enabled"`

	// CreatedAt is when this policy was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`

	// UpdatedAt is when this policy was last modified.
	UpdatedAt time.Time `gorm:"not null;default:now()" json:"updated_at"`

	// Tiers are loaded via repository.GetPolicyWithTiers — not auto-loaded by GORM.
	Tiers []EscalationTier `gorm:"-" json:"tiers,omitempty"`
}

type EscalationSeverityRule struct {
	ID                 uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	Severity           string    `gorm:"type:varchar(50);not null;uniqueIndex"          json:"severity"`
	EscalationPolicyID uuid.UUID `gorm:"type:uuid;not null"                             json:"escalation_policy_id"`
	CreatedAt          time.Time `gorm:"not null;default:now()"                         json:"created_at"`
	UpdatedAt          time.Time `gorm:"not null;default:now()"                         json:"updated_at"`
}

type EscalationState struct {
	// ID is the unique identifier for this state row.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// AlertID is set for alert-sourced escalations (nullable for incident escalations).
	AlertID *uuid.UUID `gorm:"type:uuid;uniqueIndex" json:"alert_id,omitempty"`

	// IncidentID is set for incident-sourced (manual) escalations.
	IncidentID *uuid.UUID `gorm:"type:uuid;index" json:"incident_id,omitempty"`

	// SourceType distinguishes alert vs. incident escalations.
	SourceType string `gorm:"type:varchar(20);not null;default:'alert'" json:"source_type"`

	// PolicyID is the escalation policy driving this escalation.
	PolicyID uuid.UUID `gorm:"type:uuid;not null;index" json:"policy_id"`

	// CurrentTierIndex is the tier that was most recently notified.
	// Starts at 0; incremented by the worker on timeout.
	CurrentTierIndex int `gorm:"not null;default:0" json:"current_tier_index"`

	// Status reflects the current lifecycle stage of this escalation.
	Status EscalationStateStatus `gorm:"type:varchar(50);not null;default:'pending'" json:"status"`

	// LastNotifiedAt is when the current tier's notifications were last sent.
	// Nil means tier 0 has not yet been notified (status == pending).
	LastNotifiedAt *time.Time `gorm:"type:timestamptz" json:"last_notified_at,omitempty"`

	// AcknowledgedAt is when the escalation was stopped by a user.
	// Nil means not yet acknowledged.
	AcknowledgedAt *time.Time `gorm:"type:timestamptz" json:"acknowledged_at,omitempty"`

	// AcknowledgedBy is the user_name of whoever acknowledged the alert.
	AcknowledgedBy *string `gorm:"type:varchar(255)" json:"acknowledged_by,omitempty"`

	// AcknowledgedVia records the channel used: "slack", "api", or "cli".
	AcknowledgedVia *AcknowledgmentVia `gorm:"type:varchar(50)" json:"acknowledged_via,omitempty"`

	// CreatedAt is when this escalation was triggered (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
}

type EscalationStateStatus string

type EscalationTargetType string

type EscalationTier struct {
	// ID is the unique identifier for this tier.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// PolicyID is the parent escalation policy.
	PolicyID uuid.UUID `gorm:"type:uuid;not null;index" json:"policy_id"`

	// TierIndex is the 0-based position in the escalation chain.
	// A UNIQUE constraint on (policy_id, tier_index) is enforced by the DB.
	TierIndex int `gorm:"not null;default:0" json:"tier_index"`

	// TimeoutSeconds is how long to wait at this tier before advancing.
	// Minimum 1 second; typical values are 300 (5 min) or 600 (10 min).
	TimeoutSeconds int `gorm:"not null;default:300" json:"timeout_seconds"`

	// TargetType defines which targets are notified.
	TargetType EscalationTargetType `gorm:"type:varchar(50);not null;default:'schedule'" json:"target_type"`

	// ScheduleID is the schedule whose on-call user will be notified.
	// Nullable: nil means no schedule target (only relevant when TargetType is
	// "schedule" or "both").  Set to nil if the referenced schedule is deleted.
	ScheduleID *uuid.UUID `gorm:"type:uuid;index" json:"schedule_id,omitempty"`

	// UserNames is a list of free-text user identifiers to notify directly.
	// Mirrors the user_name convention used in schedule_participants.
	// Example: ["alice", "@bob", "Carol Smith"]
	UserNames JSONBArray `gorm:"type:jsonb;not null;default:'[]'" json:"user_names"`

	// CreatedAt is when this tier was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
}

type GroupingRule struct {
	// ID is the unique identifier for this grouping rule
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// Name is a human-readable identifier for this rule
	// Example: "Group by service and environment"
	Name string `gorm:"type:varchar(255);not null" json:"name"`

	// Description explains what this rule does and why it exists
	// Example: "Groups alerts from the same service in the same environment..."
	Description string `gorm:"type:text;default:''" json:"description"`

	// Enabled controls whether this rule is active
	// Disabled rules are skipped during alert processing
	Enabled bool `gorm:"not null" json:"enabled"`

	// Priority determines evaluation order (lower number = higher priority)
	// Rules are evaluated in ascending priority order until one matches
	// Example: Priority 1 is evaluated before Priority 100
	// UNIQUE constraint ensures no two rules have the same priority
	Priority int `gorm:"not null;uniqueIndex:idx_grouping_rules_priority" json:"priority"`

	// MatchLabels defines which alerts this rule applies to
	// Stored as JSONB map[string]string
	//
	// Matching logic:
	//   - Empty map {} matches all alerts
	//   - {"alertname": "*"} matches all alerts (wildcard)
	//   - {"alertname": "HighCPU"} matches alerts with exactly that alertname
	//   - {"service": "api", "env": "prod"} matches alerts with both labels
	//
	// Example: {"service": "*", "severity": "critical"} matches all critical alerts
	// that have a service label (regardless of value)
	MatchLabels JSONB `gorm:"type:jsonb;not null;default:'{}'" json:"match_labels"`

	// TimeWindowSeconds defines the grouping time window in seconds
	//
	// Alerts are grouped if:
	//   1. They match the same rule
	//   2. They have the same group key (derived from labels)
	//   3. An open incident exists within this time window
	//
	// Example: 300 (5 minutes) means alerts within 5 minutes are grouped together
	//
	// Use cases:
	//   - Short window (60s): Group rapid-fire alerts from same issue
	//   - Medium window (300s): Group related alerts during incident
	//   - Long window (3600s): Group slow-developing issues
	TimeWindowSeconds int `gorm:"not null;default:300" json:"time_window_seconds"`

	// CrossSourceLabels enables grouping alerts from different monitoring sources
	// Stored as JSONB []string
	//
	// When specified, alerts from different sources (prometheus, grafana, cloudwatch)
	// can be grouped together if they share the same values for these labels.
	//
	// Example: ["service", "env"] means:
	//   - Prometheus alert: {service: "api", env: "prod"}
	//   - Grafana alert: {service: "api", env: "prod"}
	//   → Both alerts grouped into same incident
	//
	// Use cases:
	//   - Cross-monitoring correlation: Same service failing in both Prometheus and Grafana
	//   - Multi-region deployments: Correlate alerts across CloudWatch regions
	//
	// Default: [] (empty array) means no cross-source grouping
	CrossSourceLabels JSONBArray `gorm:"type:jsonb;default:'[]'" json:"cross_source_labels"`

	// CreatedAt is when this rule was created (immutable)
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`

	// UpdatedAt is when this rule was last modified
	UpdatedAt time.Time `gorm:"not null;default:now()" json:"updated_at"`
}

type Incident struct {
	ID             uuid.UUID        `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	IncidentNumber int              `gorm:"autoIncrement;unique;not null" json:"incident_number"`
	Title          string           `gorm:"type:varchar(500);not null" json:"title"`
	Slug           string           `gorm:"type:varchar(100);not null" json:"slug"`
	Status         IncidentStatus   `gorm:"type:varchar(20);not null;default:'triggered';index:idx_incidents_status" json:"status"`
	Severity       IncidentSeverity `gorm:"type:varchar(20);not null;default:'medium';index:idx_incidents_severity" json:"severity"`
	Summary        string           `gorm:"type:text" json:"summary,omitempty"`

	// Slack integration
	SlackChannelID   string `gorm:"type:varchar(50)" json:"slack_channel_id,omitempty"`
	SlackChannelName string `gorm:"type:varchar(100)" json:"slack_channel_name,omitempty"`
	SlackMessageTS   string `gorm:"type:varchar(64)" json:"slack_message_ts,omitempty"`

	// Teams integration (v0.8+)
	// TeamsChannelID is the channel ID in the format "19:xxx@thread.tacv2"
	// TeamsConversationID is the Bot Framework conversation ID (a:xxx) — distinct from channel ID,
	// required for proactive messaging via Bot Framework REST API (v0.9+)
	// TeamsActivityID is the ID of the root adaptive card posted in the channel (used for updates)
	TeamsChannelID      *string `gorm:"type:varchar(255)" json:"teams_channel_id,omitempty"`
	TeamsChannelName    *string `gorm:"type:varchar(255)" json:"teams_channel_name,omitempty"`
	TeamsConversationID *string `gorm:"type:varchar(500)" json:"teams_conversation_id,omitempty"`
	TeamsActivityID     *string `gorm:"type:varchar(1024)" json:"teams_activity_id,omitempty"`

	// Timestamps (created_at and triggered_at are immutable)
	CreatedAt      time.Time  `gorm:"not null;default:now()" json:"created_at"`
	TriggeredAt    time.Time  `gorm:"not null;default:now();index:idx_incidents_triggered_at" json:"triggered_at"`
	AcknowledgedAt *time.Time `json:"acknowledged_at,omitempty"`
	ResolvedAt     *time.Time `json:"resolved_at,omitempty"`

	// Ownership
	CreatedByType string     `gorm:"type:varchar(20);not null" json:"created_by_type"`
	CreatedByID   string     `gorm:"type:varchar(100)" json:"created_by_id,omitempty"`
	CommanderID   *uuid.UUID `gorm:"type:uuid" json:"commander_id,omitempty"`
	CommanderName string     `gorm:"-" json:"-"` // resolved at service layer, never stored

	// Metadata
	Labels       JSONB `gorm:"type:jsonb;default:'{}'" json:"labels"`
	CustomFields JSONB `gorm:"type:jsonb;default:'{}'" json:"custom_fields"`

	// Grouping (v0.3+)
	// GroupKey is a hash derived from alert labels according to grouping rules
	// Alerts with the same group_key (within time window) are grouped into this incident
	// NULL for manually created incidents or incidents created before v0.3
	GroupKey *string `gorm:"type:varchar(64);index:idx_incidents_group_key_status_created" json:"group_key,omitempty"`

	// AIEnabled controls whether AI agents process this incident.
	// Default true. Can be set false via routing rules, integration defaults, or the Properties panel.
	AIEnabled bool `gorm:"not null;default:true;column:ai_enabled" json:"ai_enabled"`

	// AI Summarization (v0.6+)
	// AISummary is an on-demand AI-generated summary, distinct from the manual Summary field.
	// AISummaryGeneratedAt records when the summary was last regenerated.
	AISummary            *string    `gorm:"type:text" json:"ai_summary,omitempty"`
	AISummaryGeneratedAt *time.Time `gorm:"type:timestamptz" json:"ai_summary_generated_at,omitempty"`

	// Relationships (not in database, loaded via joins)
	Alerts []Alert `gorm:"many2many:incident_alerts;" json:"alerts,omitempty"`
}

type IncidentSeverity string

type IncidentStatus string

type JSONB map[string]interface{}

type JSONBArray []string

type LocalSession struct {
	Token     string    `gorm:"type:text;primaryKey"           json:"-"`
	UserID    uuid.UUID `gorm:"type:uuid;not null;index"        json:"-"`
	ExpiresAt time.Time `gorm:"not null"                        json:"-"`
	CreatedAt time.Time `gorm:"not null;default:now()"          json:"-"`
}

type PostMortem struct {
	ID           uuid.UUID        `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	IncidentID   uuid.UUID        `gorm:"type:uuid;not null;uniqueIndex:idx_post_mortems_incident_id" json:"incident_id"`
	TemplateID   *uuid.UUID       `gorm:"type:uuid" json:"template_id,omitempty"`
	TemplateName string           `gorm:"type:varchar(100);not null;default:'Standard'" json:"template_name"`
	Status       PostMortemStatus `gorm:"type:varchar(20);not null;default:'draft'" json:"status"`
	Content      string           `gorm:"type:text;not null;default:''" json:"content"`
	GeneratedBy  string           `gorm:"type:varchar(20);not null;default:'ai'" json:"generated_by"`
	GeneratedAt  *time.Time       `json:"generated_at,omitempty"`
	PublishedAt  *time.Time       `json:"published_at,omitempty"`
	CreatedByID  string           `gorm:"type:varchar(255);not null;default:'system'" json:"created_by_id"`
	CreatedAt    time.Time        `gorm:"not null;default:now()" json:"created_at"`
	UpdatedAt    time.Time        `gorm:"not null;default:now()" json:"updated_at"`

	// Relationships (loaded explicitly, not by GORM auto-join)
	ActionItems []ActionItem `gorm:"-" json:"action_items,omitempty"`
}

type PostMortemComment struct {
	ID           uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	PostMortemID uuid.UUID `gorm:"type:uuid;not null;index"                       json:"post_mortem_id"`
	AuthorID     string    `gorm:"type:varchar(255);not null;default:'anonymous'" json:"author_id"`
	AuthorName   string    `gorm:"type:varchar(255);not null;default:'Unknown'"   json:"author_name"`
	Content      string    `gorm:"type:text;not null"                             json:"content"`
	CreatedAt    time.Time `gorm:"not null;default:now()"                         json:"created_at"`
}

type PostMortemStatus string

type PostMortemTemplate struct {
	ID          uuid.UUID  `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	Name        string     `gorm:"type:varchar(100);not null;uniqueIndex" json:"name"`
	Description string     `gorm:"type:text;not null;default:''" json:"description"`
	Sections    JSONBArray `gorm:"type:jsonb;not null;default:'[]'" json:"sections"`
	IsBuiltIn   bool       `gorm:"not null;default:false" json:"is_built_in"`
	CreatedAt   time.Time  `gorm:"not null;default:now()" json:"created_at"`
	UpdatedAt   time.Time  `gorm:"not null;default:now()" json:"updated_at"`
}

type RotationType string

type RoutingRule struct {
	// ID is the unique identifier for this routing rule
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// Name is a human-readable identifier for this rule
	Name string `gorm:"type:varchar(255);not null" json:"name"`

	// Description explains what this rule does and why it exists
	Description string `gorm:"type:text;default:''" json:"description"`

	// Enabled controls whether this rule is active
	Enabled bool `gorm:"not null;default:true" json:"enabled"`

	// Priority determines evaluation order (lower number = higher priority).
	// UNIQUE constraint ensures no two rules share the same priority.
	Priority int `gorm:"not null;uniqueIndex:idx_routing_rules_priority" json:"priority"`

	// MatchCriteria defines which alerts this rule applies to (JSONB).
	// Empty map {} matches all alerts.
	MatchCriteria JSONB `gorm:"type:jsonb;not null;default:'{}'" json:"match_criteria"`

	// Actions defines what to do when this rule matches (JSONB).
	// Supported keys: create_incident, suppress, severity_override, channel_override.
	Actions JSONB `gorm:"type:jsonb;not null;default:'{}'" json:"actions"`

	// CreatedAt is when this rule was created (immutable)
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`

	// UpdatedAt is when this rule was last modified
	UpdatedAt time.Time `gorm:"not null;default:now()" json:"updated_at"`
}

type Schedule struct {
	// ID is the unique identifier for this schedule.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// Name is a human-readable label.
	// Example: "Platform Team Primary"
	Name string `gorm:"type:varchar(255);not null" json:"name"`

	// Description explains the purpose of this schedule.
	Description string `gorm:"type:text;default:''" json:"description"`

	// Timezone is an IANA timezone string used for shift boundary calculations.
	// Example: "America/New_York", "UTC"
	Timezone string `gorm:"type:varchar(100);not null;default:'UTC'" json:"timezone"`

	// NotificationChannel is an optional Slack channel or other destination
	// to post shift-change notifications to. Free-form string; may be empty.
	// Example: "#oncall-platform"
	NotificationChannel string `gorm:"type:varchar(255);default:''" json:"notification_channel"`

	// DefaultEscalationPolicyID optionally links this schedule to an escalation
	// policy that fires when alerts are routed to this schedule but no explicit
	// policy is set on the routing rule.
	DefaultEscalationPolicyID *uuid.UUID `gorm:"type:uuid" json:"default_escalation_policy_id,omitempty"`

	// CreatedAt is when this schedule was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`

	// UpdatedAt is when this schedule was last modified.
	UpdatedAt time.Time `gorm:"not null;default:now()" json:"updated_at"`

	// Layers are loaded via GetWithLayers — not auto-loaded by GORM.
	// Populated only when explicitly fetched.
	Layers []ScheduleLayer `gorm:"-" json:"layers,omitempty"`

	// HolidayCountries is the list of ISO 3166-1 country codes for which public
	// holidays are surfaced on this schedule. Loaded separately from
	// schedule_holiday_configs; not a real column on the schedules table.
	HolidayCountries []string `gorm:"-" json:"holiday_countries"`
}

type ScheduleHoliday struct {
	ID          uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	ScheduleID  uuid.UUID `gorm:"type:uuid;not null;index"                      json:"schedule_id"`
	CountryCode string    `gorm:"type:varchar(10);not null"                     json:"country_code"`
	Date        time.Time `gorm:"type:date;not null"                            json:"date"`
	Name        string    `gorm:"type:varchar(255);not null"                    json:"name"`
	CreatedAt   time.Time `gorm:"not null;default:now()"                        json:"created_at"`
}

type ScheduleLayer struct {
	// ID is the unique identifier for this layer.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// ScheduleID is the parent schedule.
	ScheduleID uuid.UUID `gorm:"type:uuid;not null;index" json:"schedule_id"`

	// Name is a human-readable label.
	// Example: "Primary", "Secondary"
	Name string `gorm:"type:varchar(255);not null" json:"name"`

	// OrderIndex determines evaluation precedence. Lower wins.
	// 0 = primary, 1 = secondary, etc.
	OrderIndex int `gorm:"not null;default:0" json:"order_index"`

	// RotationType defines the cadence: "daily", "weekly", or "custom".
	RotationType RotationType `gorm:"type:varchar(50);not null;default:'weekly'" json:"rotation_type"`

	// RotationStart is the epoch from which shift slots are computed.
	// Defaults to midnight UTC on the day the layer is created.
	// All slot boundaries are: RotationStart + N * ShiftDurationSeconds.
	RotationStart time.Time `gorm:"not null" json:"rotation_start"`

	// ShiftDurationSeconds is the length of one shift in seconds.
	// For "daily" this is 86400, for "weekly" 604800.
	// For "custom" the caller sets it explicitly.
	ShiftDurationSeconds int `gorm:"not null;default:604800" json:"shift_duration_seconds"`

	// CreatedAt is when this layer was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`

	// Participants are loaded alongside the layer — not auto-loaded by GORM.
	Participants []ScheduleParticipant `gorm:"-" json:"participants,omitempty"`
}

type ScheduleOverride struct {
	// ID is the unique identifier for this override.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// ScheduleID is the parent schedule.
	ScheduleID uuid.UUID `gorm:"type:uuid;not null;index" json:"schedule_id"`

	// OverrideUser is the user taking over on-call during this window.
	OverrideUser string `gorm:"type:varchar(255);not null" json:"override_user"`

	// StartTime is the beginning of the override window (inclusive).
	StartTime time.Time `gorm:"not null" json:"start_time"`

	// EndTime is the end of the override window (exclusive).
	EndTime time.Time `gorm:"not null" json:"end_time"`

	// CreatedBy is the user_name of whoever created this override.
	CreatedBy string `gorm:"type:varchar(255);not null;default:'system'" json:"created_by"`

	// CreatedAt is when this override was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
}

type ScheduleParticipant struct {
	// ID is the unique identifier for this participant slot.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// LayerID is the parent layer.
	LayerID uuid.UUID `gorm:"type:uuid;not null;index" json:"layer_id"`

	// UserName is the display name or identifier for the on-call person.
	// Free-text; not a foreign key. Examples: "alice", "@alice", "Alice Smith".
	UserName string `gorm:"type:varchar(255);not null" json:"user_name"`

	// OrderIndex determines the rotation order within the layer.
	// Slot 0 is on-call first from RotationStart, then slot 1, etc.
	OrderIndex int `gorm:"not null;default:0" json:"order_index"`

	// CreatedAt is when this participant was added (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
}

type ScheduleUnavailability struct {
	// ID is the unique identifier for this unavailability record.
	ID uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`

	// ScheduleID is the parent schedule.
	ScheduleID uuid.UUID `gorm:"type:uuid;not null;index" json:"schedule_id"`

	// UserName is the user who is unavailable.
	UserName string `gorm:"type:varchar(255);not null" json:"user_name"`

	// StartDate is the first day of unavailability (inclusive, stored as DATE).
	StartDate time.Time `gorm:"type:date;not null" json:"start_date"`

	// EndDate is the last day of unavailability (inclusive, stored as DATE).
	EndDate time.Time `gorm:"type:date;not null" json:"end_date"`

	// Reason is an optional human-readable explanation (e.g., "PTO", "sick leave").
	Reason string `gorm:"type:varchar(500)" json:"reason,omitempty"`

	// CreatedBy is the user_name of whoever created this record.
	CreatedBy string `gorm:"type:varchar(255);not null;default:'system'" json:"created_by"`

	// CreatedAt is when this record was created (immutable, server-generated).
	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
}

type SlackConfig struct {
	ID                int        `gorm:"primaryKey;default:1"`
	BotToken          string     `gorm:"column:bot_token"`
	SigningSecret     string     `gorm:"column:signing_secret"`
	AppToken          string     `gorm:"column:app_token"`
	WorkspaceID       string     `gorm:"column:workspace_id"`
	WorkspaceName     string     `gorm:"column:workspace_name"`
	BotUserID         string     `gorm:"column:bot_user_id"`
	OAuthClientID     string     `gorm:"column:oauth_client_id"`
	OAuthClientSecret string     `gorm:"column:oauth_client_secret"`
	ConnectedAt       time.Time  `gorm:"column:connected_at;autoCreateTime"`
	ConnectedBy       *uuid.UUID `gorm:"column:connected_by"`
}

type SystemSetting struct {
	Key       string    `gorm:"primaryKey"      json:"key"`
	Value     string    `gorm:"type:jsonb"      json:"value"`
	UpdatedAt time.Time `gorm:"not null;autoUpdateTime" json:"updated_at"`
}

type TeamsConfig struct {
	ID          int        `gorm:"primaryKey;default:1"`
	AppID       string     `gorm:"column:app_id"`
	AppPassword string     `gorm:"column:app_password"`
	TenantID    string     `gorm:"column:tenant_id"`
	TeamID      string     `gorm:"column:team_id"`
	BotUserID   string     `gorm:"column:bot_user_id"`
	ServiceURL  string     `gorm:"column:service_url"`
	TeamName    string     `gorm:"column:team_name"`
	ConnectedAt time.Time  `gorm:"column:connected_at;autoCreateTime"`
	ConnectedBy *uuid.UUID `gorm:"column:connected_by"`
}

type TelegramConfig struct {
	ID          int        `gorm:"primaryKey;default:1"`
	BotToken    string     `gorm:"column:bot_token"`
	ChatID      string     `gorm:"column:chat_id"`
	ChatName    string     `gorm:"column:chat_name"`
	ConnectedAt time.Time  `gorm:"column:connected_at;autoCreateTime"`
	ConnectedBy *uuid.UUID `gorm:"column:connected_by"`
}

type TimelineEntry struct {
	ID         uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	IncidentID uuid.UUID `gorm:"type:uuid;not null;index:idx_timeline_incident_timestamp" json:"incident_id"`
	Timestamp  time.Time `gorm:"not null;default:now();index:idx_timeline_incident_timestamp" json:"timestamp"`
	Type       string    `gorm:"type:varchar(50);not null" json:"type"`
	ActorType  string    `gorm:"type:varchar(20);not null" json:"actor_type"`
	ActorID    string    `gorm:"type:varchar(100)" json:"actor_id,omitempty"`
	Content    JSONB     `gorm:"type:jsonb;not null" json:"content"`
	CreatedAt  time.Time `gorm:"not null;default:now()" json:"created_at"`

	// Relationship
	Incident *Incident `gorm:"foreignKey:IncidentID" json:"incident,omitempty"`
}

type User struct {
	ID    uuid.UUID `gorm:"type:uuid;primaryKey;default:gen_random_uuid()" json:"id"`
	Email string    `gorm:"type:varchar(255);not null;uniqueIndex"          json:"email"`
	Name  string    `gorm:"type:varchar(255);not null;default:''"           json:"name"`

	// SAMLSubject is the NameID from the SAML assertion — immutable after first login.
	// Nullable so that locally-authenticated users can be stored without a SAML subject.
	SAMLSubject   *string `gorm:"type:varchar(500);uniqueIndex;column:saml_subject" json:"-"`
	SAMLIDPIssuer string  `gorm:"type:varchar(500);not null;default:'';column:saml_idp_issuer" json:"-"`

	// Local auth fields — only set for auth_source='local'.
	PasswordHash *string `gorm:"type:text;column:password_hash" json:"-"`
	AuthSource   string  `gorm:"type:varchar(20);not null;default:'saml';column:auth_source" json:"-"`

	// AgentType identifies AI agent accounts. NULL for all human users.
	// Valid values: "postmortem", "triage", "comms", "oncall", "commander"
	AgentType *string `gorm:"type:varchar(50);column:agent_type" json:"agent_type,omitempty"`

	// Active controls whether this user (or agent) can operate.
	// Defaults to true for all existing rows via migration.
	Active bool `gorm:"not null;default:true;column:active" json:"active"`

	// SlackUserID is the Slack member ID (e.g. U0AJLLY3678).
	// Set automatically when user is imported from Slack, or manually by admin.
	// Used to invite on-call responders to incident channels and send DMs.
	SlackUserID *string `gorm:"type:varchar(20);column:slack_user_id" json:"slack_user_id,omitempty"`

	// TeamsUserID is the Azure AD Object ID (e.g. 29dcb621-b60b-4b3d-aa41-...).
	// Set automatically when user is imported from Teams, or manually by admin.
	// Used to send proactive Adaptive Card DMs via Bot Framework.
	TeamsUserID *string `gorm:"type:varchar(255);column:teams_user_id" json:"teams_user_id,omitempty"`

	Role        UserRole   `gorm:"type:varchar(50);not null;default:'member'" json:"role"`
	LastLoginAt *time.Time `json:"last_login_at,omitempty"`

	CreatedAt time.Time `gorm:"not null;default:now()" json:"created_at"`
	UpdatedAt time.Time `gorm:"not null;default:now()" json:"updated_at"`
}

type UserRole string