Content moderation

Describes content moderation setup and principles of Citizen OS

Managing moderators

There are 2 types of moderators:

• Global moderators - can moderate all Citizen OS content. This is the most common type of moderator, if you host Citizen OS for your own community/company.
• Partner moderators - can only moderate content of specific Partner. Only relevant if you host Citizen OS and provide a service to Partners. All Partners are registered in Partners table.

All moderators are registered in Moderators table Moderators that have userId and NOT partnerId global moderators. Moderators that have userId and partnerId are Partner moderators.

Create/delete global moderator

Create

INSERT INTO "Moderators" ("userId", "createdAt", "updatedAt") VALUES ('faccdf47-3c33-47c0-a974-e63a1dc36b95', NOW(), NOW());

Where:

• faccdf47-3c33-47c0-a974-e63a1dc36b95 - is the id from Users table.

Delete

DELETE FROM "Moderators" WHERE "userId" = 'faccdf47-3c33-47c0-a974-e63a1dc36b95'

Where:

• faccdf47-3c33-47c0-a974-e63a1dc36b95 - is the id from Users table.

Create/delete Partner moderator

Create

INSERT INTO "Moderators" ("userId", "partnerId", "createdAt", "updatedAt") VALUES ('faccdf47-3c33-47c0-a974-e63a1dc36b95', '2a666c99-0254-49a6-9a10-b09cbae36f6b', NOW(), NOW());

Where:

• faccdf47-3c33-47c0-a974-e63a1dc36b95 - is the id from Users table.
• 2a666c99-0254-49a6-9a10-b09cbae36f6b - is the id from Parnters table.

Delete

DELETE FROM "Moderators" 
WHERE "userId" = 'faccdf47-3c33-47c0-a974-e63a1dc36b95' 
  AND "partnerId" = '2a666c99-0254-49a6-9a10-b09cbae36f6b'

Where:

• faccdf47-3c33-47c0-a974-e63a1dc36b95 - is the id from Users table.
• 2a666c99-0254-49a6-9a10-b09cbae36f6b - is the id from Parnters table.