System-test-only. While a row here has held_until in the
future, an unscoped claim_due call (the live background worker) skips
every credit_registrations row of that user (and course, if given); a
scoped call (a Playwright spec ticking its own rows) ignores every hold
regardless. Keyed on the identity a spec drives its scenario under, not
on a ledger row id, so a hold can be set before materialize creates the
row it is meant to protect: an owner-narrowed request-level mock-Suotar
fault (mock_suotar::faults::matches_request requires every item in a
batch to match) would otherwise be silently defeated by the worker
materializing and batching a fresh row before the spec gets to hold it.
Written only through the mock-Suotar control API, gated the same as the
rest of it on test_mode && test_suotar, and never by production
code.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| course_id | uuid | true | public.courses | NULL holds every course for the user; set to narrow the hold to one, for a student whose other courses must keep moving. | ||
| created_at | timestamp with time zone | now() | false | |||
| held_until | timestamp with time zone | false | ||||
| id | uuid | uuid_generate_v4() | false | |||
| user_id | uuid | false | public.users |
| Name | Type | Definition |
|---|---|---|
| credit_registration_test_exclusive_holds_course_id_fkey | FOREIGN KEY | FOREIGN KEY (course_id) REFERENCES courses(id) |
| credit_registration_test_exclusive_holds_created_at_not_null | n | NOT NULL created_at |
| credit_registration_test_exclusive_holds_held_until_not_null | n | NOT NULL held_until |
| credit_registration_test_exclusive_holds_id_not_null | n | NOT NULL id |
| credit_registration_test_exclusive_holds_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| credit_registration_test_exclusive_holds_user_id_fkey | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) |
| credit_registration_test_exclusive_holds_user_id_not_null | n | NOT NULL user_id |
| Name | Definition |
|---|---|
| credit_registration_test_exclusive_holds_pkey | CREATE UNIQUE INDEX credit_registration_test_exclusive_holds_pkey ON public.credit_registration_test_exclusive_holds USING btree (id) |
| idx_credit_registration_test_exclusive_holds_user_id | CREATE INDEX idx_credit_registration_test_exclusive_holds_user_id ON public.credit_registration_test_exclusive_holds USING btree (user_id) |
Generated by tbls