1diesel::table! {
4 notifications (id) {
5 #[max_length = 36]
6 id -> Varchar,
7 #[max_length = 36]
8 player -> Varchar,
9 #[max_length = 255]
10 title -> Varchar,
11 #[max_length = 255]
12 content -> Varchar,
13 #[max_length = 36]
14 player_group -> Varchar,
15 date -> Datetime,
16 }
17}
18
19diesel::table! {
20 group_chat (id) {
21 #[max_length = 36]
22 id -> Varchar,
23 #[max_length = 255]
24 name -> Varchar,
25 }
26}
27
28diesel::table! {
29 group_members (id) {
30 #[max_length = 36]
31 id -> Varchar,
32 #[max_length = 36]
33 group_id -> Varchar,
34 #[max_length = 36]
35 player_id -> Varchar,
36 }
37}
38
39diesel::table! {
40 interactions (id) {
41 #[max_length = 36]
42 id -> Varchar,
43 interaction_type -> Varchar,
44 #[max_length = 36]
45 player -> Varchar,
46 #[max_length = 36]
47 target -> Nullable<Varchar>,
48 date -> Nullable<Datetime>,
49 }
50}
51
52diesel::table! {
53 messages (id) {
54 #[max_length = 36]
55 id -> Varchar,
56 #[max_length = 36]
57 sender -> Varchar,
58 #[max_length = 36]
59 receiver -> Varchar,
60 #[max_length = 255]
61 message -> Nullable<Varchar>,
62 date -> Nullable<Datetime>,
63 }
64}
65
66diesel::table! {
67 players (id) {
68 #[max_length = 36]
69 id -> Varchar,
70 #[max_length = 255]
71 name -> Varchar,
72 #[max_length = 255]
73 surname -> Varchar,
74 #[max_length = 255]
75 bio -> Varchar,
76 #[max_length = 255]
77 pronouns -> Varchar,
78 #[max_length = 255]
79 alias -> Varchar,
80 #[max_length = 10]
81 niu -> Varchar,
82 #[max_length = 255]
83 email -> Varchar,
84 #[max_length = 31]
85 phone -> Varchar,
86 #[max_length = 255]
87 faculty -> Varchar,
88 isuab -> Bool,
89 #[max_length = 1024]
90 how_did_you_hear_about_us -> Varchar,
91 #[max_length = 1024]
92 social_media -> Nullable<Varchar>,
93 #[max_length = 255]
94 password -> Varchar,
95 player_number -> Integer,
96 state -> Varchar,
97 role -> Varchar,
98 birth_date -> Date,
99 accept_info_other_editions -> Bool,
100 next_feeding -> Nullable<Datetime>,
101 last_login -> Nullable<Datetime>,
102 checkpoint -> Nullable<Datetime>,
103 wants_to_be_zombie -> Integer,
104 register_date -> Nullable<Datetime>,
105 }
106}
107
108diesel::table! {
109 settings (id) {
110 #[max_length = 36]
111 id -> Varchar,
112 #[max_length = 255]
113 settings_key -> Varchar,
114 #[max_length = 255]
115 settings_value -> Varchar,
116 }
117}
118
119diesel::table! {
120 tokens (token) {
121 #[max_length = 64]
122 token -> Varchar,
123 #[max_length = 36]
124 user_id -> Varchar,
125 expiration -> Datetime,
126 }
127}
128
129diesel::table! {
130 subscriptions {
131 #[max_length = 36]
132 id -> Varchar,
133 #[max_length = 36]
134 player_id -> Varchar,
135 #[max_length = 255]
136 endpoint -> Varchar,
137 #[max_length = 255]
138 p256dh -> Varchar,
139 #[max_length = 255]
140 auth -> Varchar,
141 date -> Datetime
142 }
143}
144
145diesel::joinable!(notifications -> players (player));
146diesel::joinable!(group_members -> group_chat (group_id));
147diesel::joinable!(group_members -> players (player_id));
148diesel::joinable!(tokens -> players (user_id));
149diesel::joinable!(subscriptions -> players (player_id));
150
151diesel::allow_tables_to_appear_in_same_query!(
152 notifications,
153 group_chat,
154 group_members,
155 interactions,
156 messages,
157 players,
158 settings,
159 tokens,
160 subscriptions,
161);