uhr_manager database 

Tables;
contacts (id, First_name, last_name,email,phone,address_line1,address_line2,city, region,postal_code,country, is_active, password_hash,created_at, updated_at);
contact_roles (id,contact_id,role_id, assigned_at, ended_at);
contact_preferences (contact_id,preference_id,assigned_at,ended_at);
events (id,title,description,event_date,location,status,prompt_email,created_at, updated_at);
preferences (id, name, category);
registrations (id,event_id,contact_id,status,registered_at,updated_at);
roles (id,role_name,description);
skills (id,skill_name,description,created_at, updated_at);
system_audit_log;
volunteers_skills (contact_id,skill_id, created_at,updated_at);

Views;
event_registrations (registration_id,first_name,last_name,event_title,event_date,email,phone,status,registered_at,contact_id,event_id,location);
event_skill_availability (event_id,event_title,event_date,skill_name,skill_description);
volunteer_contacts (id,first_name,last_name,email,phone,address_line1,address_line2,city,region,postal_code,country,is_active,created_at,updated_at);
