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