القائمة
Design EF Core schema changes, constraints, and migrations for the backend data model. Use for entity updates, indexes, uniqueness rules, cascade behavior, and migration planning.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Design ASP.NET Core minimal API request and response contracts. Use for DTO shapes, route and verb decisions, OpenAPI metadata, and compatibility planning before implementation.
Define focused tests for ASP.NET Core minimal APIs. Use for endpoint branch coverage, contract assertions, regression planning, and choosing the narrowest useful verification command.
Design and implement the delegated Graph sync pipeline from fetch through normalization, upsert, and metrics recompute. Use for user-initiated registrations or attendance sync, idempotency, and atomic recomputation.
Define deployment safeguards, environment protections, and rollback readiness for CI/CD releases. Use when adding or reviewing release jobs, promotion controls, or recovery plans.
Apply email and domain normalization plus session and series metric rules, including W1/W2 warm-account logic and internal-domain exclusion. Use for domain logic changes, recompute behavior, and mandatory unit-test coverage.
Review Next.js interfaces for accessibility and UX acceptance. Use for semantic markup, keyboard flow, responsive behavior, async states, and final user-flow validation before merge.
| name | data-schema-migration |
| description | Design EF Core schema changes, constraints, and migrations for the backend data model. Use for entity updates, indexes, uniqueness rules, cascade behavior, and migration planning. |
| argument-hint | Describe the entity or table change, columns or constraints affected, and any migration or data-compatibility concerns. |
Canonical schema reference for the backend data model.
dotnet ef migrations add; verify applies cleanly.seriesId (UUID, PK), ownerUserId (string), title (string), status (Draft|Published), createdAt (datetime2 UTC), updatedAt (datetime2 UTC)(ownerUserId, title)sessionId (UUID, PK), seriesId (FK→Series), ownerUserId, title, startsAt, endsAt, status (Draft|Published), teamsWebinarId (nullable), driftStatus (None|DriftDetected), reconcileStatus (Synced|Reconciling|Retrying|Disabled), lastSyncAt (nullable), lastError (nullable)registrationId (UUID, PK), sessionId (FK→Session), ownerUserId, email, emailDomain, registeredAt(ownerUserId, sessionId, email)attendanceId (UUID, PK), sessionId (FK→Session), ownerUserId, email, emailDomain, attended (bool), durationSeconds (nullable), durationPercent (nullable), firstJoinAt (nullable), lastLeaveAt (nullable)(ownerUserId, sessionId, email)sessionId (UUID, PK, FK→Session), totalRegistrations, totalAttendees, uniqueRegistrantAccountDomains, uniqueAttendeeAccountDomains, warmAccountsTriggered (nvarchar(max) JSON)seriesId (UUID, PK, FK→Series), totalRegistrations, totalAttendees, uniqueRegistrantAccountDomains, uniqueAccountsInfluenced, warmAccounts (nvarchar(max) JSON)EnsureCreatedSeries(ownerUserId, createdAt desc)Session(seriesId, startsAt)NormalizedRegistration(sessionId, emailDomain)NormalizedAttendance(sessionId, emailDomain)