Set of administration tools for 42l's infrastructure
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

67 lines
1.4 KiB

table! {
adhesions (id) {
id -> Int4,
user_id -> Int4,
adh_date -> Date,
}
}
table! {
alias (id) {
id -> Int4,
user_id -> Int4,
from_email -> Varchar,
to_email -> Varchar,
}
}
table! {
email (id) {
id -> Int4,
user_id -> Int4,
address -> Varchar,
}
}
table! {
email_domains (id) {
id -> Int4,
fqdn -> Varchar,
free_access -> Bool,
owner -> Int4,
}
}
table! {
email_groups (user_id, email_domains_id) {
user_id -> Int4,
email_domains_id -> Int4,
}
}
table! {
user (id) {
id -> Int4,
username -> Nullable<Bytea>,
recovery_email -> Bytea,
notify_email -> Bytea,
password -> Bpchar,
sub_newsletter -> Bool,
sub_ag -> Bool,
blocked -> Int2,
max_emails -> Int2,
max_alias -> Int2,
gitea_id -> Nullable<Int8>,
nextcloud_username -> Nullable<Bpchar>,
username_plain -> Varchar,
}
}
joinable!(adhesions -> user (user_id));
joinable!(alias -> user (user_id));
joinable!(email -> user (user_id));
joinable!(email_domains -> user (owner));
joinable!(email_groups -> email_domains (email_domains_id));
joinable!(email_groups -> user (user_id));
allow_tables_to_appear_in_same_query!(adhesions, alias, email, email_domains, email_groups, user,);