Stores Request Handler user account information.
Definition:
Column | Type | Collation | Nullable | Default
-----------------------+-------------------+-----------+----------+-------------------------
account_id | character varying | | not null |
request_handler_id | numeric | | |
version | numeric | | not null | 1
password_digest | character varying | | |
firstname | character varying | | not null |
lastname | character varying | | not null |
initials | character varying | | |
creationtimestamp | character varying | | |
modificationtimestamp | character varying | | |
preferredarc | character varying | | |
email | character varying | | |
executive | character varying | | not null | 'na'::character varying
aliases | character varying | | |
inst_no | numeric | | not null | 1
provider | character varying | | |
provider_principal | character varying | | |
Indexes:
"account_pkey" PRIMARY KEY, btree (account_id)
"account_provider_provider_principal_key" UNIQUE CONSTRAINT, btree (provider, provider_principal)
Referenced by:
TABLE "account_role" CONSTRAINT "account_role_account_id_fkey" FOREIGN KEY (account_id) REFERENCES account(account_id)
Columns:
account_id: foreign key into account
request_handler_id: ?
version: always 1
password_digest: encrypted password
firstname: user's first name
lastname: user's last name
initials: user's middle initial(s), if any
creationtimestamp: when account was created? not populated
modificationtimestamp: when account was last modified? not populated
preferredarc: preferred archive? not populated
executive: data reducer executive? values: na, NA
aliases: ? not populated
inst_no: institution? not populated
provider: institutional affiliation? value: null, ALMA, NRAO
provider_principal: appears to be user_id; compound FK with