users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"users_ID_seq"'::regclass)
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
creator int4 10 null
users.ID FK_users_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

contact int4 10 null
contacts.ID FK_users_contact N

Reference to the associated contact

activity int2 5 0

0: Active, 1: Deactivated

name text 2147483647 null
email text 2147483647 null
password text 2147483647 ''::text
nopublic int2 5 0

User can only access group objects, but not public objects

expdate int8 19 null
lastlogin int8 19 null
lastloginattempt int8 19 null
loginattempts int4 10 0
logintoken varchar 40 ''::character varying
persistentlogintoken varchar 40 ''::character varying
sessionid int4 10 null
description text 2147483647 ''::text

The general description field

settings json 2147483647 null
signature varchar 32 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_users_ID Primary key Asc ID
UNQ_users_email Must be unique
UNQ_users_name Must be unique
UNQ_users_persistentlogintoken Must be unique Asc persistentlogintoken

Relationships