Database schema

This is the schema of the database used to store information about the spots and their reactions

        erDiagram
"pending_post" {
   user_id BIGINT
   u_message_id BIGINT
   g_message_id BIGINT PK
   admin_group_id BIGINT PK
   message_date TIMESTAMP
}

"admin_votes" {
   admin_id BIGINT PK
   g_message_id BIGINT PK
   admin_group_id BIGINT PK
   is_upvote BOOLEAN
}

pending_post ||--o{ admin_votes : receives

"published_post" {
   channel_id BIGINT PK
   c_message_id BIGINT PK
   message_date TIMESTAMP
}

"spot_report" {
   user_id BIGINT PK
   channel_id BIGINT
   c_message_id BIGINT PK
   g_message_id BIGINT
   admin_group_id BIGINT
   message_date TIMESTAMP
}

published_post ||--o{ spot_report : receives
    
        erDiagram
"credited_users" {
   user_id BIGINT PK
}

"banned_users" {
   user_id BIGINT PK
   ban_date TIMESTAMP
}
    
        erDiagram
"user_report" {
   user_id BIGINT PK
   target_username VARCHAR(32) PK
   g_message_id BIGINT
   admin_group_id BIGINT
   message_date TIMESTAMP PK
}

"user_follow" {
   user_id BIGINT PK
   message_id BIGINT PK
   private_message_id BIGINT
   follow_date TIMESTAMP
}