CriticalHeroERD

Tables (6)

Incident (장애/인시던트)

  • incident_id (Pk) — UUID — Primary key — NOT NULL
  • repository_id (Fk) — UUID — Foreign key → Repository.repository_id — NOT NULL
  • title (에러 제목) — VARCHAR
  • status (상태(OPEN, ANALYZING, RESOLVED)) — VARCHAR
  • slack_thread_ts (슬랙에 보고한 스래드의 타임스탬프) — VARCHAR
  • created_at (생성시점) — TIMESTAMP
  • resolved_at (해결시점) — TIMESTAMP
  • updated_at (수정시점) — TIMESTAMP

Integration (외부 연동 인증 정보)

  • integration_id (Pk) — UUID — Primary key — NOT NULL
  • workspace_id (FK) — UUID — Foreign key → Workspace.workspace_id — NOT NULL
  • provider (연동 플랫폼(GITHUB, NOTION, PROMETHEUS)) — VARCHAR
  • access_token (암호화된 API 토큰) — VARCHAR
  • status (연동 상태(ACTIVE, ERROR)) — VARCHAR
  • created_at (생성일시) — TIMESTAMP
  • updated_at (수정일시) — TIMESTAMP

Postmortem (사후 분석서)

  • postmortem_id (Pk) — UUID — Primary key — NOT NULL
  • incident_id (FK) — UUID — Foreign key → Incident.incident_id — NOT NULL
  • notion_page_url (생성된 노션 페이지 링크) — VARCHAR
  • content (사후 분석서 내용) — TEXT
  • created_at (생성시점) — TIMESTAMP
  • updated_at (수정시점) — TIMESTAMP

Repository (저장소)

  • repository_id (Pk) — UUID — Primary key — NOT NULL
  • workspace_id (FK) — UUID — Foreign key → Workspace.workspace_id — NOT NULL
  • github_repo_id (깃허브 상의 레포지토리 ID) — VARCHAR
  • name (레포지토리 이름) — VARCHAR
  • url (레포지토리 주소) — VARCHAR
  • is_tracking (현재 추적 중인지 여부) — BOOLEAN
  • created_at (생성일시) — TIMESTAMP
  • updated_at (수정일시) — TIMESTAMP

User (사용자)

  • user_id (Pk) — UUID — Primary key — NOT NULL
  • workspace_id (어떤 워크스페이스 소속인지) — UUID — Foreign key → Workspace.workspace_id — NOT NULL
  • slack_user_id (슬랙 유저 고유 ID) — VARCHAR
  • name (유저 이름) — VARCHAR
  • email (이메일) — VARCHAR
  • role (권한(ADMIN,USER)) — VARCHAR

Workspace (워크스페이스)

  • workspace_id (Pk) — UUID — Primary key — NOT NULL
  • slack_team_id (슬랙 워크스페이스 고유 ID) — VARCHAR
  • name (워크스페이스 이름) — VARCHAR
  • created_at (생성일시) — TIMESTAMP
  • updated_at (수정일시) — TIMESTAMP