Home
The following stored procedures are used by the package:
- upsert_dc_group_v2
- upsert_dc_file_attachment
- retrieve_dc_main
- upsert_robot_action
- update_dc_position
- upsert_dcg_grid
- upsert_energy_scan
- upsert_xfe_fluo_spectrum
- upsert_fluo_mapping
- upsert_fluo_mapping_roi
- upsert_session_for_proposal_code_number
- upsert_person
- upsert_session_has_person
- upsert_proposal_has_person
- retrieve_current_sessions
- retrieve_current_sessions_for_person
- retrieve_most_recent_session
- retrieve_persons_for_proposal
- retrieve_current_cm_sessions
- retrieve_containers_submitted_non_ls ...
The following stored functions are used by the package:
- upsert_dc
- upsert_image
- upsert_sample
- retrieve_visit_id
- retrieve_datacollection_id
- retrieve_proposal_title ...
Below is a simplified database diagram of the most relevant tables and their relationships. Note that:
- not all columns are shown
- the datatypes are omitted
- the primary keys are always the first column(s) in each table (usually named after the table and ending in "Id")
- next follow the foreign keys (usually named after the table it referenes and ending in "Id")
- all the regular columns are shown last
Click here to edit this image in a browser (?t=0 to bypass caches). Use the Chrome App for native PNG+XML support.
