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>,
83 published -> Timestamp,
84 updated -> Nullable<Timestamp>,
89 private_key -> Nullable<Text>,
90 public_key -> Nullable<Text>,
91 last_refreshed_at -> Timestamp,
92 icon -> Nullable<Varchar>,
93 banner -> Nullable<Varchar>,
94 followers_url -> Varchar,
96 shared_inbox_url -> Nullable<Varchar>,
101 community_aggregates (id) {
103 community_id -> Int4,
107 published -> Timestamp,
108 users_active_day -> Int8,
109 users_active_week -> Int8,
110 users_active_month -> Int8,
111 users_active_half_year -> Int8,
116 community_follower (id) {
118 community_id -> Int4,
120 published -> Timestamp,
121 pending -> Nullable<Bool>,
126 community_moderator (id) {
128 community_id -> Int4,
130 published -> Timestamp,
135 community_person_ban (id) {
137 community_id -> Int4,
139 published -> Timestamp,
147 password_encrypted -> Text,
148 email -> Nullable<Text>,
152 default_sort_type -> Int2,
153 default_listing_type -> Int2,
155 show_avatars -> Bool,
156 send_notifications_to_email -> Bool,
157 matrix_user_id -> Nullable<Text>,
164 mod_person_id -> Int4,
165 other_person_id -> Int4,
166 removed -> Nullable<Bool>,
172 mod_add_community (id) {
174 mod_person_id -> Int4,
175 other_person_id -> Int4,
176 community_id -> Int4,
177 removed -> Nullable<Bool>,
185 mod_person_id -> Int4,
186 other_person_id -> Int4,
187 reason -> Nullable<Text>,
188 banned -> Nullable<Bool>,
189 expires -> Nullable<Timestamp>,
195 mod_ban_from_community (id) {
197 mod_person_id -> Int4,
198 other_person_id -> Int4,
199 community_id -> Int4,
200 reason -> Nullable<Text>,
201 banned -> Nullable<Bool>,
202 expires -> Nullable<Timestamp>,
210 mod_person_id -> Int4,
212 locked -> Nullable<Bool>,
218 mod_remove_comment (id) {
220 mod_person_id -> Int4,
222 reason -> Nullable<Text>,
223 removed -> Nullable<Bool>,
229 mod_remove_community (id) {
231 mod_person_id -> Int4,
232 community_id -> Int4,
233 reason -> Nullable<Text>,
234 removed -> Nullable<Bool>,
235 expires -> Nullable<Timestamp>,
241 mod_remove_post (id) {
243 mod_person_id -> Int4,
245 reason -> Nullable<Text>,
246 removed -> Nullable<Bool>,
252 mod_sticky_post (id) {
254 mod_person_id -> Int4,
256 stickied -> Nullable<Bool>,
262 password_reset_request (id) {
264 token_encrypted -> Text,
265 published -> Timestamp,
266 local_user_id -> Int4,
274 preferred_username -> Nullable<Varchar>,
275 avatar -> Nullable<Varchar>,
277 published -> Timestamp,
278 updated -> Nullable<Timestamp>,
280 bio -> Nullable<Text>,
282 private_key -> Nullable<Text>,
283 public_key -> Nullable<Text>,
284 last_refreshed_at -> Timestamp,
285 banner -> Nullable<Varchar>,
287 inbox_url -> Varchar,
288 shared_inbox_url -> Nullable<Varchar>,
293 person_aggregates (id) {
298 comment_count -> Int8,
299 comment_score -> Int8,
307 published -> Timestamp,
312 person_mention (id) {
314 recipient_id -> Int4,
317 published -> Timestamp,
325 url -> Nullable<Varchar>,
326 body -> Nullable<Text>,
328 community_id -> Int4,
331 published -> Timestamp,
332 updated -> Nullable<Timestamp>,
336 embed_title -> Nullable<Text>,
337 embed_description -> Nullable<Text>,
338 embed_html -> Nullable<Text>,
339 thumbnail_url -> Nullable<Text>,
346 post_aggregates (id) {
354 published -> Timestamp,
355 newest_comment_time_necro -> Timestamp,
356 newest_comment_time -> Timestamp,
366 published -> Timestamp,
375 published -> Timestamp,
384 original_post_name -> Varchar,
385 original_post_url -> Nullable<Text>,
386 original_post_body -> Nullable<Text>,
389 resolver_id -> Nullable<Int4>,
390 published -> Timestamp,
391 updated -> Nullable<Timestamp>,
400 published -> Timestamp,
405 private_message (id) {
408 recipient_id -> Int4,
412 published -> Timestamp,
413 updated -> Nullable<Timestamp>,
423 description -> Nullable<Text>,
425 published -> Timestamp,
426 updated -> Nullable<Timestamp>,
427 enable_downvotes -> Bool,
428 open_registration -> Bool,
430 icon -> Nullable<Varchar>,
431 banner -> Nullable<Varchar>,
436 site_aggregates (id) {
443 users_active_day -> Int8,
444 users_active_week -> Int8,
445 users_active_month -> Int8,
446 users_active_half_year -> Int8,
450 // These are necessary since diesel doesn't have self joins / aliases
452 comment_alias_1 (id) {
456 parent_id -> Nullable<Int4>,
460 published -> Timestamp,
461 updated -> Nullable<Timestamp>,
469 person_alias_1 (id) {
472 preferred_username -> Nullable<Varchar>,
473 avatar -> Nullable<Varchar>,
475 published -> Timestamp,
476 updated -> Nullable<Timestamp>,
478 bio -> Nullable<Text>,
480 private_key -> Nullable<Text>,
481 public_key -> Nullable<Text>,
482 last_refreshed_at -> Timestamp,
483 banner -> Nullable<Varchar>,
485 inbox_url -> Varchar,
486 shared_inbox_url -> Nullable<Varchar>,
491 person_alias_2 (id) {
494 preferred_username -> Nullable<Varchar>,
495 avatar -> Nullable<Varchar>,
497 published -> Timestamp,
498 updated -> Nullable<Timestamp>,
500 bio -> Nullable<Text>,
502 private_key -> Nullable<Text>,
503 public_key -> Nullable<Text>,
504 last_refreshed_at -> Timestamp,
505 banner -> Nullable<Varchar>,
507 inbox_url -> Varchar,
508 shared_inbox_url -> Nullable<Varchar>,
512 joinable!(comment_alias_1 -> person_alias_1 (creator_id));
513 joinable!(comment -> comment_alias_1 (parent_id));
514 joinable!(person_mention -> person_alias_1 (recipient_id));
515 joinable!(post -> person_alias_1 (creator_id));
516 joinable!(comment -> person_alias_1 (creator_id));
518 joinable!(post_report -> person_alias_2 (resolver_id));
519 joinable!(comment_report -> person_alias_2 (resolver_id));
521 joinable!(comment -> person (creator_id));
522 joinable!(comment -> post (post_id));
523 joinable!(comment_aggregates -> comment (comment_id));
524 joinable!(comment_like -> comment (comment_id));
525 joinable!(comment_like -> person (person_id));
526 joinable!(comment_like -> post (post_id));
527 joinable!(comment_report -> comment (comment_id));
528 joinable!(comment_saved -> comment (comment_id));
529 joinable!(comment_saved -> person (person_id));
530 joinable!(community -> person (creator_id));
531 joinable!(community_aggregates -> community (community_id));
532 joinable!(community_follower -> community (community_id));
533 joinable!(community_follower -> person (person_id));
534 joinable!(community_moderator -> community (community_id));
535 joinable!(community_moderator -> person (person_id));
536 joinable!(community_person_ban -> community (community_id));
537 joinable!(community_person_ban -> person (person_id));
538 joinable!(local_user -> person (person_id));
539 joinable!(mod_add_community -> community (community_id));
540 joinable!(mod_ban_from_community -> community (community_id));
541 joinable!(mod_lock_post -> person (mod_person_id));
542 joinable!(mod_lock_post -> post (post_id));
543 joinable!(mod_remove_comment -> comment (comment_id));
544 joinable!(mod_remove_comment -> person (mod_person_id));
545 joinable!(mod_remove_community -> community (community_id));
546 joinable!(mod_remove_community -> person (mod_person_id));
547 joinable!(mod_remove_post -> person (mod_person_id));
548 joinable!(mod_remove_post -> post (post_id));
549 joinable!(mod_sticky_post -> person (mod_person_id));
550 joinable!(mod_sticky_post -> post (post_id));
551 joinable!(password_reset_request -> local_user (local_user_id));
552 joinable!(person_aggregates -> person (person_id));
553 joinable!(person_ban -> person (person_id));
554 joinable!(person_mention -> comment (comment_id));
555 joinable!(person_mention -> person (recipient_id));
556 joinable!(post -> community (community_id));
557 joinable!(post -> person (creator_id));
558 joinable!(post_aggregates -> post (post_id));
559 joinable!(post_like -> person (person_id));
560 joinable!(post_like -> post (post_id));
561 joinable!(post_read -> person (person_id));
562 joinable!(post_read -> post (post_id));
563 joinable!(post_report -> post (post_id));
564 joinable!(post_saved -> person (person_id));
565 joinable!(post_saved -> post (post_id));
566 joinable!(site -> person (creator_id));
567 joinable!(site_aggregates -> site (site_id));
569 allow_tables_to_appear_in_same_query!(
577 community_aggregates,
580 community_person_ban,
585 mod_ban_from_community,
588 mod_remove_community,
591 password_reset_request,