users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
accounts.assigneduser fk_accounts_assigneduser N
accounts.creator fk_accounts_creator N
actionsteps.assigneduser fk_actionsteps_assigneduser N
actionsteps.creator fk_actionsteps_creator N
actionsteps.owneruser fk_actionsteps_owneruser C
addresses.creator fk_addresses_creator N
applications.creator fk_applications_creator N
appointments.assigneduser fk_appointments_assigneduser N
appointments.creator fk_appointments_creator N
appointments.owneruser fk_appointments_owneruser C
campaigns.assigneduser fk_campaigns_assigneduser N
campaigns.creator fk_campaigns_creator N
categories.creator fk_categories_creator N
categories.owneruser fk_categories_owneruser C
comments.creator fk_comments_creator N
components.creator fk_components_creator N
contacts.assigneduser fk_contacts_assigneduser N
contacts.creator fk_contacts_creator N
contacts.owneruser fk_contacts_owneruser C
contacts2contacts.creator fk_contacts2contacts_creator N
contracts.assigneduser fk_contracts_assigneduser N
contracts.creator fk_contracts_creator N
couponcodes.creator fk_couponcodes_creator N
coupons.creator fk_coupons_creator N
davservers.creator fk_davservers_creator N
davservers.owneruser fk_davservers_owneruser C
davservers.recipientuser fk_davservers_recipientuser N
dunning.assigneduser fk_dunning_assigneduser N
dunning.creator fk_dunning_creator N
dunning2transactions.creator fk_dunning2transactions_creator N
events.creator fk_events_creator N
events.owneruser fk_events_owneruser C
feedservers.creator fk_feedservers_creator N
feedservers.owneruser fk_feedservers_owneruser C
feedservers.recipientuser fk_feedservers_recipientuser N
files.creator fk_files_creator N
follows.creator fk_follows_creator C
groups.creator fk_groups_creator N
groups.leader fk_groups_leader N
groups2users.creator fk_groups2users_creator N
groups2users.user fk_groups2users_user C
invitations.creator fk_invitations_creator N
items.creator fk_items_creator N
ledgers.creator fk_ledgers_creator N
likes.creator fk_likes_creator C
links.assigneduser fk_links_assigneduser N
links.creator fk_links_creator N
links.owneruser fk_links_owneruser C
mailinglists.assigneduser fk_mailinglists_assigneduser N
mailinglists.creator fk_mailinglists_creator N
mailinglists.owneruser fk_mailinglists_owneruser C
mailservers.creator fk_mailservers_creator N
mailservers.owneruser fk_mailservers_owneruser C
mailservers.recipientuser fk_mailservers_recipientuser N
messagereads.creator fk_messagereads_creator C
messages.creator fk_messages_creator N
messages.owneruser fk_messages_owneruser C
notes.assigneduser fk_notes_assigneduser N
notes.creator fk_notes_creator N
notes.owneruser fk_notes_owneruser C
objects.assigneduser fk_objects_assigneduser N
objects.creator fk_objects_creator N
objects.owneruser fk_objects_owneruser C
opportunities.assigneduser fk_opportunities_assigneduser N
opportunities.creator fk_opportunities_creator N
participants.creator fk_participants_creator N
payments.assigneduser fk_payments_assigneduser N
payments.creator fk_payments_creator N
permissions.creator fk_permissions_creator N
pricelists.creator fk_pricelists_creator N
pricelists2accounts.creator fk_pricelists2accounts_creator N
prices.creator fk_prices_creator N
projects.assigneduser fk_projects_assigneduser N
projects.creator fk_projects_creator N
projects.owneruser fk_projects_owneruser C
records.assigneduser fk_records_assigneduser C
records.creator fk_records_creator N
records.owneruser fk_records_owneruser C
resources.creator fk_resources_creator N
services.creator fk_services_creator N
stocktransactions.creator fk_stocktransactions_creator N
storages.creator fk_storages_creator N
suppliers.creator fk_suppliers_creator N
tasks.assigneduser fk_tasks_assigneduser N
tasks.creator fk_tasks_creator N
tasks.owneruser fk_tasks_owneruser C
tickets.assigneduser fk_tickets_assigneduser N
tickets.creator fk_tickets_creator N
transactions.assigneduser fk_transactions_assigneduser N
transactions.creator fk_transactions_creator N
users.creator fk_users_creator N
weblets.creator fk_weblets_creator N

User ID
creator int4 10 √ null
users.ID fk_users_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
contact int4 10 √ null
contacts.ID fk_users_contact N

Contact ID
activity int2 5 0

Activity (0=ACTIVE, 1=DEACTIVATED, 2=DELETED)
name text 2147483647 null

Username (case-insensitively unique)
email text 2147483647 null

System e-mail address (case-insensitively unique)
password text 2147483647 ''::text
otpsecret text 2147483647 ''::text
nopublic int2 5 0

Deny access to public data
expdate int8 19 √ null

Expiry date and time as a Unix time stamp
lastlogin int8 19 √ null

Last login date and time as a Unix time stamp
lastloginattempt int8 19 √ null
loginattempts int4 10 0
resetlogintoken varchar 40 ''::character varying
persistentlogintoken varchar 40 ''::character varying
sessionid varchar 40 ''::character varying
signature varchar 32 null
description text 2147483647 ''::text
settings json 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_users Primary key Asc ID
fk_users_contact Performance Asc contact
s_users Performance Asc/Asc name + email
u_users_email Must be unique
u_users_name Must be unique
u_users_persistentlogintoken Must be unique Asc persistentlogintoken

Relationships

Close relationships within degrees of separation