7 published -> Timestamp,
8 updated -> Nullable<Timestamp>,
24 parent_id -> Nullable<Int4>,
28 published -> Timestamp,
29 updated -> Nullable<Timestamp>,
37 comment_aggregates_fast (id) {
39 creator_id -> Nullable<Int4>,
40 post_id -> Nullable<Int4>,
41 parent_id -> Nullable<Int4>,
42 content -> Nullable<Text>,
43 removed -> Nullable<Bool>,
44 read -> Nullable<Bool>,
45 published -> Nullable<Timestamp>,
46 updated -> Nullable<Timestamp>,
47 deleted -> Nullable<Bool>,
48 ap_id -> Nullable<Varchar>,
49 local -> Nullable<Bool>,
50 post_name -> Nullable<Varchar>,
51 community_id -> Nullable<Int4>,
52 community_actor_id -> Nullable<Varchar>,
53 community_local -> Nullable<Bool>,
54 community_name -> Nullable<Varchar>,
55 banned -> Nullable<Bool>,
56 banned_from_community -> Nullable<Bool>,
57 creator_actor_id -> Nullable<Varchar>,
58 creator_local -> Nullable<Bool>,
59 creator_name -> Nullable<Varchar>,
60 creator_published -> Nullable<Timestamp>,
61 creator_avatar -> Nullable<Text>,
62 score -> Nullable<Int8>,
63 upvotes -> Nullable<Int8>,
64 downvotes -> Nullable<Int8>,
65 hot_rank -> Nullable<Int4>,
76 published -> Timestamp,
85 published -> Timestamp,
94 description -> Nullable<Text>,
98 published -> Timestamp,
99 updated -> Nullable<Timestamp>,
104 private_key -> Nullable<Text>,
105 public_key -> Nullable<Text>,
106 last_refreshed_at -> Timestamp,
111 community_aggregates_fast (id) {
113 name -> Nullable<Varchar>,
114 title -> Nullable<Varchar>,
115 description -> Nullable<Text>,
116 category_id -> Nullable<Int4>,
117 creator_id -> Nullable<Int4>,
118 removed -> Nullable<Bool>,
119 published -> Nullable<Timestamp>,
120 updated -> Nullable<Timestamp>,
121 deleted -> Nullable<Bool>,
122 nsfw -> Nullable<Bool>,
123 actor_id -> Nullable<Varchar>,
124 local -> Nullable<Bool>,
125 last_refreshed_at -> Nullable<Timestamp>,
126 creator_actor_id -> Nullable<Varchar>,
127 creator_local -> Nullable<Bool>,
128 creator_name -> Nullable<Varchar>,
129 creator_avatar -> Nullable<Text>,
130 category_name -> Nullable<Varchar>,
131 number_of_subscribers -> Nullable<Int8>,
132 number_of_posts -> Nullable<Int8>,
133 number_of_comments -> Nullable<Int8>,
134 hot_rank -> Nullable<Int4>,
139 community_follower (id) {
141 community_id -> Int4,
143 published -> Timestamp,
148 community_moderator (id) {
150 community_id -> Int4,
152 published -> Timestamp,
157 community_user_ban (id) {
159 community_id -> Int4,
161 published -> Timestamp,
169 other_user_id -> Int4,
170 removed -> Nullable<Bool>,
176 mod_add_community (id) {
179 other_user_id -> Int4,
180 community_id -> Int4,
181 removed -> Nullable<Bool>,
190 other_user_id -> Int4,
191 reason -> Nullable<Text>,
192 banned -> Nullable<Bool>,
193 expires -> Nullable<Timestamp>,
199 mod_ban_from_community (id) {
202 other_user_id -> Int4,
203 community_id -> Int4,
204 reason -> Nullable<Text>,
205 banned -> Nullable<Bool>,
206 expires -> Nullable<Timestamp>,
216 locked -> Nullable<Bool>,
222 mod_remove_comment (id) {
226 reason -> Nullable<Text>,
227 removed -> Nullable<Bool>,
233 mod_remove_community (id) {
236 community_id -> Int4,
237 reason -> Nullable<Text>,
238 removed -> Nullable<Bool>,
239 expires -> Nullable<Timestamp>,
245 mod_remove_post (id) {
249 reason -> Nullable<Text>,
250 removed -> Nullable<Bool>,
256 mod_sticky_post (id) {
260 stickied -> Nullable<Bool>,
266 password_reset_request (id) {
269 token_encrypted -> Text,
270 published -> Timestamp,
278 url -> Nullable<Text>,
279 body -> Nullable<Text>,
281 community_id -> Int4,
284 published -> Timestamp,
285 updated -> Nullable<Timestamp>,
289 embed_title -> Nullable<Text>,
290 embed_description -> Nullable<Text>,
291 embed_html -> Nullable<Text>,
292 thumbnail_url -> Nullable<Text>,
299 post_aggregates_fast (id) {
301 name -> Nullable<Varchar>,
302 url -> Nullable<Text>,
303 body -> Nullable<Text>,
304 creator_id -> Nullable<Int4>,
305 community_id -> Nullable<Int4>,
306 removed -> Nullable<Bool>,
307 locked -> Nullable<Bool>,
308 published -> Nullable<Timestamp>,
309 updated -> Nullable<Timestamp>,
310 deleted -> Nullable<Bool>,
311 nsfw -> Nullable<Bool>,
312 stickied -> Nullable<Bool>,
313 embed_title -> Nullable<Text>,
314 embed_description -> Nullable<Text>,
315 embed_html -> Nullable<Text>,
316 thumbnail_url -> Nullable<Text>,
317 ap_id -> Nullable<Varchar>,
318 local -> Nullable<Bool>,
319 creator_actor_id -> Nullable<Varchar>,
320 creator_local -> Nullable<Bool>,
321 creator_name -> Nullable<Varchar>,
322 creator_published -> Nullable<Timestamp>,
323 creator_avatar -> Nullable<Text>,
324 banned -> Nullable<Bool>,
325 banned_from_community -> Nullable<Bool>,
326 community_actor_id -> Nullable<Varchar>,
327 community_local -> Nullable<Bool>,
328 community_name -> Nullable<Varchar>,
329 community_removed -> Nullable<Bool>,
330 community_deleted -> Nullable<Bool>,
331 community_nsfw -> Nullable<Bool>,
332 number_of_comments -> Nullable<Int8>,
333 score -> Nullable<Int8>,
334 upvotes -> Nullable<Int8>,
335 downvotes -> Nullable<Int8>,
336 hot_rank -> Nullable<Int4>,
337 newest_activity_time -> Nullable<Timestamp>,
347 published -> Timestamp,
356 published -> Timestamp,
365 published -> Timestamp,
370 private_message (id) {
373 recipient_id -> Int4,
377 published -> Timestamp,
378 updated -> Nullable<Timestamp>,
388 description -> Nullable<Text>,
390 published -> Timestamp,
391 updated -> Nullable<Timestamp>,
392 enable_downvotes -> Bool,
393 open_registration -> Bool,
402 preferred_username -> Nullable<Varchar>,
403 password_encrypted -> Text,
404 email -> Nullable<Text>,
405 avatar -> Nullable<Text>,
408 published -> Timestamp,
409 updated -> Nullable<Timestamp>,
412 default_sort_type -> Int2,
413 default_listing_type -> Int2,
415 show_avatars -> Bool,
416 send_notifications_to_email -> Bool,
417 matrix_user_id -> Nullable<Text>,
419 bio -> Nullable<Text>,
421 private_key -> Nullable<Text>,
422 public_key -> Nullable<Text>,
423 last_refreshed_at -> Timestamp,
431 published -> Timestamp,
438 actor_id -> Nullable<Varchar>,
439 name -> Nullable<Varchar>,
440 avatar -> Nullable<Text>,
441 email -> Nullable<Text>,
442 matrix_user_id -> Nullable<Text>,
443 bio -> Nullable<Text>,
444 local -> Nullable<Bool>,
445 admin -> Nullable<Bool>,
446 banned -> Nullable<Bool>,
447 show_avatars -> Nullable<Bool>,
448 send_notifications_to_email -> Nullable<Bool>,
449 published -> Nullable<Timestamp>,
450 number_of_posts -> Nullable<Int8>,
451 post_score -> Nullable<Int8>,
452 number_of_comments -> Nullable<Int8>,
453 comment_score -> Nullable<Int8>,
460 recipient_id -> Int4,
463 published -> Timestamp,
467 joinable!(activity -> user_ (user_id));
468 joinable!(comment -> post (post_id));
469 joinable!(comment -> user_ (creator_id));
470 joinable!(comment_like -> comment (comment_id));
471 joinable!(comment_like -> post (post_id));
472 joinable!(comment_like -> user_ (user_id));
473 joinable!(comment_saved -> comment (comment_id));
474 joinable!(comment_saved -> user_ (user_id));
475 joinable!(community -> category (category_id));
476 joinable!(community -> user_ (creator_id));
477 joinable!(community_follower -> community (community_id));
478 joinable!(community_follower -> user_ (user_id));
479 joinable!(community_moderator -> community (community_id));
480 joinable!(community_moderator -> user_ (user_id));
481 joinable!(community_user_ban -> community (community_id));
482 joinable!(community_user_ban -> user_ (user_id));
483 joinable!(mod_add_community -> community (community_id));
484 joinable!(mod_ban_from_community -> community (community_id));
485 joinable!(mod_lock_post -> post (post_id));
486 joinable!(mod_lock_post -> user_ (mod_user_id));
487 joinable!(mod_remove_comment -> comment (comment_id));
488 joinable!(mod_remove_comment -> user_ (mod_user_id));
489 joinable!(mod_remove_community -> community (community_id));
490 joinable!(mod_remove_community -> user_ (mod_user_id));
491 joinable!(mod_remove_post -> post (post_id));
492 joinable!(mod_remove_post -> user_ (mod_user_id));
493 joinable!(mod_sticky_post -> post (post_id));
494 joinable!(mod_sticky_post -> user_ (mod_user_id));
495 joinable!(password_reset_request -> user_ (user_id));
496 joinable!(post -> community (community_id));
497 joinable!(post -> user_ (creator_id));
498 joinable!(post_like -> post (post_id));
499 joinable!(post_like -> user_ (user_id));
500 joinable!(post_read -> post (post_id));
501 joinable!(post_read -> user_ (user_id));
502 joinable!(post_saved -> post (post_id));
503 joinable!(post_saved -> user_ (user_id));
504 joinable!(site -> user_ (creator_id));
505 joinable!(user_ban -> user_ (user_id));
506 joinable!(user_mention -> comment (comment_id));
507 joinable!(user_mention -> user_ (recipient_id));
509 allow_tables_to_appear_in_same_query!(
513 comment_aggregates_fast,
517 community_aggregates_fast,
524 mod_ban_from_community,
527 mod_remove_community,
530 password_reset_request,
532 post_aggregates_fast,