get the next unreviewed relation-edit suggestion, for the moderator queue - same permission as reviewing a person edit (Auth policies: ganjoor:modify)

suggestion id

what a GanjoorPersonRelationEditSuggestion proposes doing to the kinship graph

which kind of edge a GanjoorPersonRelationEditSuggestion is about: a kinship tie (GanjoorPersonRelation, via SuggestedRelationType/ExistingRelationId) or a non-family affiliation tie (GanjoorPersonAffiliation, via SuggestedAffiliationType/ExistingAffiliationId). Defaults to Family (0), so every suggestion row created before this field existed keeps being read exactly as it was before - a plain kinship suggestion.

for Modify/Remove when Kind is Family: the existing GanjoorPersonRelation row this suggestion targets. Null for Add, where there's nothing existing yet, and for any Kind == Affiliation suggestion (see ExistingAffiliationId instead).

for Modify/Remove when Kind is Affiliation: the existing GanjoorPersonAffiliation row this suggestion targets. Null for Add, and for any Kind == Family suggestion (see ExistingRelationId instead).

the pair this suggestion is about. For Add, this and Person2Id define the new relation. For Modify/Remove, these are copied from ExistingRelation at submission time, so the suggestion always accurately reflects what it targets even if the underlying relation changes again before this is reviewed.

second person id, see Person1Id

the kind of kinship edge a GanjoorPersonRelation represents between two GanjoorRelatedPerson rows. The graph is not a strict tree - siblings can be known without their parents, an ancestor can be known without the exact number of generations in between, etc. - so this is a small, deliberately open set rather than a rigid parent/child-only model.

only meaningful when SuggestedRelationType is Parent. Normally, a third Parent edge for the same child is rejected (familytree.js's buildLayout only ever attaches the first two it sorts to the front and silently drops the rest). Set this to true only when a third recorded parent is genuinely intended (e.g. competing genealogy traditions for the same legendary figure) to add/keep it anyway.

only meaningful for a Modify of a directional edge (Parent/Ancestor kinship, or any non-symmetric affiliation type): when true, approving the suggestion swaps the existing edge's Person1Id/Person2Id (e.g. fixes a Killer edge recorded the wrong way round) instead of the submitter having to delete it and add a new one. Person1Id/Person2Id of this suggestion itself stay those of the existing edge at submission time.

the kind of non-family tie a GanjoorPersonAffiliation represents between two people - e.g. a minister serving a king, an advisor, a patron. Unlike PersonRelationType this has nothing to do with kinship; it's what lets two otherwise unrelated family trees show up as adjacent (e.g. "some Barmakids served the Abbasid court") without merging them into one tree. New values can be appended safely later (stored as int) as more cases come up.

see GanjoorPersonRelation.DegreeHint - same for/Add/Modify/Remove-display purpose as SuggestedRelationType above

see GanjoorPersonRelation.Note - same Add/Modify/Remove-display purpose as SuggestedRelationType above

evidence couplet (see GanjoorPersonRelationEvidence): the poem it is in. Required for Action == AddEvidence; optional for Action == Add (the evidence is attached to the new relation when the suggestion is approved). Ignored otherwise.

evidence couplet index inside EvidencePoemId's poem

snapshot of the evidence couplet's text, filled in by the server at submission time so the moderator sees exactly what the suggester pointed at

for Action == RemoveEvidence: the GanjoorPersonRelationEvidence row to detach (a plain id, not an FK, so deleting that row never conflicts with old suggestions that mention it)

suggester's note to the moderator (e.g. why an existing relation is wrong)

date

suggester's user id

reviewed

correction review result

review date

review note

reviewer's user id