roles

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('roles_id_seq'::regclass)
api_users.role_id fk_rails_b82ad50b98 R
members.role_id fk_rails_ba7343b1aa R
role_permissions.role_id fk_autog808c2ef223 R
role_id int4 10 √ null
description text 2147483647 √ null
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null
super_admin bool 1 false
send_sms bool 1 false
manage_members bool 1 false
imports bool 1 false
manage_variables bool 1 false
read_mailings bool 1 false
send_mailings bool 1 false
plivo_webhook bool 1 false
twilio_webhook bool 1 false
nexmo_webhook bool 1 false
paypal_webhook bool 1 false
go_cardless_webhook bool 1 false
stripe_webhook bool 1 false
razorpay_webhook bool 1 false
csl_webhook bool 1 false
lists_api bool 1 false
searches_api bool 1 false
groups_api bool 1 false
members_api bool 1 false
member_subscriptions_api bool 1 false
donations_api bool 1 false
events_api bool 1 false
actions_api bool 1 false
mailjet_api bool 1 false
mailings_api bool 1 false
canonical_questions_api bool 1 false
sms bool 1 false
view_members bool 1 false
update_member_details bool 1 false
update_member_subscriptions bool 1 false
anonymize_members bool 1 false
bulk_update_members bool 1 false
push_members_to_service bool 1 false
manage_searches bool 1 false
upload_lists bool 1 false
read_lists bool 1 false
download_lists bool 1 false
anonymize_lists bool 1 false
view_job_status bool 1 false

Indexes

Constraint Name Type Sort Column(s)
roles_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation