fix: remove incorrect v_attendance_summary from README.md database views

[claude]

Problem

In PR #28, v_attendance_summary was added to the database views table in README.md, but this is incorrect. attendance_summary is a table, not a view.

Evidence

• src/database/schema.sql:129 defines attendance_summary as a TABLE
• src/database/views.sql contains exactly 13 views, none named v_attendance_summary
• The actual 13 views are correctly listed in the other entries

Required Fix

Location: README.md line ~216

Remove this row from the database views table:

| `v_attendance_summary` | Overall attendance statistics per student |

The view count should remain 13 (which is correct), but this specific entry should be deleted.

References

• Identified in PR docs: comprehensive documentation accuracy and compliance update #28 review: docs: comprehensive documentation accuracy and compliance update #28 (comment)
• Related file: src/database/schema.sql (defines attendance_summary as a table)
• Related file: src/database/views.sql (contains the actual 13 views)

[cculb]

@claude fix this issue. push the changes and open a merger plus

[cculb]

@claude fix this issue. push the changes and open a merger plus

[claude]

Claude finished @cculb's task in 1m 11s —— View job • claude/issue-29-20251222-0018 • Create PR ➔

---

Tasks

• Read README.md to locate the incorrect entry
• Remove the v_attendance_summary row from the database views table
• Commit and push changes
• Provide PR creation link

Summary

Fixed the issue by removing the incorrect v_attendance_summary entry from the database views table in README.md (line 216). This entry was incorrectly added in PR #28 - attendance_summary is actually a table (defined in src/database/schema.sql:129), not a view.

The database views table now correctly lists the 13 actual views defined in src/database/views.sql.

Changes Made

• File modified: README.md
• Change: Removed the | v_attendance_summary | Overall attendance statistics per student | row from the database views table
• Commit: 922b14c

---

Branch |

[claude]

Claude finished @cculb's task in 1m 24s —— View job • claude/issue-29-20251222-0018 • Create PR ➔

---

Tasks Completed

• Read README.md to locate the incorrect entry
• Remove the v_attendance_summary row from the database views table
• Commit and push the changes
• Provide PR creation link

Summary

I've successfully removed the incorrect v_attendance_summary entry from the README.md database views table. As noted in the issue, attendance_summary is a table (defined in src/database/schema.sql:129), not a view. The 13 views listed in src/database/views.sql do not include this entry.

Changes made:

• Removed line 216 from README.md: | v_attendance_summary | Overall attendance statistics per student |
• The view count remains correctly at 13

Commit: 922b14c

---

Branch: claude/issue-29-20251222-0018 |

[cculb]

@claude create a pr

[claude]

Claude finished @cculb's task in 1m 10s —— View job • claude/issue-29-20251222-0508 • Create PR ➔

---

Tasks

• Check current state of README.md on this branch
• Apply the fix (remove v_attendance_summary row from line 216)
• Commit and push changes
• Provide PR creation link

Summary

Removed the incorrect v_attendance_summary entry from the database views table in README.md. As documented in the issue, attendance_summary is a table (defined in src/database/schema.sql:129), not a view. The 13 actual views are defined in src/database/views.sql and do not include this entry.

Changes

• File modified: README.md:216
• Change: Removed the | v_attendance_summary | Overall attendance statistics per student | row
• Commit: f5a7125

--- | Branch: claude/issue-29-20251222-0508