상황
Residential community managers need to track resident requests for security guard services and schedule guards on patrol routes. The ERD links residents, guards, bookings, patrol routes, and assignments.
이 도면에 담긴 내용
그 이면의 의사결정을 읽어 보세요.
01
Modeled Booking as an associative entity connecting Resident and Guard with date, time, and status.
02
Modeled PatrolAssignment as a separate entity to support many-to-many between Guard and PatrolRoute with schedule details.
03
Introduced Community entity to scope residents and patrol routes to a residential community.
Reusable for apartment complexes, gated communities, or HOA-managed security operations that need to coordinate guard bookings and patrol schedules.