master

W34P Foundation K9 Registration Database

Overview

This database schema supports the W34P Foundation’s K9 search and rescue registration system, allowing handlers to register their certified K9 teams for emergency response operations.

Database Structure

Core Tables

`handlers`

Stores information about K9 handlers/owners including contact details, experience, and organization type.

`k9_dogs`

Contains detailed information about each registered K9 including breed, specialization, and training details.

`k9_health_records`

Tracks health information, vaccination records, and veterinary details for each K9.

`k9_photos`

Stores K9 photos with file management information.

`handler_certifications`

Manages uploaded certification documents for handlers.

Support Tables

`registration_submissions`

Tracks form submissions and processing status.

`file_uploads`

Comprehensive file upload tracking with integrity checking.

`audit_log`

Maintains audit trail of all database changes.

`admin_users`

System administrators and reviewers.

File Size Limits

PDF Documents: 10MB maximum
Images (K9 Photos): 5MB maximum
Health Records: 10MB maximum

Security Features

All passwords are hashed using secure algorithms
File integrity checking with SHA-256 hashes
Virus scanning status tracking
Comprehensive audit logging
IP address and user agent tracking

Usage

Installation: Run k9_registration_schema.sql on your MySQL/MariaDB server
Configuration: Update connection settings in your application
Security: Ensure proper firewall and access controls are in place

Views

active_k9_teams: Shows all approved and active K9 teams
registration_summary: Daily registration statistics

Procedures

insert_k9_team(): Safely insert new handler records

Maintenance

Regular backup recommended
Monitor file upload storage space
Archive old audit logs periodically
Update vaccination status based on dates

Support

For technical questions about the database schema, contact the development team.