Database schema

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

This image has been created with the following script on dbdiagram.io:

Table pending_post as PE {
user_id bigint [not null]
u_message_id bigint [not null]
g_message_id bigint [pk]
admin_group_id bigint [pk]
message_date timestamp
}

Table published_post as PU {
channel_id bigint [pk]
c_message_id bigint [pk]
}

Table admin_votes {
admin_id bigint [pk]
g_message_id bigint [pk, ref: > PE.g_message_id]
admin_group_id bigint [pk, ref: > PE.admin_group_id]
is_upvote boolean [not null]
}

Table credited_users {
user_id bigint [pk]
}

Table banned_users {
user_id bigint [pk]
}

Table spot_report {
user_id bigint [pk]
channel_id bigint [pk, ref: > PU.channel_id]
c_message_id bigint [pk, ref: > PU.c_message_id]
g_message_id bigint [not null]
admin_group_id bigint [not null]
}

Table user_report {
user_id bigint [pk]
target_username varchar(32) [pk]
g_message_id bigint [not null]
admin_group_id bigint [not null]
message_date timestamp [pk]
}

Table user_follow {
user_id bigint [not null]
message_id BIGINT [not null]
private_message_id BIGINT [not null]
}