6 published -> Timestamp,
7 updated -> Nullable<Timestamp>,
8 ap_id -> Nullable<Text>,
9 sensitive -> Nullable<Bool>,
18 parent_id -> Nullable<Int4>,
22 published -> Timestamp,
23 updated -> Nullable<Timestamp>,
31 comment_aggregates (id) {
37 published -> Timestamp,
48 published -> Timestamp,
57 original_comment_text -> Text,
60 resolver_id -> Nullable<Int4>,
61 published -> Timestamp,
62 updated -> Nullable<Timestamp>,
71 published -> Timestamp,
80 description -> Nullable<Text>,
82 published -> Timestamp,
83 updated -> Nullable<Timestamp>,
88 private_key -> Nullable<Text>,
89 public_key -> Nullable<Text>,
90 last_refreshed_at -> Timestamp,
91 icon -> Nullable<Varchar>,
92 banner -> Nullable<Varchar>,
93 followers_url -> Varchar,
95 shared_inbox_url -> Nullable<Varchar>,
100 community_aggregates (id) {
102 community_id -> Int4,
106 published -> Timestamp,
107 users_active_day -> Int8,
108 users_active_week -> Int8,
109 users_active_month -> Int8,
110 users_active_half_year -> Int8,
115 community_follower (id) {
117 community_id -> Int4,
119 published -> Timestamp,
120 pending -> Nullable<Bool>,
125 community_moderator (id) {
127 community_id -> Int4,
129 published -> Timestamp,
134 community_person_ban (id) {
136 community_id -> Int4,
138 published -> Timestamp,
146 password_encrypted -> Text,
147 email -> Nullable<Text>,
150 default_sort_type -> Int2,
151 default_listing_type -> Int2,
153 show_avatars -> Bool,
154 send_notifications_to_email -> Bool,
155 validator_time -> Timestamp,
163 mod_person_id -> Int4,
164 other_person_id -> Int4,
165 removed -> Nullable<Bool>,
171 mod_add_community (id) {
173 mod_person_id -> Int4,
174 other_person_id -> Int4,
175 community_id -> Int4,
176 removed -> Nullable<Bool>,
184 mod_person_id -> Int4,
185 other_person_id -> Int4,
186 reason -> Nullable<Text>,
187 banned -> Nullable<Bool>,
188 expires -> Nullable<Timestamp>,
194 mod_ban_from_community (id) {
196 mod_person_id -> Int4,
197 other_person_id -> Int4,
198 community_id -> Int4,
199 reason -> Nullable<Text>,
200 banned -> Nullable<Bool>,
201 expires -> Nullable<Timestamp>,
209 mod_person_id -> Int4,
211 locked -> Nullable<Bool>,
217 mod_remove_comment (id) {
219 mod_person_id -> Int4,
221 reason -> Nullable<Text>,
222 removed -> Nullable<Bool>,
228 mod_remove_community (id) {
230 mod_person_id -> Int4,
231 community_id -> Int4,
232 reason -> Nullable<Text>,
233 removed -> Nullable<Bool>,
234 expires -> Nullable<Timestamp>,
240 mod_remove_post (id) {
242 mod_person_id -> Int4,
244 reason -> Nullable<Text>,
245 removed -> Nullable<Bool>,
251 mod_sticky_post (id) {
253 mod_person_id -> Int4,
255 stickied -> Nullable<Bool>,
261 password_reset_request (id) {
263 token_encrypted -> Text,
264 published -> Timestamp,
265 local_user_id -> Int4,
273 display_name -> Nullable<Varchar>,
274 avatar -> Nullable<Varchar>,
276 published -> Timestamp,
277 updated -> Nullable<Timestamp>,
279 bio -> Nullable<Text>,
281 private_key -> Nullable<Text>,
282 public_key -> Nullable<Text>,
283 last_refreshed_at -> Timestamp,
284 banner -> Nullable<Varchar>,
286 inbox_url -> Varchar,
287 shared_inbox_url -> Nullable<Varchar>,
288 matrix_user_id -> Nullable<Text>,
294 person_aggregates (id) {
299 comment_count -> Int8,
300 comment_score -> Int8,
308 published -> Timestamp,
313 person_mention (id) {
315 recipient_id -> Int4,
318 published -> Timestamp,
326 url -> Nullable<Varchar>,
327 body -> Nullable<Text>,
329 community_id -> Int4,
332 published -> Timestamp,
333 updated -> Nullable<Timestamp>,
337 embed_title -> Nullable<Text>,
338 embed_description -> Nullable<Text>,
339 embed_html -> Nullable<Text>,
340 thumbnail_url -> Nullable<Text>,
347 post_aggregates (id) {
355 published -> Timestamp,
356 newest_comment_time_necro -> Timestamp,
357 newest_comment_time -> Timestamp,
367 published -> Timestamp,
376 published -> Timestamp,
385 original_post_name -> Varchar,
386 original_post_url -> Nullable<Text>,
387 original_post_body -> Nullable<Text>,
390 resolver_id -> Nullable<Int4>,
391 published -> Timestamp,
392 updated -> Nullable<Timestamp>,
401 published -> Timestamp,
406 private_message (id) {
409 recipient_id -> Int4,
413 published -> Timestamp,
414 updated -> Nullable<Timestamp>,
424 sidebar -> Nullable<Text>,
426 published -> Timestamp,
427 updated -> Nullable<Timestamp>,
428 enable_downvotes -> Bool,
429 open_registration -> Bool,
431 icon -> Nullable<Varchar>,
432 banner -> Nullable<Varchar>,
433 description -> Nullable<Text>,
438 site_aggregates (id) {
445 users_active_day -> Int8,
446 users_active_week -> Int8,
447 users_active_month -> Int8,
448 users_active_half_year -> Int8,
452 // These are necessary since diesel doesn't have self joins / aliases
454 comment_alias_1 (id) {
458 parent_id -> Nullable<Int4>,
462 published -> Timestamp,
463 updated -> Nullable<Timestamp>,
471 person_alias_1 (id) {
474 display_name -> Nullable<Varchar>,
475 avatar -> Nullable<Varchar>,
477 published -> Timestamp,
478 updated -> Nullable<Timestamp>,
480 bio -> Nullable<Text>,
482 private_key -> Nullable<Text>,
483 public_key -> Nullable<Text>,
484 last_refreshed_at -> Timestamp,
485 banner -> Nullable<Varchar>,
487 inbox_url -> Varchar,
488 shared_inbox_url -> Nullable<Varchar>,
489 matrix_user_id -> Nullable<Text>,
495 person_alias_2 (id) {
498 display_name -> Nullable<Varchar>,
499 avatar -> Nullable<Varchar>,
501 published -> Timestamp,
502 updated -> Nullable<Timestamp>,
504 bio -> Nullable<Text>,
506 private_key -> Nullable<Text>,
507 public_key -> Nullable<Text>,
508 last_refreshed_at -> Timestamp,
509 banner -> Nullable<Varchar>,
511 inbox_url -> Varchar,
512 shared_inbox_url -> Nullable<Varchar>,
513 matrix_user_id -> Nullable<Text>,
518 joinable!(comment_alias_1 -> person_alias_1 (creator_id));
519 joinable!(comment -> comment_alias_1 (parent_id));
520 joinable!(person_mention -> person_alias_1 (recipient_id));
521 joinable!(post -> person_alias_1 (creator_id));
522 joinable!(comment -> person_alias_1 (creator_id));
524 joinable!(post_report -> person_alias_2 (resolver_id));
525 joinable!(comment_report -> person_alias_2 (resolver_id));
527 joinable!(comment -> person (creator_id));
528 joinable!(comment -> post (post_id));
529 joinable!(comment_aggregates -> comment (comment_id));
530 joinable!(comment_like -> comment (comment_id));
531 joinable!(comment_like -> person (person_id));
532 joinable!(comment_like -> post (post_id));
533 joinable!(comment_report -> comment (comment_id));
534 joinable!(comment_saved -> comment (comment_id));
535 joinable!(comment_saved -> person (person_id));
536 joinable!(community_aggregates -> community (community_id));
537 joinable!(community_follower -> community (community_id));
538 joinable!(community_follower -> person (person_id));
539 joinable!(community_moderator -> community (community_id));
540 joinable!(community_moderator -> person (person_id));
541 joinable!(community_person_ban -> community (community_id));
542 joinable!(community_person_ban -> person (person_id));
543 joinable!(local_user -> person (person_id));
544 joinable!(mod_add_community -> community (community_id));
545 joinable!(mod_ban_from_community -> community (community_id));
546 joinable!(mod_lock_post -> person (mod_person_id));
547 joinable!(mod_lock_post -> post (post_id));
548 joinable!(mod_remove_comment -> comment (comment_id));
549 joinable!(mod_remove_comment -> person (mod_person_id));
550 joinable!(mod_remove_community -> community (community_id));
551 joinable!(mod_remove_community -> person (mod_person_id));
552 joinable!(mod_remove_post -> person (mod_person_id));
553 joinable!(mod_remove_post -> post (post_id));
554 joinable!(mod_sticky_post -> person (mod_person_id));
555 joinable!(mod_sticky_post -> post (post_id));
556 joinable!(password_reset_request -> local_user (local_user_id));
557 joinable!(person_aggregates -> person (person_id));
558 joinable!(person_ban -> person (person_id));
559 joinable!(person_mention -> comment (comment_id));
560 joinable!(person_mention -> person (recipient_id));
561 joinable!(post -> community (community_id));
562 joinable!(post -> person (creator_id));
563 joinable!(post_aggregates -> post (post_id));
564 joinable!(post_like -> person (person_id));
565 joinable!(post_like -> post (post_id));
566 joinable!(post_read -> person (person_id));
567 joinable!(post_read -> post (post_id));
568 joinable!(post_report -> post (post_id));
569 joinable!(post_saved -> person (person_id));
570 joinable!(post_saved -> post (post_id));
571 joinable!(site -> person (creator_id));
572 joinable!(site_aggregates -> site (site_id));
574 allow_tables_to_appear_in_same_query!(
582 community_aggregates,
585 community_person_ban,
590 mod_ban_from_community,
593 mod_remove_community,
596 password_reset_request,