test

Tables (5)

a11y_issues

  • issue_id — UUID
  • scan_id — UUID — Foreign key → scan_sessions.scan_id — NOT NULL
  • rule_id — VARCHAR(100) — NOT NULL
  • severity — VARCHAR(20) — 이슈
  • element_selector — TEXT — 문제가
  • description — TEXT
  • raw_detail — JSONB — 검사
  • created_at — TIMESTAMP

code_corrections

  • correction_id — UUID
  • issue_id — UUID — Foreign key → a11y_issues.issue_id — NOT NULL
  • original_code — TEXT
  • fixed_code — TEXT — 접근성
  • status — correction_status — 수정안
  • applied_at — TIMESTAMP
  • created_at — TIMESTAMP

organizations

  • org_id — UUID
  • org_name — VARCHAR(100) — NOT NULL — 고객사
  • business_number — VARCHAR(20) — 사업자
  • created_at — TIMESTAMP — 고객사

projects

  • project_id — UUID
  • org_id — UUID — Foreign key → organizations.org_id — NOT NULL — 해당
  • name — VARCHAR(100) — NOT NULL — 프로젝트
  • base_url — TEXT — NOT NULL — 접근성
  • created_at — TIMESTAMP

scan_sessions

  • scan_id — UUID
  • project_id — UUID — Foreign key → projects.project_id — NOT NULL
  • status — scan_status
  • overall_score — INTEGER — 해당
  • started_at — TIMESTAMP — 검사
  • finished_at — TIMESTAMP — 검사
  • created_at — TIMESTAMP