Content moderation

Describes content moderation setup and principles of Citizen OS

What content can be moderated?

• Arguments (comments) on public Topics

Future:

• Public topics - https://github.com/citizenos/citizenos-api/issues/5
• Images (Avatars, EP content)
• ..

Basic moderation principles

• Never delete anything when possible, but hide it from default views. This provides a mechanism to any User to verify if moderation was justified.
• Community reporting
• Community up and downvote

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" (
  "id",
  "userId", 
  "createdAt", 
  "updatedAt"
) 
VALUES (
  md5(random()::text || clock_timestamp()::text)::uuid,
  '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" (
  "id", 
  "userId", 
  "partnerId", 
  "createdAt", 
  "updatedAt"
) 
VALUES (
  md5(random()::text || clock_timestamp()::text)::uuid,
  '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.