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









  • No labels