ST Database Table ownerOrganization

phpMyAdmin can provide a detailed look at the current table definition (if you have the needed permissions).

A row in this table indicates that the request owner indicated by the ownerId field should appear on the welcome page of the front end hosted by the organization indicated by the orgId, which is 1 for CSCF and 2 for MFCF. It is also used to categorize staff in ways used by various analysis programs. We currently have only one such:

RSG

Research Support Group

See the owner table as well, which has to have the "ownerId" field defined before additions can be made to this table.

E.g. to add King Kong (userid "kkong") as a CSCF staff member, one could:

st-sql 'insert into ownerOrganization set ownerId="kkong", orgId=1'

To remove, one could:

st-sql '"delete from ownerOrganization where ownerId="kkong"'

`st-sql` resides in /software/rt-math-1/maintenance/st-sql.

The roles field has values that are distinct from the organization names; a role name can not be the same as an organization name. The values are constrained. The add 'CSG' to the existing role of 'RSG', one could:

alter table ownerOrganization modify roles enum ('RSG', 'CSG');