13 parent_id -> Nullable<Int4>,
17 published -> Timestamp,
18 updated -> Nullable<Timestamp>,
30 published -> Timestamp,
39 published -> Timestamp,
48 description -> Nullable<Text>,
52 published -> Timestamp,
53 updated -> Nullable<Timestamp>,
60 community_follower (id) {
64 published -> Timestamp,
69 community_moderator (id) {
73 published -> Timestamp,
78 community_user_ban (id) {
82 published -> Timestamp,
90 other_user_id -> Int4,
91 removed -> Nullable<Bool>,
97 mod_add_community (id) {
100 other_user_id -> Int4,
101 community_id -> Int4,
102 removed -> Nullable<Bool>,
111 other_user_id -> Int4,
112 reason -> Nullable<Text>,
113 banned -> Nullable<Bool>,
114 expires -> Nullable<Timestamp>,
120 mod_ban_from_community (id) {
123 other_user_id -> Int4,
124 community_id -> Int4,
125 reason -> Nullable<Text>,
126 banned -> Nullable<Bool>,
127 expires -> Nullable<Timestamp>,
137 locked -> Nullable<Bool>,
143 mod_remove_comment (id) {
147 reason -> Nullable<Text>,
148 removed -> Nullable<Bool>,
154 mod_remove_community (id) {
157 community_id -> Int4,
158 reason -> Nullable<Text>,
159 removed -> Nullable<Bool>,
160 expires -> Nullable<Timestamp>,
166 mod_remove_post (id) {
170 reason -> Nullable<Text>,
171 removed -> Nullable<Bool>,
177 mod_sticky_post (id) {
181 stickied -> Nullable<Bool>,
190 url -> Nullable<Text>,
191 body -> Nullable<Text>,
193 community_id -> Int4,
196 published -> Timestamp,
197 updated -> Nullable<Timestamp>,
210 published -> Timestamp,
219 published -> Timestamp,
228 published -> Timestamp,
236 description -> Nullable<Text>,
238 published -> Timestamp,
239 updated -> Nullable<Timestamp>,
247 fedi_name -> Varchar,
248 preferred_username -> Nullable<Varchar>,
249 password_encrypted -> Text,
250 email -> Nullable<Text>,
251 icon -> Nullable<Bytea>,
254 published -> Timestamp,
255 updated -> Nullable<Timestamp>,
265 published -> Timestamp,
269 joinable!(comment -> post (post_id));
270 joinable!(comment -> user_ (creator_id));
271 joinable!(comment_like -> comment (comment_id));
272 joinable!(comment_like -> post (post_id));
273 joinable!(comment_like -> user_ (user_id));
274 joinable!(comment_saved -> comment (comment_id));
275 joinable!(comment_saved -> user_ (user_id));
276 joinable!(community -> category (category_id));
277 joinable!(community -> user_ (creator_id));
278 joinable!(community_follower -> community (community_id));
279 joinable!(community_follower -> user_ (user_id));
280 joinable!(community_moderator -> community (community_id));
281 joinable!(community_moderator -> user_ (user_id));
282 joinable!(community_user_ban -> community (community_id));
283 joinable!(community_user_ban -> user_ (user_id));
284 joinable!(mod_add_community -> community (community_id));
285 joinable!(mod_ban_from_community -> community (community_id));
286 joinable!(mod_lock_post -> post (post_id));
287 joinable!(mod_lock_post -> user_ (mod_user_id));
288 joinable!(mod_remove_comment -> comment (comment_id));
289 joinable!(mod_remove_comment -> user_ (mod_user_id));
290 joinable!(mod_remove_community -> community (community_id));
291 joinable!(mod_remove_community -> user_ (mod_user_id));
292 joinable!(mod_remove_post -> post (post_id));
293 joinable!(mod_remove_post -> user_ (mod_user_id));
294 joinable!(mod_sticky_post -> post (post_id));
295 joinable!(mod_sticky_post -> user_ (mod_user_id));
296 joinable!(post -> community (community_id));
297 joinable!(post -> user_ (creator_id));
298 joinable!(post_like -> post (post_id));
299 joinable!(post_like -> user_ (user_id));
300 joinable!(post_read -> post (post_id));
301 joinable!(post_read -> user_ (user_id));
302 joinable!(post_saved -> post (post_id));
303 joinable!(post_saved -> user_ (user_id));
304 joinable!(site -> user_ (creator_id));
305 joinable!(user_ban -> user_ (user_id));
307 allow_tables_to_appear_in_same_query!(
319 mod_ban_from_community,
322 mod_remove_community,